I_BILLINGDOCEXTDITEM
Billing Document Item Extended
I_BILLINGDOCEXTDITEM is a CDS View in S/4HANA. Billing Document Item Extended. It contains 166 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BillingDocItemAnalytics | view | from | COMPOSITE | Billing Document Item Analytics |
| P_BillgDocBySlsVolProfitMargin | view | from | CONSUMPTION | Sales Volume / Profit Margin |
| P_BillgDocSlsVolumeBySalesArea | view | from | CONSUMPTION | Sales Volume / Sales Area |
Fields (166)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocument | BillingDocument | 1 |
| _AdditionalCustomerGroup1 | _AdditionalCustomerGroup1 | 1 | |
| _AdditionalCustomerGroup2 | _AdditionalCustomerGroup2 | 1 | |
| _AdditionalCustomerGroup3 | _AdditionalCustomerGroup3 | 1 | |
| _AdditionalCustomerGroup4 | _AdditionalCustomerGroup4 | 1 | |
| _AdditionalCustomerGroup5 | _AdditionalCustomerGroup5 | 1 | |
| _AdditionalMaterialGroup2 | _AdditionalMaterialGroup2 | 1 | |
| _AdditionalMaterialGroup3 | _AdditionalMaterialGroup3 | 1 | |
| _AdditionalMaterialGroup4 | _AdditionalMaterialGroup4 | 1 | |
| _AdditionalMaterialGroup5 | _AdditionalMaterialGroup5 | 1 | |
| _BaseUnit | _BaseUnit | 1 | |
| _Batch | _Batch | 1 | |
| _BillingDocumentCategory | _BillingDocumentCategory | 1 | |
| _BillingDocumentType | _BillingDocumentType | 1 | |
| _BillingPlanRule | _BillingPlanRule | 1 | |
| _BillingQuantityUnit | _BillingQuantityUnit | 1 | |
| _BillToParty | _BillToParty | 1 | |
| _BillToPartyCountry | _BillToPartyCountry | 1 | |
| _BillToPartyRegion | _BillToPartyRegion | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessAreaText | _BusinessAreaText | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _CreatedByUser | _CreatedByUser | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerPriceGroup | _CustomerPriceGroup | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _Division | _Division | 1 | |
| _HigherLevelItem | _HigherLevelItem | 1 | |
| _ItemVolumeUnit | _ItemVolumeUnit | 1 | |
| _ItemWeightUnit | _ItemWeightUnit | 1 | |
| _MainItemPricingRefMaterial | _MainItemPricingRefMaterial | 1 | |
| _Material | _Material | 1 | |
| _MaterialCommissionGroup | _MaterialCommissionGroup | 1 | |
| _MaterialGroup | _MaterialGroup | 1 | |
| _MaterialGroupText | _MaterialGroupText | 1 | |
| _MaterialText | _MaterialText | 1 | |
| _OrganizationDivision | _OrganizationDivision | 1 | |
| _OriginallyRequestedMaterial | _OriginallyRequestedMaterial | 1 | |
| _OriginallyRequestedMatlText | _OriginallyRequestedMatlText | 1 | |
| _OverallBillingStatus | _OverallBillingStatus | 1 | |
| _OverallSDProcessStatus | _OverallSDProcessStatus | 1 | |
| _PayerParty | _PayerParty | 1 | |
| _Plant | _Plant | 1 | |
| _PricingReferenceMaterial | _PricingReferenceMaterial | 1 | |
| _PricingReferenceMaterialText | _PricingReferenceMaterialText | 1 | |
| _Product | _Product | 1 | |
| _ProductGroup | _ProductGroup | 1 | |
| _ProductHierarchyNode | _ProductHierarchyNode | 1 | |
| _ProductText | _ProductText | 1 | |
| _ReferenceLogicalSystem | _LogicalSystem | 1 | |
| _ReferenceSDDocumentCategory | _ReferenceSDDocumentCategory | 1 | |
| _ResponsibleEmployee_2 | _ResponsibleEmployee_2 | 1 | |
| _SalesDeal | _SalesDeal | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesDocumentItem | _SalesDocumentItem | 1 | |
| _SalesDocumentItemCategory | _SalesDocumentItemCategory | 1 | |
| _SalesDocumentItemType | _SalesDocumentItemType | 1 | |
| _SalesEmployee_2 | _SalesEmployee_2 | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _SalesSDDocumentCategory | _SalesSDDocumentCategory | 1 | |
| _SDDocumentCategory | _SDDocumentCategory | 1 | |
| _SDDocumentReason | _SDDocumentReason | 1 | |
| _ShippingPoint | _ShippingPoint | 1 | |
| _ShippingPointText | _ShippingPointText | 1 | |
| _ShipToParty | _ShipToParty | 1 | |
| _SoldToParty | _SoldToParty | 1 | |
| _SolutionOrder | _SolutionOrder | 1 | |
| _SolutionOrderItem | _SolutionOrderItem | 1 | |
| _StatisticalValueControl | _StatisticalValueControl | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| _WBSElement | _WBSElement | 1 | |
| _WBSElementBasicData | _WBSElementBasicData | 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 | |
| BillingDocumentCategory | BillingDocumentCategory | 1 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| BillingDocumentItemInPartSgmt | BillingDocumentItemInPartSgmt | 1 | |
| BillingDocumentType | BillingDocumentType | 1 | |
| BillingPlan | BillingPlan | 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 | |
| BusinessArea | BusinessArea | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostAmount | CostAmount | 1 | |
| CostCenter | CostCenter | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerPriceGroup | CustomerPriceGroup | 1 | |
| DistributionChannel | DistributionChannel | 2 | |
| Division | Division | 1 | |
| EligibleAmountForCashDiscount | EligibleAmountForCashDiscount | 1 | |
| GrossAmount | ItemGrossAmountOfBillingDoc | 1 | |
| HigherLevelItem | HigherLevelItem | 1 | |
| InternationalArticleNumber | InternationalArticleNumber | 1 | |
| ItemGrossWeight | ItemGrossWeight | 1 | |
| ItemNetWeight | ItemNetWeight | 1 | |
| ItemVolume | ItemVolume | 1 | |
| ItemVolumeUnit | ItemVolumeUnit | 1 | |
| ItemWeightUnit | ItemWeightUnit | 1 | |
| Material | Material | 1 | |
| MaterialCommissionGroup | MaterialCommissionGroup | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MRPRequiredQuantityInBaseUnit | MRPRequiredQuantityInBaseUnit | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| OriginallyRequestedMaterial | OriginallyRequestedMaterial | 1 | |
| OriginSDDocument | OriginSDDocument | 1 | |
| PayerParty | PayerParty | 1 | |
| Plant | Plant | 1 | |
| PriceDetnExchangeRate | PriceDetnExchangeRate | 1 | |
| PriceDetnExchangeRateDate | ExchangeRateDate | 1 | |
| PricingDate | PricingDate | 1 | |
| PricingReferenceMaterial | PricingReferenceMaterial | 1 | |
| PricingScaleQuantityInBaseUnit | PricingScaleQuantityInBaseUnit | 1 | |
| ProductGroup | ProductGroup | 1 | |
| ProductHierarchyNode | ProductHierarchyNode | 1 | |
| ProfitabilitySegment_2 | ProfitabilitySegment,ProfitabilitySegment_2 | 1 | |
| ReferenceLogicalSystem | LogicalSystem | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 1 | |
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | 1 | |
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | 1 | |
| SalesDeal | SalesDeal | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesGroup | SalesGroup | 1 | |
| SalesOffice | SalesOffice | 1 | |
| SalesOrganization | SalesOrganization | 2 | |
| SDDocumentCategory | SDDocumentCategory | 1 | |
| SDDocumentReason | SDDocumentReason | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShippingPoint | ShippingPoint | 1 | |
| SoldToParty | SoldToParty | 1 | |
| StatisticalValueControl | StatisticalValueControl | 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 | |
| VolumeRebateGroup | VolumeRebateGroup | 1 | |
| WBSElementInternalID | WBSElementInternalID | 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.
-- Billing Document Item Extended
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCEXTDITEM (
BILLINGDOCUMENT,
_ADDITIONALCUSTOMERGROUP1,
_ADDITIONALCUSTOMERGROUP2,
_ADDITIONALCUSTOMERGROUP3,
_ADDITIONALCUSTOMERGROUP4,
_ADDITIONALCUSTOMERGROUP5,
_ADDITIONALMATERIALGROUP2,
_ADDITIONALMATERIALGROUP3,
_ADDITIONALMATERIALGROUP4,
_ADDITIONALMATERIALGROUP5,
_BASEUNIT,
_BATCH,
_BILLINGDOCUMENTCATEGORY,
_BILLINGDOCUMENTTYPE,
_BILLINGPLANRULE,
_BILLINGQUANTITYUNIT,
_BILLTOPARTY,
_BILLTOPARTYCOUNTRY,
_BILLTOPARTYREGION,
_BUSINESSAREA,
_BUSINESSAREATEXT,
_CONTROLLINGAREA,
_COSTCENTER,
_CREATEDBYUSER,
_CUSTOMERGROUP,
_CUSTOMERPRICEGROUP,
_DISTRIBUTIONCHANNEL,
_DIVISION,
_HIGHERLEVELITEM,
_ITEMVOLUMEUNIT,
_ITEMWEIGHTUNIT,
_MAINITEMPRICINGREFMATERIAL,
_MATERIAL,
_MATERIALCOMMISSIONGROUP,
_MATERIALGROUP,
_MATERIALGROUPTEXT,
_MATERIALTEXT,
_ORGANIZATIONDIVISION,
_ORIGINALLYREQUESTEDMATERIAL,
_ORIGINALLYREQUESTEDMATLTEXT,
_OVERALLBILLINGSTATUS,
_OVERALLSDPROCESSSTATUS,
_PAYERPARTY,
_PLANT,
_PRICINGREFERENCEMATERIAL,
_PRICINGREFERENCEMATERIALTEXT,
_PRODUCT,
_PRODUCTGROUP,
_PRODUCTHIERARCHYNODE,
_PRODUCTTEXT,
_REFERENCELOGICALSYSTEM,
_REFERENCESDDOCUMENTCATEGORY,
_RESPONSIBLEEMPLOYEE_2,
_SALESDEAL,
_SALESDISTRICT,
_SALESDOCUMENT,
_SALESDOCUMENTITEM,
_SALESDOCUMENTITEMCATEGORY,
_SALESDOCUMENTITEMTYPE,
_SALESEMPLOYEE_2,
_SALESGROUP,
_SALESOFFICE,
_SALESORGANIZATION,
_SALESSDDOCUMENTCATEGORY,
_SDDOCUMENTCATEGORY,
_SDDOCUMENTREASON,
_SHIPPINGPOINT,
_SHIPPINGPOINTTEXT,
_SHIPTOPARTY,
_SOLDTOPARTY,
_SOLUTIONORDER,
_SOLUTIONORDERITEM,
_STATISTICALVALUECONTROL,
_STORAGELOCATION,
_TRANSACTIONCURRENCY,
_WBSELEMENT,
_WBSELEMENTBASICDATA,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALMATERIALGROUP1,
ADDITIONALMATERIALGROUP2,
ADDITIONALMATERIALGROUP3,
ADDITIONALMATERIALGROUP4,
ADDITIONALMATERIALGROUP5,
BASEUNIT,
BATCH,
BILLINGDOCUMENTCATEGORY,
BILLINGDOCUMENTDATE,
BILLINGDOCUMENTITEMINPARTSGMT,
BILLINGDOCUMENTTYPE,
BILLINGPLAN,
BILLINGPLANRULE,
BILLINGQUANTITY,
BILLINGQUANTITYINBASEUNIT,
BILLINGQUANTITYUNIT,
BILLINGTOBASEQUANTITYDNMNTR,
BILLINGTOBASEQUANTITYNMRTR,
BILLTOPARTYCOUNTRY,
BILLTOPARTYREGION,
BUSINESSAREA,
CONTROLLINGAREA,
COSTAMOUNT,
COSTCENTER,
CREATEDBYUSER,
CREATIONDATE,
CUSTOMERGROUP,
CUSTOMERPRICEGROUP,
DISTRIBUTIONCHANNEL,
DIVISION,
ELIGIBLEAMOUNTFORCASHDISCOUNT,
GROSSAMOUNT,
HIGHERLEVELITEM,
INTERNATIONALARTICLENUMBER,
ITEMGROSSWEIGHT,
ITEMNETWEIGHT,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
MATERIAL,
MATERIALCOMMISSIONGROUP,
MATERIALGROUP,
MRPREQUIREDQUANTITYINBASEUNIT,
ORDERID,
ORGANIZATIONDIVISION,
ORIGINALLYREQUESTEDMATERIAL,
ORIGINSDDOCUMENT,
PAYERPARTY,
PLANT,
PRICEDETNEXCHANGERATE,
PRICEDETNEXCHANGERATEDATE,
PRICINGDATE,
PRICINGREFERENCEMATERIAL,
PRICINGSCALEQUANTITYINBASEUNIT,
PRODUCTGROUP,
PRODUCTHIERARCHYNODE,
PROFITABILITYSEGMENT_2,
REFERENCELOGICALSYSTEM,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
REFERENCESDDOCUMENTITEM,
SALESDEAL,
SALESDISTRICT,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESGROUP,
SALESOFFICE,
SALESORGANIZATION,
SDDOCUMENTCATEGORY,
SDDOCUMENTREASON,
SERVICESRENDEREDDATE,
SHIPPINGPOINT,
SOLDTOPARTY,
STATISTICALVALUECONTROL,
STORAGELOCATION,
SUBTOTAL1AMOUNT,
SUBTOTAL2AMOUNT,
SUBTOTAL3AMOUNT,
SUBTOTAL4AMOUNT,
SUBTOTAL5AMOUNT,
SUBTOTAL6AMOUNT,
TAXAMOUNT,
VOLUMEREBATEGROUP,
WBSELEMENTINTERNALID,
PRIMARY KEY (BILLINGDOCUMENT)
);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