P_CorrespondenceHistory

DDL: P_CORRESPONDENCEHISTORY SQL: PCRRSPNDNCHSTR Type: view CONSUMPTION Package: ODATA_CORRESPONDENCEHISTORY
87 Fields 2 Data Sources 2 Associations

Display Correspondence History

P_CorrespondenceHistory is a Consumption CDS View that provides data about "Display Correspondence History" in SAP S/4HANA. It reads from 2 data sources (I_BillgDocForCorrespncHistory, I_CorrespondenceHistory) and exposes 87 fields with key fields Correspondence, CompanyCode, AccountType, APARAccount, AccountingDocument. It has 2 associations to related views. Part of development package ODATA_CORRESPONDENCEHISTORY.

Data Sources (2)

SourceAliasJoin Type
I_BillgDocForCorrespncHistory I_BillgDocForCorrespncHistory union_all
I_CorrespondenceHistory I_CorrespondenceHistory from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_OutputRequestItemEmail _EmailCounter _EmailCounter.OutputRequestItemUUID = $projection.OutputRequestItemUUID
[1..1] I_OutputRequestItemEmail _EmailFilter _EmailFilter.OutputRequestItemUUID = $projection.OutputRequestItemUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCRRSPNDNCHSTR view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (87)

KeyFieldSource TableSource FieldDescription
KEY Correspondence Correspondence Time
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountType AccountType Accounting Type(dtl)
KEY APARAccount APARAccount Account
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CreatedByUser CreatedByUser User Name
KEY CreationDateTime CreationDateTime Timestamp
KEY OutputRequestItemUUID OutputRequestItemUUID
KEY OutputControlApplicationObject OutputControlApplicationObject Appl. Object ID
OutputRequestItem OutputRequestItem
CorrespondenceName CorrespondenceName
CorrespondenceRequestMode CorrespondenceRequestMode
OutputControlApplObjectType OutputControlApplObjectType Appl. Object Type
CorrespondenceFirstDateName CorrespondenceFirstDateName
CorrespondenceSecondDateName CorrespondenceSecondDateName
CorrespondenceFirstDate CorrespondenceFirstDate
CorrespondenceSecondDate CorrespondenceSecondDate
CorrespondenceNmbrOfRecipients
OutputChannel OutputChannel
PrintQueue PrintQueue Print Queue
OutputRequestItemStatus OutputRequestItemStatus
OutputRequestItemStatusDescr OutputRequestItemStatusDescr
Recipient Recipient To
RecipientRole RecipientRole
CompanyCodeName _CompanyCode CompanyCodeName Company Name
FullName _UserContactCard FullName Name
EmailAddress
CustomerSupplierAccount CustomerSupplierAccount
Customer _Customer Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
Supplier _Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
_CompanyCode _CompanyCode
_CorrespondenceType _CorrespondenceType
_Customer _Customer
_Email _Email
_EmailFilter _EmailFilter
_OutputRequestItem _OutputRequestItem
_Supplier _Supplier
_UserContactCard _UserContactCard
_SupplierCompany _SupplierCompany
_CustomerCompany _CustomerCompany
OutputRequestItemUUIDkeyCorrespondence
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountType AccountType Accounting Type(dtl)
KEY APARAccount APARAccount Account
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CreatedByUser CreatedByUser User Name
KEY CreationDateTime CreationDateTime Timestamp
KEY OutputRequestItemUUID OutputRequestItemUUID
KEY OutputControlApplicationObject OutputControlApplicationObject Appl. Object ID
OutputRequestItem OutputRequestItem
CorrespondenceName CorrespondenceName
CorrespondenceRequestMode CorrespondenceRequestMode
OutputControlApplObjectType OutputControlApplObjectType Appl. Object Type
CorrespondenceFirstDateName CorrespondenceFirstDateName
CorrespondenceSecondDateName CorrespondenceSecondDateName
CorrespondenceFirstDate CorrespondenceFirstDate
CorrespondenceSecondDate CorrespondenceSecondDate
CorrespondenceNmbrOfRecipients
OutputChannel OutputChannel
PrintQueue PrintQueue Print Queue
OutputRequestItemStatus OutputRequestItemStatus
OutputRequestItemStatusDescr OutputRequestItemStatusDescr
Recipient Recipient To
RecipientRole RecipientRole
CompanyCodeName _CompanyCode CompanyCodeName Company Name
FullName _UserContactCard FullName Name
EmailAddress
CustomerSupplierAccount CustomerSupplierAccount
Customer _Customer Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
Supplier _Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
_CompanyCode _CompanyCode
_CorrespondenceType _CorrespondenceType
_Customer _Customer
_Email _Email
_EmailFilter _EmailFilter
_OutputRequestItem _OutputRequestItem
_Supplier _Supplier
_UserContactCard _UserContactCard
_SupplierCompany _SupplierCompany
_CustomerCompany _CustomerCompany
_PartnerFunction _PartnerFunction

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 P_CorrespondenceHistory.
-- 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: PCRRSPNDNCHSTR

CREATE VIEW P_CorrespondenceHistory AS
SELECT
  Correspondence,
  CompanyCode,
  AccountType,
  APARAccount,
  AccountingDocument,
  FiscalYear,
  CreatedByUser,
  CreationDateTime,
  OutputRequestItemUUID,
  OutputControlApplicationObject,
  OutputRequestItem,
  CorrespondenceName,
  CorrespondenceRequestMode,
  OutputControlApplObjectType,
  CorrespondenceFirstDateName,
  CorrespondenceSecondDateName,
  CorrespondenceFirstDate,
  CorrespondenceSecondDate,
  cast ( count ( distinct _EmailCounter.EmailAddress ) as farp_corr_nmbr_of_recipients ) AS CorrespondenceNmbrOfRecipients,
  OutputChannel,
  PrintQueue,
  OutputRequestItemStatus,
  OutputRequestItemStatusDescr,
  Recipient,
  RecipientRole,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _UserContactCard.FullName AS FullName,
  cast ( '' as char1024 ) AS EmailAddress,
  CustomerSupplierAccount,
  _Customer.Customer AS Customer,
  _Customer.CustomerName AS CustomerName,
  _Supplier.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName
FROM I_CorrespondenceHistory
LEFT OUTER JOIN I_OutputRequestItemEmail AS _EmailCounter ON _EmailCounter.OutputRequestItemUUID = OutputRequestItemUUID  -- association [0..*]
LEFT OUTER JOIN I_OutputRequestItemEmail AS _EmailFilter ON _EmailFilter.OutputRequestItemUUID = OutputRequestItemUUID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_BillgDocForCorrespncHistory
;

Learn More