I_BillingDocumentItem

Billing Document Item | view: ISDBILLGDOCITEM | ATTR | Extraction: Not supported | Component: Billing
Tables used: VBRK, VBRP
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
TaxRateValidityStartDate Valid-From Date of the Tax Rate
BillingPerformancePeriodStrDte Period of Performance Start Date
BillingPerformancePeriodEndDte Period of Performance End Date
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
StatisticalValueControl Statistical Values Show values
CashDiscountIsDeductible Cash Discount Indicator Show values
ManualPriceChangeType Status manual price change Show values
PricingRelevance Carry out pricing 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
ProductConfiguration Configuration CUOBJ
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
TransitPlant Transit Plant WERKS
ValueChainCategory Value Chain Category VCM_CHAIN_CATEGORY
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
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
StatisticsExchangeRate Exchange rate for statistics (Exch.rate at time of creation) KURRF_NOT_CONVERTED
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
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
TaxCode Tax on sales/purchases code MWSKZ
CountryOfOrigin Country/Region of Origin of Material (Non-Preferential Ori.) LAND1
RegionOfOrigin Region of Origin of Material (Non-Preferential Origin) REGIO
CommodityCode Commodity Code /SAPSLL/CCNGN
ProfitCenter Profit Center PRCTR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
WBSElementInternalID WBS Element PS_S4_PSPNR
ProviderContract Identification of a Provider Contract VTKEY_KK
ProviderContractItem Provider Contract Item VTPOS_KK
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
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
BillingDocExtReferenceDocItem External Reference Document Item of Billing Document Item POSNR
PrelimBillingDocument Preliminary Billing Document VBELN
PrelimBillingDocumentItem Preliminary Billing Document Item POSNR
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
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_BILLINGDOCUMENTITEM.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_BILLINGDOCUMENTITEM.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • I_BILLINGDOCUMENTITEM.MANDT == TVV3.MANDT
  • I_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Customer Group 4
  • Client
  • I_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_BILLINGDOCUMENTITEM.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • I_BILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_BILLINGDOCUMENTITEM.MANDT == TVV5.MANDT
Material Group 1
  • Client
  • Material Group 1
  • I_BILLINGDOCUMENTITEM.MANDT == TVM1.MANDT
  • I_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_BILLINGDOCUMENTITEM.MANDT == TVM2.MANDT
  • I_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • I_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_BILLINGDOCUMENTITEM.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • I_BILLINGDOCUMENTITEM.MANDT == TVM4.MANDT
  • I_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • I_BILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • I_BILLINGDOCUMENTITEM.MANDT == TVM5.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_BILLINGDOCUMENTITEM.MANDT == T006.MANDT
  • I_BILLINGDOCUMENTITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Product Number
  • Material Number
  • Batch Number
  • Client
  • Plant
  • I_BILLINGDOCUMENTITEM.PRODUCT == MCHA.MATNR
  • I_BILLINGDOCUMENTITEM.MATERIAL == MCHA.MATNR
  • I_BILLINGDOCUMENTITEM.BATCH == MCHA.CHARG
  • I_BILLINGDOCUMENTITEM.MANDT == MCHA.MANDT
  • I_BILLINGDOCUMENTITEM.PLANT == MCHA.WERKS
Sales unit
  • Client
  • Sales unit
  • I_BILLINGDOCUMENTITEM.MANDT == T006.MANDT
  • I_BILLINGDOCUMENTITEM.BILLINGQUANTITYUNIT == T006.MSEHI
Destination Country/Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • I_BILLINGDOCUMENTITEM.BILLTOPARTYCOUNTRY == T005.LAND1
  • I_BILLINGDOCUMENTITEM.MANDT == T005.MANDT
Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • Region of Sales Order
  • I_BILLINGDOCUMENTITEM.BILLTOPARTYCOUNTRY == T005S.LAND1
  • I_BILLINGDOCUMENTITEM.MANDT == T005S.MANDT
  • I_BILLINGDOCUMENTITEM.BILLTOPARTYREGION == T005S.BLAND
BOM explosion number
  • Client
  • BOM explosion number
  • I_BILLINGDOCUMENTITEM.MANDT == SNUM.MANDT
  • I_BILLINGDOCUMENTITEM.BOMEXPLOSION == SNUM.SERNR
