I_BillingDocExtdItem

Billing Document Item Extended | view: ISDBILDOCEXITM | ATTR | Extraction: Not supported | Component: Billing
Tables used: 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
PriceDetnExchangeRateDate Translation date
BillingDocumentDate Billing 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
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SalesSDDocumentCategory SD 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
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallBillingStatus SD Billing Status Show values
BillingDocumentCategory Billing Category Show values
BillingDocumentIsTemporary Boolean Variable (X = True, - = False, Space = Unknown) 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
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
ProfitCenter Profit Center PRCTR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
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
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
CustomerPriceGroup Customer Price Group KONDA
CustomerGroup Customer Group KDGRP
Country Destination Country/Region LAND1
Region Region (State, Province, County) REGIO
CityCode City Code CITYC
SalesDistrict Sales District BZIRK
SoldToParty Sold-to Party KUNNR
PayerParty Payer KUNNR
CompanyCode Company Code BUKRS
County County Code COUNC
CustomerRebateAgreement Agreement (various conditions grouped together) KNUMA
PricingDocument Number of the Document Condition KNUMV
CancelledBillingDocument Number of canceled billing document VBELN
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
SalesEmployee Sales Employee PERNR
ResponsibleEmployee Employee Responsible PERNR
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_BILLINGDOCEXTDITEM.MANDT == TVV1.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • I_BILLINGDOCEXTDITEM.MANDT == TVV2.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • I_BILLINGDOCEXTDITEM.MANDT == TVV3.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • I_BILLINGDOCEXTDITEM.MANDT == TVV4.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • I_BILLINGDOCEXTDITEM.MANDT == TVV5.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Material Group 1
  • Client
  • Material Group 1
  • I_BILLINGDOCEXTDITEM.MANDT == TVM1.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_BILLINGDOCEXTDITEM.MANDT == TVM2.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_BILLINGDOCEXTDITEM.MANDT == TVM3.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_BILLINGDOCEXTDITEM.MANDT == TVM4.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_BILLINGDOCEXTDITEM.MANDT == TVM5.MANDT
  • I_BILLINGDOCEXTDITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_BILLINGDOCEXTDITEM.MANDT == T006.MANDT
  • I_BILLINGDOCEXTDITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Product Number
  • Material Number
  • Plant
  • Batch Number
  • I_BILLINGDOCEXTDITEM.MANDT == MCHA.MANDT
  • I_BILLINGDOCEXTDITEM.PRODUCT == MCHA.MATNR
  • I_BILLINGDOCEXTDITEM.MATERIAL == MCHA.MATNR
  • I_BILLINGDOCEXTDITEM.PLANT == MCHA.WERKS
  • I_BILLINGDOCEXTDITEM.BATCH == MCHA.CHARG
Sales unit
  • Client
  • Sales unit
  • I_BILLINGDOCEXTDITEM.MANDT == T006.MANDT
  • I_BILLINGDOCEXTDITEM.BILLINGQUANTITYUNIT == T006.MSEHI
Destination Country/Region of Sales Order
  • Client
  • Destination Country/Region of Sales Order
  • I_BILLINGDOCEXTDITEM.MANDT == T005.MANDT
  • I_BILLINGDOCEXTDITEM.BILLTOPARTYCOUNTRY == T005.LAND1
Region of Sales Order
  • Client
  • Destination Country/Region of Sales Order
  • Region of Sales Order
  • I_BILLINGDOCEXTDITEM.MANDT == T005S.MANDT
  • I_BILLINGDOCEXTDITEM.BILLTOPARTYCOUNTRY == T005S.LAND1
  • I_BILLINGDOCEXTDITEM.BILLTOPARTYREGION == T005S.BLAND
BOM explosion number
  • Client
  • BOM explosion number
  • I_BILLINGDOCEXTDITEM.MANDT == SNUM.MANDT
  • I_BILLINGDOCEXTDITEM.BOMEXPLOSION == SNUM.SERNR
Business Area
  • Client
  • Business Area
  • I_BILLINGDOCEXTDITEM.MANDT == TGSB.MANDT
  • I_BILLINGDOCEXTDITEM.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • I_BILLINGDOCEXTDITEM.MANDT == TKA01.MANDT
  • I_BILLINGDOCEXTDITEM.CONTROLLINGAREA == TKA01.KOKRS
Customer condition group 1
  • Client
  • Customer condition group 1
  • I_BILLINGDOCEXTDITEM.MANDT == TVKGG.MANDT
  • I_BILLINGDOCEXTDITEM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
