I_CADunningReduction

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_CADunningReduction.
-- 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: ICADUNNREDUCTION

CREATE VIEW I_CADunningReduction AS
SELECT
  laufd AS CAMassRunDate,
  cast(laufi as laufi_kk preserving type) AS CAMassRunID,
  cast(gpart as bu_partner preserving type) AS BusinessPartner,
  cast(vkont as vkont_gfn_kk preserving type) AS ContractAccount,
  mazae AS CADunningCounter,
  obj1t AS CADunningReductionType,
  obj1r AS DisputeCaseUUID,
  cast(int_ref as fdm_ext_key) AS CADisputeCase,
  ext_ref AS CADisputeCaseExternalRef,
  betrh AS CAAmountInLocalCurrency,
  cast(betrw as rsalm_kk preserving type) AS CADunningReductionAmount,
  cast(waers as fis_rwcur preserving type) AS TransactionCurrency,
  cast(hwaer as fc_curr preserving type) AS LocalCurrency,
  reason AS CADisputeType
FROM fkkmareduct
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _CAHeader ON ContractAccount = _CAHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CADunningHeader AS _DunHeader ON (CAMassRunDate = _DunHeader.CAMassRunDate AND CAMassRunID = _DunHeader.CAMassRunID AND BusinessPartner = _DunHeader.BusinessPartner AND ContractAccount = _DunHeader.ContractAccount AND CADunningCounter = _DunHeader.CADunningCounter)  -- association [1..1]
;