C_BillgDocItmPrcgElmntBscDEX_1

Data Extraction for Billing Doc Item Pricing Element Basic | view: CSDBDOCITMPECDX1 | TRAN | Extraction: Full or Incremental | Component: Sales Analytics
Tables used: VBRP, VBRK, PRCD_ELEMENTS, 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 (BillingQuantityUnit):
BillingQuantity Actual billed quantity
Column Name Description
LastChangeDate Last Changed On
CreationDate Date on which the record was created
CreationTime Entry time
PricingDate Date for Pricing and Exchange Rate
PriceDetnExchangeRateDate Translation date
BillingDocumentDate Billing Date
ServicesRenderedDate Date on which services are rendered
Column Name Description
ConditionCategory Condition Category (Examples: Tax, Freight, Price, Cost) Show values
ConditionClass Condition Class Show values
BillingDocumentCategory Billing Category Show values
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type Show values
ReturnItemProcessingType Returns item Show values
ConditionIsForStatistics Condition is used for statistics Show values
ConditionOrigin Origin of the Condition Show values
ConditionInactiveReason Condition is Inactive Show values
ConditionIsForConfiguration Condition Used for Variant Configuration Show values
StatisticalValueControl Statistical Values Show values
BillingDocumentIsCancelled Billing document is canceled Show values
BillingDocumentIsTemporary IsDraft Indicator Show values
BillingPlanRule Rule in billing plan/invoice plan Show values
OverallBillingStatus SD Billing Status Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
BillingDocument Billing Document VBELN
BillingDocumentItem Billing Item POSNR
ConditionApplication Application KAPPL
ConditionType Condition Type KSCHL
SalesDocumentItemCategory Sales document item category PSTYV
BillToParty Bill-to Party KUNNR
ShipToParty Ship-to Party KUNNR
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
VariantCondition Variant Condition Key VARCON
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
AccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
CostCenter Cost Center KOSTL
StatisticsExchangeRate Exchange rate for statistics (Exch.rate at time of creation) KURRF_NOT_CONVERTED
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_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVV1.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVV3.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVV4.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVV5.MANDT
Material Group 1
  • Material Group 1
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVM2.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVM3.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVM4.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVM5.MANDT
Billing Type
  • Billing Type
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVFK.MANDT
Sales unit
  • Sales unit
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.BILLINGQUANTITYUNIT == T006.MSEHI
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.COMPANYCODE == T001.BUKRS
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TKA01.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Currency Key
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.CURRENCY == TCURC.WAERS
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TCURC.MANDT
Customer Group
  • Customer Group
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.CUSTOMERGROUP == T151.KDGRP
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == T151.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVTW.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TSPA.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.EXCHANGERATETYPE == TCURV.KURST
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TCURV.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.FISCALYEARVARIANT == T009.PERIV
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == T009.MANDT
Material Number
  • Material Number
  • Product Number
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MATERIAL == MARA.MATNR
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.PRODUCT == MARA.MATNR
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == MARA.MANDT
Commission Group
  • Commission Group
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MATERIALCOMMISSIONGROUP == TVPR.PROVG
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVPR.MANDT
Material Group
  • Material Group
  • Product Group
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MATERIALGROUP == T023.MATKL
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.PRODUCTGROUP == T023.MATKL
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == T023.MANDT
Division for order header
  • Division for order header
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ORGANIZATIONDIVISION == TSPA.SPART
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TSPA.MANDT
Material Entered
  • Material Entered
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == MARA.MANDT
Payer
  • Payer
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.PAYERPARTY == KNA1.KUNNR
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == KNA1.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MATERIAL == MARA.MATNR
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.PRODUCT == MARA.MATNR
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == MARA.MANDT
Product Group
  • Material Group
  • Product Group
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MATERIALGROUP == T023.MATKL
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.PRODUCTGROUP == T023.MATKL
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == T023.MANDT
Sales District
  • Sales District
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.SALESDISTRICT == T171.BZIRK
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == T171.MANDT
Sales group
  • Sales group
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.SALESGROUP == TVKGR.VKGRP
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVKGR.MANDT
Sales office
  • Client
  • Sales office
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVBUR.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Sales Organization
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.SALESORGANIZATION == TVKO.VKORG
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.SOLDTOPARTY == KNA1.KUNNR
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.MANDT == TCURC.MANDT
  • C_BILLGDOCITMPRCGELMNTBSCDEX_1.STATISTICSCURRENCY == TCURC.WAERS