C_CorrespondenceHistory

DDL: C_CORRESPONDENCEHISTORY SQL: CCRRSPNDNCHSTR Type: view CONSUMPTION Package: ODATA_CORRESPONDENCEHISTORY
44 Fields 1 Data Sources 1 OData Services

Correspondence History

C_CorrespondenceHistory is a Consumption CDS View that provides data about "Correspondence History" in SAP S/4HANA. It reads from 1 data source (P_CorrespondenceHistory) and exposes 44 fields with key fields Correspondence, CompanyCode, AccountType, APARAccount, AccountingDocument. It is exposed through 1 OData service (ASQL_F2934). Part of development package ODATA_CORRESPONDENCEHISTORY.

Data Sources (1)

SourceAliasJoin Type
P_CorrespondenceHistory P_CorrespondenceHistory from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CCRRSPNDNCHSTR view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Correspondence History view
UI.headerInfo.typeName Correspondence History view
UI.headerInfo.typeNamePlural Correspondence History view
UI.headerInfo.title.label Correspondence History view
UI.headerInfo.title.value Correspondence view
UI.presentationVariant.sortOrder.by CreationDateTime view
UI.presentationVariant.sortOrder.direction #DESC view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2934 ASQL_F2934 C2 NOT_RELEASED

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY Correspondence Correspondence
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
FullName FullName Name
CorrespondenceName CorrespondenceName
CustomerSupplierAccount CustomerSupplierAccount
CorrespondenceFirstDateName CorrespondenceFirstDateName
CorrespondenceSecondDateName CorrespondenceSecondDateName
CorrespondenceFirstDate CorrespondenceFirstDate
CorrespondenceSecondDate CorrespondenceSecondDate
OutputControlApplObjectType OutputControlApplObjectType Appl. Object Type
CorrespondenceRequestMode CorrespondenceRequestMode
OutputChannel OutputChannel
PrintQueue PrintQueue Print Queue
OutputRequestItemStatus OutputRequestItemStatus
OutputRequestItemStatusDescr OutputRequestItemStatusDescr
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
Recipient Recipient To
RecipientRole RecipientRole
PartnerFunctionName
CompanyCodeName CompanyCodeName Company Name
CorrespondenceNmbrOfRecipients CorrespondenceNmbrOfRecipients
EmailAddress EmailAddress E-Mail Address
_EmailFilter _EmailFilter
_CompanyCode _CompanyCode
_CorrespondenceType _CorrespondenceType
_Email _Email
_OutputRequestItem _OutputRequestItem
_UserContactCard _UserContactCard
_Customer _Customer
_Supplier _Supplier
_CustomerCompany _CustomerCompany
_SupplierCompany _SupplierCompany

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_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: CCRRSPNDNCHSTR

CREATE VIEW C_CorrespondenceHistory AS
SELECT
  Correspondence,
  CompanyCode,
  AccountType,
  APARAccount,
  AccountingDocument,
  FiscalYear,
  CreatedByUser,
  CreationDateTime,
  OutputRequestItemUUID,
  OutputControlApplicationObject,
  OutputRequestItem,
  FullName,
  CorrespondenceName,
  CustomerSupplierAccount,
  CorrespondenceFirstDateName,
  CorrespondenceSecondDateName,
  CorrespondenceFirstDate,
  CorrespondenceSecondDate,
  OutputControlApplObjectType,
  CorrespondenceRequestMode,
  OutputChannel,
  PrintQueue,
  OutputRequestItemStatus,
  OutputRequestItemStatusDescr,
  Supplier,
  SupplierName,
  Customer,
  CustomerName,
  Recipient,
  RecipientRole,
  _PartnerFunction._Text[1:Language = $session.system_language].PartnerFunctionName AS PartnerFunctionName,
  CompanyCodeName,
  CorrespondenceNmbrOfRecipients,
  EmailAddress
FROM P_CorrespondenceHistory
;

Learn More