I_BILLINGDOCUMENTITEM
Billing Document Item
I_BILLINGDOCUMENTITEM is a CDS View in S/4HANA. Billing Document Item. It contains 194 fields. 77 CDS views read from this table.
CDS Views using this table (77)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_BillingDocumentItem | view | from | COMPOSITE | Billing Document Item |
| C_BillgDocItemRedacted | view | from | CONSUMPTION | |
| C_BillingDocumentItem_F0797 | view | from | CONSUMPTION | Billing Document Item |
| C_BillingDocumentItemFs | view | from | CONSUMPTION | Billing Document Item Fact Sheet |
| C_BSOrdItmProcFlwCrdtMemo | view | from | CONSUMPTION | Credit Memo Item Attrib for BSOrd Prgrs |
| C_BSOrdItmProcFlwCrdtMemoCancl | view | from | CONSUMPTION | CrdtMemoItmCancln Attrib for BSOrd Prgrs |
| C_BSOrdItmProcFlwCustInvc | view | from | CONSUMPTION | CustInvc Item Attrib for BSOrd Prgrs |
| C_BSOrdItmProcFlwDebitMemo | view | from | CONSUMPTION | Debit Memo Item Attrib for BSOrd Prgrs |
| C_BSOrdItmProcFlwInvcCancln | view | from | CONSUMPTION | Invc Cancln Item Attrib for BSOrd Prgrs |
| C_BSQPMBillingDocumentItem | view_entity | from | CONSUMPTION | BSQPM Billing Document Item Attribute |
| C_CustomerProjectInvoices | view | inner | CONSUMPTION | Customer Project Invoices |
| C_CustRetSubsqntCrdtMemo | view_entity | from | CONSUMPTION | Returns Order Subsequent Credit Memo |
| C_EG_StRpBillingItem | view | inner | CONSUMPTION | Egypt ACR Specific Billing Item details of tax items |
| C_RelatedBillingDocumentItem | view | from | CONSUMPTION | |
| C_RetsRefDocItemAttribute | view_entity | union_all | CONSUMPTION | Returns Document Item Attribute Search |
| C_ReturnRefDocItem_F1708 | view | union | CONSUMPTION | Return Reference Document Item |
| C_ReturnsReferenceDocumentItem | view | union_all | CONSUMPTION | Return Reference Document Item |
| C_ReturnsReferenceInvoiceItem | view_entity | from | CONSUMPTION | Customer Return Reference Invoice Item |
| C_SalesDocumentBillingStatus | view | from | CONSUMPTION | Billing Status of a Sales Document |
| C_SalesOrderAgedDebtDetails | view | inner | CONSUMPTION | Aged Debt Details for a Sales Order |
| C_SlsDocFlfmtBillgDocItem | view | from | CONSUMPTION | Sales Doc Fulfillment: Billing Doc Item |
| C_SlsDocReltdBillgDocItm | view | from | CONSUMPTION | |
| C_SlsDocReltdBillgDocItm | view | union_all | CONSUMPTION | |
| FAC_AUDIT_Z3_BILLHDRITEM | view | union_all | Billing Document Header & Item | |
| I_BillgItmPrcgElForCoTypAn | view | inner | COMPOSITE | Billing Document Item Pricing Element Analytics |
| I_BillgItmPrcgElmntsAnlyts | view | inner | COMPOSITE | Billing Document Item Pricing Element Analytics |
| I_BillingDocItmReturnableQty | view | from | COMPOSITE | Returnable Quantity of Billing |
| I_BillingDocumentItemStdVH | view | from | COMPOSITE | Billing Document Item |
| I_CFinBillingDocumentItem | view | union_all | COMPOSITE | Central Finance Billing Document: Item |
| I_DigitalVehBillingDocItem_2 | view_entity | from | COMPOSITE | Digital vehicle billing document |
| I_DigitalVehicleBillingDocItem | view_entity | from | COMPOSITE | Billing Document |
| I_IN_SubcontrgInptTxCrdt | view_entity | from | COMPOSITE | GST IN Subcontracting Input Tax Credit |
| I_MPBillingSummary | view | inner | COMPOSITE | Master Project Billing and Receivable Summary |
| I_MstrProjCreditMemoSummary | view | inner | COMPOSITE | Master Project Credit Memo Summary |
| I_PT_BillgDocMatlVers | view | inner | COMPOSITE | PT BillingDoc Material Version |
| I_PT_SAFTBillgInvcListItem | view_entity | inner | COMPOSITE | Invoice List Document Item |
| I_PT_SAFTBillgSlsInvcItem | view_entity | inner | COMPOSITE | Billing Document Item |
| I_PT_SAFTBillgWorkingDocItem | view_entity | from | COMPOSITE | Working Documents Item Collector |
| I_PT_SAFTBillingItemAmount | view_entity | from | COMPOSITE | Billing Document Items Amount |
| I_PT_SAFTSalesInvcBillingTax | view_entity | inner | COMPOSITE | Billing Document Item Tax Information |
| I_PT_SAFTSlsInvcBillgProduct | view_entity | from | COMPOSITE | Product from Billing Document |
| I_PT_SAFTTaxLikeMatInvcList | view_entity | inner | COMPOSITE | Tax Like Material Item from Invoice List |
| I_SAFTBillingItem | view | from | COMPOSITE | SAF-T Billing Item |
| I_SAFTBillingItemMax | view | from | COMPOSITE | SAF-T PT Billing Item Max |
| I_SAFTBillingProduct | view | from | COMPOSITE | SAF-T Billing Product |
| I_SAFTBillingTax | view | from | COMPOSITE | SAF-T Billing Tax |
| I_SDDocItmReturnedQuantity | view | inner | COMPOSITE | Return Quantity Union |
| I_SDDocumentProcessItemsFlowVH | view | inner | COMPOSITE | Billing Docs Items with Delivery Items |
| P_AR_BillingDocumentZeroVATRsn | view | from | CONSUMPTION | Billing Document for Argentina Export |
| P_BillingDocProcFlowCP0 | view | inner | CONSUMPTION | |
| P_BillingDocProcFlowCP1 | view | inner | CONSUMPTION | |
| P_BillingDocProcFlowM1 | view | inner | CONSUMPTION | |
| P_BillingDocProcFlowPM1 | view | inner | CONSUMPTION | |
| P_BillingDocProcFlowPM2 | view | inner | CONSUMPTION | |
| P_BillingDocumentsForProjects | view | from | COMPOSITE | |
| P_BUSSOLNORDSUBSCRPNFLWVL3 | view | inner | CONSUMPTION | Solution Order Subscription Flow: Level3 |
| P_CanclnBillingDocProcFlowM2 | view | inner | CONSUMPTION | |
| P_CanclnBillingDocProcFlowPM2 | view | inner | CONSUMPTION | |
| P_CanclnBillingDocProcFlowPM3 | view | inner | CONSUMPTION | |
| P_CN_GoldenTaxBillingDocItem | view | from | COMPOSITE | |
| P_EG_StRpBillingItem | view | inner | COMPOSITE | |
| P_EntProjBillgDocwithWBSElmnt | view_entity | inner | COMPOSITE | Billing Documnet with WBS Element |
| P_Hu_SDInvoiceCorrection | view | from | COMPOSITE | |
| P_JP_TaxReallocationBillingItm | view | from | COMPOSITE | |
| P_LstMiBillDocumentToDelivery | view | from | COMPOSITE | |
| P_MY_BillingDocumentItem | view | inner | COMPOSITE | |
| P_PL_SAFTBillingDocument | view | inner | COMPOSITE | |
| P_PL_SAFTDwnPayInvoice | view | inner | BASIC | |
| P_PL_SAFTSalesInvItem | view | inner | COMPOSITE | |
| P_PL_SAFTTaxBillingDocItem | view | from | COMPOSITE | |
| P_PT_SAFTSALESINVPLANT | view | inner | COMPOSITE | |
| P_SAFTExcludeBillingPlan | view | from | COMPOSITE | |
| P_SalesDocumentItemFulfillmnt5 | view | from | COMPOSITE | |
| P_SDDocumentTotalItems | view | union_all | CONSUMPTION | |
| P_SlsDocFlfmtProcHierarchyD23 | view | from | CONSUMPTION | |
| P_StRpBillingDocumentItem | view | inner | COMPOSITE | |
| R_BillingDocumentItemTP | view_entity | from | TRANSACTIONAL | Billing Document Item - TP |
Fields (194)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 1 |
| KEY | BillingDocument | BillingDocument,SubcontrgChallan,SubsequentDocument | 36 |
| KEY | BillingDocumentItem | BillingDocumentItem,ReferenceDocumentItem,ReferenceSDDocumentItem,ReturnsReferenceDocumentItem,SubsequentDocumentItem,TaxItemAcctgDocItemRef | 33 |
| KEY | CompanyCode | CompanyCode | 5 |
| KEY | FiscalYear | FiscalYear | 1 |
| KEY | Material | Material | 12 |
| KEY | PrelimBillingDocument | LevelCM1Document,LevelM1Document,LevelM2Document | 3 |
| KEY | PrelimBillingDocumentItem | LevelCM1DocumentItem,LevelM1DocumentItem,LevelM2DocumentItem | 3 |
| KEY | Product | Material,Product | 8 |
| KEY | ReferenceSDDocument | DebitMemoRequest,LevelM2Document,LevelM2DocumentItem,LevelM3Document,LevelM3DocumentItem,ReferenceSDDocument | 7 |
| KEY | ReferenceSDDocumentCategory | DebitMemoRequestItemCategory,LevelM2DocumentCategory,LevelM3DocumentCategory,ReferenceSDDocumentCategory | 7 |
| KEY | SalesDocument | SalesDocument,SalesOrder | 12 |
| KEY | SalesDocumentItem | SalesDocumentItem,SalesOrderItem | 8 |
| KEY | SenderLogicalSystem | SenderLogicalSystem | 1 |
| KEY | TaxCode | TaxCode | 6 |
| _AdditionalCustomerGroup1 | _AdditionalCustomerGroup1 | 1 | |
| _AdditionalCustomerGroup2 | _AdditionalCustomerGroup2 | 1 | |
| _AdditionalCustomerGroup3 | _AdditionalCustomerGroup3 | 1 | |
| _AdditionalCustomerGroup4 | _AdditionalCustomerGroup4 | 1 | |
| _AdditionalCustomerGroup5 | _AdditionalCustomerGroup5 | 1 | |
| _AdditionalMaterialGroup1 | _AdditionalMaterialGroup1 | 1 | |
| _AdditionalMaterialGroup2 | _AdditionalMaterialGroup2 | 1 | |
| _AdditionalMaterialGroup3 | _AdditionalMaterialGroup3 | 1 | |
| _AdditionalMaterialGroup4 | _AdditionalMaterialGroup4 | 1 | |
| _AdditionalMaterialGroup5 | _AdditionalMaterialGroup5 | 1 | |
| _BillingDocument | _BillingDocument | 2 | |
| _BillingDocumentCategory | _BillingDocumentCategory | 2 | |
| _BillingDocumentType | _BillingDocumentType | 2 | |
| _BillingPlanRule | _BillingPlanRule | 1 | |
| _BillingQuantityUnit | _BillingQuantityUnit | 3 | |
| _BillToPartyCountry | _BillToPartyCountry | 1 | |
| _BillToPartyRegion | _BillToPartyRegion | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _CostCenter_2 | _CostCenter_2 | 1 | |
| _DepartureCountry | _DepartureCountry | 2 | |
| _DistributionChannel | _DistributionChannel | 2 | |
| _Division | _Division | 3 | |
| _HigherLevelItem | _HigherLevelItem | 2 | |
| _Material | _Material | 3 | |
| _MaterialCommissionGroup | _MaterialCommissionGroup | 1 | |
| _MaterialPricingGroup | _MaterialPricingGroup | 1 | |
| _MatlAccountAssignmentGroup | _MatlAccountAssignmentGroup | 1 | |
| _OrganizationDivision | _OrganizationDivision | 3 | |
| _OriginallyRequestedMaterial | _OriginallyRequestedMaterial | 1 | |
| _Plant | _Plant | 1 | |
| _PlantRegion | _PlantRegion | 1 | |
| _PricingReferenceMaterial | _PricingReferenceMaterial | 1 | |
| _Product | _Product | 3 | |
| _ProductGroup | _ProductGroup | 2 | |
| _ProductHierarchyNode | _ProductHierarchyNode | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProviderContract | _ProviderContract | 1 | |
| _ProviderContractItem | _ProviderContractItem | 1 | |
| _ReferenceSDDocumentCategory | _ReferenceSDDocumentCategory | 1 | |
| _RetailPromotion | _RetailPromotion | 1 | |
| _SalesDeal | _SalesDeal | 1 | |
| _SalesDocumentItemCategory | _SalesDocumentItemCategory | 4 | |
| _SalesDocumentItemType | _SalesDocumentItemType | 2 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 3 | |
| _SalesOrderCustomerGroup | _SalesOrderCustomerGroup | 1 | |
| _SalesOrderCustomerPriceGroup | _SalesOrderCustomerPriceGroup | 1 | |
| _SalesOrderDistributionChannel | _SalesOrderDistributionChannel | 1 | |
| _SalesOrderPriceListType | _SalesOrderPriceListType | 1 | |
| _SalesOrderSalesDistrict | _SalesOrderSalesDistrict | 1 | |
| _SalesOrderSalesOrganization | _SalesOrderSalesOrganization | 1 | |
| _SalesOrganization | _SalesOrganization | 2 | |
| _SalesSDDocumentCategory | _SalesSDDocumentCategory | 1 | |
| _SDDocumentCategory | _SDDocumentCategory | 2 | |
| _SDDocumentReason | _SDDocumentReason | 3 | |
| _ServiceDocumentType | _ServiceDocumentType | 2 | |
| _StatisticalValueControl | _StatisticalValueControl | 2 | |
| _StorageLocation | _StorageLocation | 1 | |
| _TransactionCurrency | _TransactionCurrency | 2 | |
| _TransitPlant | _TransitPlant | 1 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 1 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 1 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 1 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 1 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 1 | |
| AdditionalMaterialGroup1 | AdditionalMaterialGroup1 | 1 | |
| AdditionalMaterialGroup2 | AdditionalMaterialGroup2 | 1 | |
| AdditionalMaterialGroup3 | AdditionalMaterialGroup3 | 1 | |
| AdditionalMaterialGroup4 | AdditionalMaterialGroup4 | 1 | |
| AdditionalMaterialGroup5 | AdditionalMaterialGroup5 | 1 | |
| BaseUnit | BaseUnit | 4 | |
| Batch | Batch | 3 | |
| BillingDocumentDate | BillingDocumentDate | 3 | |
| BillingDocumentItemText | BillingDocumentItemText | 14 | |
| BillingDocumentType | BillingDocumentType | 5 | |
| BillingPerformancePeriodEndDte | BillingPerformancePeriodEndDte | 1 | |
| BillingPerformancePeriodStrDte | BillingPerformancePeriodStrDte | 1 | |
| BillingPlan | BillingPlan | 1 | |
| BillingPlanRule | BillingPlanRule | 4 | |
| BillingQuantity | BillingQuantity,Quantity | 21 | |
| BillingQuantityInBaseUnit | BillingQuantityInBaseUnit,RequestedQuantityInBaseUnit | 3 | |
| BillingQuantityUnit | BillingQuantityUnit,QuantityUnit,ReturnQuantityUnit,UnitOfMeasure | 23 | |
| BillingToBaseQuantityDnmntr | BillingToBaseQuantityDnmntr | 1 | |
| BillingToBaseQuantityNmrtr | BillingToBaseQuantityNmrtr | 1 | |
| BillToPartyCountry | BillToPartyCountry | 1 | |
| BillToPartyRegion | BillToPartyRegion | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessSolutionOrder | BusinessSolutionOrder | 1 | |
| BusinessSolutionOrderItem | BusinessSolutionOrderItem | 1 | |
| ConditionBaseValue | ConditionBaseValue | 1 | |
| ControllingArea | ControllingArea | 2 | |
| CostCenter | CostCenter | 2 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate,InvoiceDate | 5 | |
| DepartureCountry | DepartureCountry | 2 | |
| DistributionChannel | DistributionChannel | 3 | |
| Division | Division | 3 | |
| EligibleAmountForCashDiscount | EligibleAmountForCashDiscount | 1 | |
| GrossAmount | GrossAmount,ItemGrossAmountOfBillingDoc | 8 | |
| HigherLevelItem | HigherLevelItem | 4 | |
| InternationalArticleNumber | InternationalArticleNumber | 1 | |
| ItemGrossWeight | ItemGrossWeight | 1 | |
| ItemNetWeight | ItemNetWeight | 1 | |
| ItemVolume | ItemVolume | 1 | |
| ItemVolumeUnit | ItemVolumeUnit | 1 | |
| ItemWeightUnit | ItemWeightUnit | 1 | |
| ManualPriceChangeType | ManualPriceChangeType | 1 | |
| MaterialCommissionGroup | MaterialCommissionGroup | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MaterialPricingGroup | MaterialPricingGroup | 1 | |
| MaterialType | MaterialType | 1 | |
| MatlAccountAssignmentGroup | MatlAccountAssignmentGroup | 1 | |
| NetAmount | ItemNetAmount,ItemNetAmountOfBillingDoc,NetAmount | 18 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 2 | |
| OriginallyRequestedMaterial | OriginallyRequestedMaterial | 1 | |
| Plant | Plant | 1 | |
| PlantCity | PlantCity | 1 | |
| PlantCounty | PlantCounty | 1 | |
| PlantRegion | PlantRegion | 1 | |
| PriceDetnExchangeRate | ExchangeRate | 1 | |
| PriceDetnExchangeRateDate | ExchangeRateDate | 2 | |
| PricingDate | ExchangeRateDate,PricingDate | 3 | |
| PricingReferenceMaterial | PricingReferenceMaterial | 1 | |
| ProductConfiguration | ProductConfiguration | 1 | |
| ProductGroup | ProductGroup | 2 | |
| ProductHierarchyNode | ProductHierarchyNode | 1 | |
| ProductTaxClassification1 | ProductTaxClassification1 | 2 | |
| ProductTaxClassification2 | ProductTaxClassification2 | 2 | |
| ProductTaxClassification3 | ProductTaxClassification3 | 2 | |
| ProductTaxClassification4 | ProductTaxClassification4 | 2 | |
| ProductTaxClassification5 | ProductTaxClassification5 | 2 | |
| ProductTaxClassification6 | ProductTaxClassification6 | 2 | |
| ProductTaxClassification7 | ProductTaxClassification7 | 2 | |
| ProductTaxClassification8 | ProductTaxClassification8 | 2 | |
| ProductTaxClassification9 | ProductTaxClassification9 | 2 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProviderContract | ProviderContract | 1 | |
| ProviderContractItem | ProviderContractItem | 1 | |
| ReferenceSDDocumentItem | DebitMemoRequestItem,ReferenceSDDocumentItem | 5 | |
| RetailPromotion | RetailPromotion | 1 | |
| ReturnItemProcessingType | ReturnItemProcessingType | 1 | |
| SalesDeal | SalesDeal | 1 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 2 | |
| SalesDocumentItemType | SalesDocumentItemType | 1 | |
| SalesGroup | SalesGroup | 1 | |
| SalesOffice | SalesOffice | 3 | |
| SalesOrderCustomerGroup | SalesOrderCustomerGroup | 1 | |
| SalesOrderCustomerPriceGroup | SalesOrderCustomerPriceGroup | 1 | |
| SalesOrderDistributionChannel | SalesOrderDistributionChannel | 1 | |
| SalesOrderPriceListType | SalesOrderPriceListType | 1 | |
| SalesOrderSalesDistrict | SalesOrderSalesDistrict | 1 | |
| SalesOrderSalesOrganization | SalesOrderSalesOrganization | 1 | |
| SalesOrganization | SalesOrganization | 8 | |
| SalesPromotion | SalesPromotion | 1 | |
| SalesSDDocumentCategory | SalesSDDocumentCategory | 2 | |
| SDDocumentCategory | SDDocumentCategory | 5 | |
| SDDocumentReason | SDDocumentReason | 4 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 2 | |
| ShippingPoint | ShippingPoint | 2 | |
| StatisticalValueControl | StatisticalValueControl | 2 | |
| StorageLocation | StorageLocation | 1 | |
| Subtotal1Amount | Subtotal1Amount | 1 | |
| Subtotal2Amount | Subtotal2Amount | 1 | |
| Subtotal3Amount | Subtotal3Amount | 1 | |
| Subtotal4Amount | Subtotal4Amount | 1 | |
| Subtotal5Amount | Subtotal5Amount | 1 | |
| Subtotal6Amount | Subtotal6Amount | 1 | |
| TaxAmount | BillDocItemTaxAmt,TaxAmount | 9 | |
| TaxJurisdiction | TaxJurisdiction | 2 | |
| TaxRateValidityStartDate | TaxRateValidityStartDate | 1 | |
| TransactionCurrency | Currency,DocumentCurrency,TransactionCurrency | 20 | |
| TransitPlant | TransitPlant | 1 | |
| VolumeRebateGroup | VolumeRebateGroup | 1 | |
| ZeroVATRsn | ZeroVATRsn | 2 |
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.
-- Billing Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCUMENTITEM (
ACCOUNTINGDOCUMENT,
BILLINGDOCUMENT,
BILLINGDOCUMENTITEM,
COMPANYCODE,
FISCALYEAR,
MATERIAL,
PRELIMBILLINGDOCUMENT,
PRELIMBILLINGDOCUMENTITEM,
PRODUCT,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SENDERLOGICALSYSTEM,
TAXCODE,
_ADDITIONALCUSTOMERGROUP1,
_ADDITIONALCUSTOMERGROUP2,
_ADDITIONALCUSTOMERGROUP3,
_ADDITIONALCUSTOMERGROUP4,
_ADDITIONALCUSTOMERGROUP5,
_ADDITIONALMATERIALGROUP1,
_ADDITIONALMATERIALGROUP2,
_ADDITIONALMATERIALGROUP3,
_ADDITIONALMATERIALGROUP4,
_ADDITIONALMATERIALGROUP5,
_BILLINGDOCUMENT,
_BILLINGDOCUMENTCATEGORY,
_BILLINGDOCUMENTTYPE,
_BILLINGPLANRULE,
_BILLINGQUANTITYUNIT,
_BILLTOPARTYCOUNTRY,
_BILLTOPARTYREGION,
_CONTROLLINGAREA,
_COSTCENTER,
_COSTCENTER_2,
_DEPARTURECOUNTRY,
_DISTRIBUTIONCHANNEL,
_DIVISION,
_HIGHERLEVELITEM,
_MATERIAL,
_MATERIALCOMMISSIONGROUP,
_MATERIALPRICINGGROUP,
_MATLACCOUNTASSIGNMENTGROUP,
_ORGANIZATIONDIVISION,
_ORIGINALLYREQUESTEDMATERIAL,
_PLANT,
_PLANTREGION,
_PRICINGREFERENCEMATERIAL,
_PRODUCT,
_PRODUCTGROUP,
_PRODUCTHIERARCHYNODE,
_PROFITCENTER,
_PROVIDERCONTRACT,
_PROVIDERCONTRACTITEM,
_REFERENCESDDOCUMENTCATEGORY,
_RETAILPROMOTION,
_SALESDEAL,
_SALESDOCUMENTITEMCATEGORY,
_SALESDOCUMENTITEMTYPE,
_SALESGROUP,
_SALESOFFICE,
_SALESORDERCUSTOMERGROUP,
_SALESORDERCUSTOMERPRICEGROUP,
_SALESORDERDISTRIBUTIONCHANNEL,
_SALESORDERPRICELISTTYPE,
_SALESORDERSALESDISTRICT,
_SALESORDERSALESORGANIZATION,
_SALESORGANIZATION,
_SALESSDDOCUMENTCATEGORY,
_SDDOCUMENTCATEGORY,
_SDDOCUMENTREASON,
_SERVICEDOCUMENTTYPE,
_STATISTICALVALUECONTROL,
_STORAGELOCATION,
_TRANSACTIONCURRENCY,
_TRANSITPLANT,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALMATERIALGROUP1,
ADDITIONALMATERIALGROUP2,
ADDITIONALMATERIALGROUP3,
ADDITIONALMATERIALGROUP4,
ADDITIONALMATERIALGROUP5,
BASEUNIT,
BATCH,
BILLINGDOCUMENTDATE,
BILLINGDOCUMENTITEMTEXT,
BILLINGDOCUMENTTYPE,
BILLINGPERFORMANCEPERIODENDDTE,
BILLINGPERFORMANCEPERIODSTRDTE,
BILLINGPLAN,
BILLINGPLANRULE,
BILLINGQUANTITY,
BILLINGQUANTITYINBASEUNIT,
BILLINGQUANTITYUNIT,
BILLINGTOBASEQUANTITYDNMNTR,
BILLINGTOBASEQUANTITYNMRTR,
BILLTOPARTYCOUNTRY,
BILLTOPARTYREGION,
BUSINESSAREA,
BUSINESSSOLUTIONORDER,
BUSINESSSOLUTIONORDERITEM,
CONDITIONBASEVALUE,
CONTROLLINGAREA,
COSTCENTER,
CREATEDBYUSER,
CREATIONDATE,
DEPARTURECOUNTRY,
DISTRIBUTIONCHANNEL,
DIVISION,
ELIGIBLEAMOUNTFORCASHDISCOUNT,
GROSSAMOUNT,
HIGHERLEVELITEM,
INTERNATIONALARTICLENUMBER,
ITEMGROSSWEIGHT,
ITEMNETWEIGHT,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
MANUALPRICECHANGETYPE,
MATERIALCOMMISSIONGROUP,
MATERIALGROUP,
MATERIALPRICINGGROUP,
MATERIALTYPE,
MATLACCOUNTASSIGNMENTGROUP,
NETAMOUNT,
ORDERID,
ORGANIZATIONDIVISION,
ORIGINALLYREQUESTEDMATERIAL,
PLANT,
PLANTCITY,
PLANTCOUNTY,
PLANTREGION,
PRICEDETNEXCHANGERATE,
PRICEDETNEXCHANGERATEDATE,
PRICINGDATE,
PRICINGREFERENCEMATERIAL,
PRODUCTCONFIGURATION,
PRODUCTGROUP,
PRODUCTHIERARCHYNODE,
PRODUCTTAXCLASSIFICATION1,
PRODUCTTAXCLASSIFICATION2,
PRODUCTTAXCLASSIFICATION3,
PRODUCTTAXCLASSIFICATION4,
PRODUCTTAXCLASSIFICATION5,
PRODUCTTAXCLASSIFICATION6,
PRODUCTTAXCLASSIFICATION7,
PRODUCTTAXCLASSIFICATION8,
PRODUCTTAXCLASSIFICATION9,
PROFITCENTER,
PROVIDERCONTRACT,
PROVIDERCONTRACTITEM,
REFERENCESDDOCUMENTITEM,
RETAILPROMOTION,
RETURNITEMPROCESSINGTYPE,
SALESDEAL,
SALESDOCUMENTITEMCATEGORY,
SALESDOCUMENTITEMTYPE,
SALESGROUP,
SALESOFFICE,
SALESORDERCUSTOMERGROUP,
SALESORDERCUSTOMERPRICEGROUP,
SALESORDERDISTRIBUTIONCHANNEL,
SALESORDERPRICELISTTYPE,
SALESORDERSALESDISTRICT,
SALESORDERSALESORGANIZATION,
SALESORGANIZATION,
SALESPROMOTION,
SALESSDDOCUMENTCATEGORY,
SDDOCUMENTCATEGORY,
SDDOCUMENTREASON,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SERVICESRENDEREDDATE,
SHIPPINGPOINT,
STATISTICALVALUECONTROL,
STORAGELOCATION,
SUBTOTAL1AMOUNT,
SUBTOTAL2AMOUNT,
SUBTOTAL3AMOUNT,
SUBTOTAL4AMOUNT,
SUBTOTAL5AMOUNT,
SUBTOTAL6AMOUNT,
TAXAMOUNT,
TAXJURISDICTION,
TAXRATEVALIDITYSTARTDATE,
TRANSACTIONCURRENCY,
TRANSITPLANT,
VOLUMEREBATEGROUP,
ZEROVATRSN,
PRIMARY KEY (ACCOUNTINGDOCUMENT, BILLINGDOCUMENT, BILLINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, MATERIAL, PRELIMBILLINGDOCUMENT, PRELIMBILLINGDOCUMENTITEM, PRODUCT, REFERENCESDDOCUMENT, REFERENCESDDOCUMENTCATEGORY, SALESDOCUMENT, SALESDOCUMENTITEM, SENDERLOGICALSYSTEM, TAXCODE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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