I_CAInboundCorrespondence

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_CAInboundCorrespondence.
-- 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: ICAINBCORRESPNC

CREATE VIEW I_CAInboundCorrespondence AS
SELECT
  cokey AS CACorrespondence,
  cast(abrzo as abrzo_kk) AS CAEndDateOfBillingPeriod,
  cast(cast(persl as abap.char(4)) as persl_kk) AS CAPeriodCode,
  cast(defer as studt_kk) AS CADeferralDate,
  incotyp AS CAInboundCorrespncCategory,
  spccal AS AlternativePeriodIsExisting,
  augrd AS CAInbCorrespncClearingRsn,
  leadobj AS CAInbCorrespncLeadingObject,
  constatus AS CAInbCorrespncCnsldtnStatus,
  xreminder AS ReminderIsSent
FROM dfkkcohincorr
LEFT OUTER JOIN I_CAInboundCorrespncCategory AS _Category ON CAInboundCorrespncCategory = _Category.CAInboundCorrespncCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInbCorrespncClearingRsn AS _ClearingRsn ON CAInbCorrespncClearingRsn = _ClearingRsn.CAInbCorrespncClearingRsn  -- association [0..1]
LEFT OUTER JOIN I_CAPeriodCode AS _Period ON CAPeriodCode = _Period.CAPeriodCode  -- association [0..1]
;