I_RecnclnCloseReqForCnsldtn

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 I_RecnclnCloseReqForCnsldtn.
-- 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: IICARCRFC

CREATE VIEW I_RecnclnCloseReqForCnsldtn AS
SELECT
  CR.close_req_uuid AS RecnclnCloseReqUUID,
  CS.recon_case_id AS ReconciliationCaseID,
  CS.ryear AS FiscalYear,
  CS.poper AS FiscalPeriod,
  cast(CS.fiscyearper as fins_fyearperiod preserving type) AS FiscalYearPeriod,
  CS.rldnr AS ConsolidationLedger,
  CS.rvers AS ConsolidationVersion,
  CS.ritclg AS ConsolidationChartOfAccounts,
  cast( CS.rbunit as fis_md_bunit preserving type ) AS ConsolidationUnit,
  cast( CS.rbuptr as fis_md_buptr preserving type ) AS PartnerConsolidationUnit
FROM ica_recon_cr AS CR
INNER JOIN ica_recon_cs AS CS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReconciliationCase AS _ReconCase ON _ReconCase.ReconciliationCaseID = ReconciliationCaseID  -- association [1]
LEFT OUTER JOIN I_CnsldtnUnit_2 AS _ConsolidationUnit ON _ConsolidationUnit.ConsolidationDimension = 'Y1' AND _ConsolidationUnit.ConsolidationUnit = ConsolidationUnit  -- association [1]
LEFT OUTER JOIN I_CnsldtnUnit_2 AS _PartnerUnit ON _PartnerUnit.ConsolidationDimension = 'Y1' AND _PartnerUnit.ConsolidationUnit = PartnerConsolidationUnit  -- association [1]
;