Business Area
  • Business Area
  • Client
  • I_BILLINGDOCUMENTITEM.BUSINESSAREA == TGSB.GSBER
  • I_BILLINGDOCUMENTITEM.MANDT == TGSB.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_BILLINGDOCUMENTITEM.MANDT == TKA01.MANDT
  • I_BILLINGDOCUMENTITEM.CONTROLLINGAREA == TKA01.KOKRS
Customer condition group 1
  • Customer condition group 1
  • Client
  • I_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • I_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Customer condition group 2
  • Customer condition group 2
  • Client
  • I_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • I_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Customer condition group 3
  • Client
  • Customer condition group 3
  • I_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
  • I_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer condition group 4
  • Customer condition group 4
  • Client
  • I_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • I_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Customer condition group 5
  • Customer condition group 5
  • Client
  • I_BILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • I_BILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Departure Country/Region (from which the goods are sent)
  • Departure Country/Region (from which the goods are sent)
  • Client
  • I_BILLINGDOCUMENTITEM.DEPARTURECOUNTRY == T005.LAND1
  • I_BILLINGDOCUMENTITEM.MANDT == T005.MANDT
Division
  • Division
  • Client
  • I_BILLINGDOCUMENTITEM.DIVISION == TSPA.SPART
  • I_BILLINGDOCUMENTITEM.MANDT == TSPA.MANDT
Volume unit
  • Client
  • Volume unit
  • I_BILLINGDOCUMENTITEM.MANDT == T006.MANDT
  • I_BILLINGDOCUMENTITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_BILLINGDOCUMENTITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • I_BILLINGDOCUMENTITEM.MANDT == T006.MANDT
Material pricing group of main item
  • Material pricing group of main item
  • Client
  • I_BILLINGDOCUMENTITEM.MAINITEMMATERIALPRICINGGROUP == T178.KONDM
  • I_BILLINGDOCUMENTITEM.MANDT == T178.MANDT
Pricing reference material of main item
  • Pricing reference material of main item
  • Client
  • I_BILLINGDOCUMENTITEM.MAINITEMPRICINGREFMATERIAL == MARA.MATNR
  • I_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT
Material Number
  • Product Number
  • Material Number
  • Client
  • I_BILLINGDOCUMENTITEM.PRODUCT == MARA.MATNR
  • I_BILLINGDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT
Commission Group
  • Commission Group
  • Client
  • I_BILLINGDOCUMENTITEM.MATERIALCOMMISSIONGROUP == TVPR.PROVG
  • I_BILLINGDOCUMENTITEM.MANDT == TVPR.MANDT
Material Group
  • Client
  • Product Group
  • Material Group
  • I_BILLINGDOCUMENTITEM.MANDT == T023.MANDT
  • I_BILLINGDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_BILLINGDOCUMENTITEM.MATERIALGROUP == T023.MATKL
Material Price Group
  • Material Price Group
  • Client
  • I_BILLINGDOCUMENTITEM.MATERIALPRICINGGROUP == T178.KONDM
  • I_BILLINGDOCUMENTITEM.MANDT == T178.MANDT
Account Assignment Group for Material
  • Client
  • Account Assignment Group for Material
  • I_BILLINGDOCUMENTITEM.MANDT == TVKM.MANDT
  • I_BILLINGDOCUMENTITEM.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM
Order Number
  • Client
  • Order Number
  • I_BILLINGDOCUMENTITEM.MANDT == AUFK.MANDT
  • I_BILLINGDOCUMENTITEM.ORDERID == AUFK.AUFNR
Division in Sales Order Header
  • Division in Sales Order Header
  • Client
  • I_BILLINGDOCUMENTITEM.ORGANIZATIONDIVISION == TSPA.SPART
  • I_BILLINGDOCUMENTITEM.MANDT == TSPA.MANDT
Material Entered
  • Material Entered
  • Client
  • I_BILLINGDOCUMENTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • I_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • I_BILLINGDOCUMENTITEM.MANDT == T001W.MANDT
  • I_BILLINGDOCUMENTITEM.PLANT == T001W.WERKS
Region in which plant is located
  • Departure Country/Region (from which the goods are sent)
  • Region in which plant is located
  • Client
  • I_BILLINGDOCUMENTITEM.DEPARTURECOUNTRY == T005S.LAND1
  • I_BILLINGDOCUMENTITEM.PLANTREGION == T005S.BLAND
  • I_BILLINGDOCUMENTITEM.MANDT == T005S.MANDT
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • I_BILLINGDOCUMENTITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR
  • I_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT
