ESH_S_CACORRESPONDENCE

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 ESH_S_CACORRESPONDENCE.
-- 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: ESH_U_CORRSPON
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_CACORRESPONDENCE AS
SELECT
  BUSINESSPARTNER,
  CAAUTHORIZATIONGROUP,
  PCAUTHORIZATIONGROUP,
  CACORRESPNCDISPATCHCONTROL,
  CACORRESPNCDISPATCHCONTROLNAME,
  CACORRESPONDENCE,
  CACORRESPONDENCESTATUSNAME,
  CACORRESPONDENCETYPE,
  CACORRESPONDENCETYPENAME,
  CATECHCORRESPONDENCESTATUS,
  CATECHCORRESPONDENCESTATUSNAME,
  COMPANYCODE,
  CONTRACTACCOUNT,
  CORRESPONDENCEISSUEDATE,
  CORRESPONDENCEISSUEDBYUSER,
  CORRESPONDENCEPRINTDATE,
  CORRESPONDENCEPRINTEDBYUSER,
  CREATIONDATE,
  ISBUSINESSPURPOSECOMPLETED,
  ORIGLCORRESPONDENCERECIPIENT
FROM ESH_N_CACORRESPONDENCE
;