C_SalesDocItmPrcgElmntDEX_1

Data Extraction for Sales Doc Item Pricing Elements | view: CSDSDOCITMPEDX1 | TRAN | Extraction: Full or Incremental | Component: Sales Analytics
Tables used: VBAP, PRCD_ELEMENTS, VBAK, VBAK, VBAP, VBKD, VEDA, T001, TKA02
Column Name Description
PricingDocument Number of the Document Condition
PricingDocumentItem Condition item number
PricingProcedureStep Step Number
PricingProcedureCounter Condition Counter
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ConditionAmount Condition Value
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesDocumentDate Document Date (Date Received/Sent)
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
BillingDocumentDate Billing Date
Column Name Description
ConditionCategory Condition Category (Examples: Tax, Freight, Price, Cost) Show values
ConditionClass Condition Class Show values
SDDocumentCategory SD Document Category Show values
IsReturnsItem Returns Item Show values
ConditionInactiveReason Condition is Inactive Show values
ConditionIsForConfiguration Condition Used for Variant Configuration Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ConditionIsForStatistics Condition is used for statistics Show values
ConditionOrigin Origin of the Condition Show values
StatisticalValueControl Statistical Values Show values
ItemIsBillingRelevant Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
Column Name Description Domain name
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ConditionApplication Application KAPPL
ConditionType Condition Type KSCHL
IncotermsTransferLocation Incoterms (Part 2) INCO2
ShipToParty Ship-to Party KUNNR
PayerParty Payer KUNNR
BillToParty Bill-to Party KUNNR
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
VariantCondition Variant Condition Key VARCON
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
CostCenter Cost Center KOSTL
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVV1.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVV3.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVV4.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVV5.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Material Group 1
  • Material Group 1
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVM2.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVM4.MANDT
Material Group 5
  • Client
  • Material Group 5
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVM5.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T001.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.BILLINGCOMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TKA01.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TCURC.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.CURRENCY == TCURC.WAERS
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.CUSTOMERGROUP == T151.KDGRP
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T151.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVKOV.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESDOCITMPRCGELMNTDEX_1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • Division
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TSPA.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.DIVISION == TSPA.SPART
  • C_SALESDOCITMPRCGELMNTDEX_1.ORGANIZATIONDIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TCURV.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.EXCHANGERATETYPE == TCURV.KURST
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T009.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.FISCALYEARVARIANT == T009.PERIV
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TINC.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVFS.MANDT
Material: order item
  • Client
  • Material Number
  • Product Number
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == MARA.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.MATERIAL == MARA.MATNR
  • C_SALESDOCITMPRCGELMNTDEX_1.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • Product Group
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T023.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.MATERIALGROUP == T023.MATKL
  • C_SALESDOCITMPRCGELMNTDEX_1.PRODUCTGROUP == T023.MATKL
Sales unit
  • Client
  • Sales unit
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T006.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Client
  • Division
  • Division
  • Sales Organization
  • Distribution Channel
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVTA.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.DIVISION == TVTA.SPART
  • C_SALESDOCITMPRCGELMNTDEX_1.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESORGANIZATION == TVTA.VKORG
  • C_SALESDOCITMPRCGELMNTDEX_1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Material Entered
  • Material Entered
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == MARA.MANDT
Material: order item
  • Client
  • Material Number
  • Product Number
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == MARA.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.MATERIAL == MARA.MATNR
  • C_SALESDOCITMPRCGELMNTDEX_1.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Material Group
  • Product Group
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T023.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.MATERIALGROUP == T023.MATKL
  • C_SALESDOCITMPRCGELMNTDEX_1.PRODUCTGROUP == T023.MATKL
Sales District
  • Client
  • Sales District
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T171.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Sales document item category
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVAG.MANDT
Order type in order header
  • Client
  • Sales Document Type
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVAK.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVBVK.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESOFFICE == TVBVK.VKBUR
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVKO.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.SDDOCUMENTREASON == TVAU.AUGRU
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVAU.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESDOCITMPRCGELMNTDEX_1.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TCURC.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.STATISTICSCURRENCY == TCURC.WAERS
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == T006.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.TARGETQUANTITYUNIT == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Division
  • Division
  • Sales Organization
  • Distribution Channel
  • C_SALESDOCITMPRCGELMNTDEX_1.MANDT == TVKBZ.MANDT
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESDOCITMPRCGELMNTDEX_1.DIVISION == TVKBZ.SPART
  • C_SALESDOCITMPRCGELMNTDEX_1.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SALESDOCITMPRCGELMNTDEX_1.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESDOCITMPRCGELMNTDEX_1.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG