I_PrelimBillingDocumentItem

Preliminary Billing Document Item | view: ISDPREBILDOCITEM | ATTR | Extraction: Not supported | Component: Billing
Tables used: VBRK, VBRP
Column Name Description
PrelimBillingDocument FK Preliminary Billing Document
PrelimBillingDocumentItem Preliminary Billing Document 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
📏 Billing Quantity Unit (BillingQuantityUnit):
BillingQuantity Billing 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 Sales Document 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
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 Billing Document Item TEXT40
BillingToBaseQuantityDnmntr Denominator (divisor) for conversion of billing Qty into SKU UMBSN
BillingToBaseQuantityNmrtr Numerator (factor) for conversion of bill. 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
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
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
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_PRELIMBILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVV5.MANDT
Material Group 1
  • Material Group 1
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVM2.MANDT
Material Group 3
  • Client
  • Material Group 3
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVM3.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Material Group 4
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.BASEUNIT == T006.MSEHI
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Plant
  • Client
  • Material Number
  • Product Number
  • I_PRELIMBILLINGDOCUMENTITEM.BATCH == MCHA.CHARG
  • I_PRELIMBILLINGDOCUMENTITEM.PLANT == MCHA.WERKS
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == MCHA.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.MATERIAL == MCHA.MATNR
  • I_PRELIMBILLINGDOCUMENTITEM.PRODUCT == MCHA.MATNR
Billing Quantity Unit
  • Client
  • Billing Quantity Unit
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T006.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.BILLINGQUANTITYUNIT == T006.MSEHI
Destination Country/Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.BILLTOPARTYCOUNTRY == T005.LAND1
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T005.MANDT
Region of Sales Order
  • Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.BILLTOPARTYREGION == T005S.BLAND
  • I_PRELIMBILLINGDOCUMENTITEM.BILLTOPARTYCOUNTRY == T005S.LAND1
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T005S.MANDT
BOM explosion number
  • Client
  • BOM explosion number
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == SNUM.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.BOMEXPLOSION == SNUM.SERNR
Business Area
  • Business Area
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.BUSINESSAREA == TGSB.GSBER
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TKA01.MANDT
Customer condition group 1
  • Customer condition group 1
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Customer condition group 2
  • Customer condition group 2
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Customer condition group 3
  • Customer condition group 3
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Customer condition group 4
  • Customer condition group 4
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Customer condition group 5
  • Customer condition group 5
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKGG.MANDT
Departure Country/Region (from which the goods are sent)
  • Departure Country/Region (from which the goods are sent)
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.DEPARTURECOUNTRY == T005.LAND1
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T005.MANDT
Division
  • Division
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.DIVISION == TSPA.SPART
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TSPA.MANDT
Volume unit
  • Client
  • Volume unit
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T006.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T006.MANDT
Material pricing group of main item
  • Client
  • Material pricing group of main item
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T178.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.MAINITEMMATERIALPRICINGGROUP == T178.KONDM
Pricing reference material of main item
  • Pricing reference material of main item
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.MAINITEMPRICINGREFMATERIAL == MARA.MATNR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == MARA.MANDT
Material Number
  • Client
  • Material Number
  • Product Number
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == MARA.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_PRELIMBILLINGDOCUMENTITEM.PRODUCT == MARA.MATNR
Commission Group
  • Commission Group
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.MATERIALCOMMISSIONGROUP == TVPR.PROVG
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVPR.MANDT
Material Group
  • Product Group
  • Material Group
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_PRELIMBILLINGDOCUMENTITEM.MATERIALGROUP == T023.MATKL
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T023.MANDT
Material Price Group
  • Material Price Group
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.MATERIALPRICINGGROUP == T178.KONDM
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T178.MANDT
Account Assignment Group for Material
  • Account Assignment Group for Material
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKM.MANDT
Order Number
  • Order Number
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ORDERID == AUFK.AUFNR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == AUFK.MANDT
Division in Sales Order Header
  • Client
  • Division in Sales Order Header
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TSPA.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.ORGANIZATIONDIVISION == TSPA.SPART
Material Entered
  • Client
  • Material Entered
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == MARA.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.PLANT == T001W.WERKS
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T001W.MANDT
Region in which plant is located
  • Departure Country/Region (from which the goods are sent)
  • Client
  • Region in which plant is located
  • I_PRELIMBILLINGDOCUMENTITEM.DEPARTURECOUNTRY == T005S.LAND1
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T005S.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.PLANTREGION == T005S.BLAND
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == MARA.MANDT
Product Number
  • Client
  • Material Number
  • Product Number
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == MARA.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_PRELIMBILLINGDOCUMENTITEM.PRODUCT == MARA.MATNR
Product Group
  • Product Group
  • Material Group
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_PRELIMBILLINGDOCUMENTITEM.MATERIALGROUP == T023.MATKL
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T023.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T179.MANDT
Promotion
  • Promotion
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.RETAILPROMOTION == WAKH.AKTNR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == WAKH.MANDT
Sales Deal
  • Sales Deal
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESDEAL == KONA.KNUMA
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == KONA.MANDT
Sales group
  • Client
  • Sales group
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKGR.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.SALESGROUP == TVKGR.VKGRP
Sales office
  • Sales office
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESOFFICE == TVBUR.VKBUR
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVBUR.MANDT
Customer group of sales order
  • Customer group of sales order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESORDERCUSTOMERGROUP == T151.KDGRP
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T151.MANDT
Price group of sales order
  • Price group of sales order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T188.MANDT
Distribution channel of sales order
  • Distribution channel of sales order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESORDERDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVTW.MANDT
Price list type of sales order
  • Price list type of sales order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESORDERPRICELISTTYPE == T189.PLTYP
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T189.MANDT
Sales district of sales order
  • Sales district of sales order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESORDERSALESDISTRICT == T171.BZIRK
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T171.MANDT
Sales organization of sales order
  • Sales organization of sales order
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESORDERSALESORGANIZATION == TVKO.VKORG
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVKO.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SALESPROMOTION == KONA.KNUMA
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == KONA.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.SDDOCUMENTREASON == TVAU.AUGRU
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVAU.MANDT
Service Document Type
  • Service Document Type
  • Client
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVST.MANDT
  • I_PRELIMBILLINGDOCUMENTITEM.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Storage location
  • Plant
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.STORAGELOCATION == T001L.LGORT
  • I_PRELIMBILLINGDOCUMENTITEM.PLANT == T001L.WERKS
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == T001L.MANDT
Volume rebate group
  • Volume rebate group
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.VOLUMEREBATEGROUP == TVBO.BONUS
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == TVBO.MANDT
Foreign key for J_1ARFZ
  • Reason for Zero VAT
  • Client
  • I_PRELIMBILLINGDOCUMENTITEM.ZEROVATRSN == J_1ARFZ.J_1ARFZ
  • I_PRELIMBILLINGDOCUMENTITEM.MANDT == J_1ARFZ.MANDT