P_WaterfallSemtagItem

DDL: P_WATERFALLSEMTAGITEM SQL: PWATERFSEMTGITM Type: view COMPOSITE Package: ODATA_PP_SC
31 Fields 2 Data Sources 6 Associations

Financial Amounts for P&L Waterfall

P_WaterfallSemtagItem is a Composite CDS View that provides data about "Financial Amounts for P&L Waterfall" in SAP S/4HANA. It reads from 2 data sources (I_LedgerCA, P_Kkag_Werk_Bukrs_Kokrs) and exposes 31 fields with key fields Ledger, FiscalYear, CompanyCode, AccountingDocument, LedgerGLLineItem. It has 6 associations to related views. Part of development package ODATA_PP_SC.

Data Sources (2)

SourceAliasJoin Type
I_LedgerCA LedgerCA inner
P_Kkag_Werk_Bukrs_Kokrs plantcompanycode inner

Parameters (1)

NameTypeDefault
P_SysDate sydate

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_CustomerCompany _CustomerCompany $projection.CompanyCode = _CustomerCompany.CompanyCode and $projection.Customer = _CustomerCompany.Customer
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _Supplier $projection.Customer = _Supplier.Supplier
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PWATERFSEMTGITM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_GLAccountLineItemSemTag Ledger Ledger
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
CompanyCodeName _CompanyCode CompanyCodeName Company Name
PostingDate PostingDate Posting Date for GR
LeadingLedger I_LedgerCA Ledger Ledger
FinancialAccountType FinancialAccountType Fin. Account Type
ControllingArea P_Kkag_Werk_Bukrs_Kokrs kokrs Org. Value
ProfitCenter ProfitCenter Profit Center
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
GLAccountHierarchy GLAccountHierarchy
SemanticTag SemanticTag Semantic Tag
SemanticTagName
Material Material Vehicle Model
MaterialName
Customer I_GLAccountLineItemSemTag Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
Industry _Customer Industry Industry Sector
CustomerBasicAuthorizationGrp _Customer AuthorizationGroup AuthorizGroup
CustomerFinsAuthorizationGrp _CustomerCompany AuthorizationGroup AuthorizGroup
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
KeyDate
_Material _Material
_Customer _Customer
_Supplier _Supplier
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_WaterfallSemtagItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PWATERFSEMTGITM
-- Parameters: P_SysDate : sydate

CREATE VIEW P_WaterfallSemtagItem AS
SELECT
  I_GLAccountLineItemSemTag.Ledger AS Ledger,
  FiscalYear,
  CompanyCode,
  AccountingDocument,
  LedgerGLLineItem,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PostingDate,
  LedgerCA.Ledger AS LeadingLedger,
  FinancialAccountType,
  plantcompanycode.kokrs AS ControllingArea,
  ProfitCenter,
  ValidityStartDate,
  ValidityEndDate,
  GLAccountHierarchy,
  SemanticTag,
  _SemanticTag._Text[1: Language = $session.system_language ].SemanticTagName AS SemanticTagName,
  Material,
  _Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
  I_GLAccountLineItemSemTag.Customer AS Customer,
  _Customer.CustomerName AS CustomerName,
  _Customer.Industry AS Industry,
  _Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp,
  _CustomerCompany.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  CompanyCodeCurrency,
  GlobalCurrency,
  dats_add_months($parameters.P_SysDate, -12, 'FAIL') AS KeyDate
INNER JOIN P_Kkag_Werk_Bukrs_Kokrs AS plantcompanycode ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCA AS LedgerCA ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON CompanyCode = _CustomerCompany.CompanyCode AND Customer = _CustomerCompany.Customer  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Customer = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
;

Learn More