C_BillgItmPrcgElForCoTypQ

Billing Item Pricing Element for Condition Type - Query | view: CSDBDIPEFCOTYQ | Extraction: Not supported | Component: Sales Analytics
Column Name Description
BillingDocument FK Billing Document
BillingDocumentItem Billing Document Item
PricingProcedureStep Step Number
PricingProcedureCounter Condition Counter
Column Name Description
💲 Display Currency (DisplayCurrency):
ConditionAmountInDC Condition Value in Display Currrency
NormalizedConditionAmountInDC Condition Value in Display Currency
Column Name Description
Column Name Description
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
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
PricingDateTime Timestamp for Pricing TIMESTAMP
BillingDocumentDateYear Year of Billing NUM4
BillingDocDateYearQuarter Quarter/Year of Billing NUM5
BillingDocDateYearMonth Month/Year of Billing NUM6
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
ConditionRecord Number of the Condition Record KNUMH
ConditionSequentialNumber Sequential Number of the Condition NUM03
ConditionBaseQuantity Quantity of the Condition Basis
Master Data Relations Join Conditions
Division
  • Division
  • Client
  • C_BILLGITMPRCGELFORCOTYPQ.DIVISION == TSPA.SPART
  • C_BILLGITMPRCGELFORCOTYPQ.MANDT == TSPA.MANDT
Organization Division
  • Client
  • Organization Division
  • C_BILLGITMPRCGELFORCOTYPQ.MANDT == TSPA.MANDT
  • C_BILLGITMPRCGELFORCOTYPQ.ORGANIZATIONDIVISION == TSPA.SPART
Product Number
  • Product Number
  • Client
  • C_BILLGITMPRCGELFORCOTYPQ.PRODUCT == MARA.MATNR
  • C_BILLGITMPRCGELFORCOTYPQ.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_BILLGITMPRCGELFORCOTYPQ.PRODUCTGROUP == T023.MATKL
  • C_BILLGITMPRCGELFORCOTYPQ.MANDT == T023.MANDT
Sales office
  • Sales office
  • Client
  • C_BILLGITMPRCGELFORCOTYPQ.SALESOFFICE == TVBUR.VKBUR
  • C_BILLGITMPRCGELFORCOTYPQ.MANDT == TVBUR.MANDT