I_CACorrespondenceHistory

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_CACorrespondenceHistory.
-- 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: ICACORRESPNCHIST

CREATE VIEW I_CACorrespondenceHistory AS
SELECT
  cotyp AS CACorrespondenceType,
  cast(vkont as vkont_gfn_kk preserving type ) AS ContractAccount,
  cast(gpart as bu_partner preserving type ) AS BusinessPartner,
  cokey AS CACorrespondence,
  cast(vtref as vtref_kk preserving type ) AS CAContract,
  bukrs AS CompanyCode,
  cast(cdate as fis_cpdat preserving type ) AS CreationDate,
  copri AS CorrespondencePrintDate,
  coidt AS CorrespondenceIssueDate,
  coitm AS CorrespondenceIssueTime,
  cast(salwa as waers preserving type ) AS Currency,
  cast(salbe as betrh_kk preserving type ) AS CAAmountInLocalCurrency,
  corr_status AS CACorrespondenceStatus,
  incorr_faedn AS InboundCorrespncDueDate,
  incorr_indate AS InboundCorrespncReceivedDate,
  gpart_guid AS BusinessPartnerUUID,
  org_gpart AS OriglCorrespondenceRecipient,
  org_gpart_guid AS OriglCorrespncRecipientUUID,
  coisststmp AS CreationDateTime,
  coisststmpnew AS CorrespondenceIssueDateTime,
  coissuser AS CorrespondenceIssuedByUser,
  copritstmp AS CorrespondencePrintDateTime,
  copriuser AS CorrespondencePrintedByUser,
  cocyr AS CorrespondenceCreationYear,
  coper AS CACorrespondenceRecurrence,
  cast(copnr as copnr_gfn_kk) AS CACorrespondenceRecurrencePerd,
  coemp AS CorrespondenceIsEmpty,
  umbuch AS TransferPostgHasBeenCarriedOut,
  cast(copri_laufd as copri_laufd_gfn_kk) AS CAPrintRunDate,
  cast(copri_laufi as copri_laufi_gfn_kk) AS CAPrintRunID,
  subap AS CASubApplication,
  xtrial AS CorrespondenceIsTest,
  tech_status AS CATechCorrespondenceStatus,
  formkey AS ApplicationForm,
  formkey_rdi AS RawDataInterfaceApplForm,
  sendcontrol AS CACorrespncDispatchControl,
  incorr AS IsInboundCorrespondence
FROM dfkkcohi
LEFT OUTER JOIN I_ContractAccountHeader AS _ContrAcc ON ContractAccount = _ContrAcc.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _OriginalBusinessPartner ON OriglCorrespondenceRecipient = _OriginalBusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _SubApplication ON CASubApplication = _SubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CACorrespondenceStatus AS _CorrespncStatus ON CACorrespondenceStatus = _CorrespncStatus.CACorrespondenceStatus  -- association [0..1]
LEFT OUTER JOIN I_CATechCorrespondenceStatus AS _CorrespncTechStatus ON CATechCorrespondenceStatus = _CorrespncTechStatus.CATechCorrespondenceStatus  -- association [1..1]
LEFT OUTER JOIN I_CACorrespondenceType AS _CorrespncType ON CACorrespondenceType = _CorrespncType.CACorrespondenceType  -- association [1..1]
LEFT OUTER JOIN I_CACorrespncDispatchControl AS _CorrespncDispContr ON CACorrespncDispatchControl = _CorrespncDispContr.CACorrespncDispatchControl  -- association [1..1]
;