BILLINGDOCUMENTITEM
BILLINGDOCUMENTITEM is an SAP database table in S/4HANA. It contains 153 fields.
Fields (153)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocument | BillingDocument | 3 |
| KEY | BillingDocumentItem | BillingDocumentItem | 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 | 1 | |
| Batch | Batch | 1 | |
| BillingDocExtReferenceDocItem | BillingDocExtReferenceDocItem | 1 | |
| BillingDocumentItemInPartSgmt | BillingDocumentItemInPartSgmt | 1 | |
| BillingDocumentItemText | BillingDocumentItemText | 1 | |
| BillingDocumentType | BillingDocumentType | 1 | |
| BillingPerformancePeriodEndDte | BillingPerformancePeriodEndDte | 1 | |
| BillingPerformancePeriodStrDte | BillingPerformancePeriodStrDte | 1 | |
| BillingPlan | BillingPlan | 1 | |
| BillingPlanItem | BillingPlanItem | 1 | |
| BillingPlanRule | BillingPlanRule | 1 | |
| BillingQuantity | BillingQuantity | 1 | |
| BillingQuantityInBaseUnit | BillingQuantityInBaseUnit | 1 | |
| BillingQuantityUnit | BillingQuantityUnit | 1 | |
| BillingToBaseQuantityDnmntr | BillingToBaseQuantityDnmntr | 1 | |
| BillingToBaseQuantityNmrtr | BillingToBaseQuantityNmrtr | 1 | |
| BillToPartyCountry | BillToPartyCountry | 1 | |
| BillToPartyRegion | BillToPartyRegion | 1 | |
| BOMExplosion | BOMExplosion | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessSolutionOrder | BusinessSolutionOrder | 1 | |
| BusinessSolutionOrderItem | BusinessSolutionOrderItem | 1 | |
| CashDiscountIsDeductible | CashDiscountIsDeductible | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostAmount | CostAmount | 1 | |
| CostCenter | CostCenter | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 1 | |
| CreditRelatedPrice | CreditRelatedPrice | 1 | |
| CustomerConditionGroup1 | CustomerConditionGroup1 | 1 | |
| CustomerConditionGroup2 | CustomerConditionGroup2 | 1 | |
| CustomerConditionGroup3 | CustomerConditionGroup3 | 1 | |
| CustomerConditionGroup4 | CustomerConditionGroup4 | 1 | |
| CustomerConditionGroup5 | CustomerConditionGroup5 | 1 | |
| DepartureCountry | DepartureCountry | 1 | |
| Division | Division | 1 | |
| EligibleAmountForCashDiscount | EligibleAmountForCashDiscount | 1 | |
| ExternalReferenceDocument | ExternalReferenceDocument | 1 | |
| GrossAmount | GrossAmount | 1 | |
| HigherLevelItem | HigherLevelItem | 1 | |
| HigherLevelItemUsage | HigherLevelItemUsage | 1 | |
| InternationalArticleNumber | InternationalArticleNumber | 1 | |
| ItemGrossWeight | ItemGrossWeight | 1 | |
| ItemIsRelevantForCredit | ItemIsRelevantForCredit | 1 | |
| ItemNetWeight | ItemNetWeight | 1 | |
| ItemVolume | ItemVolume | 1 | |
| ItemVolumeUnit | ItemVolumeUnit | 1 | |
| ItemWeightUnit | ItemWeightUnit | 1 | |
| MainItemMaterialPricingGroup | MainItemMaterialPricingGroup | 1 | |
| MainItemPricingRefMaterial | MainItemPricingRefMaterial | 1 | |
| ManualPriceChangeType | ManualPriceChangeType | 1 | |
| MaterialCommissionGroup | MaterialCommissionGroup | 1 | |
| MaterialDeterminationType | MaterialDeterminationType | 1 | |
| MaterialGroupHierarchy1 | MaterialGroupHierarchy1 | 1 | |
| MaterialGroupHierarchy2 | MaterialGroupHierarchy2 | 1 | |
| MaterialPricingGroup | MaterialPricingGroup | 1 | |
| MatlAccountAssignmentGroup | MatlAccountAssignmentGroup | 1 | |
| MRPRequiredQuantityInBaseUnit | MRPRequiredQuantityInBaseUnit | 1 | |
| NetAmount | NetAmount | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| OriginallyRequestedMaterial | OriginallyRequestedMaterial | 1 | |
| OriginSDDocument | OriginSDDocument | 1 | |
| OriginSDDocumentItem | OriginSDDocumentItem | 1 | |
| Plant | Plant | 1 | |
| PlantCity | PlantCity | 1 | |
| PlantCounty | PlantCounty | 1 | |
| PlantRegion | PlantRegion | 1 | |
| PrelimBillingDocument | PrelimBillingDocument | 1 | |
| PrelimBillingDocumentItem | PrelimBillingDocumentItem | 1 | |
| PriceDetnExchangeRate | PriceDetnExchangeRate | 1 | |
| PriceDetnExchangeRateDate | PriceDetnExchangeRateDate | 1 | |
| PricingDate | PricingDate | 1 | |
| PricingReferenceMaterial | PricingReferenceMaterial | 1 | |
| PricingScaleQuantityInBaseUnit | PricingScaleQuantityInBaseUnit | 1 | |
| Product | Product | 1 | |
| ProductConfiguration | ProductConfiguration | 1 | |
| ProductGroup | ProductGroup | 1 | |
| ProductHierarchyNode | ProductHierarchyNode | 1 | |
| ProductTaxClassification1 | ProductTaxClassification1 | 1 | |
| ProductTaxClassification2 | ProductTaxClassification2 | 1 | |
| ProductTaxClassification3 | ProductTaxClassification3 | 1 | |
| ProductTaxClassification4 | ProductTaxClassification4 | 1 | |
| ProductTaxClassification5 | ProductTaxClassification5 | 1 | |
| ProductTaxClassification6 | ProductTaxClassification6 | 1 | |
| ProductTaxClassification7 | ProductTaxClassification7 | 1 | |
| ProductTaxClassification8 | ProductTaxClassification8 | 1 | |
| ProductTaxClassification9 | ProductTaxClassification9 | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProviderContract | ProviderContract | 1 | |
| ProviderContractItem | ProviderContractItem | 1 | |
| RebateBasisAmount | RebateBasisAmount | 1 | |
| ReferenceLogicalSystem | ReferenceLogicalSystem | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 1 | |
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | 1 | |
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | 1 | |
| ReplacementPartType | ReplacementPartType | 1 | |
| RetailPromotion | RetailPromotion | 1 | |
| ReturnItemProcessingType | ReturnItemProcessingType | 1 | |
| SalesDeal | SalesDeal | 1 | |
| SalesDocIsCreatedFromReference | SalesDocIsCreatedFromReference | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 1 | |
| SalesDocumentItemType | SalesDocumentItemType | 1 | |
| SalesGroup | SalesGroup | 1 | |
| SalesOffice | SalesOffice | 1 | |
| SalesOrderCustomerGroup | SalesOrderCustomerGroup | 1 | |
| SalesOrderCustomerPriceGroup | SalesOrderCustomerPriceGroup | 1 | |
| SalesOrderDistributionChannel | SalesOrderDistributionChannel | 1 | |
| SalesOrderPriceListType | SalesOrderPriceListType | 1 | |
| SalesOrderSalesDistrict | SalesOrderSalesDistrict | 1 | |
| SalesOrderSalesOrganization | SalesOrderSalesOrganization | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| SalesPromotion | SalesPromotion | 1 | |
| SalesSDDocumentCategory | SalesSDDocumentCategory | 1 | |
| SDDocumentReason | SDDocumentReason | 1 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShippingPoint | ShippingPoint | 1 | |
| StatisticalValueControl | StatisticalValueControl | 1 | |
| StatisticsExchangeRate | StatisticsExchangeRate | 1 | |
| StorageLocation | StorageLocation | 1 | |
| Subtotal1Amount | Subtotal1Amount | 1 | |
| Subtotal2Amount | Subtotal2Amount | 1 | |
| Subtotal3Amount | Subtotal3Amount | 1 | |
| Subtotal4Amount | Subtotal4Amount | 1 | |
| Subtotal5Amount | Subtotal5Amount | 1 | |
| Subtotal6Amount | Subtotal6Amount | 1 | |
| TaxAmount | TaxAmount | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TaxRateValidityStartDate | TaxRateValidityStartDate | 1 | |
| TimeSheetOvertimeCategory | TimeSheetOvertimeCategory | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| VolumeRebateGroup | VolumeRebateGroup | 1 | |
| WBSElementInternalID | WBSElementInternalID | 1 | |
| ZeroVATRsn | ZeroVATRsn | 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 BILLINGDOCUMENTITEM (
BILLINGDOCUMENT,
BILLINGDOCUMENTITEM,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALMATERIALGROUP1,
ADDITIONALMATERIALGROUP2,
ADDITIONALMATERIALGROUP3,
ADDITIONALMATERIALGROUP4,
ADDITIONALMATERIALGROUP5,
BASEUNIT,
BATCH,
BILLINGDOCEXTREFERENCEDOCITEM,
BILLINGDOCUMENTITEMINPARTSGMT,
BILLINGDOCUMENTITEMTEXT,
BILLINGDOCUMENTTYPE,
BILLINGPERFORMANCEPERIODENDDTE,
BILLINGPERFORMANCEPERIODSTRDTE,
BILLINGPLAN,
BILLINGPLANITEM,
BILLINGPLANRULE,
BILLINGQUANTITY,
BILLINGQUANTITYINBASEUNIT,
BILLINGQUANTITYUNIT,
BILLINGTOBASEQUANTITYDNMNTR,
BILLINGTOBASEQUANTITYNMRTR,
BILLTOPARTYCOUNTRY,
BILLTOPARTYREGION,
BOMEXPLOSION,
BUSINESSAREA,
BUSINESSSOLUTIONORDER,
BUSINESSSOLUTIONORDERITEM,
CASHDISCOUNTISDEDUCTIBLE,
CONTROLLINGAREA,
COSTAMOUNT,
COSTCENTER,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CREDITRELATEDPRICE,
CUSTOMERCONDITIONGROUP1,
CUSTOMERCONDITIONGROUP2,
CUSTOMERCONDITIONGROUP3,
CUSTOMERCONDITIONGROUP4,
CUSTOMERCONDITIONGROUP5,
DEPARTURECOUNTRY,
DIVISION,
ELIGIBLEAMOUNTFORCASHDISCOUNT,
EXTERNALREFERENCEDOCUMENT,
GROSSAMOUNT,
HIGHERLEVELITEM,
HIGHERLEVELITEMUSAGE,
INTERNATIONALARTICLENUMBER,
ITEMGROSSWEIGHT,
ITEMISRELEVANTFORCREDIT,
ITEMNETWEIGHT,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
MAINITEMMATERIALPRICINGGROUP,
MAINITEMPRICINGREFMATERIAL,
MANUALPRICECHANGETYPE,
MATERIALCOMMISSIONGROUP,
MATERIALDETERMINATIONTYPE,
MATERIALGROUPHIERARCHY1,
MATERIALGROUPHIERARCHY2,
MATERIALPRICINGGROUP,
MATLACCOUNTASSIGNMENTGROUP,
MRPREQUIREDQUANTITYINBASEUNIT,
NETAMOUNT,
ORDERID,
ORGANIZATIONDIVISION,
ORIGINALLYREQUESTEDMATERIAL,
ORIGINSDDOCUMENT,
ORIGINSDDOCUMENTITEM,
PLANT,
PLANTCITY,
PLANTCOUNTY,
PLANTREGION,
PRELIMBILLINGDOCUMENT,
PRELIMBILLINGDOCUMENTITEM,
PRICEDETNEXCHANGERATE,
PRICEDETNEXCHANGERATEDATE,
PRICINGDATE,
PRICINGREFERENCEMATERIAL,
PRICINGSCALEQUANTITYINBASEUNIT,
PRODUCT,
PRODUCTCONFIGURATION,
PRODUCTGROUP,
PRODUCTHIERARCHYNODE,
PRODUCTTAXCLASSIFICATION1,
PRODUCTTAXCLASSIFICATION2,
PRODUCTTAXCLASSIFICATION3,
PRODUCTTAXCLASSIFICATION4,
PRODUCTTAXCLASSIFICATION5,
PRODUCTTAXCLASSIFICATION6,
PRODUCTTAXCLASSIFICATION7,
PRODUCTTAXCLASSIFICATION8,
PRODUCTTAXCLASSIFICATION9,
PROFITCENTER,
PROVIDERCONTRACT,
PROVIDERCONTRACTITEM,
REBATEBASISAMOUNT,
REFERENCELOGICALSYSTEM,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
REFERENCESDDOCUMENTITEM,
REPLACEMENTPARTTYPE,
RETAILPROMOTION,
RETURNITEMPROCESSINGTYPE,
SALESDEAL,
SALESDOCISCREATEDFROMREFERENCE,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESDOCUMENTITEMCATEGORY,
SALESDOCUMENTITEMTYPE,
SALESGROUP,
SALESOFFICE,
SALESORDERCUSTOMERGROUP,
SALESORDERCUSTOMERPRICEGROUP,
SALESORDERDISTRIBUTIONCHANNEL,
SALESORDERPRICELISTTYPE,
SALESORDERSALESDISTRICT,
SALESORDERSALESORGANIZATION,
SALESORGANIZATION,
SALESPROMOTION,
SALESSDDOCUMENTCATEGORY,
SDDOCUMENTREASON,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SERVICESRENDEREDDATE,
SHIPPINGPOINT,
STATISTICALVALUECONTROL,
STATISTICSEXCHANGERATE,
STORAGELOCATION,
SUBTOTAL1AMOUNT,
SUBTOTAL2AMOUNT,
SUBTOTAL3AMOUNT,
SUBTOTAL4AMOUNT,
SUBTOTAL5AMOUNT,
SUBTOTAL6AMOUNT,
TAXAMOUNT,
TAXCODE,
TAXJURISDICTION,
TAXRATEVALIDITYSTARTDATE,
TIMESHEETOVERTIMECATEGORY,
TRANSACTIONCURRENCY,
VOLUMEREBATEGROUP,
WBSELEMENTINTERNALID,
ZEROVATRSN,
PRIMARY KEY (BILLINGDOCUMENT, BILLINGDOCUMENTITEM)
);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