ESH_N_CACORRESPONDENCE

DDL: ESH_N_CACORRESPONDENCE SQL: ESH_L_CORRSPON Type: view
20 Fields 1 Data Sources 1 Associations

ESH_N_CACORRESPONDENCE is a CDS View in SAP S/4HANA. It reads from 1 data source (I_CACORRESPONDENCEHISTORY) and exposes 20 fields with key fields BUSINESSPARTNER, CACORRESPONDENCE, CACORRESPONDENCETYPE, CONTRACTACCOUNT. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CACORRESPONDENCEHISTORY I_CACORRESPONDENCEHISTORY from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _CORRESPNCTECHSTATUS $projection.CATechCorrespondenceStatus=_CORRESPNCTECHSTATUS.domvalue_l and _CORRESPNCTECHSTATUS.domname='CORR_TECH_STATUS_KK' and _CORRESPNCTECHSTATUS.as4local='A'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_CORRSPON view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BUSINESSPARTNER BUSINESSPARTNER Issuing Authority
KEY CACORRESPONDENCE CACORRESPONDENCE Correspond. Key
KEY CACORRESPONDENCETYPE CACORRESPONDENCETYPE Corresp. Type
KEY CONTRACTACCOUNT CONTRACTACCOUNT Contract Acct
CAAUTHORIZATIONGROUP _CAPARTNER CAAUTHORIZATIONGROUP AuthorizGroup
PCAUTHORIZATIONGROUP _PROVIDERCONTRACT CAAUTHORIZATIONGROUP AuthorizGroup
CACORRESPNCDISPATCHCONTROL CACORRESPNCDISPATCHCONTROL Disp. Control
CACORRESPNCDISPATCHCONTROLNAME
CACORRESPONDENCESTATUSNAME
CACORRESPONDENCETYPENAME
CATECHCORRESPONDENCESTATUS CATECHCORRESPONDENCESTATUS Techn. Status
CATECHCORRESPONDENCESTATUSNAME
COMPANYCODE COMPANYCODE Receiver Company Code
CORRESPONDENCEISSUEDATE CORRESPONDENCEISSUEDATE Issue Date
CORRESPONDENCEISSUEDBYUSER CORRESPONDENCEISSUEDBYUSER Issue User
CORRESPONDENCEPRINTDATE CORRESPONDENCEPRINTDATE Print Date
CORRESPONDENCEPRINTEDBYUSER CORRESPONDENCEPRINTEDBYUSER Print User
CREATIONDATE CREATIONDATE Time Stamp
ISBUSINESSPURPOSECOMPLETED _BUSINESSPARTNER ISBUSINESSPURPOSECOMPLETED Purpose Completed
ORIGLCORRESPONDENCERECIPIENT ORIGLCORRESPONDENCERECIPIENT Orig. Recipient

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_N_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_L_CORRSPON
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_CACORRESPONDENCE AS
SELECT
  BUSINESSPARTNER,
  CACORRESPONDENCE,
  CACORRESPONDENCETYPE,
  CONTRACTACCOUNT,
  _CAPARTNER.CAAUTHORIZATIONGROUP AS CAAUTHORIZATIONGROUP,
  _PROVIDERCONTRACT.CAAUTHORIZATIONGROUP AS PCAUTHORIZATIONGROUP,
  CACORRESPNCDISPATCHCONTROL,
  _CORRESPNCDISPCONTR._TEXT[1: Language = $parameters. P_Language].CACORRESPNCDISPATCHCONTROLNAME AS CACORRESPNCDISPATCHCONTROLNAME,
  _CORRESPNCSTATUS._TEXT[1: LANGUAGE = $parameters. P_Language].CACORRESPONDENCESTATUSNAME AS CACORRESPONDENCESTATUSNAME,
  _CORRESPNCTYPE._TEXT[1: Language = $parameters. P_Language].CACORRESPONDENCETYPENAME AS CACORRESPONDENCETYPENAME,
  CATECHCORRESPONDENCESTATUS,
  _CORRESPNCTECHSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS CATECHCORRESPONDENCESTATUSNAME,
  COMPANYCODE,
  CORRESPONDENCEISSUEDATE,
  CORRESPONDENCEISSUEDBYUSER,
  CORRESPONDENCEPRINTDATE,
  CORRESPONDENCEPRINTEDBYUSER,
  CREATIONDATE,
  _BUSINESSPARTNER.ISBUSINESSPURPOSECOMPLETED AS ISBUSINESSPURPOSECOMPLETED,
  ORIGLCORRESPONDENCERECIPIENT
FROM I_CACORRESPONDENCEHISTORY
LEFT OUTER JOIN dd07t AS _CORRESPNCTECHSTATUS ON CATechCorrespondenceStatus=_CORRESPNCTECHSTATUS.domvalue_l AND _CORRESPNCTECHSTATUS.domname='CORR_TECH_STATUS_KK' AND _CORRESPNCTECHSTATUS.as4local='A'  -- association [0..*]
;

Learn More