C_CACorrespondenceHdrEmail

DDL: C_CACORRESPONDENCEHDREMAIL Type: view_entity CONSUMPTION Package: FKC_CORR
50 Fields 1 Data Sources 1 Associations

Contract Acctg E-Mail Correspondence

C_CACorrespondenceHdrEmail is a Consumption CDS View that provides data about "Contract Acctg E-Mail Correspondence" in SAP S/4HANA. It reads from 1 data source (I_CACorrespondenceHeader) and exposes 50 fields with key fields CACorrespondenceType, CACorrespondence. It has 1 association to related views. Part of development package FKC_CORR.

Data Sources (1)

SourceAliasJoin Type
I_CACorrespondenceHeader I_CACorrespondenceHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_AddressDefaultRepresentation _SenderAddress $projection.CACorrespncSenderAddressID = _SenderAddress.AddressID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Contract Acctg E-Mail Correspondence view
ObjectModel.modelingPattern #OUTPUT_EMAIL_DATA_PROVIDER view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY CACorrespondenceType CACorrespondenceType Corresp. Type
KEY CACorrespondence CACorrespondence Correspond. Key
ContractAccount ContractAccount Contract Acct
BusinessPartner BusinessPartner Issuing Authority
CAContract CAContract Contract
OriglCorrespondenceRecipient OriglCorrespondenceRecipient Orig. Recipient
CompanyCode CompanyCode Receiver Company Code
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CorrespondencePrintDate CorrespondencePrintDate Print Date
CorrespondenceIssueDate CorrespondenceIssueDate Issue Date
CorrespondenceIssueTime CorrespondenceIssueTime Issue Time
Currency Currency Valuation Crcy
CAAmountInLocalCurrency CAAmountInLocalCurrency Local Crcy Amt
CAMassRunDate CAMassRunDate Date ID
CAMassRunID CAMassRunID Run ID
Language Language Report Text Language
Correspondence1stEntityIdn Correspondence1stEntityIdn Data
Correspondence1stEntityData Correspondence1stEntityData Fred Reference Data1
Correspondence2ndEntityIdn Correspondence2ndEntityIdn Data
Correspondence2ndEntityData Correspondence2ndEntityData Fred Reference Data2
Correspondence3rdEntityIdn Correspondence3rdEntityIdn Data
Correspondence3rdEntityData Correspondence3rdEntityData Fred Reference Data3
Correspondence4thEntityIdn Correspondence4thEntityIdn Data
Correspondence4thEntityData Correspondence4thEntityData Fred Reference Data4
CACorrespncSenderAddressID CACorrespncSenderAddressID Address Number
SenderCityName _SenderAddress CityName Name
SenderPostalCode _SenderAddress PostalCode Postal Code
SenderStreetName _SenderAddress StreetName Text
SenderHouseNumber _SenderAddress HouseNumber House Number
SenderCountry _SenderAddress Country Venue: Ctry/Reg
RecipientCityName
RecipientPostalCode
RecipientStreetName
RecipientHouseNumber
RecipientCountry
CustomerCityName
CustomerPostalCode
CustomerStreetName
BusinessPartnerHouseNumber
CustomerCountry
_CorrespncType _CorrespncType
_CorrespncTypeT _CorrespncTypeT
_ContrAcc _ContrAcc
_CAPartner _CAPartner
_BusinessPartner _BusinessPartner
_OriglCorrespncRcpnt _OriglCorrespncRcpnt
_CompCode _CompCode
_SenderAddress _SenderAddress

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 C_CACorrespondenceHdrEmail.
-- 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 C_CACorrespondenceHdrEmail AS
SELECT
  CACorrespondenceType,
  CACorrespondence,
  ContractAccount,
  BusinessPartner,
  CAContract,
  OriglCorrespondenceRecipient,
  CompanyCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CorrespondencePrintDate,
  CorrespondenceIssueDate,
  CorrespondenceIssueTime,
  Currency,
  CAAmountInLocalCurrency,
  CAMassRunDate,
  CAMassRunID,
  Language,
  Correspondence1stEntityIdn,
  Correspondence1stEntityData,
  Correspondence2ndEntityIdn,
  Correspondence2ndEntityData,
  Correspondence3rdEntityIdn,
  Correspondence3rdEntityData,
  Correspondence4thEntityIdn,
  Correspondence4thEntityData,
  CACorrespncSenderAddressID,
  _SenderAddress.CityName AS SenderCityName,
  _SenderAddress.PostalCode AS SenderPostalCode,
  _SenderAddress.StreetName AS SenderStreetName,
  _SenderAddress.HouseNumber AS SenderHouseNumber,
  _SenderAddress.Country AS SenderCountry,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS RecipientCityName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS RecipientPostalCode,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS RecipientStreetName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber AS RecipientHouseNumber,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS RecipientCountry,
  _OriglCorrespncRcpnt._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS CustomerCityName,
  _OriglCorrespncRcpnt._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS CustomerPostalCode,
  _OriglCorrespncRcpnt._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS CustomerStreetName,
  _OriglCorrespncRcpnt._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber AS BusinessPartnerHouseNumber,
  _OriglCorrespncRcpnt._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS CustomerCountry
FROM I_CACorrespondenceHeader
LEFT OUTER JOIN I_AddressDefaultRepresentation AS _SenderAddress ON CACorrespncSenderAddressID = _SenderAddress.AddressID  -- association [0..1]
;

Learn More