P_WaterfallSemtagItem

Financial Amounts for P&L Waterfall | view: PWATERFSEMTGITM | Extraction: Not supported | Component: Stock Champion
Column Name Description
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
CompanyCode FK Company Code
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
BilledRevenueAmtInCoCodeCrcy Amount in Company Code Currency
SalesDeductionAmtInCoCodeCrcy Amount in Company Code Currency
RevenueAdjustAmtInCoCodeCrcy Amount in Company Code Currency
COGSAmountInCoCodeCrcy Amount in Company Code Currency
VariancesAmountInCoCodeCrcy Amount in Company Code Currency
ScrapAmountInCoCodeCrcy Amount in Company Code Currency
AdminOverheadAmtInCoCodeCrcy Amount in Company Code Currency
SalesOverheadAmtInCoCodeCrcy Amount in Company Code Currency
MarketingOvhdAmtInCoCodeCrcy Amount in Company Code Currency
ResearchDevOvhdAmtInCoCodeCrcy Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
BilledRevenueAmtInGlobCrcy Amount in Global Currency
SalesDeductionAmountInGlobCrcy Amount in Global Currency
RevenueAdjustAmtInGlobCrcy Amount in Global Currency
COGSAmountInGlobCrcy Amount in Global Currency
VariancesAmountInGlobCrcy Amount in Global Currency
ScrapAmountInGlobCrcy Amount in Global Currency
AdminOverheadAmtInGlobCrcy Amount in Global Currency
SalesOverheadAmtInGlobCrcy Amount in Global Currency
MarketingOverheadAmtInGlobCrcy Amount in Global Currency
ResearchDevOvhdAmtInGlobCrcy Amount in Global Currency
Column Name Description
Column Name Description
PostingDate Posting Date
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
KeyDate null
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
SemanticTagName Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
MaterialName Material Description TEXT40
CustomerName Name of Customer TEXT80
CustomerBasicAuthorizationGrp Authorization Group BRGRU
CustomerFinsAuthorizationGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_WATERFALLSEMTAGITEM.MANDT == T001.MANDT
  • P_WATERFALLSEMTAGITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_WATERFALLSEMTAGITEM.MANDT == TCURC.MANDT
  • P_WATERFALLSEMTAGITEM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_WATERFALLSEMTAGITEM.CONTROLLINGAREA == TKA01.KOKRS
  • P_WATERFALLSEMTAGITEM.MANDT == TKA01.MANDT
Customer Number
  • Client
  • Customer Number
  • P_WATERFALLSEMTAGITEM.MANDT == KNA1.MANDT
  • P_WATERFALLSEMTAGITEM.CUSTOMER == KNA1.KUNNR
Global Currency
  • Client
  • Global Currency
  • P_WATERFALLSEMTAGITEM.MANDT == TCURC.MANDT
  • P_WATERFALLSEMTAGITEM.GLOBALCURRENCY == TCURC.WAERS
Industry key
  • Industry key
  • Client
  • P_WATERFALLSEMTAGITEM.INDUSTRY == T016.BRSCH
  • P_WATERFALLSEMTAGITEM.MANDT == T016.MANDT
Ledger from which CO reads actual data
  • Ledger from which CO reads actual data
  • Ledger in General Ledger Accounting
  • Client
Ledger in General Ledger Accounting
  • Ledger from which CO reads actual data
  • Ledger in General Ledger Accounting
  • Client
Material Number
  • Material Number
  • Client
  • P_WATERFALLSEMTAGITEM.MATERIAL == MARA.MATNR
  • P_WATERFALLSEMTAGITEM.MANDT == MARA.MANDT
Profit Center
  • Client
  • Controlling Area
  • ?
  • Profit Center
  • P_WATERFALLSEMTAGITEM.MANDT == CEPC.MANDT
  • P_WATERFALLSEMTAGITEM.CONTROLLINGAREA == CEPC.KOKRS
  • P_WATERFALLSEMTAGITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_WATERFALLSEMTAGITEM.PROFITCENTER == CEPC.PRCTR
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client