I_PrelimBillgDocItemAnalytics

Preliminary Billing Document Item Analytics | view: ISDPREBILDITMANA | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRK, VBRP, T001, TKA02, TKA01, KNA1, T042Z, T042ZT, T001W, KONA, TVKO, T000, T001L, USR21
Column Name Description
PrelimBillingDocument FK Preliminary Billing Document
PrelimBillingDocumentItem Preliminary Billing Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
RebateBasisAmount Rebate Basis 1
ItemGrossAmountOfBillingDoc 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
PrelimBillgSlsVolNetAmt Preliminary Sales Volume Net Amount
ItemNetAmountOfBillingDoc Net Value of Billing item in Document Currency
💲 Statistics currency (StatisticsCurrency):
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
LastChangeDate Last Changed On
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
BillingDocumentDate Billing Date
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
FixedValueDate Fixed Value Date
ExchangeRateDate Translation date
Column Name Description
SDDocumentCategory SD Document Category Show values
BillingDocumentCategory Billing Category Show values
SalesDocumentItemType Sales Document Item Type Show values
ReturnItemProcessingType Processing Type of Return Item Show values
ItemIsRelevantForCredit Item Relevant for Credit Check Show values
BillingPlanRule Rule in billing plan/invoice plan Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
StatisticalValueControl Statistical Values Show values
ReferenceSDDocumentCategory Reference Document Category Show values
SalesSDDocumentCategory Sales SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
BillingIssueType Billing Document Issue Type Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
Column Name Description Domain name
SalesDocumentItemCategory Sales Document Item Category PSTYV
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
SoldToPartyName Name of Sold-to Party TEXT80
PayerPartyName Payer Name TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
SalesDealDescription Sales Deal Description TEXT40
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
ForeignTrade Number of foreign trade data in MM and SD documents EXNUM
IsExportDelivery Export Delivery Indicator EXPKZ
BillingDocCombinationCriteria Combination criteria in the billing document CHAR40
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
TaxDepartureCountry Tax Departure Country/Region LAND1
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
CustomerTaxClassification1 Tax Classification 1 for Customer TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ContractAccount Contract Account Number CORR_VKONT_KK
CustomerPaymentTerms Terms of payment key ZTERM
PaymentMethodName Payment Method Name TEXT30
PaymentReference Payment Reference CHAR30
AdditionalValueDays Additional Value Days TAGE2
CompanyCodeName Name of Company Code or Company TEXT25
DocumentReferenceID Document Reference ID XBLNR1
AssignmentReference Assignment Number ZUONR
ProfitCenter Profit Center PRCTR
ControllingAreaName Controlling Area Name TEXT25
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
CostCenter Cost Center KOSTL
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating SD Document 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
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVV1.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVV5.MANDT
Material Group 1
  • Client
  • Material Group 1
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVM1.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Material Group 2
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVM2.MANDT
Material Group 3
  • Client
  • Material Group 3
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVM3.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVM4.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.BASEUNIT == T006.MSEHI
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Plant
  • Material Number
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.BATCH == MCHA.CHARG
  • I_PRELIMBILLGDOCITEMANALYTICS.PLANT == MCHA.WERKS
  • I_PRELIMBILLGDOCITEMANALYTICS.MATERIAL == MCHA.MATNR
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == MCHA.MANDT
Billing Type
  • Billing Type
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVFK.MANDT
Billing Quantity Unit
  • Billing Quantity Unit
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.BILLINGQUANTITYUNIT == T006.MSEHI
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T006.MANDT
Destination Country/Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.BILLTOPARTYCOUNTRY == T005.LAND1
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T005.MANDT
Region of Sales Order
  • Region of Sales Order
  • Destination Country/Region of Sales Order
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.BILLTOPARTYREGION == T005S.BLAND
  • I_PRELIMBILLGDOCITEMANALYTICS.BILLTOPARTYCOUNTRY == T005S.LAND1
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T005S.MANDT
Business Area
  • Business Area
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.BUSINESSAREA == TGSB.GSBER
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TGSB.MANDT
City Code
  • Client
  • Region (State, Province, County)
  • City Code
  • Destination Country/Region
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T005G.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.REGION == T005G.REGIO
  • I_PRELIMBILLGDOCITEMANALYTICS.CITYCODE == T005G.CITYC
  • I_PRELIMBILLGDOCITEMANALYTICS.COUNTRY == T005G.LAND1
Company Code
  • Company Code
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.COMPANYCODE == T001.BUKRS
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.CONTROLLINGAREA == TKA01.KOKRS
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TKA01.MANDT
Destination Country/Region
  • Client
  • Destination Country/Region
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T005.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.COUNTRY == T005.LAND1
County Code
  • Client
  • Region (State, Province, County)
  • County Code
  • Destination Country/Region
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T005E.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.REGION == T005E.REGIO
  • I_PRELIMBILLGDOCITEMANALYTICS.COUNTY == T005E.COUNC
  • I_PRELIMBILLGDOCITEMANALYTICS.COUNTRY == T005E.LAND1
