I_Waterfall

Financial Amounts for P&L Waterfall | view: IWATERFALL | Extraction: Not supported | Component: Stock Champion
Column Name Description
Ledger Ledger in General Ledger Accounting
CompanyCode Company Code
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
BilledRevenueAmtInCoCodeCrcy null
SalesDeductionAmtInCoCodeCrcy null
RevenueAdjustAmtInCoCodeCrcy null
COGSAmountInCoCodeCrcy null
VariancesAmountInCoCodeCrcy null
ScrapAmountInCoCodeCrcy null
AdminOverheadAmtInCoCodeCrcy null
SalesOverheadAmtInCoCodeCrcy null
MarketingOvhdAmtInCoCodeCrcy null
ResearchDevOvhdAmtInCoCodeCrcy null
ContrbnMargin1AmtInCoCodeCrcy null
ContrbnMargin2AmtInCoCodeCrcy null
ContrbnMargin3AmtInCoCodeCrcy null
💲 Global Currency (GlobalCurrency):
BilledRevenueAmtInGlobCrcy null
SalesDeductionAmountInGlobCrcy null
RevenueAdjustAmtInGlobCrcy null
COGSAmountInGlobCrcy null
VariancesAmountInGlobCrcy null
ScrapAmountInGlobCrcy null
AdminOverheadAmtInGlobCrcy null
SalesOverheadAmtInGlobCrcy null
MarketingOverheadAmtInGlobCrcy null
ResearchDevOvhdAmtInGlobCrcy null
ContrbnMargin1AmtInGlobCrcy null
ContrbnMargin2AmtInGlobCrcy null
ContrbnMargin3AmtInGlobCrcy null
Column Name Description
Column Name Description
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
ProfitCenter Profit Center PRCTR
CompanyCodeName Name of Company Code or Company TEXT25
GLAccountHierarchy Financial Statement Version DHRYID
Material Material Number MATNR
MaterialName Material Description TEXT40
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
SupplierIndustryName Description of the Industry Key TEXT20
CustomerBasicAuthorizationGrp Authorization Group BRGRU
CustomerFinsAuthorizationGrp Authorization Group BRGRU
BilledRevenueAsSalesPct null
SalesDeductionAsSalesPct null
RevenueAdjustAsSalesPct null
COGSAsSalesPct null
VariancesAsSalesPct null
ScrapAsSalesPct null
OverheadAdminAsSalesPct null
OverheadSalesAsSalesPct null
OverheadMarketingAsSalesPct null
OverheadResearchAsSalesPct null
ContributionMargin1AsSalesPct null
ContributionMargin2AsSalesPct null
ContributionMargin3AsSalesPct null
Master Data Relations Join Conditions
Controlling Area
  • Client
  • Controlling Area
  • I_WATERFALL.MANDT == TKA01.MANDT
  • I_WATERFALL.CONTROLLINGAREA == TKA01.KOKRS
Industry key
  • Client
  • Industry key
  • I_WATERFALL.MANDT == T016.MANDT
  • I_WATERFALL.INDUSTRY == T016.BRSCH
Ledger from which CO reads actual data
  • Client
  • Ledger from which CO reads actual data