P_BILLINGDOCUMENTITEMBASIC
P_BILLINGDOCUMENTITEMBASIC is a CDS View in S/4HANA. It contains 186 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BillingDocumentItemBasic | view | from | BASIC | Billing Document Item Basic |
Fields (186)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocument | BillingDocument | 1 |
| 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 | |
| BillingDocumentCategory | BillingDocumentCategory | 1 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| BillingDocumentIsTemporary | BillingDocumentIsTemporary | 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 | |
| BillToParty | BillToParty | 1 | |
| BillToPartyCountry | BillToPartyCountry | 1 | |
| BillToPartyRegion | BillToPartyRegion | 1 | |
| BOMExplosion | BOMExplosion | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessSolutionOrder | BusinessSolutionOrder | 1 | |
| BusinessSolutionOrderItem | BusinessSolutionOrderItem | 1 | |
| CancelledBillingDocument | CancelledBillingDocument | 1 | |
| CashDiscountIsDeductible | CashDiscountIsDeductible | 1 | |
| CityCode | CityCode | 1 | |
| CommodityCode | CommodityCode | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostAmount | CostAmount | 1 | |
| CostCenter | CostCenter | 1 | |
| Country | Country | 1 | |
| CountryOfOrigin | CountryOfOrigin | 1 | |
| County | County | 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 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerPriceGroup | CustomerPriceGroup | 1 | |
| CustomerRebateAgreement | CustomerRebateAgreement | 1 | |
| DepartureCountry | DepartureCountry | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| Division | Division | 1 | |
| DocumentBillingStatus | DocumentBillingStatus | 1 | |
| EligibleAmountForCashDiscount | EligibleAmountForCashDiscount | 1 | |
| ExternalReferenceDocument | ExternalReferenceDocument | 1 | |
| GrossAmount | GrossAmount | 1 | |
| HigherLevelItem | HigherLevelItem | 1 | |
| HigherLevelItemUsage | HigherLevelItemUsage | 1 | |
| HigherLvlItmOfBatSpltItm | HigherLvlItmOfBatSpltItm | 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 | |
| OverallBillingStatus | OverallBillingStatus | 1 | |
| OverallSDProcessStatus | OverallSDProcessStatus | 1 | |
| PayerParty | PayerParty | 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 | |
| PricingDocument | PricingDocument | 1 | |
| PricingReferenceMaterial | PricingReferenceMaterial | 1 | |
| PricingRelevance | PricingRelevance | 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 | |
| ProfitabilitySegment_2 | ProfitabilitySegment_2 | 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 | |
| Region | Region | 1 | |
| RegionOfOrigin | RegionOfOrigin | 1 | |
| ReplacementPartType | ReplacementPartType | 1 | |
| ResponsibleEmployee | ResponsibleEmployee | 1 | |
| RetailPromotion | RetailPromotion | 1 | |
| ReturnItemProcessingType | ReturnItemProcessingType | 1 | |
| SalesDeal | SalesDeal | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocIsCreatedFromReference | SalesDocIsCreatedFromReference | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 1 | |
| SalesDocumentItemType | SalesDocumentItemType | 1 | |
| SalesEmployee | SalesEmployee | 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 | |
| SDDocumentCategory | SDDocumentCategory | 1 | |
| SDDocumentReason | SDDocumentReason | 1 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShippingPoint | ShippingPoint | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldToParty | SoldToParty | 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 | |
| TransitPlant | TransitPlant | 1 | |
| ValueChainCategory | ValueChainCategory | 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 P_BILLINGDOCUMENTITEMBASIC (
BILLINGDOCUMENT,
BILLINGDOCUMENTITEM,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALMATERIALGROUP1,
ADDITIONALMATERIALGROUP2,
ADDITIONALMATERIALGROUP3,
ADDITIONALMATERIALGROUP4,
ADDITIONALMATERIALGROUP5,
BASEUNIT,
BATCH,
BILLINGDOCEXTREFERENCEDOCITEM,
BILLINGDOCUMENTCATEGORY,
BILLINGDOCUMENTDATE,
BILLINGDOCUMENTISTEMPORARY,
BILLINGDOCUMENTITEMINPARTSGMT,
BILLINGDOCUMENTITEMTEXT,
BILLINGDOCUMENTTYPE,
BILLINGPERFORMANCEPERIODENDDTE,
BILLINGPERFORMANCEPERIODSTRDTE,
BILLINGPLAN,
BILLINGPLANITEM,
BILLINGPLANRULE,
BILLINGQUANTITY,
BILLINGQUANTITYINBASEUNIT,
BILLINGQUANTITYUNIT,
BILLINGTOBASEQUANTITYDNMNTR,
BILLINGTOBASEQUANTITYNMRTR,
BILLTOPARTY,
BILLTOPARTYCOUNTRY,
BILLTOPARTYREGION,
BOMEXPLOSION,
BUSINESSAREA,
BUSINESSSOLUTIONORDER,
BUSINESSSOLUTIONORDERITEM,
CANCELLEDBILLINGDOCUMENT,
CASHDISCOUNTISDEDUCTIBLE,
CITYCODE,
COMMODITYCODE,
COMPANYCODE,
CONTROLLINGAREA,
COSTAMOUNT,
COSTCENTER,
COUNTRY,
COUNTRYOFORIGIN,
COUNTY,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CREDITRELATEDPRICE,
CUSTOMERCONDITIONGROUP1,
CUSTOMERCONDITIONGROUP2,
CUSTOMERCONDITIONGROUP3,
CUSTOMERCONDITIONGROUP4,
CUSTOMERCONDITIONGROUP5,
CUSTOMERGROUP,
CUSTOMERPRICEGROUP,
CUSTOMERREBATEAGREEMENT,
DEPARTURECOUNTRY,
DISTRIBUTIONCHANNEL,
DIVISION,
DOCUMENTBILLINGSTATUS,
ELIGIBLEAMOUNTFORCASHDISCOUNT,
EXTERNALREFERENCEDOCUMENT,
GROSSAMOUNT,
HIGHERLEVELITEM,
HIGHERLEVELITEMUSAGE,
HIGHERLVLITMOFBATSPLTITM,
INTERNATIONALARTICLENUMBER,
ITEMGROSSWEIGHT,
ITEMISRELEVANTFORCREDIT,
ITEMNETWEIGHT,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
MAINITEMMATERIALPRICINGGROUP,
MAINITEMPRICINGREFMATERIAL,
MANUALPRICECHANGETYPE,
MATERIALCOMMISSIONGROUP,
MATERIALDETERMINATIONTYPE,
MATERIALGROUPHIERARCHY1,
MATERIALGROUPHIERARCHY2,
MATERIALPRICINGGROUP,
MATLACCOUNTASSIGNMENTGROUP,
MRPREQUIREDQUANTITYINBASEUNIT,
NETAMOUNT,
ORDERID,
ORGANIZATIONDIVISION,
ORIGINALLYREQUESTEDMATERIAL,
ORIGINSDDOCUMENT,
ORIGINSDDOCUMENTITEM,
OVERALLBILLINGSTATUS,
OVERALLSDPROCESSSTATUS,
PAYERPARTY,
PLANT,
PLANTCITY,
PLANTCOUNTY,
PLANTREGION,
PRELIMBILLINGDOCUMENT,
PRELIMBILLINGDOCUMENTITEM,
PRICEDETNEXCHANGERATE,
PRICEDETNEXCHANGERATEDATE,
PRICINGDATE,
PRICINGDOCUMENT,
PRICINGREFERENCEMATERIAL,
PRICINGRELEVANCE,
PRICINGSCALEQUANTITYINBASEUNIT,
PRODUCT,
PRODUCTCONFIGURATION,
PRODUCTGROUP,
PRODUCTHIERARCHYNODE,
PRODUCTTAXCLASSIFICATION1,
PRODUCTTAXCLASSIFICATION2,
PRODUCTTAXCLASSIFICATION3,
PRODUCTTAXCLASSIFICATION4,
PRODUCTTAXCLASSIFICATION5,
PRODUCTTAXCLASSIFICATION6,
PRODUCTTAXCLASSIFICATION7,
PRODUCTTAXCLASSIFICATION8,
PRODUCTTAXCLASSIFICATION9,
PROFITABILITYSEGMENT_2,
PROFITCENTER,
PROVIDERCONTRACT,
PROVIDERCONTRACTITEM,
REBATEBASISAMOUNT,
REFERENCELOGICALSYSTEM,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
REFERENCESDDOCUMENTITEM,
REGION,
REGIONOFORIGIN,
REPLACEMENTPARTTYPE,
RESPONSIBLEEMPLOYEE,
RETAILPROMOTION,
RETURNITEMPROCESSINGTYPE,
SALESDEAL,
SALESDISTRICT,
SALESDOCISCREATEDFROMREFERENCE,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESDOCUMENTITEMCATEGORY,
SALESDOCUMENTITEMTYPE,
SALESEMPLOYEE,
SALESGROUP,
SALESOFFICE,
SALESORDERCUSTOMERGROUP,
SALESORDERCUSTOMERPRICEGROUP,
SALESORDERDISTRIBUTIONCHANNEL,
SALESORDERPRICELISTTYPE,
SALESORDERSALESDISTRICT,
SALESORDERSALESORGANIZATION,
SALESORGANIZATION,
SALESPROMOTION,
SALESSDDOCUMENTCATEGORY,
SDDOCUMENTCATEGORY,
SDDOCUMENTREASON,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SERVICEDOCUMENTTYPE,
SERVICESRENDEREDDATE,
SHIPPINGPOINT,
SHIPTOPARTY,
SOLDTOPARTY,
STATISTICALVALUECONTROL,
STATISTICSEXCHANGERATE,
STORAGELOCATION,
SUBTOTAL1AMOUNT,
SUBTOTAL2AMOUNT,
SUBTOTAL3AMOUNT,
SUBTOTAL4AMOUNT,
SUBTOTAL5AMOUNT,
SUBTOTAL6AMOUNT,
TAXAMOUNT,
TAXCODE,
TAXJURISDICTION,
TAXRATEVALIDITYSTARTDATE,
TIMESHEETOVERTIMECATEGORY,
TRANSACTIONCURRENCY,
TRANSITPLANT,
VALUECHAINCATEGORY,
VOLUMEREBATEGROUP,
WBSELEMENTINTERNALID,
ZEROVATRSN,
PRIMARY KEY (BILLINGDOCUMENT, BILLINGDOCUMENTITEM)
);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