Customer condition group 2
  • Client
  • Customer condition group 2
  • I_BILLINGDOCEXTDITEM.MANDT == TVKGG.MANDT
  • I_BILLINGDOCEXTDITEM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
Customer condition group 3
  • Client
  • Customer condition group 3
  • I_BILLINGDOCEXTDITEM.MANDT == TVKGG.MANDT
  • I_BILLINGDOCEXTDITEM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer condition group 4
  • Client
  • Customer condition group 4
  • I_BILLINGDOCEXTDITEM.MANDT == TVKGG.MANDT
  • I_BILLINGDOCEXTDITEM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
Customer condition group 5
  • Client
  • Customer condition group 5
  • I_BILLINGDOCEXTDITEM.MANDT == TVKGG.MANDT
  • I_BILLINGDOCEXTDITEM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Departure Country/Region (from which the goods are sent)
  • Client
  • Departure Country/Region (from which the goods are sent)
  • I_BILLINGDOCEXTDITEM.MANDT == T005.MANDT
  • I_BILLINGDOCEXTDITEM.DEPARTURECOUNTRY == T005.LAND1
Division
  • Client
  • Division
  • I_BILLINGDOCEXTDITEM.MANDT == TSPA.MANDT
  • I_BILLINGDOCEXTDITEM.DIVISION == TSPA.SPART
Volume unit
  • Client
  • Volume unit
  • I_BILLINGDOCEXTDITEM.MANDT == T006.MANDT
  • I_BILLINGDOCEXTDITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • I_BILLINGDOCEXTDITEM.MANDT == T006.MANDT
  • I_BILLINGDOCEXTDITEM.ITEMWEIGHTUNIT == T006.MSEHI
Material pricing group of main item
  • Client
  • Material pricing group of main item
  • I_BILLINGDOCEXTDITEM.MANDT == T178.MANDT
  • I_BILLINGDOCEXTDITEM.MAINITEMMATERIALPRICINGGROUP == T178.KONDM
Pricing reference material of main item
  • Client
  • Pricing reference material of main item
  • I_BILLINGDOCEXTDITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCEXTDITEM.MAINITEMPRICINGREFMATERIAL == MARA.MATNR
Material Number
  • Client
  • Product Number
  • Material Number
  • I_BILLINGDOCEXTDITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCEXTDITEM.PRODUCT == MARA.MATNR
  • I_BILLINGDOCEXTDITEM.MATERIAL == MARA.MATNR
Commission Group
  • Client
  • Commission Group
  • I_BILLINGDOCEXTDITEM.MANDT == TVPR.MANDT
  • I_BILLINGDOCEXTDITEM.MATERIALCOMMISSIONGROUP == TVPR.PROVG
Material Group
  • Client
  • Product Group
  • Material Group
  • I_BILLINGDOCEXTDITEM.MANDT == T023.MANDT
  • I_BILLINGDOCEXTDITEM.PRODUCTGROUP == T023.MATKL
  • I_BILLINGDOCEXTDITEM.MATERIALGROUP == T023.MATKL
Material Price Group
  • Client
  • Material Price Group
  • I_BILLINGDOCEXTDITEM.MANDT == T178.MANDT
  • I_BILLINGDOCEXTDITEM.MATERIALPRICINGGROUP == T178.KONDM
Account Assignment Group for Material
  • Account Assignment Group for Material
  • Client
  • I_BILLINGDOCEXTDITEM.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM
  • I_BILLINGDOCEXTDITEM.MANDT == TVKM.MANDT
Order Number
  • Order Number
  • Client
  • I_BILLINGDOCEXTDITEM.ORDERID == AUFK.AUFNR
  • I_BILLINGDOCEXTDITEM.MANDT == AUFK.MANDT
Division for order header
  • Client
  • Division for order header
  • I_BILLINGDOCEXTDITEM.MANDT == TSPA.MANDT
  • I_BILLINGDOCEXTDITEM.ORGANIZATIONDIVISION == TSPA.SPART
Material Entered
  • Client
  • Material Entered
  • I_BILLINGDOCEXTDITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCEXTDITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_BILLINGDOCEXTDITEM.MANDT == T001W.MANDT
  • I_BILLINGDOCEXTDITEM.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)
  • I_BILLINGDOCEXTDITEM.MANDT == T005S.MANDT
  • I_BILLINGDOCEXTDITEM.PLANTREGION == T005S.BLAND
  • I_BILLINGDOCEXTDITEM.DEPARTURECOUNTRY == T005S.LAND1
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • I_BILLINGDOCEXTDITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCEXTDITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR
Product Number
  • Client
  • Product Number
  • Material Number
  • I_BILLINGDOCEXTDITEM.MANDT == MARA.MANDT
  • I_BILLINGDOCEXTDITEM.PRODUCT == MARA.MATNR
  • I_BILLINGDOCEXTDITEM.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Product Group
  • Material Group
  • I_BILLINGDOCEXTDITEM.MANDT == T023.MANDT
  • I_BILLINGDOCEXTDITEM.PRODUCTGROUP == T023.MATKL
  • I_BILLINGDOCEXTDITEM.MATERIALGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • I_BILLINGDOCEXTDITEM.MANDT == T179.MANDT
  • I_BILLINGDOCEXTDITEM.PRODUCTHIERARCHYNODE == T179.PRODH
