I_CACollectionSuccessCube

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_CACollectionSuccessCube.
-- 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_DisplayCurrency : waers_kk

CREATE VIEW I_CACollectionSuccessCube AS
SELECT
  entity: { name: 'I_CurrencyStdVH', element: 'Currency' AS CADunningAmountasamount_disp_kk,
  source_currency => DunHeader.TransactionCurrency AS TransactionCurrency,
  target_currency => $parameters.P_DisplayCurrency AS P_DisplayCurrency,
  exchange_rate_date => $session.system_date AS system_date
FROM I_CADunningHeader AS DunHeader
LEFT OUTER JOIN I_CalendarDate AS _CalendarIssueDate ON CAIssueDate = _CalendarIssueDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountCategory AS _ContrAcctCat ON contractaccountcategory = _ContrAcctCat.ContractAccountCategory AND caapplicationarea = _ContrAcctCat.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CACompanyCode AS _CACompanyCode ON CAStandardCompanyCode = _CACompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartnerVH AS _ContractAccountVH ON ContractAccount = _ContractAccountVH.ContractAccount AND BusinessPartner = _ContractAccountVH.BusinessPartner  -- association [0..1]
;