P_RU_FinancialStatementItem_2

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_RU_FinancialStatementItem_2.
-- 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: PRUFINSTMNTITEM2
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_FinancialStatementHierarchy : hryid, P_FinancialStatementFormType : firu_finstat_formtype, P_AlternativeGLAccountIsUsed : char1, P_FromPostingDate : fis_budat, P_ToPostingDate : fis_budat

CREATE VIEW P_RU_FinancialStatementItem_2 AS
SELECT
  ReportedItem.FinancialStatementHierarchy AS FinancialStatementHierarchy,
  ReportedItem.HierarchyNode AS HierarchyNode,
  ReportedItem.ParentNode AS HierarchyParentNode,
  ReportedItem.ValidityEndDate AS ValidityEndDate,
  FinancialStatementFormType,
  ReportedItem.Ledger AS Ledger,
  ReportedItem.CompanyCode AS CompanyCode,
  ReportedItem.FiscalYear AS FiscalYear,
  ReportedItem.AccountingDocument AS AccountingDocument,
  ReportedItem.LedgerGLLineItem AS LedgerGLLineItem,
  ReportedItem.ParentNode AS ParentNode,
  Hierarchy.FinancialStatementLeafItem AS FinancialStatementLeafItem,
  ReportedItem.NodeType AS NodeType,
  ReportedItem.FinStatementHierarchyNodeValue AS FinStatementHierarchyNodeValue,
  Hierarchy.FunctionalAreaIsUsed AS FunctionalAreaIsUsed,
  ReportedItem.DebitCreditCode AS DebitCreditCode,
  ReportedItem.PostingDate AS PostingDate,
  ReportedItem.ChartOfAccounts AS ChartOfAccounts,
  $parameters.P_AlternativeGLAccountIsUsed AS AlternativeGLAccountIsUsed,
  ReportedItem.GLAccount AS RealGLAccount,
  ReportedItem.AlternativeGLAccount AS AlternativeGLAccount,
  ReportedItem.Currency AS Currency,
  '' AS FinancialStatementExplanation,
  _ParentText.HierarchyNodeText AS HierarchyNodeText,
  _GLAccountLineItem.ControllingArea AS ControllingArea,
  _GLAccountLineItem.Segment AS Segment,
  _GLAccountLineItem.ProfitCenter AS ProfitCenter,
  _GLAccountLineItem.CostCenter AS CostCenter,
  _GLAccountLineItem.BusinessArea AS BusinessArea,
  _GLAccountLineItem.Supplier AS Supplier,
  _GLAccountLineItem.Customer AS Customer,
  _GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  _GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  _GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  _GLAccountLineItem.FixedAsset AS FixedAsset,
  _GLAccountLineItem.AssetClass AS AssetClass,
  _GLAccountLineItem.AssignmentReference AS AssignmentReference,
  _GLAccountLineItem.Plant AS Plant,
  _GLAccountLineItem.InventoryValuationType AS InventoryValuationType,
  _GLAccountLineItem.ValuationArea AS ValuationArea,
  _GLAccountLineItem.Product AS Product,
  _GLAccountLineItem.FunctionalArea AS FunctionalArea,
  _GLAccountLineItem.Material AS Material,
  _GLAccountLineItem._Customer AS _Customer,
  _GLAccountLineItem._Supplier AS _Supplier,
  _GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  _GLAccountLineItem._CostCenter AS _CostCenter,
  _GLAccountLineItem._BusinessArea AS _BusinessArea,
  _GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  _GLAccountLineItem._ControllingArea AS _ControllingArea,
  _GLAccountLineItem._Segment AS _Segment,
  _GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  _GLAccountLineItem._InventoryValuationType AS _InventoryValuationType,
  _GLAccountLineItem._Product AS _Product,
  _GLAccountLineItem._PurReqValuationArea AS _PurReqValuationArea,
  _GLAccountLineItem._Material AS _Material,
  _GLAccountLineItem._Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  _GLAccountLineItem._Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp
FROM P_RU_FinStmntRptgItems_2
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON ReportedItem.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON ReportedItem.FiscalYear = _FiscalYear.FiscalYear AND ReportedItem.CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ReportedItem.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON ReportedItem.CompanyCode = _GLAccountInCompanyCode.CompanyCode AND ReportedItem.FinStatementHierarchyNodeValue = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountLineItem AS _GLAccountLineItem ON ReportedItem.Ledger = _GLAccountLineItem.Ledger AND ReportedItem.CompanyCode = _GLAccountLineItem.CompanyCode AND ReportedItem.FiscalYear = _GLAccountLineItem.FiscalYear AND ReportedItem.AccountingDocument = _GLAccountLineItem.AccountingDocument AND ReportedItem.LedgerGLLineItem = _GLAccountLineItem.LedgerGLLineItem  -- association [1..1]
;