A_BillingDocumentItem

Billing Document Item | view: ASDBDITEM | TRAN | Extraction: Not supported | Component: Billing

Tables used: VBRK, VBRP

🔑 Keys (2)
💰 Amounts (13)
∑ Quantities (7)
📅 Dates (5)
☰ Categorical (15)
Other (35)
🔗 Relations (64)

Column Name	Description
BillingDocument FK	Billing Document
BillingDocumentItem	Billing Item

Column Name	Description
💲 SD Document Currency (TransactionCurrency):
NetAmount	Net Value of Billing item in Document Currency
GrossAmount	Gross Value of the Billing Item in Document Currency
TaxAmount	Tax Amount in Document Currency
CostAmount	Cost in Document Currency
Subtotal1Amount	Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount	Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount	Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount	Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount	Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount	Subtotal 6 from Pricing Procedure for Price Element
EligibleAmountForCashDiscount	Amount eligible for cash discount in document currency
RebateBasisAmount	Rebate Basis 1
CreditRelatedPrice	Item credit price

Column Name	Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity	Actual billed quantity
📏 Base Unit of Measure (BaseUnit):
BillingQuantityInBaseUnit	Billing quantity in stock keeping unit
MRPRequiredQuantityInBaseUnit	Required quantity for mat.management in stockkeeping units
PricingScaleQuantityInBaseUnit	Scale Quantity in base unit of measure
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight	Gross weight
ItemNetWeight	Net weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume	Volume

Column Name	Description
CreationDate	Date on which the record was created
CreationTime	Entry time
ServicesRenderedDate	Date on which services are rendered
PricingDate	Date for Pricing and Exchange Rate
PriceDetnExchangeRateDate	Translation date

Column Name	Description
SalesDocumentItemType	Item Type	Show values
ReturnItemProcessingType	Returns item	Show values
ReplacementPartType	Replacement part	Show values
MaterialDeterminationType	ID for material determination	Show values
BillingPlanRule	Rule in billing plan/invoice plan	Show values
PriceDetnExchRateIsIndrctQtan	Pricing exchange rate quotation is indirect	Show values
StatisticalValueControl	Statistical Values	Show values
CashDiscountIsDeductible	Cash Discount Indicator	Show values
ManualPriceChangeType	Status manual price change	Show values
StatisticsExchRateIsIndrctQtan	Statistics exchange rate quotation is indirect	Show values
ReferenceSDDocumentCategory	Reference Document Category	Show values
SalesSDDocumentCategory	Sales Document Category	Show values
ItemIsRelevantForCredit	ID: Item with active credit function / relevant for credit	Show values
SalesDocIsCreatedFromReference	Sales document was created from reference	Show values
HigherLevelItemUsage	ID for higher-level item usage	Show values

Column Name	Description	Domain name
SalesDocumentItemCategory	Sales Document Item Category	PSTYV
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
ReferenceLogicalSystem	Logical system	LOGSYS
InternationalArticleNumber	International Article Number (EAN/UPC)	EAN11
MaterialGroupHierarchy1	Material group hierarchy 1	KLASSE
MaterialGroupHierarchy2	Material group hierarchy 2	KLASSE
PlantCounty	County in which plant is located	CHAR3
PlantCity	City in which plant is located	CHAR4
BillingDocumentItemText	Short text for sales order item	TEXT40
BillingToBaseQuantityDnmntr	Denominator (divisor) for conversion of sales Qty into SKU	UMBSN
BillingToBaseQuantityNmrtr	Numerator (factor) for conversion of sales quantity into SKU	UMBSZ
BillingPlanItem	Item for billing plan/invoice plan/payment cards	FPLTR
AbsltPriceDetnExchangeRate	Absolute exchange rate for price determination	KURRF_ABS
AbsltStatisticsExchangeRate	Absolute exchange rate for statistics	KURRF_ABS
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
ProfitCenter	Profit Center	PRCTR
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSNR
ProfitabilitySegment	Deprecated: Profitability Segment	RKEOBJNR_NUMC
CostCenter	Cost Center	KOSTL
OriginSDDocument	Originating Document	VBELN
OriginSDDocumentItem	Originating Item	POSNR
ReferenceSDDocument	Document number of the reference document	VBELN
ReferenceSDDocumentItem	Item number of the reference item	POSNR
HigherLevelItem	Higher-Level Item in Bill of Material Structures	POSNR
ExternalReferenceDocument	External Reference Document	VBELN
ExternalReferenceDocumentItem	External Reference Document Item	POSNR

Master Data Relations	Join Conditions
Customer Group 1 Customer Group 1 Client	`A_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1` `A_BILLINGDOCUMENTITEM.MANDT == TVV1.MANDT`
Customer Group 2 Client Customer Group 2	`A_BILLINGDOCUMENTITEM.MANDT == TVV2.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2`
Customer Group 3 Client Customer Group 3	`A_BILLINGDOCUMENTITEM.MANDT == TVV3.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3`
Customer Group 4 Customer Group 4 Client	`A_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4` `A_BILLINGDOCUMENTITEM.MANDT == TVV4.MANDT`
Customer Group 5 Client Customer Group 5	`A_BILLINGDOCUMENTITEM.MANDT == TVV5.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5`
Material Group 1 Client Material Group 1	`A_BILLINGDOCUMENTITEM.MANDT == TVM1.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1`
Material Group 2 Client Material Group 2	`A_BILLINGDOCUMENTITEM.MANDT == TVM2.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2`
Material Group 3 Client Material Group 3	`A_BILLINGDOCUMENTITEM.MANDT == TVM3.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3`
Material Group 4 Client Material Group 4	`A_BILLINGDOCUMENTITEM.MANDT == TVM4.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4`
Material Group 5 Client Material Group 5	`A_BILLINGDOCUMENTITEM.MANDT == TVM5.MANDT` `A_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5`
Base Unit of Measure Client Base Unit of Measure	`A_BILLINGDOCUMENTITEM.MANDT == T006.MANDT` `A_BILLINGDOCUMENTITEM.BASEUNIT == T006.MSEHI`
Batch Number Client Material Number Batch Number Plant	`A_BILLINGDOCUMENTITEM.MANDT == MCHA.MANDT` `A_BILLINGDOCUMENTITEM.MATERIAL == MCHA.MATNR` `A_BILLINGDOCUMENTITEM.BATCH == MCHA.CHARG` `A_BILLINGDOCUMENTITEM.PLANT == MCHA.WERKS`
Billing Type Billing Type Client	`A_BILLINGDOCUMENTITEM.BILLINGDOCUMENTTYPE == TVFK.FKART` `A_BILLINGDOCUMENTITEM.MANDT == TVFK.MANDT`
Sales unit Client Sales unit	`A_BILLINGDOCUMENTITEM.MANDT == T006.MANDT` `A_BILLINGDOCUMENTITEM.BILLINGQUANTITYUNIT == T006.MSEHI`
Destination Country/Region of Sales Order Client Destination Country/Region of Sales Order	`A_BILLINGDOCUMENTITEM.MANDT == T005.MANDT` `A_BILLINGDOCUMENTITEM.BILLTOPARTYCOUNTRY == T005.LAND1`
Region of Sales Order Client Region of Sales Order Destination Country/Region of Sales Order	`A_BILLINGDOCUMENTITEM.MANDT == T005S.MANDT` `A_BILLINGDOCUMENTITEM.BILLTOPARTYREGION == T005S.BLAND` `A_BILLINGDOCUMENTITEM.BILLTOPARTYCOUNTRY == T005S.LAND1`
BOM explosion number Client BOM explosion number	`A_BILLINGDOCUMENTITEM.MANDT == SNUM.MANDT` `A_BILLINGDOCUMENTITEM.BOMEXPLOSION == SNUM.SERNR`
Business Area Client Business Area	`A_BILLINGDOCUMENTITEM.MANDT == TGSB.MANDT` `A_BILLINGDOCUMENTITEM.BUSINESSAREA == TGSB.GSBER`
Controlling Area Client Controlling Area	`A_BILLINGDOCUMENTITEM.MANDT == TKA01.MANDT` `A_BILLINGDOCUMENTITEM.CONTROLLINGAREA == TKA01.KOKRS`
Customer condition group 1 Client Customer condition group 1	`A_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT` `A_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR`
Customer condition group 2 Customer condition group 2 Client	`A_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR` `A_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT`
Customer condition group 3 Customer condition group 3 Client	`A_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR` `A_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT`
Customer condition group 4 Client Customer condition group 4	`A_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT` `A_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR`
Customer condition group 5 Client Customer condition group 5	`A_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT` `A_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR`
Departure Country/Region (from which the goods are sent) Client Departure Country/Region (from which the goods are sent)	`A_BILLINGDOCUMENTITEM.MANDT == T005.MANDT` `A_BILLINGDOCUMENTITEM.DEPARTURECOUNTRY == T005.LAND1`
Division Client Division	`A_BILLINGDOCUMENTITEM.MANDT == TSPA.MANDT` `A_BILLINGDOCUMENTITEM.DIVISION == TSPA.SPART`
Volume unit Client Volume unit	`A_BILLINGDOCUMENTITEM.MANDT == T006.MANDT` `A_BILLINGDOCUMENTITEM.ITEMVOLUMEUNIT == T006.MSEHI`
Weight Unit Client Weight Unit	`A_BILLINGDOCUMENTITEM.MANDT == T006.MANDT` `A_BILLINGDOCUMENTITEM.ITEMWEIGHTUNIT == T006.MSEHI`
Material pricing group of main item Client Material pricing group of main item	`A_BILLINGDOCUMENTITEM.MANDT == T178.MANDT` `A_BILLINGDOCUMENTITEM.MAINITEMMATERIALPRICINGGROUP == T178.KONDM`
Pricing reference material of main item Client Pricing reference material of main item	`A_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT` `A_BILLINGDOCUMENTITEM.MAINITEMPRICINGREFMATERIAL == MARA.MATNR`
Material Number Client Material Number	`A_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT` `A_BILLINGDOCUMENTITEM.MATERIAL == MARA.MATNR`
Commission Group Client Commission Group	`A_BILLINGDOCUMENTITEM.MANDT == TVPR.MANDT` `A_BILLINGDOCUMENTITEM.MATERIALCOMMISSIONGROUP == TVPR.PROVG`
Material Group Client Material Group	`A_BILLINGDOCUMENTITEM.MANDT == T023.MANDT` `A_BILLINGDOCUMENTITEM.MATERIALGROUP == T023.MATKL`
Material Price Group Material Price Group Client	`A_BILLINGDOCUMENTITEM.MATERIALPRICINGGROUP == T178.KONDM` `A_BILLINGDOCUMENTITEM.MANDT == T178.MANDT`
Account Assignment Group for Material Client Account Assignment Group for Material	`A_BILLINGDOCUMENTITEM.MANDT == TVKM.MANDT` `A_BILLINGDOCUMENTITEM.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM`
Order Number Client Order Number	`A_BILLINGDOCUMENTITEM.MANDT == AUFK.MANDT` `A_BILLINGDOCUMENTITEM.ORDERID == AUFK.AUFNR`
Division in Sales Order Header Client Division in Sales Order Header	`A_BILLINGDOCUMENTITEM.MANDT == TSPA.MANDT` `A_BILLINGDOCUMENTITEM.ORGANIZATIONDIVISION == TSPA.SPART`
Material Entered Client Material Entered	`A_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT` `A_BILLINGDOCUMENTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR`
Plant Client Plant	`A_BILLINGDOCUMENTITEM.MANDT == T001W.MANDT` `A_BILLINGDOCUMENTITEM.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)	`A_BILLINGDOCUMENTITEM.MANDT == T005S.MANDT` `A_BILLINGDOCUMENTITEM.PLANTREGION == T005S.BLAND` `A_BILLINGDOCUMENTITEM.DEPARTURECOUNTRY == T005S.LAND1`
Pricing Reference Material Client Pricing Reference Material	`A_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT` `A_BILLINGDOCUMENTITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR`
Product hierarchy Client Product hierarchy	`A_BILLINGDOCUMENTITEM.MANDT == T179.MANDT` `A_BILLINGDOCUMENTITEM.PRODUCTHIERARCHYNODE == T179.PRODH`
Promotion Promotion Client	`A_BILLINGDOCUMENTITEM.RETAILPROMOTION == WAKH.AKTNR` `A_BILLINGDOCUMENTITEM.MANDT == WAKH.MANDT`
Sales Deal Client Sales Deal	`A_BILLINGDOCUMENTITEM.MANDT == KONA.MANDT` `A_BILLINGDOCUMENTITEM.SALESDEAL == KONA.KNUMA`
Sales group Client Sales group	`A_BILLINGDOCUMENTITEM.MANDT == TVKGR.MANDT` `A_BILLINGDOCUMENTITEM.SALESGROUP == TVKGR.VKGRP`
Sales office Client Sales office	`A_BILLINGDOCUMENTITEM.MANDT == TVBUR.MANDT` `A_BILLINGDOCUMENTITEM.SALESOFFICE == TVBUR.VKBUR`
Customer group of sales order Client Customer group of sales order	`A_BILLINGDOCUMENTITEM.MANDT == T151.MANDT` `A_BILLINGDOCUMENTITEM.SALESORDERCUSTOMERGROUP == T151.KDGRP`
Price group of sales order Price group of sales order Client	`A_BILLINGDOCUMENTITEM.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA` `A_BILLINGDOCUMENTITEM.MANDT == T188.MANDT`
Distribution channel of sales order Client Distribution channel of sales order	`A_BILLINGDOCUMENTITEM.MANDT == TVTW.MANDT` `A_BILLINGDOCUMENTITEM.SALESORDERDISTRIBUTIONCHANNEL == TVTW.VTWEG`
Price list type of sales order Client Price list type of sales order	`A_BILLINGDOCUMENTITEM.MANDT == T189.MANDT` `A_BILLINGDOCUMENTITEM.SALESORDERPRICELISTTYPE == T189.PLTYP`
Sales district of sales order Client Sales district of sales order	`A_BILLINGDOCUMENTITEM.MANDT == T171.MANDT` `A_BILLINGDOCUMENTITEM.SALESORDERSALESDISTRICT == T171.BZIRK`
Sales organization of sales order Client Sales organization of sales order	`A_BILLINGDOCUMENTITEM.MANDT == TVKO.MANDT` `A_BILLINGDOCUMENTITEM.SALESORDERSALESORGANIZATION == TVKO.VKORG`
Sales Organization Client Sales Organization	`A_BILLINGDOCUMENTITEM.MANDT == TVKO.MANDT` `A_BILLINGDOCUMENTITEM.SALESORGANIZATION == TVKO.VKORG`
Sales Promotion Client Sales Promotion	`A_BILLINGDOCUMENTITEM.MANDT == KONA.MANDT` `A_BILLINGDOCUMENTITEM.SALESPROMOTION == KONA.KNUMA`
Order Reason (Reason for the Business Transaction) Order Reason (Reason for the Business Transaction) Client	`A_BILLINGDOCUMENTITEM.SDDOCUMENTREASON == TVAU.AUGRU` `A_BILLINGDOCUMENTITEM.MANDT == TVAU.MANDT`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`A_BILLINGDOCUMENTITEM.MANDT == TVST.MANDT` `A_BILLINGDOCUMENTITEM.SHIPPINGPOINT == TVST.VSTEL`
Storage location Client Storage location Plant	`A_BILLINGDOCUMENTITEM.MANDT == T001L.MANDT` `A_BILLINGDOCUMENTITEM.STORAGELOCATION == T001L.LGORT` `A_BILLINGDOCUMENTITEM.PLANT == T001L.WERKS`
Volume rebate group Client Volume rebate group	`A_BILLINGDOCUMENTITEM.MANDT == TVBO.MANDT` `A_BILLINGDOCUMENTITEM.VOLUMEREBATEGROUP == TVBO.BONUS`
Foreign key for J_1ARFZ Client Reason for Zero VAT	`A_BILLINGDOCUMENTITEM.MANDT == J_1ARFZ.MANDT` `A_BILLINGDOCUMENTITEM.ZEROVATRSN == J_1ARFZ.J_1ARFZ`