C_RU_FinancialStatementItemQ_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 C_RU_FinancialStatementItemQ_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: CRUFINSTMNTITMQ2
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_FiscalYear : srf_report_year, P_PreviousFiscalYear : srf_report_year, P_FinancialStatementHierarchy : hryid, P_FinancialStatementFormType : firu_finstat_formtype, P_AlternativeGLAccountIsUsed : char1, P_FromPostingDate : fis_budat, P_ToPostingDate : fis_budat, P_Ledger : fins_ledger

CREATE VIEW C_RU_FinancialStatementItemQ_2 AS
SELECT
  cast( ParentNode as firu_item_code) AS ParentNode,
  GLAccount,
  FinancialStatementLeafItem,
  FinancialStatementFormType,
  AlternativeGLAccount,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(HierarchyNode as firu_finst_tech_item ) AS HierarchyNode,
  cast(AccountingDocument as farp_belnr_d) AS AccountingDocument,
  Currency,
  HierarchyNodeText,
  FiscalYear,
  cast(YearlyBalAmtInDspCrcy as firu_year_open_bal_amt) AS YearlyBalAmtInDspCrcy,
  cast(StartingBalAmtInDspCrcy as firu_open_bal_amt) AS StartingBalAmtInDspCrcy,
  cast(DebitAmountInDisplayCrcy as firu_debit_period_bal) AS DebitAmountInDisplayCrcy,
  cast(CreditAmountInDisplayCrcy as firu_credit_period_bal) AS CreditAmountInDisplayCrcy,
  cast(PeriodBalAmtInDspCrcy as firu_period_bal_amt) AS PeriodBalAmtInDspCrcy,
  cast(EndingBalAmtInDspCrcy as firu_closing_period_bal) AS EndingBalAmtInDspCrcy,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  Segment,
  _Segment._Text[1: Language = $session.system_language].SegmentName AS SegmentName,
  ProfitCenter,
  _ProfitCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  CostCenter,
  BusinessArea,
  _BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  FunctionalArea,
  _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  Supplier,
  _Supplier.BPSupplierFullName AS BPSupplierFullName,
  Customer,
  _Customer.BPCustomerFullName AS BPCustomerFullName,
  Material,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1: Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  FiscalPeriod,
  MasterFixedAsset,
  FixedAsset,
  AssetClass,
  AssignmentReference,
  InventoryValuationType,
  ValuationArea,
  Product,
  _Product._Text[1: Language = $session.system_language].ProductName AS ProductName
;