P_Z0_RecnclnRptEmlTemplate0

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_Z0_RecnclnRptEmlTemplate0.
-- 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.

CREATE VIEW P_Z0_RecnclnRptEmlTemplate0 AS
SELECT
  ReconRepHeader.ReconciliationReportUUID AS ReconciliationReportUUID,
  ReconRepHeader.BusinessPartner AS BusinessPartner,
  ReconRepCust.Language AS Language,
  ReconRepHeader.StartDate AS StartDate,
  ReconRepHeader.EndDate AS EndDate,
  RepEntCompanyCode.CompanyCode AS ValidityStartDate,
  $session.client AS client,
  RepEntCompanyCode.CompanyCode AS CompanyCode
FROM I_Z0_ReconciliationReportHdr AS ReconRepHeader
INNER JOIN I_StRpEntityOrganizationalUnit AS RepEntCompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_Z0_RecnclnRptPrtnCstmzg AS ReconRepCust ON /* join condition not captured in parsed metadata */
INNER JOIN I_Language AS Language ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartnerAddress AS BusinessPartner ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_Z0_ReconciliationReportHdr
;