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,
  vkont AS ContractAccount,
  gpart AS BusinessPartner,
  cokey AS CACorrespondence,
  vtref AS CAContract,
  bukrs AS CompanyCode,
  cdate AS CreationDate,
  copri AS CorrespondencePrintDate,
  coidt AS CorrespondenceIssueDate,
  coitm AS CorrespondenceIssueTime,
  salwa AS Currency,
  salbe 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,
  copnr AS CACorrespondenceRecurrencePerd,
  coemp AS CorrespondenceIsEmpty,
  umbuch AS TransferPostgHasBeenCarriedOut,
  copri_laufd AS CAPrintRunDate,
  copri_laufi AS CAPrintRunID,
  subap AS CASubApplication,
  xtrial AS CorrespondenceIsTest,
  tech_status AS CATechCorrespondenceStatus,
  formkey AS ApplicationForm,
  formkey_rdi AS RawDataInterfaceApplForm,
  sendcontrol_oc AS CACorrespncDispatchControl,
  incorr AS IsInboundCorrespondence
FROM dfkkcohi
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _OriglCorrespondenceRecipient ON OriglCorrespondenceRecipient = _OriglCorrespondenceRecipient.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CACorrespncDispatchControl_2 AS _CACorrespncDispatchControl ON CACorrespncDispatchControl = _CACorrespncDispatchControl.CACorrespncDispatchControl  -- association [1..1]
LEFT OUTER JOIN I_CACorrespondenceStatus AS _CACorrespondenceStatus ON CACorrespondenceStatus = _CACorrespondenceStatus.CACorrespondenceStatus  -- association [0..1]
LEFT OUTER JOIN I_CACorrespondenceType AS _CACorrespondenceType ON CACorrespondenceType = _CACorrespondenceType.CACorrespondenceType  -- association [1..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _CAProviderContract ON CASubApplication = 'P' AND CAContract = _CAProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CATechCorrespondenceStatus AS _CATechCorrespondenceStatus ON CATechCorrespondenceStatus = _CATechCorrespondenceStatus.CATechCorrespondenceStatus  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CorrespondenceIssuedByUser ON CorrespondenceIssuedByUser = _CorrespondenceIssuedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CorrespondencePrintedByUser ON CorrespondencePrintedByUser = _CorrespondencePrintedByUser.UserID  -- association [0..1]
;