I_BillgItmPrcgElmntsAnlyts

Billing Document Item Pricing Element Analytics | view: ISDBDIPEANA | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRPPRCD_ELEMENTS
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Document Item
PricingProcedureStep Step Number
PricingProcedureCounter Condition Counter
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ConditionAmount Condition Value in Transactional Currency
NormalizedConditionAmount Normalized Condition Value in Transactional Currency
Column Name Description
Column Name Description
PriceConditionDeterminationDte null
BillingDocumentDate Billing Date
Column Name Description
ConditionCategory Condition Category (Examples: Tax, Freight, Price, Cost) Show values
ConditionClass Condition Class Show values
ConditionIsForStatistics Condition is used for statistics Show values
ConditionControl Condition Control Show values
ConditionInactiveReason Condition is Inactive Show values
ReturnItemProcessingType Processing Type of Return Item Show values
SalesDocumentItemType Sales Document Item Type Show values
BillingDocumentCategory Billing Category Show values
SDDocumentCategory SD Document Category Show values
ConditionOrigin Origin of the Condition Show values
ConditionIsManuallyChanged Condition Changed Manually Show values
ConditionCalculationType Calculation Type for Condition Show values
Column Name Description Domain name
ConditionApplication Application KAPPL
ConditionType Condition Type KSCHL
SalesDocumentItemCategory Sales Document Item Category PSTYV
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
ConditionRecord Number of the Condition Record KNUMH
ConditionSequentialNumber Sequential Number of the Condition NUM03
ConditionQuantity Condition Pricing Unit KPEIN
ConditionBaseQuantity Quantity of the Condition Basis VFPRC_DEC_VALUE
Master Data Relations Join Conditions
Division
  • Division
  • Client
  • I_BILLGITMPRCGELMNTSANLYTS.DIVISION == TSPA.SPART
  • I_BILLGITMPRCGELMNTSANLYTS.MANDT == TSPA.MANDT
Organization Division
  • Organization Division
  • Client
  • I_BILLGITMPRCGELMNTSANLYTS.ORGANIZATIONDIVISION == TSPA.SPART
  • I_BILLGITMPRCGELMNTSANLYTS.MANDT == TSPA.MANDT
Product Number
  • Product Number
  • Client
  • I_BILLGITMPRCGELMNTSANLYTS.PRODUCT == MARA.MATNR
  • I_BILLGITMPRCGELMNTSANLYTS.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • I_BILLGITMPRCGELMNTSANLYTS.PRODUCTGROUP == T023.MATKL
  • I_BILLGITMPRCGELMNTSANLYTS.MANDT == T023.MANDT
Sales office
  • Sales office
  • Client
  • I_BILLGITMPRCGELMNTSANLYTS.SALESOFFICE == TVBUR.VKBUR
  • I_BILLGITMPRCGELMNTSANLYTS.MANDT == TVBUR.MANDT