Product Number
  • Product Number
  • Material Number
  • Client
  • I_BILLINGDOCUMENTITEM.PRODUCT == MARA.MATNR
  • I_BILLINGDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_BILLINGDOCUMENTITEM.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • Material Group
  • I_BILLINGDOCUMENTITEM.MANDT == T023.MANDT
  • I_BILLINGDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_BILLINGDOCUMENTITEM.MATERIALGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • I_BILLINGDOCUMENTITEM.MANDT == T179.MANDT
  • I_BILLINGDOCUMENTITEM.PRODUCTHIERARCHYNODE == T179.PRODH
Promotion
  • Client
  • Promotion
  • I_BILLINGDOCUMENTITEM.MANDT == WAKH.MANDT
  • I_BILLINGDOCUMENTITEM.RETAILPROMOTION == WAKH.AKTNR
Sales Deal
  • Sales Deal
  • Client
  • I_BILLINGDOCUMENTITEM.SALESDEAL == KONA.KNUMA
  • I_BILLINGDOCUMENTITEM.MANDT == KONA.MANDT
Sales group
  • Sales group
  • Client
  • I_BILLINGDOCUMENTITEM.SALESGROUP == TVKGR.VKGRP
  • I_BILLINGDOCUMENTITEM.MANDT == TVKGR.MANDT
Sales office
  • Sales office
  • Client
  • I_BILLINGDOCUMENTITEM.SALESOFFICE == TVBUR.VKBUR
  • I_BILLINGDOCUMENTITEM.MANDT == TVBUR.MANDT
Customer group of sales order
  • Customer group of sales order
  • Client
  • I_BILLINGDOCUMENTITEM.SALESORDERCUSTOMERGROUP == T151.KDGRP
  • I_BILLINGDOCUMENTITEM.MANDT == T151.MANDT
Price group of sales order
  • Price group of sales order
  • Client
  • I_BILLINGDOCUMENTITEM.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
  • I_BILLINGDOCUMENTITEM.MANDT == T188.MANDT
Distribution channel of sales order
  • Distribution channel of sales order
  • Client
  • I_BILLINGDOCUMENTITEM.SALESORDERDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_BILLINGDOCUMENTITEM.MANDT == TVTW.MANDT
Price list type of sales order
  • Price list type of sales order
  • Client
  • I_BILLINGDOCUMENTITEM.SALESORDERPRICELISTTYPE == T189.PLTYP
  • I_BILLINGDOCUMENTITEM.MANDT == T189.MANDT
Sales district of sales order
  • Sales district of sales order
  • Client
  • I_BILLINGDOCUMENTITEM.SALESORDERSALESDISTRICT == T171.BZIRK
  • I_BILLINGDOCUMENTITEM.MANDT == T171.MANDT
Sales organization of sales order
  • Sales organization of sales order
  • Client
  • I_BILLINGDOCUMENTITEM.SALESORDERSALESORGANIZATION == TVKO.VKORG
  • I_BILLINGDOCUMENTITEM.MANDT == TVKO.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • I_BILLINGDOCUMENTITEM.SALESPROMOTION == KONA.KNUMA
  • I_BILLINGDOCUMENTITEM.MANDT == KONA.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_BILLINGDOCUMENTITEM.SDDOCUMENTREASON == TVAU.AUGRU
  • I_BILLINGDOCUMENTITEM.MANDT == TVAU.MANDT
Service Document Type
  • Client
  • Service Document Type
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_BILLINGDOCUMENTITEM.MANDT == TVST.MANDT
  • I_BILLINGDOCUMENTITEM.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Storage location
  • Client
  • Plant
  • I_BILLINGDOCUMENTITEM.STORAGELOCATION == T001L.LGORT
  • I_BILLINGDOCUMENTITEM.MANDT == T001L.MANDT
  • I_BILLINGDOCUMENTITEM.PLANT == T001L.WERKS
Volume rebate group
  • Volume rebate group
  • Client
  • I_BILLINGDOCUMENTITEM.VOLUMEREBATEGROUP == TVBO.BONUS
  • I_BILLINGDOCUMENTITEM.MANDT == TVBO.MANDT
Foreign key for J_1ARFZ
  • Reason for Zero VAT
  • Client
  • I_BILLINGDOCUMENTITEM.ZEROVATRSN == J_1ARFZ.J_1ARFZ
  • I_BILLINGDOCUMENTITEM.MANDT == J_1ARFZ.MANDT