I_BILLINGDOCUMENTITEM

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);