P_RO_SAFTCActgBalance0

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_RO_SAFTCActgBalance0.
-- 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.
-- Parameters: p_alt_acc_used : saft_ro_alt_gl_account_flag, p_from_date : budat_kk, p_to_date : budat_kk, p_bukrs : bukrs

CREATE VIEW P_RO_SAFTCActgBalance0 AS
SELECT
  BusinessPartner,
  case when $parameters.p_alt_acc_used = '' then CAReconciliationAccount else _GLAccountInCompanyCode.AlternativeGLAccount end as ActiveGLAccount AS AlternativeGLAccountendasActiveGLAccount
FROM I_CADocumentBPItem AS dfkkop
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON dfkkop.CompanyCode = _GLAccountInCompanyCode.CompanyCode AND dfkkop.CAReconciliationAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON dfkkop.CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN P_RO_SAFTCActgDocumentSrc0 AS _DocumentSrc0 ON dfkkop.CADocumentNumber = _DocumentSrc0.CADocumentNumber  -- association [1..1]
;