C_ProductProfitabilityQuery

Product Profitability with Production Variances | view: CPRDPROFBIQ | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, PROJ, HRRP_FSV_DIR, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
Column Name Description
💲 Global Currency (GlobalCurrency):
BilledRevenueAmtInGlobCrcy Actual Revenue
SalesDeductionAmountInGlobCrcy Sales Deduction
RevenueAdjustAmtInGlobCrcy Revenue Adjustment
RecognizedRevnAmtInGlobCrcy Recognized Revenue
VarblCOGSAmtInGlobCrcy Cost of Goods Sold - Variable
ContrbnMargin1AmtInGlobCrcy Contribution Margin I
FxdCOGSAmtInGlobCrcy Cost of Goods Sold - Fixed
PriceDifferenceAmtInGlobCrcy Price Differences
InptPriceVarcAmtInGlobCrcy Input Price Variance Amount in Global Currency
InptQtyVarcAmtInGlobCrcy Input Quantity Variance Amount in Global Currency
RsceUsgeVarcAmtInGlobCrcy Resource Usage Variance Amount in Global Currency
LotSizeVarcAmtInGlobCrcy Lot Size Variance Amount in Global Currency
InputRmngVarcAmtInGlobCrcy Input Remaining Variance Amount in Global Currency
ContrbnMargin2AmtInGlobCrcy Contribution Margin II
AdminOverheadAmtInGlobCrcy Administration Overhead
SalesOverheadAmtInGlobCrcy Sales Overhead
MarketingOverheadAmtInGlobCrcy Marketing Overhead
RnDOverheadAmtInGlobCrcy Research and Development Overhead
ContrbnMargin3AmtInGlobCrcy Contribution Margin III
💲 Company Code Currency (CompanyCodeCurrency):
BilledRevenueAmtInCoCodeCrcy Billed Revenue Amount in Company Code Currency
SalesDeductionAmtInCoCodeCrcy Sales Deduction Amount in Company Code Currency
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment Amount in Company Code Currency
RecognizedRevnAmtInCCCrcy Recognized Revenue Amount in Company Code Currency
VarblCOGSAmtInCCCrcy COGS - Variable Amount in Company Code Currency
ContrbnMargin1AmtInCoCodeCrcy COGS - Contribution Margin 1 Amount in Company Code Currency
FxdCOGSAmtInCCCrcy COGS - Fixed Amount in Company Code Currency
PriceDifferenceAmtInCCCrcy COGS - Price Differences Amount in Company Code Currency
InptPriceVarcAmtInCoCodeCrcy Input Price Variance Amount in Company Code Currency
InptQtyVarcAmtInCoCodeCrcy Input Quantity Variance Amount in Company Code Currency
RsceUsgeVarcAmtInCoCodeCrcy Resource Usage Variance Amount in Company Code Currency
LotSizeVarcAmtInCoCodeCrcy Lot Size Variance Amount in Company Code Currency
InputRmngVarcAmtInCoCodeCrcy Input Remaining Variance Amount in Company Code Currency
ContrbnMargin2AmtInCoCodeCrcy COGS - Contribution Margin 2 Amount in Company Code Currency
AdminOverheadAmtInCoCodeCrcy COGS - Administration Overhead Amt in Company Code Currency
SalesOverheadAmtInCoCodeCrcy COGS - Sales Overhead Amount in Company Code Currency
MarketingOvhdAmtInCoCodeCrcy COGS - Marketing Overhead Amount in Company Code Currency
RnDOverheadAmtInCCCrcy COGS - Research and Dev Overhead Amount in Company Code Crcy
ContrbnMargin3AmtInCoCodeCrcy COGS - Contribution Margin 3 Amount in Company Code Currency
UnitContrbnMargAmtInCCCrcy COGS - Contribution Margin per Unit Amt in Company Code Crcy
Column Name Description
📏 Base Unit of Measure (BaseUnit):
BilledValnQtyInCostSourceUnit Billed Quantity
UnitContrbnMargAmtInGlobCrcy Contribution Margin per Unit
Column Name Description
Column Name Description
Column Name Description Domain name
SalesDocumentItem Sales Document Item POSNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_PRODUCTPROFITABILITYQUERY.BASEUNIT == T006.MSEHI
  • C_PRODUCTPROFITABILITYQUERY.MANDT == T006.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • C_PRODUCTPROFITABILITYQUERY.BILLTOPARTY == KNA1.KUNNR
  • C_PRODUCTPROFITABILITYQUERY.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • C_PRODUCTPROFITABILITYQUERY.COMPANYCODE == T001.BUKRS
  • C_PRODUCTPROFITABILITYQUERY.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_PRODUCTPROFITABILITYQUERY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PRODUCTPROFITABILITYQUERY.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_PRODUCTPROFITABILITYQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_PRODUCTPROFITABILITYQUERY.MANDT == TKA01.MANDT
Customer Number
  • Customer Number
  • Client
  • C_PRODUCTPROFITABILITYQUERY.CUSTOMER == KNA1.KUNNR
  • C_PRODUCTPROFITABILITYQUERY.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • C_PRODUCTPROFITABILITYQUERY.CUSTOMERGROUP == T151.KDGRP
  • C_PRODUCTPROFITABILITYQUERY.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • C_PRODUCTPROFITABILITYQUERY.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • C_PRODUCTPROFITABILITYQUERY.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • C_PRODUCTPROFITABILITYQUERY.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • C_PRODUCTPROFITABILITYQUERY.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_PRODUCTPROFITABILITYQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_PRODUCTPROFITABILITYQUERY.MANDT == TVTW.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_PRODUCTPROFITABILITYQUERY.GLACCOUNT == SKB1.SAKNR
  • C_PRODUCTPROFITABILITYQUERY.COMPANYCODE == SKB1.BUKRS
  • C_PRODUCTPROFITABILITYQUERY.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_PRODUCTPROFITABILITYQUERY.GLOBALCURRENCY == TCURC.WAERS
  • C_PRODUCTPROFITABILITYQUERY.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Division
  • Division
  • Client
  • C_PRODUCTPROFITABILITYQUERY.ORGANIZATIONDIVISION == TSPA.SPART
  • C_PRODUCTPROFITABILITYQUERY.MANDT == TSPA.MANDT
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • C_PRODUCTPROFITABILITYQUERY.PROFITCENTER == CEPC.PRCTR
  • C_PRODUCTPROFITABILITYQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_PRODUCTPROFITABILITYQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_PRODUCTPROFITABILITYQUERY.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • C_PRODUCTPROFITABILITYQUERY.SALESDISTRICT == T171.BZIRK
  • C_PRODUCTPROFITABILITYQUERY.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_PRODUCTPROFITABILITYQUERY.MANDT == TVKO.MANDT
  • C_PRODUCTPROFITABILITYQUERY.SALESORGANIZATION == TVKO.VKORG
Ship-to Party
  • Ship-to Party
  • Client
  • C_PRODUCTPROFITABILITYQUERY.SHIPTOPARTY == KNA1.KUNNR
  • C_PRODUCTPROFITABILITYQUERY.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • C_PRODUCTPROFITABILITYQUERY.SOLDPRODUCT == MARA.MATNR
  • C_PRODUCTPROFITABILITYQUERY.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • C_PRODUCTPROFITABILITYQUERY.SOLDPRODUCTGROUP == T023.MATKL
  • C_PRODUCTPROFITABILITYQUERY.MANDT == T023.MANDT