Credit control area
  • Credit control area
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.CREDITCONTROLAREA == T014.KKBER
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T014.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVKT.MANDT
Customer Group
  • Client
  • Customer Group
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T151.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.CUSTOMERGROUP == T151.KDGRP
Customer Price Group
  • Client
  • Customer Price Group
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T188.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.CUSTOMERPRICEGROUP == T188.KONDA
Customer Rebate Agreement
  • Customer Rebate Agreement
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == KONA.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TSPA.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.DIVISION == TSPA.SPART
Dunning Area
  • Company Code
  • Dunning Area
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.COMPANYCODE == T047M.BUKRS
  • I_PRELIMBILLGDOCITEMANALYTICS.DUNNINGAREA == T047M.MABER
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T047M.MANDT
Dunning Block
  • Dunning Block
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.DUNNINGBLOCKINGREASON == T040S.MANSP
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T040S.MANDT
Dunning Key
  • Dunning Key
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.DUNNINGKEY == T040.MSCHL
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T040.MANDT
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TCURV.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.EXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.INCOTERMSVERSION == TINCV.INCOV
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TINCV.MANDT
Volume unit
  • Client
  • Volume unit
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T006.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.ITEMWEIGHTUNIT == T006.MSEHI
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.MATERIAL == MARA.MATNR
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == MARA.MANDT
Commission Group
  • Commission Group
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.MATERIALCOMMISSIONGROUP == TVPR.PROVG
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVPR.MANDT
Material Group
  • Material Group
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.MATERIALGROUP == T023.MATKL
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T023.MANDT
Organization Division
  • Client
  • Organization Division
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TSPA.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.ORGANIZATIONDIVISION == TSPA.SPART
Material Entered
  • Client
  • Material Entered
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == MARA.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T880.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.PARTNERCOMPANY == T880.RCOMP
Payer
  • Payer
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.PAYERPARTY == KNA1.KUNNR
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == KNA1.MANDT
Payment Method
  • Payment Method
  • Client
  • Destination Country/Region
  • I_PRELIMBILLGDOCITEMANALYTICS.PAYMENTMETHOD == T042Z.ZLSCH
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T042Z.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.COUNTRY == T042Z.LAND1
Plant
  • Plant
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.PLANT == T001W.WERKS
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T001W.MANDT
Price List Type
  • Client
  • Price List Type
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T189.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.PRICELISTTYPE == T189.PLTYP
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.PRICINGREFERENCEMATERIAL == MARA.MATNR
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == MARA.MANDT
Product hierarchy
  • Client
  • Product hierarchy
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T179.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.PRODUCTHIERARCHYNODE == T179.PRODH
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Destination Country/Region
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T005S.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.REGION == T005S.BLAND
  • I_PRELIMBILLGDOCITEMANALYTICS.COUNTRY == T005S.LAND1
Retail Promotion
  • Retail Promotion
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.RETAILPROMOTION == WAKH.AKTNR
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == WAKH.MANDT
Sales Deal
  • Sales Deal
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.SALESDEAL == KONA.KNUMA
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == KONA.MANDT
Sales District
  • Sales District
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.SALESDISTRICT == T171.BZIRK
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T171.MANDT
Sales group
  • Client
  • Sales group
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVKGR.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.SALESGROUP == TVKGR.VKGRP
Sales office
  • Sales office
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.SALESOFFICE == TVBUR.VKBUR
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVBUR.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVKO.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.SALESORGANIZATION == TVKO.VKORG
Sales Promotion
  • Client
  • Sales Promotion
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == KONA.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.SALESPROMOTION == KONA.KNUMA
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.SDDOCUMENTREASON == TVAU.AUGRU
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVAU.MANDT
Pricing Procedure in Pricing
  • ?
  • Pricing Procedure in Pricing
  • ?
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.[column in domain "KVEWE"] == T683.KVEWE
  • I_PRELIMBILLGDOCITEMANALYTICS.SDPRICINGPROCEDURE == T683.KALSM
  • I_PRELIMBILLGDOCITEMANALYTICS.[column in domain "KAPPL"] == T683.KAPPL
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T683.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVSB.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.SHIPPINGPOINT == TVST.VSTEL
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVST.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.SOLDTOPARTY == KNA1.KUNNR
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == KNA1.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TKUKL.MANDT
Statistics currency
  • Client
  • Statistics currency
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TCURC.MANDT
  • I_PRELIMBILLGDOCITEMANALYTICS.STATISTICSCURRENCY == TCURC.WAERS
Storage location
  • Storage location
  • Plant
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.STORAGELOCATION == T001L.LGORT
  • I_PRELIMBILLGDOCITEMANALYTICS.PLANT == T001L.WERKS
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == T001L.MANDT
Volume rebate group
  • Volume rebate group
  • Client
  • I_PRELIMBILLGDOCITEMANALYTICS.VOLUMEREBATEGROUP == TVBO.BONUS
  • I_PRELIMBILLGDOCITEMANALYTICS.MANDT == TVBO.MANDT