Promotion
  • Client
  • Promotion
  • I_BILLINGDOCEXTDITEM.MANDT == WAKH.MANDT
  • I_BILLINGDOCEXTDITEM.RETAILPROMOTION == WAKH.AKTNR
Sales Deal
  • Client
  • Sales Deal
  • I_BILLINGDOCEXTDITEM.MANDT == KONA.MANDT
  • I_BILLINGDOCEXTDITEM.SALESDEAL == KONA.KNUMA
Sales group
  • Client
  • Sales group
  • I_BILLINGDOCEXTDITEM.MANDT == TVKGR.MANDT
  • I_BILLINGDOCEXTDITEM.SALESGROUP == TVKGR.VKGRP
Sales office
  • Client
  • Sales office
  • I_BILLINGDOCEXTDITEM.MANDT == TVBUR.MANDT
  • I_BILLINGDOCEXTDITEM.SALESOFFICE == TVBUR.VKBUR
Customer group of sales order
  • Client
  • Customer group of sales order
  • I_BILLINGDOCEXTDITEM.MANDT == T151.MANDT
  • I_BILLINGDOCEXTDITEM.SALESORDERCUSTOMERGROUP == T151.KDGRP
Price group of sales order
  • Client
  • Price group of sales order
  • I_BILLINGDOCEXTDITEM.MANDT == T188.MANDT
  • I_BILLINGDOCEXTDITEM.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
Distribution channel of sales order
  • Client
  • Distribution channel of sales order
  • I_BILLINGDOCEXTDITEM.MANDT == TVTW.MANDT
  • I_BILLINGDOCEXTDITEM.SALESORDERDISTRIBUTIONCHANNEL == TVTW.VTWEG
Price list type of sales order
  • Client
  • Price list type of sales order
  • I_BILLINGDOCEXTDITEM.MANDT == T189.MANDT
  • I_BILLINGDOCEXTDITEM.SALESORDERPRICELISTTYPE == T189.PLTYP
Sales district of sales order
  • Sales district of sales order
  • Client
  • I_BILLINGDOCEXTDITEM.SALESORDERSALESDISTRICT == T171.BZIRK
  • I_BILLINGDOCEXTDITEM.MANDT == T171.MANDT
Sales organization of sales order
  • Client
  • Sales organization of sales order
  • I_BILLINGDOCEXTDITEM.MANDT == TVKO.MANDT
  • I_BILLINGDOCEXTDITEM.SALESORDERSALESORGANIZATION == TVKO.VKORG
Sales Promotion
  • Client
  • Sales Promotion
  • I_BILLINGDOCEXTDITEM.MANDT == KONA.MANDT
  • I_BILLINGDOCEXTDITEM.SALESPROMOTION == KONA.KNUMA
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • I_BILLINGDOCEXTDITEM.MANDT == TVAU.MANDT
  • I_BILLINGDOCEXTDITEM.SDDOCUMENTREASON == TVAU.AUGRU
Service Document Type
  • Client
  • Service Document Type
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_BILLINGDOCEXTDITEM.MANDT == TVST.MANDT
  • I_BILLINGDOCEXTDITEM.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Plant
  • Storage location
  • I_BILLINGDOCEXTDITEM.MANDT == T001L.MANDT
  • I_BILLINGDOCEXTDITEM.PLANT == T001L.WERKS
  • I_BILLINGDOCEXTDITEM.STORAGELOCATION == T001L.LGORT
Volume rebate group
  • Client
  • Volume rebate group
  • I_BILLINGDOCEXTDITEM.MANDT == TVBO.MANDT
  • I_BILLINGDOCEXTDITEM.VOLUMEREBATEGROUP == TVBO.BONUS
Foreign key for J_1ARFZ
  • Reason for Zero VAT
  • Client
  • I_BILLINGDOCEXTDITEM.ZEROVATRSN == J_1ARFZ.J_1ARFZ
  • I_BILLINGDOCEXTDITEM.MANDT == J_1ARFZ.MANDT