What is C_CABillPrntInvcgHdrCorrespnc in SAP S/4HANA?

C_CABillPrntInvcgHdrCorrespnc is a consumption CDS view in SAP S/4HANA. Fakt.beleg mit Korrespondenzauftrag It contains 87 fields.

Which tables does C_CABillPrntInvcgHdrCorrespnc read from?

C_CABillPrntInvcgHdrCorrespnc reads data from: I_CACorrespondenceHeader.

What VDM layer is C_CABillPrntInvcgHdrCorrespnc?

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

C_CABillPrntInvcgHdrCorrespnc

DDL: C_CABILLPRNTINVCGHDRCORRESPNC SQL: CCAINVDOCH_COH Type: view_entity CONSUMPTION Package: FKKINV_VDM_INV

87 Fields 1 Data Sources 18 Associations

Fakt.beleg mit Korrespondenzauftrag

Invoicing Document with Correspondence Request

C_CABillPrntInvcgHdrCorrespnc (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Contract Accounting

C_CABillPrntInvcgHdrCorrespnc is a Consumption CDS View that provides data about "Fakt.beleg mit Korrespondenzauftrag" in SAP S/4HANA. It reads from 1 data source (I_CACorrespondenceHeader) and exposes 87 fields with key fields CACorrespondenceType, CACorrespondence. It has 18 associations to related views. Part of development package FKKINV_VDM_INV.

SAP Help Documentation

Category	CDS Views for Templates

Purpose
This CDS view provides the data that is used in the e-mail template, if the invoice is sent by e-mail. The invoice itself is in the attachment of the e-mail.. The CDS view is always used when invoices are sent by e-mail. The CDS view is also used if a customer-specific e-mail template is created. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description _CAInvcgTypeProcText.CAInvcgDocumentTitleText Name of Invoicing Document (for Invoicing Printing) DocumentDate Document Date in Document BusinessPartnerName Name of Business Partner ContractAccount Contract Account Number CAAmountInLocalCurrency Amount in Local Currency with +/- Sign TransactionCurrency Transaction Currency CompanyCodeName Name of Company Code or Company

View on SAP Help Portal →

SAP API Hub

Category	Consumption
State	C1
Line of Business	Contract Accounting
Application Component	FI-CA-INV-2CL
Capabilities	Output: Email Data Provider
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Contract Accounting for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view provides the data that is used in the e-mail template, if the invoice is sent by e-mail. </p> <p>The invoice itself is in the attachment of the e-mail..</p> <p>The CDS view is always used when invoices are sent by e-mail. The CDS view is also used if a customer-specific e-mail template is created.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_CACorrespondenceHeader	_CACorrespondenceHeader	from

Associations (18)

Cardinality	Target	Alias	Condition
[0..1]	I_CAInvcgDocHeader2	_CAInvcgDocHeader	`$projection.Correspondence2ndEntityData = _CAInvcgDocHeader.CAInvoicingDocument and $projection.Correspondence1stEntityData = _CAInvcgDocHeader.CAInvcgProcess`
[0..1]	I_CAInvcgDocReversalReasonText	_CAInvcgDocReversalReasonText	`$projection.CAInvcgDocumentReversalReason = _CAInvcgDocReversalReasonText.CAInvcgDocumentReversalReason and $projection.Language = _CAInvcgDocReversalReasonText.Language`
[0..1]	I_CAInvcgDocLockedForPrintText	_CAInvcgDocLockedForPrintText	`$projection.CAInvcgDocIsLockedForPrinting = _CAInvcgDocLockedForPrintText.CAInvcgDocIsLockedForPrinting and $projection.Language = _CAInvcgDocLockedForPrintText.Language`
[1..1]	I_CAInvcgProcessText	_CAInvcgProcessText	`$projection.CAInvcgProcess = _CAInvcgProcessText.CAInvcgProcess and $projection.CAApplicationArea = _CAInvcgProcessText.CAApplicationArea and $projection.Language = _CAInvcgProcessText.Language`
[0..1]	I_CAInvcgCategoryText	_CAInvcgCategoryText	`$projection.CAInvcgCategory = _CAInvcgCategoryText.CAInvcgCategory and $projection.Language = _CAInvcgCategoryText.Language`
[0..1]	I_CAInvcgTypeProcText	_CAInvcgTypeProcText	`$projection.CAInvcgType = _CAInvcgTypeProcText.CAInvcgType and $projection.CAInvcgProcess = _CAInvcgTypeProcText.CAInvcgProcess and $projection.CAApplicationArea = _CAInvcgTypeProcText.CAApplicationArea and $projection.Language = _CAInvcgTypeProcText.Language`
[0..1]	I_CAInvcgPeriodCatText	_CAInvcgPeriodCatText	`$projection.CAInvcgDocPeriodCategory = _CAInvcgPeriodCatText.CAInvcgPeriodCategory and $projection.Language = _CAInvcgPeriodCatText.Language`
[0..1]	I_CAInvcgTargetProcText	_CAInvcgTargetProcText	`$projection.CAInvcgTargetProcess = _CAInvcgTargetProcText.CAInvcgTargetProcess and $projection.Language = _CAInvcgTargetProcText.Language`
[1..1]	I_CAInvcgCorrectionCatText	_CAInvcgCorrectionCatText	`$projection.CAInvcgCorrectionCategory = _CAInvcgCorrectionCatText.CAInvcgCorrectionCategory and $projection.Language = _CAInvcgCorrectionCatText.Language`
[1..1]	I_CAInvcgDocChrgDiscItemsText	_CAInvcgDocChrgDiscItemsText	`$projection.CAInvcgDocHasChargeOrDiscItems = _CAInvcgDocChrgDiscItemsText.CAInvcgDocHasChargeOrDiscItems and $projection.Language = _CAInvcgDocChrgDiscItemsText.Language`
[1..1]	I_CAInvcgDocCreationModeText	_CAInvcgDocCreationModeText	`$projection.CAInvcgDocCreationMode = _CAInvcgDocCreationModeText.CAInvcgDocCreationMode and $projection.Language = _CAInvcgDocCreationModeText.Language`
[1..1]	I_CAInvcgMasterDataTypeText	_CAInvcgMasterDataTypeText	`$projection.CAInvcgMasterDataType = _CAInvcgMasterDataTypeText.CAInvcgMasterDataType and $projection.Language = _CAInvcgMasterDataTypeText.Language`
[1..1]	I_CAInvcgDocTechDocTypeText	_CAInvcgDocTechDocTypeText	`$projection.CAInvcgTechnicalDocumentType = _CAInvcgDocTechDocTypeText.CAInvcgTechnicalDocumentType and $projection.Language = _CAInvcgDocTechDocTypeText.Language`
[1..1]	I_CAInvcgDocPartOfListText	_CAInvcgDocPartOfListText	`$projection.CAInvcgDocIsPartOfList = _CAInvcgDocPartOfListText.CAInvcgDocIsPartOfList and $projection.Language = _CAInvcgDocPartOfListText.Language`
[1..1]	I_CAInvcgBolloTaxPostStatText	_CAInvcgBolloTaxPostStatText	`$projection.CAInvcgBolloTaxPostStatus = _CAInvcgBolloTaxPostStatText.CAInvcgBolloTaxPostStatus and $projection.Language = _CAInvcgBolloTaxPostStatText.Language`
[0..*]	I_Address_2	_SenderAddress	`$projection.CACorrespncSenderAddressID = _SenderAddress.AddressID`
[1..1]	I_CAContractPartner	_OriglCorrespncRcpnt	`$projection.OriglCorrespondenceRecipient = _OriglCorrespncRcpnt.BusinessPartner`
[0..1]	E_CAInvcgDocHeader	_Extension	`$projection.Correspondence2ndEntityData = _Extension.CAInvoicingDocument`

Annotations (9)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.modelingPattern	#OUTPUT_EMAIL_DATA_PROVIDER	view
AccessControl.personalData.blocking	#REQUIRED	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Fakt.beleg mit Korrespondenzauftrag	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (87)

Key	Field	Source Table	Source Field	Description
KEY	CACorrespondenceType		CACorrespondenceType	Correspondence Type
KEY	CACorrespondence		CACorrespondence	Correspondence Key
	ContractAccount		ContractAccount	Contract Account Number
	BusinessPartner		BusinessPartner	Correspondence Recipient
	CAContract		CAContract	Reference Specifications from Contract
	OriglCorrespondenceRecipient		OriglCorrespondenceRecipient	Original Correspondence Recipient
	CompanyCode		CompanyCode	Company Code in Correspondence
	CreatedByUser		CreatedByUser	User Name
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Creation (to the Second)
	CorrespondencePrintDate		CorrespondencePrintDate	Print Date
	CorrespondenceIssueDate		CorrespondenceIssueDate	Issue Date
	CorrespondenceIssueTime		CorrespondenceIssueTime	Issue Time to the Second
	Currency		Currency	Transaction Currency
	CAAmountInLocalCurrency		CAAmountInLocalCurrency	Amount in Local Currency with +/- Signs
	CAMassRunDate		CAMassRunDate	Date ID for Creation Run
	CAMassRunID		CAMassRunID	Additional ID Characteristic for Creation Run
	Language		Language	Report Text Language
	Correspondence1stEntityIdn		Correspondence1stEntityIdn	Correspondence data
	Correspondence1stEntityData		Correspondence1stEntityData	Correspondence Data Field
	Correspondence2ndEntityIdn		Correspondence2ndEntityIdn	Correspondence data
	Correspondence2ndEntityData		Correspondence2ndEntityData	Correspondence Data Field
	Correspondence3rdEntityIdn		Correspondence3rdEntityIdn	Correspondence data
	Correspondence3rdEntityData		Correspondence3rdEntityData	Correspondence Data Field
	Correspondence4thEntityIdn		Correspondence4thEntityIdn	Correspondence data
	Correspondence4thEntityData		Correspondence4thEntityData	Correspondence Data Field
	CACorrespncSenderAddressID		CACorrespncSenderAddressID	Address Number of Correspondence Sender
	CompanyCodeName			Name of Company Code or Company
	SenderCityName	_SenderAddress	CityName	Name
	SenderPostalCode	_SenderAddress	PostalCode	City Postal Code
	SenderStreetName	_SenderAddress	StreetName	Street
	SenderHouseNumber	_SenderAddress	HouseNumber	House Number
	SenderCountry	_SenderAddress	Country	Country/Region Key
	BusinessPartnerName
	RecipientCityName			City
	RecipientPostalCode			City Postal Code
	RecipientStreetName			Street
	RecipientHouseNumber			House Number
	RecipientCountry			Country/Region Key
	OriglCorrespncRecipientName
	CustomerCityName			City
	CustomerPostalCode			City Postal Code
	CustomerStreetName			Street
	BusinessPartnerHouseNumber			House Number
	CustomerCountry			Country/Region Key
	CAInvcgDocumentReversalReason	_CAInvcgDocHeader	CAInvcgDocumentReversalReason	Reversal Reason of Invoicing Document
	CAInvcgDocIsLockedForPrinting	_CAInvcgDocHeader	CAInvcgDocIsLockedForPrinting	Invoicing Document Locked for Printing
	CAInvcgProcess	_CAInvcgDocHeader	CAInvcgProcess	Invoicing Process
	CAApplicationArea	_CAInvcgDocHeader	CAApplicationArea	Application Area
	CAInvcgCategory	_CAInvcgDocHeader	CAInvcgCategory	Invoicing Category
	CAInvcgType	_CAInvcgDocHeader	CAInvcgType	Invoicing Type
	CAInvcgDocPeriodCategory	_CAInvcgDocHeader	CAInvcgDocPeriodCategory	Category of Invoicing Period
	CAInvcgTargetProcess	_CAInvcgDocHeader	CAInvcgTargetProcess	Target Process That Invoices the Source Document
	CAInvcgCorrectionCategory	_CAInvcgDocHeader	CAInvcgCorrectionCategory	Category of Invoice Correction
	CAInvcgDocHasChargeOrDiscItems	_CAInvcgDocHeader	CAInvcgDocHasChargeOrDiscItems	Invoicing Document Contains Charge/Discount Items
	CAInvcgDocCreationMode	_CAInvcgDocHeader	CAInvcgDocCreationMode	Creation Mode of Invoicing Document
	CAInvcgMasterDataType	_CAInvcgDocHeader	CAInvcgMasterDataType	Type of Master Record for Convergent Invoicing
	CAInvcgTechnicalDocumentType	_CAInvcgDocHeader	CAInvcgTechnicalDocumentType	Type of Technical Billing/Invoicing Document
	CAInvcgDocIsPartOfList	_CAInvcgDocHeader	CAInvcgDocIsPartOfList	Invoicing Document Is Single Document of Invoicing List
	CAInvcgBolloTaxPostStatus	_CAInvcgDocHeader	CAInvcgBolloTaxPostStatus	Stamp Tax Posted
	CAInvcgDocPeriodDate	_CAInvcgDocHeader	CAInvcgDocPeriodDate	Invoicing Period
	DocumentDate	_CAInvcgDocHeader	DocumentDate	Document Date in Document
	CAAmountInTransactionCurrency	_CAInvcgDocHeader	CAAmountInTransactionCurrency	Amount in Transaction Currency with +/- Sign
	TransactionCurrency	_CAInvcgDocHeader	TransactionCurrency	Transaction Currency
	_CAInvcgDocHeader		_CAInvcgDocHeader
	_CAInvcgDocReversalReasonText		_CAInvcgDocReversalReasonText
	_CAInvcgProcessText		_CAInvcgProcessText
	_CAInvcgDocLockedForPrintText		_CAInvcgDocLockedForPrintText
	_CAInvcgCategoryText		_CAInvcgCategoryText
	_CAInvcgTypeProcText		_CAInvcgTypeProcText
	_CAInvcgPeriodCatText		_CAInvcgPeriodCatText
	_CAInvcgTargetProcText		_CAInvcgTargetProcText
	_CAInvcgCorrectionCatText		_CAInvcgCorrectionCatText
	_CAInvcgDocChrgDiscItemsText		_CAInvcgDocChrgDiscItemsText
	_CAInvcgDocCreationModeText		_CAInvcgDocCreationModeText
	_CAInvcgMasterDataTypeText		_CAInvcgMasterDataTypeText
	_CAInvcgDocTechDocTypeText		_CAInvcgDocTechDocTypeText
	_CAInvcgDocPartOfListText		_CAInvcgDocPartOfListText
	_CAInvcgBolloTaxPostStatText		_CAInvcgBolloTaxPostStatText
	_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_CABillPrntInvcgHdrCorrespnc.
-- 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: CCAINVDOCH_COH

CREATE VIEW C_CABillPrntInvcgHdrCorrespnc 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,
  _CACorrespondenceHeader._CompCode.CompanyCodeName AS CompanyCodeName,
  _SenderAddress.CityName AS SenderCityName,
  _SenderAddress.PostalCode AS SenderPostalCode,
  _SenderAddress.StreetName AS SenderStreetName,
  _SenderAddress.HouseNumber AS SenderHouseNumber,
  _SenderAddress.Country AS SenderCountry,
  _CACorrespondenceHeader._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CACorrespondenceHeader._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS RecipientCityName,
  _CACorrespondenceHeader._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS RecipientPostalCode,
  _CACorrespondenceHeader._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS RecipientStreetName,
  _CACorrespondenceHeader._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber AS RecipientHouseNumber,
  _CACorrespondenceHeader._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS RecipientCountry,
  _OriglCorrespncRcpnt._BusinessPartner.BusinessPartnerName AS OriglCorrespncRecipientName,
  _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,
  _CAInvcgDocHeader.CAInvcgDocumentReversalReason AS CAInvcgDocumentReversalReason,
  _CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting AS CAInvcgDocIsLockedForPrinting,
  _CAInvcgDocHeader.CAInvcgProcess AS CAInvcgProcess,
  _CAInvcgDocHeader.CAApplicationArea AS CAApplicationArea,
  _CAInvcgDocHeader.CAInvcgCategory AS CAInvcgCategory,
  _CAInvcgDocHeader.CAInvcgType AS CAInvcgType,
  _CAInvcgDocHeader.CAInvcgDocPeriodCategory AS CAInvcgDocPeriodCategory,
  _CAInvcgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
  _CAInvcgDocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems AS CAInvcgDocHasChargeOrDiscItems,
  _CAInvcgDocHeader.CAInvcgDocCreationMode AS CAInvcgDocCreationMode,
  _CAInvcgDocHeader.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CAInvcgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
  _CAInvcgDocHeader.CAInvcgDocIsPartOfList AS CAInvcgDocIsPartOfList,
  _CAInvcgDocHeader.CAInvcgBolloTaxPostStatus AS CAInvcgBolloTaxPostStatus,
  _CAInvcgDocHeader.CAInvcgDocPeriodDate AS CAInvcgDocPeriodDate,
  _CAInvcgDocHeader.DocumentDate AS DocumentDate,
  _CAInvcgDocHeader.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _CAInvcgDocHeader.TransactionCurrency AS TransactionCurrency
FROM I_CACorrespondenceHeader AS _CACorrespondenceHeader
LEFT OUTER JOIN I_CAInvcgDocHeader2 AS _CAInvcgDocHeader ON Correspondence2ndEntityData = _CAInvcgDocHeader.CAInvoicingDocument AND Correspondence1stEntityData = _CAInvcgDocHeader.CAInvcgProcess  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocReversalReasonText AS _CAInvcgDocReversalReasonText ON CAInvcgDocumentReversalReason = _CAInvcgDocReversalReasonText.CAInvcgDocumentReversalReason AND Language = _CAInvcgDocReversalReasonText.Language  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocLockedForPrintText AS _CAInvcgDocLockedForPrintText ON CAInvcgDocIsLockedForPrinting = _CAInvcgDocLockedForPrintText.CAInvcgDocIsLockedForPrinting AND Language = _CAInvcgDocLockedForPrintText.Language  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgProcessText AS _CAInvcgProcessText ON CAInvcgProcess = _CAInvcgProcessText.CAInvcgProcess AND CAApplicationArea = _CAInvcgProcessText.CAApplicationArea AND Language = _CAInvcgProcessText.Language  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgCategoryText AS _CAInvcgCategoryText ON CAInvcgCategory = _CAInvcgCategoryText.CAInvcgCategory AND Language = _CAInvcgCategoryText.Language  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgTypeProcText AS _CAInvcgTypeProcText ON CAInvcgType = _CAInvcgTypeProcText.CAInvcgType AND CAInvcgProcess = _CAInvcgTypeProcText.CAInvcgProcess AND CAApplicationArea = _CAInvcgTypeProcText.CAApplicationArea AND Language = _CAInvcgTypeProcText.Language  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgPeriodCatText AS _CAInvcgPeriodCatText ON CAInvcgDocPeriodCategory = _CAInvcgPeriodCatText.CAInvcgPeriodCategory AND Language = _CAInvcgPeriodCatText.Language  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgTargetProcText AS _CAInvcgTargetProcText ON CAInvcgTargetProcess = _CAInvcgTargetProcText.CAInvcgTargetProcess AND Language = _CAInvcgTargetProcText.Language  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCorrectionCatText AS _CAInvcgCorrectionCatText ON CAInvcgCorrectionCategory = _CAInvcgCorrectionCatText.CAInvcgCorrectionCategory AND Language = _CAInvcgCorrectionCatText.Language  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgDocChrgDiscItemsText AS _CAInvcgDocChrgDiscItemsText ON CAInvcgDocHasChargeOrDiscItems = _CAInvcgDocChrgDiscItemsText.CAInvcgDocHasChargeOrDiscItems AND Language = _CAInvcgDocChrgDiscItemsText.Language  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgDocCreationModeText AS _CAInvcgDocCreationModeText ON CAInvcgDocCreationMode = _CAInvcgDocCreationModeText.CAInvcgDocCreationMode AND Language = _CAInvcgDocCreationModeText.Language  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgMasterDataTypeText AS _CAInvcgMasterDataTypeText ON CAInvcgMasterDataType = _CAInvcgMasterDataTypeText.CAInvcgMasterDataType AND Language = _CAInvcgMasterDataTypeText.Language  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgDocTechDocTypeText AS _CAInvcgDocTechDocTypeText ON CAInvcgTechnicalDocumentType = _CAInvcgDocTechDocTypeText.CAInvcgTechnicalDocumentType AND Language = _CAInvcgDocTechDocTypeText.Language  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgDocPartOfListText AS _CAInvcgDocPartOfListText ON CAInvcgDocIsPartOfList = _CAInvcgDocPartOfListText.CAInvcgDocIsPartOfList AND Language = _CAInvcgDocPartOfListText.Language  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgBolloTaxPostStatText AS _CAInvcgBolloTaxPostStatText ON CAInvcgBolloTaxPostStatus = _CAInvcgBolloTaxPostStatText.CAInvcgBolloTaxPostStatus AND Language = _CAInvcgBolloTaxPostStatText.Language  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _SenderAddress ON CACorrespncSenderAddressID = _SenderAddress.AddressID  -- association [0..*]
LEFT OUTER JOIN I_CAContractPartner AS _OriglCorrespncRcpnt ON OriglCorrespondenceRecipient = _OriglCorrespncRcpnt.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN E_CAInvcgDocHeader AS _Extension ON Correspondence2ndEntityData = _Extension.CAInvoicingDocument  -- association [0..1]
;

Depth:

C_CABillPrntInvcgHdrCorrespnc view_entity

I_CACorrespondenceHeader view