Fields (542)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingClerk | AccountingClerk | 1 |
| KEY | AccountingDocument | AccountingDocument,BillingDocument | 6 |
| KEY | AccountingDocumentItem | AccountingDocumentItem | 5 |
| KEY | AccrSubobjectItmValdtyEndDte | AccrSubobjectItmValdtyEndDte | 1 |
| KEY | AccrualItemType | AccrualItemType | 1 |
| KEY | BaseUnit | BaseUnit | 2 |
| KEY | Batch | Batch | 3 |
| KEY | BillingDocument | BillingDocument | 5 |
| KEY | BillingDocumentItem | BillingDocumentItem,DocumentItemNumber | 6 |
| KEY | BillingQuantity | BillingQuantity | 2 |
| KEY | BillingQuantityUnit | BillingQuantityUnit | 2 |
| KEY | BusinessArea | BusinessArea | 6 |
| KEY | CentralFinanceBillingDocument | BillingDocument | 1 |
| KEY | ChangeDocDatabaseTable | ChangeDocDatabaseTableForEdit | 1 |
| KEY | ChangeDocDatabaseTableField | ChangeDocDatabaseTableField,ChangeDocTableFieldForEdit | 3 |
| KEY | ChangeDocItemChangeType | ChangeDocItemChangeType | 2 |
| KEY | ChangeDocObject | ChangeDocObject,ChangeDocObjectForEdit | 3 |
| KEY | ChangeDocObjectClass | ChangeDocObjectClass,ChangeDocObjectClassForEdit | 3 |
| KEY | ChangeDocShortTableKey | ChangeDocShortTableKeyForEdit | 1 |
| KEY | ChangeDocument | ChangeDocument | 3 |
| KEY | CompanyCode | CompanyCode | 9 |
| KEY | CostCenter | CostCenter | 2 |
| KEY | Customer | Customer | 6 |
| KEY | FinSGLErrorDocument | FinSGLErrorDocument | 1 |
| KEY | FinSGLErrorFiscalYear | FinSGLErrorFiscalYear | 1 |
| KEY | FinSGLErrorItemSeverity | FinSGLErrorItemSeverity | 1 |
| KEY | FinSGLPostedCompanyCode | FinSGLPostedCompanyCode | 1 |
| KEY | FinSGLPostedDocument | FinSGLPostedDocument | 1 |
| KEY | FinSGLPostedFiscalYear | FinSGLPostedFiscalYear | 1 |
| KEY | FinSGLRunID | FinSGLRunID | 1 |
| KEY | FiscalYear | FiscalYear | 6 |
| KEY | GLAccount | GLAccount | 8 |
| KEY | HandlingUnitItem | HandlingUnitItem | 1 |
| KEY | HandlingUnitRefDocumentItem | HandlingUnitRefDocumentItem | 1 |
| KEY | InsurPlcyCashFlowDocumentItem | InsurPlcyCashFlowDocumentItem | 1 |
| KEY | IsStatisticalDocument | IsStatisticalDocument | 1 |
| KEY | Ledger | Ledger | 2 |
| KEY | Material | Material | 24 |
| KEY | pi_date | ItemDate,PaymentItemDate,pi_date | 3 |
| KEY | pi_no | ItemNumber,PaymentItemNumber,pi_no | 3 |
| KEY | Plant | Plant | 5 |
| KEY | PricingDate | PricingDate | 1 |
| KEY | ProfitabilitySegment_2 | ProfitabilitySegment | 1 |
| KEY | ProfitCenter | ProfitCenter | 3 |
| KEY | ReconciliationAccount | ReconciliationAccount | 1 |
| KEY | REFERENCESDDOCUMENT | REFERENCESDDOCUMENT,RequirementDocumentNumber | 6 |
| KEY | ReverseDocument | ReverseDocument | 5 |
| KEY | SchedulingAgreement | SchedulingAgreement | 1 |
| KEY | ShippingPoint | ShippingPoint | 3 |
| KEY | SourceLedger | SourceLedger | 3 |
| KEY | SourcingProjectItemStableUUID | SourcingProjectItemStableUUID | 1 |
| KEY | SourcingProjectItemUUID | SourcingProjectItemUUID | 1 |
| KEY | SpecialGLCode | SpecialGLCode | 3 |
| KEY | StatryRptCategory | StatryRptCategory | 3 |
| KEY | StatryRptgEntity | StatryRptgEntity | 3 |
| KEY | StatryRptRunID | StatryRptRunID | 3 |
| KEY | StorageLocation | StorageLocation | 4 |
| KEY | SupplierInvoice | BillingDocument,SupplierInvoice | 2 |
| KEY | SupplierInvoiceItem | BillingDocumentItem,DocumentItemNumber,SupplierInvoiceItem | 2 |
| KEY | TaxCode | TaxCode | 7 |
| KEY | TransactionTypeDetermination | TransactionTypeDetermination | 4 |
| _AccountingClerk | _AccountingClerk | 1 | |
| _ChangeDocLongTableKey | _ChangeDocLongTableKey | 2 | |
| _ChangeDocument | _ChangeDocument | 2 | |
| _ChangeDocumentItemExtension | _ChangeDocumentItemExtension | 2 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _Company | _Company | 1 | |
| _Customer | _Customer | 1 | |
| _DeliveryDocument | _DeliveryDocument | 1 | |
| _DisplayCurrency | _DisplayCurrency | 1 | |
| _Division | _Division | 2 | |
| _FinancialAccountType | _FinancialAccountType | 1 | |
| _GLAccount | _GLAccount | 1 | |
| _ReconciliationAccount | _ReconciliationAccount | 1 | |
| _SpecialGLCode | _SpecialGLCode | 1 | |
| AccountingDocCreatedByUser | AccountingDocCreatedByUser | 1 | |
| AccountingDocumentCategory | AccountingDocumentCategory | 1 | |
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | 1 | |
| AccountingDocumentItemType | AccountingDocumentItemType | 4 | |
| AccountingDocumentType | AccountingDocumentType | 6 | |
| AccountsReceivableIsPledged | AccountsReceivableIsPledged | 1 | |
| AccrSubobjectItmValdtyStrtDte | AccrSubobjectItmValdtyStrtDte | 1 | |
| AccrSubobjHdrEndOfLifeDate | AccrSubobjHdrEndOfLifeDate | 1 | |
| AccrSubobjHdrStartOfLifeDate | AccrSubobjHdrStartOfLifeDate | 1 | |
| AccrualItemIsObsolete | AccrualItemIsObsolete | 1 | |
| AccrualMethod | AccrualCalculationMethod | 1 | |
| acct_cur | acct_cur | 1 | |
| acct_no | acct_no | 1 | |
| ACMTrdgContrActualStartDate | ACMTrdgContrActualStartDate,ActualStartDateFrom | 2 | |
| act_post_date | act_post_date | 1 | |
| ActualStartDateFrom | ActualStartDateFrom | 1 | |
| ActualStartDateTo | ActualStartDateTo | 1 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 5 | |
| AdditionalCurrency1Role | AdditionalCurrency1Role | 1 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 5 | |
| AdditionalCurrency2Role | AdditionalCurrency2Role | 1 | |
| AlternativeGLAccount | AlternativeGLAccount | 1 | |
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | 1 | |
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | 1 | |
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | 1 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency,ItemPrice | 2 | |
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | 1 | |
| AmountInPaymentCurrency | AmountInPaymentCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| APMPaymentItemOffsetLinkValue | APMPaymentItemOffsetLinkValue | 1 | |
| AssetContract | AssetContract | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| AuthorizationGroup | AuthorizationGroup | 1 | |
| BalanceTransactionCurrency | BalanceTransactionCurrency | 1 | |
| bam_id | bam_id | 1 | |
| bank_tx_domain_code | bank_tx_domain_code | 1 | |
| bank_tx_family_code | bank_tx_family_code | 1 | |
| bank_tx_sub_family_code | bank_tx_sub_family_code | 1 | |
| bankkey | bankkey | 1 | |
| bic | bic | 1 | |
| BillingDocumentItemText | BillingDocumentItemText | 4 | |
| BILLINGDOCUMENTREQUESTITEMTEXT | BILLINGDOCUMENTREQUESTITEMTEXT | 1 | |
| BillOfExchangeUsage | BillOfExchangeUsage | 1 | |
| BillOfExchangeUsageDocument | BillOfExchangeUsageDocument | 1 | |
| BOEUsageDocFiscalYear | BOEUsageDocFiscalYear | 1 | |
| BOEUsageDocLineItem | BOEUsageDocLineItem | 1 | |
| BPBankAccountInternalID | BPBankAccountInternalID | 1 | |
| Branch | Branch | 1 | |
| BranchCode | BranchCode | 1 | |
| BusinessPartnerName | BusinessPartnerName | 3 | |
| BusinessPlace | BusinessPlace | 1 | |
| CAClrfctnStatus | CAClrfctnStatus | 1 | |
| CaseID | CaseID | 1 | |
| CashDiscount1Days | CashDiscount1Days | 1 | |
| CashDiscount1DueDate | CashDiscount1DueDate | 1 | |
| CashDiscount1Percent | CashDiscount1Percent | 1 | |
| CashDiscount2Days | CashDiscount2Days | 1 | |
| CashDiscount2Percent | CashDiscount2Percent | 1 | |
| CashDiscountAmount | CashDiscountAmount,DiscountAmount | 3 | |
| CashDiscountAmtInCoCodeCrcy | CashDiscountAmtInCoCodeCrcy | 1 | |
| CashDiscountBaseAmount | CashDiscountBaseAmount | 2 | |
| CashFlowType | CashFlowType | 1 | |
| ChangeDocCreatedByUser | ChangeDocCreatedByUser_H | 1 | |
| ChangeDocLanguage | ChangeDocLanguageKey_H | 1 | |
| ChangeDocNewCurrency | ChangeDocNewCurrency | 2 | |
| ChangeDocNewFieldValue | ChangeDocNewFieldValue_H | 1 | |
| ChangeDocNewRawString | ChangeDocNewRawString_H | 1 | |
| ChangeDocNewShortString | ChangeDocNewShortString_H | 1 | |
| ChangeDocNewString | ChangeDocNewString_H | 1 | |
| ChangeDocNewUnit | ChangeDocNewUnit | 2 | |
| ChangeDocPreviousCurrency | ChangeDocPreviousCurrency | 2 | |
| ChangeDocPreviousFieldValue | ChangeDocPreviousFieldValue_H | 1 | |
| ChangeDocPreviousRawString | ChangeDocPreviousRawString_H | 1 | |
| ChangeDocPreviousShortString | ChangeDocPreviousShortString_H | 1 | |
| ChangeDocPreviousString | ChangeDocPreviousString_H | 1 | |
| ChangeDocPreviousUnit | ChangeDocPreviousUnit | 2 | |
| ChangeDocTableKey | ChangeDocTableKey,ChangeDocTableKey_H | 3 | |
| ChangeTransactionCode | ChangeTransactionCode_H | 1 | |
| ChartOfAccounts | ChartOfAccounts | 2 | |
| chdat | chdat | 1 | |
| chtim | chtim | 1 | |
| chusr | chusr | 1 | |
| ClearingAccountingDocument | ClearingAccountingDocument | 1 | |
| ClearingDate | ClearingDate | 1 | |
| ClearingDocFiscalYear | ClearingDocFiscalYear | 1 | |
| ClearingIsReversed | ClearingIsReversed | 1 | |
| CommodityName | CommodityName | 1 | |
| CompanyCodeCountry | CompanyCodeCountry | 4 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 7 | |
| ContractCommodityItem | Commodity | 2 | |
| ContractMaterial | ContractMaterial | 2 | |
| ContractPlant | ContractPlant | 2 | |
| country | country | 1 | |
| CountryCurrency | CountryCurrency | 4 | |
| crdat | crdat | 1 | |
| CreatedByUser | CreatedByUserDB_H | 1 | |
| CreationDate | CreationDate_H,WorklistItemCreationDate | 2 | |
| CreationDateTime | CreationDateTime_H | 1 | |
| CreationTime | CreationTime_H | 1 | |
| CreditControlArea | CreditControlArea | 1 | |
| CREDITMEMOREQUESTITEMTEXT | CREDITMEMOREQUESTITEMTEXT | 1 | |
| Creditor | Creditor | 1 | |
| crtim | crtim | 1 | |
| crusr | crusr | 1 | |
| currency | currency | 2 | |
| currency_code | currency_code | 1 | |
| CustomerCountry | CustomerCountry | 1 | |
| CustomerSubtotal2Amount | Subtotal2Amount | 1 | |
| CustomerSupplierAddress | CustomerSupplierAddress | 3 | |
| DatabaseTable | DatabaseTable | 2 | |
| DataExchangeInstruction1 | DataExchangeInstruction1 | 1 | |
| DataExchangeInstruction2 | DataExchangeInstruction2 | 1 | |
| DataExchangeInstruction3 | DataExchangeInstruction3 | 1 | |
| DataExchangeInstruction4 | DataExchangeInstruction4 | 1 | |
| DebitCreditCode | DebitCreditCode | 5 | |
| DebitCreditCodeIsChanged | DebitCreditCodeIsChanged | 3 | |
| DEBITMEMOREQUESTITEMTEXT | DEBITMEMOREQUESTITEMTEXT | 1 | |
| Debtor | Debtor | 1 | |
| DeliveryDocument | DeliveryDocument | 4 | |
| DeliveryDocumentItem | DeliveryDocumentItem | 3 | |
| DELIVERYDOCUMENTITEMTEXT | DELIVERYDOCUMENTITEMTEXT | 3 | |
| DeliveryGroup | DeliveryGroup | 1 | |
| DeliveryPriority | DeliveryPriority | 1 | |
| DepartureCountry | DepartureCountry | 1 | |
| disp_stat | disp_stat | 1 | |
| DisplayCurrency | DisplayCurrency | 1 | |
| DisputeCasePriority | DisputeCasePriority | 1 | |
| DisputeCasePriorityName | DisputeCasePriorityName | 1 | |
| DisputeCaseProcessor | DisputeCaseProcessor | 1 | |
| DisputeCaseProcessorFullName | DisputeCaseProcessorFullName | 1 | |
| DisputeCaseReason | DisputeCaseReason | 1 | |
| DisputeCaseReasonName | DisputeCaseReasonName | 1 | |
| DisputeCaseStatus | DisputeCaseStatus | 1 | |
| DisputeCaseStatusName | DisputeCaseStatusName | 1 | |
| DisputeCaseTitle | DisputeCaseTitle | 1 | |
| DisputeCaseUUID | DisputeCaseUUID | 1 | |
| DistributionChannel | DistributionChannel | 5 | |
| Division | Division | 3 | |
| DocumentCurrency | DocumentCurrency | 4 | |
| DocumentDate | BillingDocumentDate,DocumentDate | 6 | |
| DocumentIsArchived | DocumentIsArchived | 1 | |
| DocumentItemText | BillingDocumentItemText,DocumentItemText | 3 | |
| DocumentReferenceID | DocumentReferenceID | 2 | |
| due_date | due_date | 1 | |
| DueCalculationBaseDate | DueCalculationBaseDate | 1 | |
| DunningArea | DunningArea | 1 | |
| DunningBlockingReason | DunningBlockingReason | 1 | |
| DunningKey | DunningKey | 1 | |
| DunningLevel | DunningLevel | 1 | |
| end_to_end_id | end_to_end_id | 2 | |
| EngagementProjectUUID | EngagementProjectUUID | 1 | |
| ETag | ETag | 2 | |
| FinancialAccountType | AccountType,FinancialAccountType | 6 | |
| FinancialStmntCashFlowItemMode | FinancialStmntCashFlowItemMode | 3 | |
| FinSGLCorrectionCompanyCode | FinSGLCorrectionCompanyCode | 1 | |
| FinSGLCorrectionDocument | FinSGLCorrectionDocument | 1 | |
| FinSGLCorrectionFiscalYear | FinSGLCorrectionFiscalYear | 1 | |
| FinSGLCrrtnReversalDocument | FinSGLCrrtnReversalDocument | 1 | |
| FinSGLCrrtnRvslCompanyCode | FinSGLCrrtnRvslCompanyCode | 1 | |
| FinSGLCrrtnRvslFiscalYear | FinSGLCrrtnRvslFiscalYear | 1 | |
| FinStmntFormStrucItemFactor | FinStmntFormStrucItemFactor | 1 | |
| FinStmntFormStrucItemSign | FinStmntFormStrucItemSign | 1 | |
| FiscalPeriod | FiscalPeriod | 6 | |
| FixedAsset | FixedAsset | 1 | |
| FixedCashDiscount | FixedCashDiscount | 1 | |
| FldLogsContainerID | FldLogsContainerID | 3 | |
| FldLogsContainerUnitUUID | FldLogsContainerUnitUUID | 2 | |
| FldLogsCtnActualWeight | FldLogsCtnActualWeight | 3 | |
| FldLogsCtnActualWeightUnit | FldLogsCtnActualWeightUnit | 3 | |
| FldLogsReferenceDocumentNumber | FldLogsReferenceDocumentNumber | 2 | |
| FldLogsShptItemActlWeightUnit | FldLogsShptItemActlWeightUnit | 3 | |
| FldLogsShptItemActualWeight | FldLogsShptItemActualWeight | 3 | |
| FldLogsShptItmHndlgUnitID | FldLogsShptItmHndlgUnitID | 2 | |
| FollowOnDocumentType | FollowOnDocumentType | 1 | |
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | 1 | |
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | 1 | |
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | 1 | |
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | 1 | |
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | 1 | |
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | 1 | |
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | 1 | |
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| FunctionalCurrency | FunctionalCurrency | 1 | |
| FundsCenter | FundsCenter | 1 | |
| GlobalCurrency | GlobalCurrency | 1 | |
| gross_amount | item_amount,item_gross_amount | 3 | |
| GrossWeight | GrossWeight | 2 | |
| HandlingUnitNestedInternalID | HandlingUnitNestedInternalID | 1 | |
| HandlingUnitQuantity | HandlingUnitQuantity | 1 | |
| HandlingUnitQuantityUnit | HandlingUnitQuantityUnit | 1 | |
| HasPaymentOrder | HasPaymentOrder | 1 | |
| HedgedAmount | HedgedAmount | 1 | |
| holder | holder | 1 | |
| HouseBank | HouseBank | 1 | |
| HouseBankAccount | HouseBankAccount | 1 | |
| iban | iban | 1 | |
| InsurancePolicyCoinsuranceKey | InsurancePolicyCoinsuranceKey | 1 | |
| InsurancePolicyInsuranceObject | InsurancePolicyInsuranceObject | 1 | |
| InsurContrAcct | InsurContrAcct | 1 | |
| InsurPlcyAccountAssignmentText | InsurPlcyAccountAssignmentText | 1 | |
| InsurPlcyAltvAddressNumber | InsurPlcyAltvAddressNumber | 1 | |
| InsurPlcyAltvBankAccount | InsurPlcyAltvBankAccount | 1 | |
| InsurPlcyAltvBusinessPartner | InsurPlcyAltvBusinessPartner | 1 | |
| InsurPlcyAltvCardNumber | InsurPlcyAltvCardNumber | 1 | |
| InsurPlcyAltvPostgTgtBizPrtn | InsurPlcyAltvPostgTgtBizPrtn | 1 | |
| InsurPlcyAltvPostingTarget | InsurPlcyAltvPostingTarget | 1 | |
| InsurPlcyAmountInLocalCurrency | InsurPlcyAmountInLocalCurrency | 1 | |
| InsurPlcyAmountInRiskCurrency | InsurPlcyAmountInRiskCurrency | 1 | |
| InsurPlcyCashFlowAddressNumber | InsurPlcyCashFlowAddressNumber | 1 | |
| InsurPlcyCashFlowBkAcctDet | InsurPlcyCashFlowBkAcctDet | 1 | |
| InsurPlcyChangedByUser | InsurPlcyChangedByUser | 1 | |
| InsurPlcyCoinsurDocCategory | InsurPlcyCoinsurDocCategory | 1 | |
| InsurPlcyCoverageID | InsurPlcyCoverageID | 1 | |
| InsurPlcyCoverageOptionID | InsurPlcyCoverageOptionID | 1 | |
| InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | 1 | |
| InsurPlcyCreditCardNumber | InsurPlcyCreditCardNumber | 1 | |
| InsurPlcyCshFlwAmtInCshFlwCrcy | InsurPlcyCshFlwAmtInCshFlwCrcy | 1 | |
| InsurPlcyCshFlwDocItmIsStstcl | InsurPlcyCshFlwDocItmIsStstcl | 1 | |
| InsurPlcyCshFlwDocItmPostgCode | InsurPlcyCshFlwDocItmPostgCode | 1 | |
| InsurPlcyCshFlwDocItmPostgType | InsurPlcyCshFlwDocItmPostgType | 1 | |
| InsurPlcyCshFlwDocItmTxCode | InsurPlcyCshFlwDocItmTxCode | 1 | |
| InsurPlcyCshFlwDocumentItemBP | InsurPlcyCshFlwDocumentItemBP | 1 | |
| InsurPlcyElementaryProdTmpl | InsurPlcyElementaryProdTmpl | 1 | |
| InsurPlcyMnlCostPostgText | InsurPlcyMnlCostPostgText | 1 | |
| InsurPlcyPaymentMethod | InsurPlcyPaymentMethod | 1 | |
| InsurPlcyStepOfProcessing | InsurPlcyStepOfProcessing | 1 | |
| IntercompanyTransaction | IntercompanyTransaction | 1 | |
| InternationalArticleNumber | InternationalArticleNumber | 1 | |
| InvoiceList | InvoiceList | 1 | |
| InvoiceReference | InvoiceReference | 5 | |
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | 4 | |
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | 3 | |
| IsCreditBalanceRelevant | IsCreditBalanceRelevant | 1 | |
| IsDebitBalanceRelevant | IsDebitBalanceRelevant | 1 | |
| IsSalesRelated | IsSalesRelated | 1 | |
| IsUsedInPaymentTransaction | IsUsedInPaymentTransaction | 1 | |
| Item | Item | 3 | |
| ITEM_TYPE_BRANCH | ITEM_TYPE_BRANCH | 1 | |
| ItemBillingBlockReason | ItemBillingBlockReason | 1 | |
| ItemIsHiddenInReporting | ItemIsHiddenInReporting | 3 | |
| ItemSignIsReversed | ItemSignIsReversed | 3 | |
| ItemType | DueItemType,ItemType | 3 | |
| JointVenture | JointVenture | 1 | |
| JointVentureBillingType | JointVentureBillingType | 1 | |
| JointVentureCorporateEquityGrp | JointVentureCorporateEquityGrp | 1 | |
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastDunningDate | LastDunningDate | 1 | |
| LedgerGroup | LedgerGroup | 1 | |
| MasterFixedAsset | MasterFixedAsset | 1 | |
| MaterialByCustomer | MaterialByCustomer | 10 | |
| MaterialGroup | MaterialGroup | 4 | |
| MaterialPricingGroup | MaterialPricingGroup | 1 | |
| MatlAccountAssignmentGroup | MatlAccountAssignmentGroup | 1 | |
| NetAmount | NetAmount | 2 | |
| NetDueDate | NetDueDate | 1 | |
| NetDueIntvl1AmtInCoCodeCrcy | NetDueIntvl1AmtInCoCodeCrcy | 1 | |
| NetDueIntvl1AmtInDspCrcy | NetDueIntvl1AmtInDspCrcy | 1 | |
| NetDueIntvl2AmtInCoCodeCrcy | NetDueIntvl2AmtInCoCodeCrcy | 1 | |
| NetDueIntvl2AmtInDspCrcy | NetDueIntvl2AmtInDspCrcy | 1 | |
| NetDueIntvl3AmtInCoCodeCrcy | NetDueIntvl3AmtInCoCodeCrcy | 1 | |
| NetDueIntvl3AmtInDspCrcy | NetDueIntvl3AmtInDspCrcy | 1 | |
| NetPaymentDays | NetPaymentDays | 1 | |
| OffsettingAccount | OffsettingAccount | 1 | |
| OffsettingAccountType | OffsettingAccountType | 1 | |
| OrderID | OrderID | 1 | |
| OrderQuantityUnit | OrderQuantityUnit | 3 | |
| OrganizationDivision | OrganizationDivision | 4 | |
| OriginalReferenceDocument | OriginalReferenceDocument | 6 | |
| OutputRequestItemStatus | OutputRequestItemStatus | 1 | |
| PackagingMaterial | PackagingMaterial | 2 | |
| parent_id | root_id | 1 | |
| parent_key | parent_key | 1 | |
| ParentItem | ParentItem | 3 | |
| PartialDeliveryIsAllowed | PartialDeliveryIsAllowed | 1 | |
| PartialPaymentAmtInDspCrcy | PartialPaymentAmtInDspCrcy | 2 | |
| PartnerCompany | PartnerCompany | 1 | |
| payment_scenario | payment_scenario | 1 | |
| PaymentBlockingReason | PaymentBlockingReason | 1 | |
| PaymentCardItem | PaymentCardItem | 1 | |
| PaymentCardPaymentSettlement | PaymentCardPaymentSettlement | 1 | |
| PaymentCurrency | PaymentCurrency | 1 | |
| PaymentDifferenceReason | PaymentDifferenceReason | 2 | |
| PaymentMethod | PaymentMethod | 1 | |
| PaymentMethodSupplement | PaymentMethodSupplement | 1 | |
| PaymentReference | PaymentReference | 1 | |
| PaymentTerms | PaymentTerms | 1 | |
| PhysicalInventoryStatusText | PhysicalInventoryStatusText | 1 | |
| pi_kind | pi_kind | 1 | |
| pl_clr_date | pl_clr_date | 1 | |
| pl_clr_time | pl_clr_time | 1 | |
| PlannedAmtInTransactionCrcy | PlannedAmtInTransactionCrcy | 1 | |
| PlannedReversalDate | PlannedReversalDate | 1 | |
| PlantName | PlantName | 1 | |
| posnr | item_position | 2 | |
| PostingDate | PostingDate | 7 | |
| PostingKey | PostingKey | 3 | |
| priority | priority | 1 | |
| Product | Product | 1 | |
| ProductTaxClassification1 | ProductTaxClassification1 | 1 | |
| ProjectPortfolioUUID | ProjectPortfolioUUID | 3 | |
| PurchasingDocument | PurchasingDocument | 2 | |
| PurchasingDocumentItem | PurchasingDocumentItem | 1 | |
| Quantity | BillingQuantity | 1 | |
| QuantityInActlPostg | QuantityInActlPostg | 4 | |
| QuantityInBaseUnit | QuantityInBaseUnit | 2 | |
| QuantityUnit | QuantityUnit | 4 | |
| RealEstateObject | RealEstateObject | 1 | |
| ReceivableAlternativePayer | ReceivableAlternativePayer | 1 | |
| ReceivableFinancingStatus | ReceivableFinancingStatus | 1 | |
| ref_clearing | ClearingAgreementID | 1 | |
| ref_cust_sgm | ref_cust_sgm | 1 | |
| ref_item_ext | ref_item_ext | 2 | |
| ref_item_ext_out | ref_item_ext_out | 2 | |
| ref_route | RouteID | 1 | |
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | 1 | |
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | 1 | |
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | 1 | |
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 6 | |
| REFERENCESDDOCUMENTCATEGORY | REFERENCESDDOCUMENTCATEGORY | 2 | |
| REFERENCESDDOCUMENTITEM | REFERENCESDDOCUMENTITEM,RequirementDocumentItem | 4 | |
| release_activity | release_activity | 1 | |
| ReportingCountry | ReportingCountry | 4 | |
| ReportingCurrency | ReportingCurrency | 3 | |
| ReportingDate | ReportingDate,TaxReportingDate | 4 | |
| ReportingPeriod | ReportingPeriod | 1 | |
| ReportingPeriodEndDate | ReportingPeriodEndDate | 1 | |
| ReportingPeriodStartDate | ReportingPeriodStartDate | 1 | |
| ReportingYear | ReportingYear | 1 | |
| RequestedQuantity | RequestedQuantity | 1 | |
| RequestedQuantityUnit | RequestedQuantityUnit | 1 | |
| RequirementSegment | RequirementSegment | 1 | |
| ResponseProfile | ResponseProfile | 1 | |
| return_code | return_code | 1 | |
| RETURNREASON | RETURNREASON | 1 | |
| ReversalReason | ReversalReason | 1 | |
| ReverseDocumentFiscalYear | ReverseDocumentFiscalYear | 4 | |
| rldat | rldat | 1 | |
| rltim | rltim | 1 | |
| rlusr | rlusr | 1 | |
| SALESCONTRACTITEMTEXT | SALESCONTRACTITEMTEXT | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SALESINQUIRYITEMTEXT | SALESINQUIRYITEMTEXT | 1 | |
| SalesOrderItemCategory | SalesOrderItemCategory | 1 | |
| SALESORDERITEMTEXT | SALESORDERITEMTEXT | 2 | |
| SALESORDERWTHOUTCHRGITEMTEXT | SALESORDERWTHOUTCHRGITEMTEXT | 1 | |
| SalesOrganization | SalesOrganization | 4 | |
| SalesPromotion | SalesPromotion | 1 | |
| SALESQUOTATIONITEMTEXT | SALESQUOTATIONITEMTEXT | 1 | |
| SalesSchedgAgrmtType | SalesSchedgAgrmtType | 4 | |
| ScheduleLine | ScheduleLine | 1 | |
| SDDocument | SDDocument | 1 | |
| SeasonCompletenessStatus | SeasonCompletenessIndicator | 1 | |
| ServiceProfile | ServiceProfile | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 2 | |
| SettlementReferenceDate | SettlementReferenceDate | 1 | |
| so_item_pos | item_position | 1 | |
| SourceCompanyCode | SourceCompanyCode | 1 | |
| SourcingProjectItem | SourcingProjectItem | 1 | |
| SourcingProjectUUID | SourcingProjectUUID | 1 | |
| SpecialGLTransactionType | SpecialGLTransactionType | 1 | |
| SrcgProjItemDescription | SrcgProjItemDescription | 1 | |
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | 1 | |
| StatusFlagValue | StatusFlagValue | 1 | |
| StockSegment | StockSegment | 1 | |
| SuplrCoIsBusPrpsCmpltd | SuplrCoIsBusPrpsCmpltd | 3 | |
| Supplier | Supplier | 4 | |
| SupplierAccountGroup | SupplierAccountGroup | 4 | |
| SupplyingCountry | SupplyingCountry | 1 | |
| TaxAmount | TaxAmount | 2 | |
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | 1 | |
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | 1 | |
| TaxCalculationDate | TaxCalculationDate | 1 | |
| TaxCountry | TaxCountry | 1 | |
| TaxItemGroup | TaxItemGroup | 2 | |
| TaxNumber1 | TaxNumber1 | 3 | |
| TaxNumber2 | TaxNumber2 | 3 | |
| TaxNumber3 | TaxNumber3 | 3 | |
| TaxRate | TaxRate | 4 | |
| TaxReportingDate | TaxReportingDate | 1 | |
| TaxSection | TaxSection | 1 | |
| tech_stat | ItemTechStat,tech_stat | 2 | |
| TotalAccrAmountInFreeDfndCrcy1 | TotalAccrAmountInFreeDfndCrcy1 | 1 | |
| TotalAccrAmountInFreeDfndCrcy2 | TotalAccrAmountInFreeDfndCrcy2 | 1 | |
| TotalAccrAmountInFreeDfndCrcy3 | TotalAccrAmountInFreeDfndCrcy3 | 1 | |
| TotalAccrAmountInFreeDfndCrcy4 | TotalAccrAmountInFreeDfndCrcy4 | 1 | |
| TotalAccrAmountInFreeDfndCrcy5 | TotalAccrAmountInFreeDfndCrcy5 | 1 | |
| TotalAccrAmountInFreeDfndCrcy6 | TotalAccrAmountInFreeDfndCrcy6 | 1 | |
| TotalAccrAmountInFreeDfndCrcy7 | TotalAccrAmountInFreeDfndCrcy7 | 1 | |
| TotalAccrAmountInFreeDfndCrcy8 | TotalAccrAmountInFreeDfndCrcy8 | 1 | |
| TotalAccrAmountInGlobalCrcy | TotalAccrAmountInGlobalCrcy | 1 | |
| TotalAccrAmountInTransCrcy | TotalAccrAmountInTransCrcy | 1 | |
| TotalAccrAmtInCompanyCodeCrcy | TotalAccrAmtInCompanyCodeCrcy | 1 | |
| TotalAccrualQuantity | AccrualEngineTotalQtyInBsUnt,TotalAccrualQuantity | 1 | |
| TotalAccrualQuantityUnit | UnitOfMeasure | 1 | |
| tr_amount | tr_amount | 1 | |
| tr_curr | tr_curr | 1 | |
| trans_type | trans_type | 1 | |
| trans_typet_l | trans_typet_l | 1 | |
| TransactionCurrency | TransactionCurrency | 3 | |
| TreasuryContractType | TreasuryContractType | 1 | |
| uetr | uetr | 1 | |
| UnitedStatesTaxCategory | UnitedStatesTaxCategory | 1 | |
| US_TaxFreeDefinedValue1 | US_TaxFreeDefinedValue1 | 1 | |
| US_TaxFreeDefinedValue10 | US_TaxFreeDefinedValue10 | 1 | |
| US_TaxFreeDefinedValue11 | US_TaxFreeDefinedValue11 | 1 | |
| US_TaxFreeDefinedValue12 | US_TaxFreeDefinedValue12 | 1 | |
| US_TaxFreeDefinedValue13 | US_TaxFreeDefinedValue13 | 1 | |
| US_TaxFreeDefinedValue14 | US_TaxFreeDefinedValue14 | 1 | |
| US_TaxFreeDefinedValue15 | US_TaxFreeDefinedValue15 | 1 | |
| US_TaxFreeDefinedValue16 | US_TaxFreeDefinedValue16 | 1 | |
| US_TaxFreeDefinedValue17 | US_TaxFreeDefinedValue17 | 1 | |
| US_TaxFreeDefinedValue18 | US_TaxFreeDefinedValue18 | 1 | |
| US_TaxFreeDefinedValue19 | US_TaxFreeDefinedValue19 | 1 | |
| US_TaxFreeDefinedValue2 | US_TaxFreeDefinedValue2 | 1 | |
| US_TaxFreeDefinedValue20 | US_TaxFreeDefinedValue20 | 1 | |
| US_TaxFreeDefinedValue21 | US_TaxFreeDefinedValue21 | 1 | |
| US_TaxFreeDefinedValue22 | US_TaxFreeDefinedValue22 | 1 | |
| US_TaxFreeDefinedValue23 | US_TaxFreeDefinedValue23 | 1 | |
| US_TaxFreeDefinedValue24 | US_TaxFreeDefinedValue24 | 1 | |
| US_TaxFreeDefinedValue25 | US_TaxFreeDefinedValue25 | 1 | |
| US_TaxFreeDefinedValue26 | US_TaxFreeDefinedValue26 | 1 | |
| US_TaxFreeDefinedValue27 | US_TaxFreeDefinedValue27 | 1 | |
| US_TaxFreeDefinedValue28 | US_TaxFreeDefinedValue28 | 1 | |
| US_TaxFreeDefinedValue29 | US_TaxFreeDefinedValue29 | 1 | |
| US_TaxFreeDefinedValue3 | US_TaxFreeDefinedValue3 | 1 | |
| US_TaxFreeDefinedValue30 | US_TaxFreeDefinedValue30 | 1 | |
| US_TaxFreeDefinedValue31 | US_TaxFreeDefinedValue31 | 1 | |
| US_TaxFreeDefinedValue32 | US_TaxFreeDefinedValue32 | 1 | |
| US_TaxFreeDefinedValue33 | US_TaxFreeDefinedValue33 | 1 | |
| US_TaxFreeDefinedValue34 | US_TaxFreeDefinedValue34 | 1 | |
| US_TaxFreeDefinedValue35 | US_TaxFreeDefinedValue35 | 1 | |
| US_TaxFreeDefinedValue36 | US_TaxFreeDefinedValue36 | 1 | |
| US_TaxFreeDefinedValue37 | US_TaxFreeDefinedValue37 | 1 | |
| US_TaxFreeDefinedValue38 | US_TaxFreeDefinedValue38 | 1 | |
| US_TaxFreeDefinedValue39 | US_TaxFreeDefinedValue39 | 1 | |
| US_TaxFreeDefinedValue4 | US_TaxFreeDefinedValue4 | 1 | |
| US_TaxFreeDefinedValue40 | US_TaxFreeDefinedValue40 | 1 | |
| US_TaxFreeDefinedValue41 | US_TaxFreeDefinedValue41 | 1 | |
| US_TaxFreeDefinedValue42 | US_TaxFreeDefinedValue42 | 1 | |
| US_TaxFreeDefinedValue43 | US_TaxFreeDefinedValue43 | 1 | |
| US_TaxFreeDefinedValue44 | US_TaxFreeDefinedValue44 | 1 | |
| US_TaxFreeDefinedValue45 | US_TaxFreeDefinedValue45 | 1 | |
| US_TaxFreeDefinedValue46 | US_TaxFreeDefinedValue46 | 1 | |
| US_TaxFreeDefinedValue47 | US_TaxFreeDefinedValue47 | 1 | |
| US_TaxFreeDefinedValue48 | US_TaxFreeDefinedValue48 | 1 | |
| US_TaxFreeDefinedValue49 | US_TaxFreeDefinedValue49 | 1 | |
| US_TaxFreeDefinedValue5 | US_TaxFreeDefinedValue5 | 1 | |
| US_TaxFreeDefinedValue50 | US_TaxFreeDefinedValue50 | 1 | |
| US_TaxFreeDefinedValue6 | US_TaxFreeDefinedValue6 | 1 | |
| US_TaxFreeDefinedValue7 | US_TaxFreeDefinedValue7 | 1 | |
| US_TaxFreeDefinedValue8 | US_TaxFreeDefinedValue8 | 1 | |
| US_TaxFreeDefinedValue9 | US_TaxFreeDefinedValue9 | 1 | |
| US_TaxPartnerReceivedTaxDate | US_TaxPartnerReceivedTaxDate | 1 | |
| ValuationDiffAmtInAddlCrcy1 | ValuationDiffAmtInAddlCrcy1 | 1 | |
| ValuationDiffAmtInAddlCrcy2 | ValuationDiffAmtInAddlCrcy2 | 1 | |
| ValuationDiffAmtInCoCodeCrcy | ValuationDiffAmtInCoCodeCrcy | 1 | |
| ValuationType | ValuationType | 1 | |
| ValueDate | ValueDate | 1 | |
| WBSElement | WBSElement | 1 | |
| WeightUnit | WeightUnit | 2 | |
| WithholdingTaxAmount | WithholdingTaxAmount | 1 | |
| WithholdingTaxBaseAmount | WithholdingTaxBaseAmount | 1 | |
| WithholdingTaxExemptionAmt | WithholdingTaxExemptionAmt | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ITEM (
ACCOUNTINGCLERK,
ACCOUNTINGDOCUMENT,
ACCOUNTINGDOCUMENTITEM,
ACCRSUBOBJECTITMVALDTYENDDTE,
ACCRUALITEMTYPE,
BASEUNIT,
BATCH,
BILLINGDOCUMENT,
BILLINGDOCUMENTITEM,
BILLINGQUANTITY,
BILLINGQUANTITYUNIT,
BUSINESSAREA,
CENTRALFINANCEBILLINGDOCUMENT,
CHANGEDOCDATABASETABLE,
CHANGEDOCDATABASETABLEFIELD,
CHANGEDOCITEMCHANGETYPE,
CHANGEDOCOBJECT,
CHANGEDOCOBJECTCLASS,
CHANGEDOCSHORTTABLEKEY,
CHANGEDOCUMENT,
COMPANYCODE,
COSTCENTER,
CUSTOMER,
FINSGLERRORDOCUMENT,
FINSGLERRORFISCALYEAR,
FINSGLERRORITEMSEVERITY,
FINSGLPOSTEDCOMPANYCODE,
FINSGLPOSTEDDOCUMENT,
FINSGLPOSTEDFISCALYEAR,
FINSGLRUNID,
FISCALYEAR,
GLACCOUNT,
HANDLINGUNITITEM,
HANDLINGUNITREFDOCUMENTITEM,
INSURPLCYCASHFLOWDOCUMENTITEM,
ISSTATISTICALDOCUMENT,
LEDGER,
MATERIAL,
PI_DATE,
PI_NO,
PLANT,
PRICINGDATE,
PROFITABILITYSEGMENT_2,
PROFITCENTER,
RECONCILIATIONACCOUNT,
REFERENCESDDOCUMENT,
REVERSEDOCUMENT,
SCHEDULINGAGREEMENT,
SHIPPINGPOINT,
SOURCELEDGER,
SOURCINGPROJECTITEMSTABLEUUID,
SOURCINGPROJECTITEMUUID,
SPECIALGLCODE,
STATRYRPTCATEGORY,
STATRYRPTGENTITY,
STATRYRPTRUNID,
STORAGELOCATION,
SUPPLIERINVOICE,
SUPPLIERINVOICEITEM,
TAXCODE,
TRANSACTIONTYPEDETERMINATION,
_ACCOUNTINGCLERK,
_CHANGEDOCLONGTABLEKEY,
_CHANGEDOCUMENT,
_CHANGEDOCUMENTITEMEXTENSION,
_CHARTOFACCOUNTS,
_COMPANY,
_CUSTOMER,
_DELIVERYDOCUMENT,
_DISPLAYCURRENCY,
_DIVISION,
_FINANCIALACCOUNTTYPE,
_GLACCOUNT,
_RECONCILIATIONACCOUNT,
_SPECIALGLCODE,
ACCOUNTINGDOCCREATEDBYUSER,
ACCOUNTINGDOCUMENTCATEGORY,
ACCOUNTINGDOCUMENTCREATIONDATE,
ACCOUNTINGDOCUMENTITEMTYPE,
ACCOUNTINGDOCUMENTTYPE,
ACCOUNTSRECEIVABLEISPLEDGED,
ACCRSUBOBJECTITMVALDTYSTRTDTE,
ACCRSUBOBJHDRENDOFLIFEDATE,
ACCRSUBOBJHDRSTARTOFLIFEDATE,
ACCRUALITEMISOBSOLETE,
ACCRUALMETHOD,
ACCT_CUR,
ACCT_NO,
ACMTRDGCONTRACTUALSTARTDATE,
ACT_POST_DATE,
ACTUALSTARTDATEFROM,
ACTUALSTARTDATETO,
ADDITIONALCURRENCY1,
ADDITIONALCURRENCY1ROLE,
ADDITIONALCURRENCY2,
ADDITIONALCURRENCY2ROLE,
ALTERNATIVEGLACCOUNT,
AMOUNTINADDITIONALCURRENCY1,
AMOUNTINADDITIONALCURRENCY2,
AMOUNTINBALANCETRANSACCRCY,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINFUNCTIONALCURRENCY,
AMOUNTINPAYMENTCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
APMPAYMENTITEMOFFSETLINKVALUE,
ASSETCONTRACT,
ASSIGNMENTREFERENCE,
AUTHORIZATIONGROUP,
BALANCETRANSACTIONCURRENCY,
BAM_ID,
BANK_TX_DOMAIN_CODE,
BANK_TX_FAMILY_CODE,
BANK_TX_SUB_FAMILY_CODE,
BANKKEY,
BIC,
BILLINGDOCUMENTITEMTEXT,
BILLINGDOCUMENTREQUESTITEMTEXT,
BILLOFEXCHANGEUSAGE,
BILLOFEXCHANGEUSAGEDOCUMENT,
BOEUSAGEDOCFISCALYEAR,
BOEUSAGEDOCLINEITEM,
BPBANKACCOUNTINTERNALID,
BRANCH,
BRANCHCODE,
BUSINESSPARTNERNAME,
BUSINESSPLACE,
CACLRFCTNSTATUS,
CASEID,
CASHDISCOUNT1DAYS,
CASHDISCOUNT1DUEDATE,
CASHDISCOUNT1PERCENT,
CASHDISCOUNT2DAYS,
CASHDISCOUNT2PERCENT,
CASHDISCOUNTAMOUNT,
CASHDISCOUNTAMTINCOCODECRCY,
CASHDISCOUNTBASEAMOUNT,
CASHFLOWTYPE,
CHANGEDOCCREATEDBYUSER,
CHANGEDOCLANGUAGE,
CHANGEDOCNEWCURRENCY,
CHANGEDOCNEWFIELDVALUE,
CHANGEDOCNEWRAWSTRING,
CHANGEDOCNEWSHORTSTRING,
CHANGEDOCNEWSTRING,
CHANGEDOCNEWUNIT,
CHANGEDOCPREVIOUSCURRENCY,
CHANGEDOCPREVIOUSFIELDVALUE,
CHANGEDOCPREVIOUSRAWSTRING,
CHANGEDOCPREVIOUSSHORTSTRING,
CHANGEDOCPREVIOUSSTRING,
CHANGEDOCPREVIOUSUNIT,
CHANGEDOCTABLEKEY,
CHANGETRANSACTIONCODE,
CHARTOFACCOUNTS,
CHDAT,
CHTIM,
CHUSR,
CLEARINGACCOUNTINGDOCUMENT,
CLEARINGDATE,
CLEARINGDOCFISCALYEAR,
CLEARINGISREVERSED,
COMMODITYNAME,
COMPANYCODECOUNTRY,
COMPANYCODECURRENCY,
CONTRACTCOMMODITYITEM,
CONTRACTMATERIAL,
CONTRACTPLANT,
COUNTRY,
COUNTRYCURRENCY,
CRDAT,
CREATEDBYUSER,
CREATIONDATE,
CREATIONDATETIME,
CREATIONTIME,
CREDITCONTROLAREA,
CREDITMEMOREQUESTITEMTEXT,
CREDITOR,
CRTIM,
CRUSR,
CURRENCY,
CURRENCY_CODE,
CUSTOMERCOUNTRY,
CUSTOMERSUBTOTAL2AMOUNT,
CUSTOMERSUPPLIERADDRESS,
DATABASETABLE,
DATAEXCHANGEINSTRUCTION1,
DATAEXCHANGEINSTRUCTION2,
DATAEXCHANGEINSTRUCTION3,
DATAEXCHANGEINSTRUCTION4,
DEBITCREDITCODE,
DEBITCREDITCODEISCHANGED,
DEBITMEMOREQUESTITEMTEXT,
DEBTOR,
DELIVERYDOCUMENT,
DELIVERYDOCUMENTITEM,
DELIVERYDOCUMENTITEMTEXT,
DELIVERYGROUP,
DELIVERYPRIORITY,
DEPARTURECOUNTRY,
DISP_STAT,
DISPLAYCURRENCY,
DISPUTECASEPRIORITY,
DISPUTECASEPRIORITYNAME,
DISPUTECASEPROCESSOR,
DISPUTECASEPROCESSORFULLNAME,
DISPUTECASEREASON,
DISPUTECASEREASONNAME,
DISPUTECASESTATUS,
DISPUTECASESTATUSNAME,
DISPUTECASETITLE,
DISPUTECASEUUID,
DISTRIBUTIONCHANNEL,
DIVISION,
DOCUMENTCURRENCY,
DOCUMENTDATE,
DOCUMENTISARCHIVED,
DOCUMENTITEMTEXT,
DOCUMENTREFERENCEID,
DUE_DATE,
DUECALCULATIONBASEDATE,
DUNNINGAREA,
DUNNINGBLOCKINGREASON,
DUNNINGKEY,
DUNNINGLEVEL,
END_TO_END_ID,
ENGAGEMENTPROJECTUUID,
ETAG,
FINANCIALACCOUNTTYPE,
FINANCIALSTMNTCASHFLOWITEMMODE,
FINSGLCORRECTIONCOMPANYCODE,
FINSGLCORRECTIONDOCUMENT,
FINSGLCORRECTIONFISCALYEAR,
FINSGLCRRTNREVERSALDOCUMENT,
FINSGLCRRTNRVSLCOMPANYCODE,
FINSGLCRRTNRVSLFISCALYEAR,
FINSTMNTFORMSTRUCITEMFACTOR,
FINSTMNTFORMSTRUCITEMSIGN,
FISCALPERIOD,
FIXEDASSET,
FIXEDCASHDISCOUNT,
FLDLOGSCONTAINERID,
FLDLOGSCONTAINERUNITUUID,
FLDLOGSCTNACTUALWEIGHT,
FLDLOGSCTNACTUALWEIGHTUNIT,
FLDLOGSREFERENCEDOCUMENTNUMBER,
FLDLOGSSHPTITEMACTLWEIGHTUNIT,
FLDLOGSSHPTITEMACTUALWEIGHT,
FLDLOGSSHPTITMHNDLGUNITID,
FOLLOWONDOCUMENTTYPE,
FREEDEFINEDCURRENCY1,
FREEDEFINEDCURRENCY2,
FREEDEFINEDCURRENCY3,
FREEDEFINEDCURRENCY4,
FREEDEFINEDCURRENCY5,
FREEDEFINEDCURRENCY6,
FREEDEFINEDCURRENCY7,
FREEDEFINEDCURRENCY8,
FUNCTIONALAREA,
FUNCTIONALCURRENCY,
FUNDSCENTER,
GLOBALCURRENCY,
GROSS_AMOUNT,
GROSSWEIGHT,
HANDLINGUNITNESTEDINTERNALID,
HANDLINGUNITQUANTITY,
HANDLINGUNITQUANTITYUNIT,
HASPAYMENTORDER,
HEDGEDAMOUNT,
HOLDER,
HOUSEBANK,
HOUSEBANKACCOUNT,
IBAN,
INSURANCEPOLICYCOINSURANCEKEY,
INSURANCEPOLICYINSURANCEOBJECT,
INSURCONTRACCT,
INSURPLCYACCOUNTASSIGNMENTTEXT,
INSURPLCYALTVADDRESSNUMBER,
INSURPLCYALTVBANKACCOUNT,
INSURPLCYALTVBUSINESSPARTNER,
INSURPLCYALTVCARDNUMBER,
INSURPLCYALTVPOSTGTGTBIZPRTN,
INSURPLCYALTVPOSTINGTARGET,
INSURPLCYAMOUNTINLOCALCURRENCY,
INSURPLCYAMOUNTINRISKCURRENCY,
INSURPLCYCASHFLOWADDRESSNUMBER,
INSURPLCYCASHFLOWBKACCTDET,
INSURPLCYCHANGEDBYUSER,
INSURPLCYCOINSURDOCCATEGORY,
INSURPLCYCOVERAGEID,
INSURPLCYCOVERAGEOPTIONID,
INSURPLCYCOVERAGEPACKAGEID,
INSURPLCYCREDITCARDNUMBER,
INSURPLCYCSHFLWAMTINCSHFLWCRCY,
INSURPLCYCSHFLWDOCITMISSTSTCL,
INSURPLCYCSHFLWDOCITMPOSTGCODE,
INSURPLCYCSHFLWDOCITMPOSTGTYPE,
INSURPLCYCSHFLWDOCITMTXCODE,
INSURPLCYCSHFLWDOCUMENTITEMBP,
INSURPLCYELEMENTARYPRODTMPL,
INSURPLCYMNLCOSTPOSTGTEXT,
INSURPLCYPAYMENTMETHOD,
INSURPLCYSTEPOFPROCESSING,
INTERCOMPANYTRANSACTION,
INTERNATIONALARTICLENUMBER,
INVOICELIST,
INVOICEREFERENCE,
INVOICEREFERENCEFISCALYEAR,
ISBUSINESSPURPOSECOMPLETED,
ISCREDITBALANCERELEVANT,
ISDEBITBALANCERELEVANT,
ISSALESRELATED,
ISUSEDINPAYMENTTRANSACTION,
ITEM,
ITEM_TYPE_BRANCH,
ITEMBILLINGBLOCKREASON,
ITEMISHIDDENINREPORTING,
ITEMSIGNISREVERSED,
ITEMTYPE,
JOINTVENTURE,
JOINTVENTUREBILLINGTYPE,
JOINTVENTURECORPORATEEQUITYGRP,
JOINTVENTURECOSTRECOVERYCODE,
LASTCHANGEDATETIME,
LASTDUNNINGDATE,
LEDGERGROUP,
MASTERFIXEDASSET,
MATERIALBYCUSTOMER,
MATERIALGROUP,
MATERIALPRICINGGROUP,
MATLACCOUNTASSIGNMENTGROUP,
NETAMOUNT,
NETDUEDATE,
NETDUEINTVL1AMTINCOCODECRCY,
NETDUEINTVL1AMTINDSPCRCY,
NETDUEINTVL2AMTINCOCODECRCY,
NETDUEINTVL2AMTINDSPCRCY,
NETDUEINTVL3AMTINCOCODECRCY,
NETDUEINTVL3AMTINDSPCRCY,
NETPAYMENTDAYS,
OFFSETTINGACCOUNT,
OFFSETTINGACCOUNTTYPE,
ORDERID,
ORDERQUANTITYUNIT,
ORGANIZATIONDIVISION,
ORIGINALREFERENCEDOCUMENT,
OUTPUTREQUESTITEMSTATUS,
PACKAGINGMATERIAL,
PARENT_ID,
PARENT_KEY,
PARENTITEM,
PARTIALDELIVERYISALLOWED,
PARTIALPAYMENTAMTINDSPCRCY,
PARTNERCOMPANY,
PAYMENT_SCENARIO,
PAYMENTBLOCKINGREASON,
PAYMENTCARDITEM,
PAYMENTCARDPAYMENTSETTLEMENT,
PAYMENTCURRENCY,
PAYMENTDIFFERENCEREASON,
PAYMENTMETHOD,
PAYMENTMETHODSUPPLEMENT,
PAYMENTREFERENCE,
PAYMENTTERMS,
PHYSICALINVENTORYSTATUSTEXT,
PI_KIND,
PL_CLR_DATE,
PL_CLR_TIME,
PLANNEDAMTINTRANSACTIONCRCY,
PLANNEDREVERSALDATE,
PLANTNAME,
POSNR,
POSTINGDATE,
POSTINGKEY,
PRIORITY,
PRODUCT,
PRODUCTTAXCLASSIFICATION1,
PROJECTPORTFOLIOUUID,
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTITEM,
QUANTITY,
QUANTITYINACTLPOSTG,
QUANTITYINBASEUNIT,
QUANTITYUNIT,
REALESTATEOBJECT,
RECEIVABLEALTERNATIVEPAYER,
RECEIVABLEFINANCINGSTATUS,
REF_CLEARING,
REF_CUST_SGM,
REF_ITEM_EXT,
REF_ITEM_EXT_OUT,
REF_ROUTE,
REFERENCE1IDBYBUSINESSPARTNER,
REFERENCE2IDBYBUSINESSPARTNER,
REFERENCE3IDBYBUSINESSPARTNER,
REFERENCEDOCUMENTLOGICALSYSTEM,
REFERENCEDOCUMENTTYPE,
REFERENCESDDOCUMENTCATEGORY,
REFERENCESDDOCUMENTITEM,
RELEASE_ACTIVITY,
REPORTINGCOUNTRY,
REPORTINGCURRENCY,
REPORTINGDATE,
REPORTINGPERIOD,
REPORTINGPERIODENDDATE,
REPORTINGPERIODSTARTDATE,
REPORTINGYEAR,
REQUESTEDQUANTITY,
REQUESTEDQUANTITYUNIT,
REQUIREMENTSEGMENT,
RESPONSEPROFILE,
RETURN_CODE,
RETURNREASON,
REVERSALREASON,
REVERSEDOCUMENTFISCALYEAR,
RLDAT,
RLTIM,
RLUSR,
SALESCONTRACTITEMTEXT,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESINQUIRYITEMTEXT,
SALESORDERITEMCATEGORY,
SALESORDERITEMTEXT,
SALESORDERWTHOUTCHRGITEMTEXT,
SALESORGANIZATION,
SALESPROMOTION,
SALESQUOTATIONITEMTEXT,
SALESSCHEDGAGRMTTYPE,
SCHEDULELINE,
SDDOCUMENT,
SEASONCOMPLETENESSSTATUS,
SERVICEPROFILE,
SERVICESRENDEREDDATE,
SETTLEMENTREFERENCEDATE,
SO_ITEM_POS,
SOURCECOMPANYCODE,
SOURCINGPROJECTITEM,
SOURCINGPROJECTUUID,
SPECIALGLTRANSACTIONTYPE,
SRCGPROJITEMDESCRIPTION,
STATECENTRALBANKPAYMENTREASON,
STATUSFLAGVALUE,
STOCKSEGMENT,
SUPLRCOISBUSPRPSCMPLTD,
SUPPLIER,
SUPPLIERACCOUNTGROUP,
SUPPLYINGCOUNTRY,
TAXAMOUNT,
TAXAMOUNTINCOCODECRCY,
TAXBASEAMOUNTINCOCODECRCY,
TAXCALCULATIONDATE,
TAXCOUNTRY,
TAXITEMGROUP,
TAXNUMBER1,
TAXNUMBER2,
TAXNUMBER3,
TAXRATE,
TAXREPORTINGDATE,
TAXSECTION,
TECH_STAT,
TOTALACCRAMOUNTINFREEDFNDCRCY1,
TOTALACCRAMOUNTINFREEDFNDCRCY2,
TOTALACCRAMOUNTINFREEDFNDCRCY3,
TOTALACCRAMOUNTINFREEDFNDCRCY4,
TOTALACCRAMOUNTINFREEDFNDCRCY5,
TOTALACCRAMOUNTINFREEDFNDCRCY6,
TOTALACCRAMOUNTINFREEDFNDCRCY7,
TOTALACCRAMOUNTINFREEDFNDCRCY8,
TOTALACCRAMOUNTINGLOBALCRCY,
TOTALACCRAMOUNTINTRANSCRCY,
TOTALACCRAMTINCOMPANYCODECRCY,
TOTALACCRUALQUANTITY,
TOTALACCRUALQUANTITYUNIT,
TR_AMOUNT,
TR_CURR,
TRANS_TYPE,
TRANS_TYPET_L,
TRANSACTIONCURRENCY,
TREASURYCONTRACTTYPE,
UETR,
UNITEDSTATESTAXCATEGORY,
US_TAXFREEDEFINEDVALUE1,
US_TAXFREEDEFINEDVALUE10,
US_TAXFREEDEFINEDVALUE11,
US_TAXFREEDEFINEDVALUE12,
US_TAXFREEDEFINEDVALUE13,
US_TAXFREEDEFINEDVALUE14,
US_TAXFREEDEFINEDVALUE15,
US_TAXFREEDEFINEDVALUE16,
US_TAXFREEDEFINEDVALUE17,
US_TAXFREEDEFINEDVALUE18,
US_TAXFREEDEFINEDVALUE19,
US_TAXFREEDEFINEDVALUE2,
US_TAXFREEDEFINEDVALUE20,
US_TAXFREEDEFINEDVALUE21,
US_TAXFREEDEFINEDVALUE22,
US_TAXFREEDEFINEDVALUE23,
US_TAXFREEDEFINEDVALUE24,
US_TAXFREEDEFINEDVALUE25,
US_TAXFREEDEFINEDVALUE26,
US_TAXFREEDEFINEDVALUE27,
US_TAXFREEDEFINEDVALUE28,
US_TAXFREEDEFINEDVALUE29,
US_TAXFREEDEFINEDVALUE3,
US_TAXFREEDEFINEDVALUE30,
US_TAXFREEDEFINEDVALUE31,
US_TAXFREEDEFINEDVALUE32,
US_TAXFREEDEFINEDVALUE33,
US_TAXFREEDEFINEDVALUE34,
US_TAXFREEDEFINEDVALUE35,
US_TAXFREEDEFINEDVALUE36,
US_TAXFREEDEFINEDVALUE37,
US_TAXFREEDEFINEDVALUE38,
US_TAXFREEDEFINEDVALUE39,
US_TAXFREEDEFINEDVALUE4,
US_TAXFREEDEFINEDVALUE40,
US_TAXFREEDEFINEDVALUE41,
US_TAXFREEDEFINEDVALUE42,
US_TAXFREEDEFINEDVALUE43,
US_TAXFREEDEFINEDVALUE44,
US_TAXFREEDEFINEDVALUE45,
US_TAXFREEDEFINEDVALUE46,
US_TAXFREEDEFINEDVALUE47,
US_TAXFREEDEFINEDVALUE48,
US_TAXFREEDEFINEDVALUE49,
US_TAXFREEDEFINEDVALUE5,
US_TAXFREEDEFINEDVALUE50,
US_TAXFREEDEFINEDVALUE6,
US_TAXFREEDEFINEDVALUE7,
US_TAXFREEDEFINEDVALUE8,
US_TAXFREEDEFINEDVALUE9,
US_TAXPARTNERRECEIVEDTAXDATE,
VALUATIONDIFFAMTINADDLCRCY1,
VALUATIONDIFFAMTINADDLCRCY2,
VALUATIONDIFFAMTINCOCODECRCY,
VALUATIONTYPE,
VALUEDATE,
WBSELEMENT,
WEIGHTUNIT,
WITHHOLDINGTAXAMOUNT,
WITHHOLDINGTAXBASEAMOUNT,
WITHHOLDINGTAXEXEMPTIONAMT,
PRIMARY KEY (ACCOUNTINGCLERK, ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ACCRSUBOBJECTITMVALDTYENDDTE, ACCRUALITEMTYPE, BASEUNIT, BATCH, BILLINGDOCUMENT, BILLINGDOCUMENTITEM, BILLINGQUANTITY, BILLINGQUANTITYUNIT, BUSINESSAREA, CENTRALFINANCEBILLINGDOCUMENT, CHANGEDOCDATABASETABLE, CHANGEDOCDATABASETABLEFIELD, CHANGEDOCITEMCHANGETYPE, CHANGEDOCOBJECT, CHANGEDOCOBJECTCLASS, CHANGEDOCSHORTTABLEKEY, CHANGEDOCUMENT, COMPANYCODE, COSTCENTER, CUSTOMER, FINSGLERRORDOCUMENT, FINSGLERRORFISCALYEAR, FINSGLERRORITEMSEVERITY, FINSGLPOSTEDCOMPANYCODE, FINSGLPOSTEDDOCUMENT, FINSGLPOSTEDFISCALYEAR, FINSGLRUNID, FISCALYEAR, GLACCOUNT, HANDLINGUNITITEM, HANDLINGUNITREFDOCUMENTITEM, INSURPLCYCASHFLOWDOCUMENTITEM, ISSTATISTICALDOCUMENT, LEDGER, MATERIAL, PI_DATE, PI_NO, PLANT, PRICINGDATE, PROFITABILITYSEGMENT_2, PROFITCENTER, RECONCILIATIONACCOUNT, REFERENCESDDOCUMENT, REVERSEDOCUMENT, SCHEDULINGAGREEMENT, SHIPPINGPOINT, SOURCELEDGER, SOURCINGPROJECTITEMSTABLEUUID, SOURCINGPROJECTITEMUUID, SPECIALGLCODE, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, STORAGELOCATION, SUPPLIERINVOICE, SUPPLIERINVOICEITEM, TAXCODE, TRANSACTIONTYPEDETERMINATION)
);Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA