What is C_CACorrespondenceHistory in SAP S/4HANA?

C_CACorrespondenceHistory is a consumption CDS view in SAP S/4HANA. Korrespondenzen anzeigen It contains 58 fields.

Which tables does C_CACorrespondenceHistory read from?

C_CACorrespondenceHistory reads data from: I_CACorrespondenceHistory.

What VDM layer is C_CACorrespondenceHistory?

C_CACorrespondenceHistory is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CACorrespondenceHistory

DDL: C_CACORRESPONDENCEHISTORY SQL: CCACORRHIST Type: view CONSUMPTION

58 Fields 1 Data Sources 5 Associations

Korrespondenzen anzeigen

C_CACorrespondenceHistory is a Consumption CDS View that provides data about "Korrespondenzen anzeigen" in SAP S/4HANA. It reads from 1 data source (I_CACorrespondenceHistory) and exposes 58 fields with key fields CACorrespondenceType, BusinessPartner, ContractAccount, CACorrespondence. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CACorrespondenceHistory	I_CACorrespondenceHistory	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_BPCurrentDefaultAddress	_BPCurrentDefaultAddress	`$projection.BusinessPartner = _BPCurrentDefaultAddress.BusinessPartner`
[0..1]	C_CAInvcgUserContact	_IssuedByContact	`$projection.CorrespondenceIssuedByUser = _IssuedByContact.ContactCardID`
[0..1]	C_CAInvcgUserContact	_PrintedByContact	`$projection.CorrespondencePrintedByUser = _PrintedByContact.ContactCardID`
[0..1]	I_User	_IssuedByUser	`$projection.CorrespondenceIssuedByUser = _IssuedByUser.UserID`
[0..1]	I_User	_PrintedByUser	`$projection.CorrespondencePrintedByUser = _PrintedByUser.UserID`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	CCACORRHIST	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Korrespondenzen anzeigen	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Search.searchable	true	view
VDM.viewType	#CONSUMPTION	view
UI.headerInfo.typeName	Korrespondenz	view
UI.headerInfo.typeNamePlural	Korrespondenzen	view
UI.headerInfo.title.value	CACorrespondenceTypeName	view
UI.headerInfo.description.value	CATechCorrespondenceStatusName	view
Metadata.allowExtensions	true	view

Fields (58)

Key	Field	Source Table	Source Field	Description
KEY	CACorrespondenceType		CACorrespondenceType	Korrespondenzart
KEY	BusinessPartner		BusinessPartner	Empfänger
KEY	ContractAccount		ContractAccount	Vertragskonto
KEY	CACorrespondence		CACorrespondence	Korrespondenzschlüssel
	CACorrespondenceTypeName
	CorrespondenceRecipientName	_BusinessPartner	BusinessPartnerFullName	Broker Name
	ContractAccountName	_CAPartner	ContractAccountName	Cont. acct name
	CATechCorrespondenceStatus		CATechCorrespondenceStatus	Technischer Status
	CATechCorrespondenceStatusName
	CorrespondenceIssueDate		CorrespondenceIssueDate	Ausstellungsdatum
	CorrespondencePrintDate		CorrespondencePrintDate	Ausgabedatum
	CACorrespncDispatchControl		CACorrespncDispatchControl	Versandsteuerung
	CACorrespncDispatchControlName
	CreationDate		CreationDate	Erstellungsdatum
	CorrespondenceIssuedByUser		CorrespondenceIssuedByUser	Angelegt von
	CorrespondenceIssuedByUserName	_IssuedByUser	UserDescription	Full Name
	CorrespondencePrintedByUser		CorrespondencePrintedByUser	Ausgegeben von
	CorrespondencePrintedByUsrName	_PrintedByContact	FullName	Name
	_IssuedByContact		_IssuedByContact	Angelegt von
	_PrintedByContact		_PrintedByContact
	CAPrintRunDate		CAPrintRunDate	Drucklaufdatum
	CAPrintRunID		CAPrintRunID	Drucklauf-ID
	CompanyCode		CompanyCode	Buchungskreis
	CompanyCodeName	_CompCode	CompanyCodeName	Company Name
	OriglCorrespondenceRecipient		OriglCorrespondenceRecipient	Ursprünglicher Empfänger
	OriglCorrespncRecipientName	_OriginalBusinessPartner	BusinessPartnerFullName	Broker Name
	HouseNumber1asHouseNumber			Straße / Nummer
	CityName1asHomeTown			Postleitzahl / Ort
	Country			Land
	CountryName
	CAContract		CAContract	Vertrag
	CAContractSemanticObject
	CASubApplication		CASubApplication	Subapplikation
	CASubApplicationText
	Currency		Currency	Valuation Crcy
	CAAmountInLocalCurrency		CAAmountInLocalCurrency	Betrag
	CACorrespondenceStatus		CACorrespondenceStatus	Korrespondenzstatus
	CreationDateTime		CreationDateTime	Erstellungszeitstempel
	CorrespondenceIssueDateTime		CorrespondenceIssueDateTime	Ausstellungszeitstempel
	CorrespondencePrintDateTime		CorrespondencePrintDateTime	Ausgabezeitstempel
	ApplicationForm		ApplicationForm	Anwendungsformular
	RawDataInterfaceApplForm		RawDataInterfaceApplForm	alternatives RDI Formular
	CorrespondenceCreationYear		CorrespondenceCreationYear	Year
	CACorrespondenceRecurrence		CACorrespondenceRecurrence	Periods
	CACorrespondenceRecurrencePerd		CACorrespondenceRecurrencePerd
	CorrespondenceIsEmpty		CorrespondenceIsEmpty	Blank Corresp.
	CorrespondenceIsTest		CorrespondenceIsTest	Test
	TransferPostgHasBeenCarriedOut		TransferPostgHasBeenCarriedOut	Transfer
	BusinessPartnerUUID		BusinessPartnerUUID	UUID
	OriglCorrespncRecipientUUID		OriglCorrespncRecipientUUID	OrigRcp. GUID
	CorrespondenceIssueTime		CorrespondenceIssueTime	Issue Time
	_ContrAcc		_ContrAcc
	_CAPartner		_CAPartner
	_ProviderContract		_ProviderContract
	_BusinessPartner		_BusinessPartner
	_CompCode		_CompCode
	_CorrespncTechStatus		_CorrespncTechStatus
	_CorrespncStatus		_CorrespncStatus

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_CACorrespondenceHistory.
-- 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: CCACORRHIST

