C_BillingDocumentItem_F0797

Billing Document Item | view: CBDOCITEMF0797 | Extraction: Not supported | Component: Billing

Tables used: VBRK, VBRP, VBFS, PRTE, ADCP, ADRC, ADR6, ADR2, TVFK, TVFKT, BUT000, T001, TKA02, KNA1, CVI_CUST_LINK, PROJ, PRPS, PRPS

🔑 Keys (2)
💰 Amounts (4)
∑ Quantities (5)
📅 Dates (5)
☰ Categorical (6)
Other (35)
🔗 Relations (52)

Column Name	Description
BillingDocument FK	Billing Document
BillingDocumentItem	Billing Item

Column Name	Description
💲 SD Document Currency (TransactionCurrency):
ItemNetAmountOfBillingDoc	Net Value of Billing item in Document Currency
TaxAmount	Tax Amount in Document Currency
ItemGrossAmountOfBillingDoc	Gross Value of the Billing Item in Document Currency
EligibleAmountForCashDiscount	Amount eligible for cash discount in document currency

Column Name	Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity	Actual billed quantity
📏 Base Unit of Measure (BaseUnit):
BillingQuantityInBaseUnit	Billing quantity in stock keeping unit
📏 Weight Unit (ItemWeightUnit):
ItemNetWeight	Net weight
ItemGrossWeight	Gross weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume	Volume

Column Name	Description
PricingDate	Date for Pricing and Exchange Rate
ServicesRenderedDate	Date on which services are rendered
CreationDate	Date on which the record was created
BillingPerformancePeriodStrDte	Period of Performance Start Date
BillingPerformancePeriodEndDte	Period of Performance End Date

Column Name	Description
ReferenceSDDocumentCategory	Reference Document Category	Show values
StatisticalValueControl	Statistical Values	Show values
ReturnItemProcessingType	Returns item	Show values
SalesSDDocumentCategory	Sales Document Category	Show values
BillingPlanRule	Rule in billing plan/invoice plan	Show values
ManualPriceChangeType	Status manual price change	Show values

Column Name	Description	Domain name
BillingDocumentItemText	Short text for sales order item	TEXT40
ReferenceSDDocument	Document number of the reference document	VBELN
ReferenceSDDocumentItem	Item number of the reference item	POSNR
SalesDocumentItemCategory	Sales Document Item Category	PSTYV
ProductConfiguration	Configuration	CUOBJ
TransitPlant	Transit Plant	WERKS
PricingDocument	Number of the Document Condition	KNUMV
WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSElementInternalID	Work Breakdown Structure Element (WBS Element)	PS_POSNR
TaxJurisdiction	Tax Jurisdiction	TXJCD
ProductTaxClassification1	Tax classification material	TAXKM
ProductTaxClassification2	Tax Classification 2 for Material	TAXKM
ProductTaxClassification3	Tax Classification 3 for Material	TAXKM
ProductTaxClassification4	Tax Classification 4 for Material	TAXKM
ProductTaxClassification5	Tax Classification 5 for Material	TAXKM
ProductTaxClassification6	Tax Classification 6 for Material	TAXKM
ProductTaxClassification7	Tax Classification 7 for Material	TAXKM
ProductTaxClassification8	Tax Classification 8 for Material	TAXKM
ProductTaxClassification9	Tax Classification 9 for Material	TAXKM
ServiceDocument	Service Document ID	CRM_OBJECT_ID
ServiceDocumentItem	Service Document Item ID	FCO_SRVDOC_ITEM_ID
BusinessSolutionOrder	Solution Order	CRM_OBJECT_ID
BusinessSolutionOrderItem	Solution Order Item	CRMS4_NUMBER_INT
InternationalArticleNumber	International Article Number (EAN/UPC)	EAN11
BillingToBaseQuantityDnmntr	Denominator (divisor) for conversion of sales Qty into SKU	UMBSN
BillingToBaseQuantityNmrtr	Numerator (factor) for conversion of sales quantity into SKU	UMBSZ
PlantCounty	County in which plant is located	CHAR3
PlantCity	City in which plant is located	CHAR4
CostCenter	Cost Center	KOSTL
ProfitCenter	Profit Center	PRCTR
HigherLevelItem	Higher-Level Item in Bill of Material Structures	POSNR
ProviderContract	Identification of a Provider Contract	VTKEY_KK
SubscrpnBillgSubscription	Subscription Billing Document
ProviderContractItem	Provider Contract Item	VTPOS_KK

Master Data Relations	Join Conditions
Customer Group 1 Customer Group 1 Client	`C_BILLINGDOCUMENTITEM_F0797.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1` `C_BILLINGDOCUMENTITEM_F0797.MANDT == TVV1.MANDT`
Customer Group 2 Client Customer Group 2	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVV2.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2`
Customer Group 3 Client Customer Group 3	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVV3.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3`
Customer Group 4 Customer Group 4 Client	`C_BILLINGDOCUMENTITEM_F0797.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4` `C_BILLINGDOCUMENTITEM_F0797.MANDT == TVV4.MANDT`
Customer Group 5 Client Customer Group 5	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVV5.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5`
Material Group 1 Client Material Group 1	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVM1.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1`
Material Group 2 Client Material Group 2	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVM2.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2`
Material Group 3 Client Material Group 3	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVM3.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3`
Material Group 4 Client Material Group 4	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVM4.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4`
Material Group 5 Client Material Group 5	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVM5.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5`
Base Unit of Measure Client Base Unit of Measure	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T006.MANDT` `C_BILLINGDOCUMENTITEM_F0797.BASEUNIT == T006.MSEHI`
Batch Number Product Number Batch Number Client Plant	`C_BILLINGDOCUMENTITEM_F0797.MATERIAL == MCHA.MATNR` `C_BILLINGDOCUMENTITEM_F0797.BATCH == MCHA.CHARG` `C_BILLINGDOCUMENTITEM_F0797.MANDT == MCHA.MANDT` `C_BILLINGDOCUMENTITEM_F0797.PLANT == MCHA.WERKS`
Sales unit Client Sales unit	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T006.MANDT` `C_BILLINGDOCUMENTITEM_F0797.BILLINGQUANTITYUNIT == T006.MSEHI`
Destination Country/Region of Sales Order Client Destination Country/Region of Sales Order	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T005.MANDT` `C_BILLINGDOCUMENTITEM_F0797.BILLTOPARTYCOUNTRY == T005.LAND1`
Region of Sales Order Client Region of Sales Order Destination Country/Region of Sales Order	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T005S.MANDT` `C_BILLINGDOCUMENTITEM_F0797.BILLTOPARTYREGION == T005S.BLAND` `C_BILLINGDOCUMENTITEM_F0797.BILLTOPARTYCOUNTRY == T005S.LAND1`
Business Area Client Business Area	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TGSB.MANDT` `C_BILLINGDOCUMENTITEM_F0797.BUSINESSAREA == TGSB.GSBER`
Controlling Area Client Controlling Area	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TKA01.MANDT` `C_BILLINGDOCUMENTITEM_F0797.CONTROLLINGAREA == TKA01.KOKRS`
Departure Country/Region (from which the goods are sent) Client Departure Country/Region (from which the goods are sent)	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T005.MANDT` `C_BILLINGDOCUMENTITEM_F0797.DEPARTURECOUNTRY == T005.LAND1`
Division Client Division	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TSPA.MANDT` `C_BILLINGDOCUMENTITEM_F0797.DIVISION == TSPA.SPART`
Volume unit Client Volume unit	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T006.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ITEMVOLUMEUNIT == T006.MSEHI`
Weight Unit Client Weight Unit	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T006.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ITEMWEIGHTUNIT == T006.MSEHI`
Product Number Product Number Client	`C_BILLINGDOCUMENTITEM_F0797.MATERIAL == MARA.MATNR` `C_BILLINGDOCUMENTITEM_F0797.MANDT == MARA.MANDT`
Commission Group Client Commission Group	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVPR.MANDT` `C_BILLINGDOCUMENTITEM_F0797.MATERIALCOMMISSIONGROUP == TVPR.PROVG`
Product Group Client Product Group	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T023.MANDT` `C_BILLINGDOCUMENTITEM_F0797.MATERIALGROUP == T023.MATKL`
Material Price Group Material Price Group Client	`C_BILLINGDOCUMENTITEM_F0797.MATERIALPRICINGGROUP == T178.KONDM` `C_BILLINGDOCUMENTITEM_F0797.MANDT == T178.MANDT`
Account Assignment Group for Material Account Assignment Group for Material Client	`C_BILLINGDOCUMENTITEM_F0797.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM` `C_BILLINGDOCUMENTITEM_F0797.MANDT == TVKM.MANDT`
Order Number Client Order Number	`C_BILLINGDOCUMENTITEM_F0797.MANDT == AUFK.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ORDERID == AUFK.AUFNR`
Division in Sales Order Header Client Division in Sales Order Header	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TSPA.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ORGANIZATIONDIVISION == TSPA.SPART`
Material Entered Client Material Entered	`C_BILLINGDOCUMENTITEM_F0797.MANDT == MARA.MANDT` `C_BILLINGDOCUMENTITEM_F0797.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR`
Plant Client Plant	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T001W.MANDT` `C_BILLINGDOCUMENTITEM_F0797.PLANT == T001W.WERKS`
Region in which plant is located Client Region in which plant is located Departure Country/Region (from which the goods are sent)	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T005S.MANDT` `C_BILLINGDOCUMENTITEM_F0797.PLANTREGION == T005S.BLAND` `C_BILLINGDOCUMENTITEM_F0797.DEPARTURECOUNTRY == T005S.LAND1`
Pricing Reference Material Client Pricing Reference Material	`C_BILLINGDOCUMENTITEM_F0797.MANDT == MARA.MANDT` `C_BILLINGDOCUMENTITEM_F0797.PRICINGREFERENCEMATERIAL == MARA.MATNR`
Product hierarchy Client Product hierarchy	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T179.MANDT` `C_BILLINGDOCUMENTITEM_F0797.PRODUCTHIERARCHYNODE == T179.PRODH`
Promotion Promotion Client	`C_BILLINGDOCUMENTITEM_F0797.RETAILPROMOTION == WAKH.AKTNR` `C_BILLINGDOCUMENTITEM_F0797.MANDT == WAKH.MANDT`
Sales Deal Sales Deal Client	`C_BILLINGDOCUMENTITEM_F0797.SALESDEAL == KONA.KNUMA` `C_BILLINGDOCUMENTITEM_F0797.MANDT == KONA.MANDT`
Sales group Client Sales group	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVKGR.MANDT` `C_BILLINGDOCUMENTITEM_F0797.SALESGROUP == TVKGR.VKGRP`
Sales office Client Sales office	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVBUR.MANDT` `C_BILLINGDOCUMENTITEM_F0797.SALESOFFICE == TVBUR.VKBUR`
Customer group of sales order Client Customer group of sales order	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T151.MANDT` `C_BILLINGDOCUMENTITEM_F0797.SALESORDERCUSTOMERGROUP == T151.KDGRP`
Price group of sales order Client Price group of sales order	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T188.MANDT` `C_BILLINGDOCUMENTITEM_F0797.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA`
Distribution channel of sales order Client Distribution channel of sales order	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVTW.MANDT` `C_BILLINGDOCUMENTITEM_F0797.SALESORDERDISTRIBUTIONCHANNEL == TVTW.VTWEG`
Price list type of sales order Price list type of sales order Client	`C_BILLINGDOCUMENTITEM_F0797.SALESORDERPRICELISTTYPE == T189.PLTYP` `C_BILLINGDOCUMENTITEM_F0797.MANDT == T189.MANDT`
Sales district of sales order Sales district of sales order Client	`C_BILLINGDOCUMENTITEM_F0797.SALESORDERSALESDISTRICT == T171.BZIRK` `C_BILLINGDOCUMENTITEM_F0797.MANDT == T171.MANDT`
Sales organization of sales order Sales organization of sales order Client	`C_BILLINGDOCUMENTITEM_F0797.SALESORDERSALESORGANIZATION == TVKO.VKORG` `C_BILLINGDOCUMENTITEM_F0797.MANDT == TVKO.MANDT`
Sales Promotion Client Sales Promotion	`C_BILLINGDOCUMENTITEM_F0797.MANDT == KONA.MANDT` `C_BILLINGDOCUMENTITEM_F0797.SALESPROMOTION == KONA.KNUMA`
Order Reason (Reason for the Business Transaction) Client Order Reason (Reason for the Business Transaction)	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVAU.MANDT` `C_BILLINGDOCUMENTITEM_F0797.SDDOCUMENTREASON == TVAU.AUGRU`
Service Document Type Client Service Document Type	`C_BILLINGDOCUMENTITEM_F0797.MANDT == CRMC_PROC_TYPE.CLIENT` `C_BILLINGDOCUMENTITEM_F0797.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Storage location Client Storage location Plant	`C_BILLINGDOCUMENTITEM_F0797.MANDT == T001L.MANDT` `C_BILLINGDOCUMENTITEM_F0797.STORAGELOCATION == T001L.LGORT` `C_BILLINGDOCUMENTITEM_F0797.PLANT == T001L.WERKS`
Volume rebate group Client Volume rebate group	`C_BILLINGDOCUMENTITEM_F0797.MANDT == TVBO.MANDT` `C_BILLINGDOCUMENTITEM_F0797.VOLUMEREBATEGROUP == TVBO.BONUS`
Foreign key for J_1ARFZ Reason for Zero VAT Client	`C_BILLINGDOCUMENTITEM_F0797.ZEROVATRSN == J_1ARFZ.J_1ARFZ` `C_BILLINGDOCUMENTITEM_F0797.MANDT == J_1ARFZ.MANDT`