R_ContrAcctPrtnCorrespncDraft

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 R_ContrAcctPrtnCorrespncDraft.
-- 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.

CREATE VIEW R_ContrAcctPrtnCorrespncDraft AS
SELECT
  ContractAccount,
  BusinessPartner,
  ContrAcctPrtnCorrespncUUID,
  DraftUUID,
  ParentDraftUUID,
  RootDraftUUID,
  AddrIDOfCorrespncRcpnt,
  CorrespncRcpntAddrIsSpecified,
  CACorrespondenceType,
  CorrespondenceRole,
  CorrespondenceRecipient,
  CAOriglPartIsNotRcvgCorrespnc,
  CACorrespondenceActivityCode,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM fkkvk_corr_draft
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
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 E_ContrAcctPrtnCorrespncDraft AS _Extension ON ContractAccount = _Extension.ContractAccount AND BusinessPartner = _Extension.BusinessPartner AND ContrAcctPrtnCorrespncUUID = _Extension.ContrAcctPrtnCorrespncUUID AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
;