CREATE VIEW C_CACorrespondenceHistory AS
SELECT
  CACorrespondenceType,
  BusinessPartner,
  ContractAccount,
  CACorrespondence,
  _CorrespncType._Text[1: Language=$session.system_language].CACorrespondenceTypeName AS CACorrespondenceTypeName,
  _BusinessPartner.BusinessPartnerFullName AS CorrespondenceRecipientName,
  _CAPartner.ContractAccountName AS ContractAccountName,
  CATechCorrespondenceStatus,
  _CorrespncTechStatus._Text[1: Language=$session.system_language].CATechCorrespondenceStatusName AS CATechCorrespondenceStatusName,
  CorrespondenceIssueDate,
  CorrespondencePrintDate,
  CACorrespncDispatchControl,
  _CorrespncDispContr._Text[1: Language=$session.system_language].CACorrespncDispatchControlName AS CACorrespncDispatchControlName,
  CreationDate,
  CorrespondenceIssuedByUser,
  _IssuedByUser.UserDescription AS CorrespondenceIssuedByUserName,
  CorrespondencePrintedByUser,
  _PrintedByContact.FullName AS CorrespondencePrintedByUsrName,
  CAPrintRunDate,
  CAPrintRunID,
  CompanyCode,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  OriglCorrespondenceRecipient,
  _OriginalBusinessPartner.BusinessPartnerFullName AS OriglCorrespncRecipientName,
  concat_with_space( _BPCurrentDefaultAddress._AddressDefaultRepresentation.StreetName, _BPCurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber, 1) as HouseNumber AS HouseNumber1asHouseNumber,
  concat_with_space( _BPCurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _BPCurrentDefaultAddress._AddressDefaultRepresentation.CityName, 1) as HomeTown AS CityName1asHomeTown,
  _BPCurrentDefaultAddress._AddressDefaultRepresentation.Country AS Country,
  _BPCurrentDefaultAddress._AddressDefaultRepresentation._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  CAContract,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  CASubApplication,
  _SubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  Currency,
  CAAmountInLocalCurrency,
  CACorrespondenceStatus,
  CreationDateTime,
  CorrespondenceIssueDateTime,
  CorrespondencePrintDateTime,
  ApplicationForm,
  RawDataInterfaceApplForm,
  CorrespondenceCreationYear,
  CACorrespondenceRecurrence,
  CACorrespondenceRecurrencePerd,
  CorrespondenceIsEmpty,
  CorrespondenceIsTest,
  TransferPostgHasBeenCarriedOut,
  BusinessPartnerUUID,
  OriglCorrespncRecipientUUID,
  CorrespondenceIssueTime
FROM I_CACorrespondenceHistory
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _BPCurrentDefaultAddress ON BusinessPartner = _BPCurrentDefaultAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _IssuedByContact ON CorrespondenceIssuedByUser = _IssuedByContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _PrintedByContact ON CorrespondencePrintedByUser = _PrintedByContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_User AS _IssuedByUser ON CorrespondenceIssuedByUser = _IssuedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _PrintedByUser ON CorrespondencePrintedByUser = _PrintedByUser.UserID  -- association [0..1]
;

Depth:

C_CACorrespondenceHistory view

I_CACorrespondenceHistory view