C_CAInvcgDocPrintReceiver

DDL: C_CAINVCGDOCPRINTRECEIVER Type: view_entity CONSUMPTION
22 Fields 1 Data Sources

Rechnungsempfänger

C_CAInvcgDocPrintReceiver is a Consumption CDS View that provides data about "Rechnungsempfänger" in SAP S/4HANA. It reads from 1 data source (I_CACorrespondenceHeader) and exposes 22 fields with key fields CACorrespondence, CAInvoicingDocument.

Data Sources (1)

SourceAliasJoin Type
I_CACorrespondenceHeader _CACorrespondenceHeader from

Annotations (9)

NameValueLevelField
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
EndUserText.label Rechnungsempfänger view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CACorrespondence CACorrespondence Correspond. Key
KEY CAInvoicingDocument Fred Reference Data2
CAInvcgProcess Fred Reference Data1
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompCode CompanyCodeName Company Name
BusinessPartnerCategory _BusinessPartner BusinessPartnerCategory Partner Cat.
PersonNumber PersonNumber Person Number
BusinessPartnerAddressID BusinessPartnerAddressID Sold-To Address
CorrespondenceRecipient Issuing Authority
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
CorrespncAddrShortWthStrText
CAInvcgDocNrOfPrntDpl
CAInvcgDocLastPrintDplDate
CAInvcgDocDuplicateIsEnabled
CorrespondencePrintDate CorrespondencePrintDate Print Date
CACorrespncDispatchControlName
CACorrespncDispatchControl CACorrespncDispatchControl Disp. Control
CACorrespondenceRoleText
CorrespondenceRole CorrespondenceRole Corresp. Role
_BusinessPartner _BusinessPartner
_CASendControl _CASendControl
_CorrespncRole _CorrespncRole

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_CAInvcgDocPrintReceiver.
-- 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_CAInvcgDocPrintReceiver AS
SELECT
  CACorrespondence,
  cast( Correspondence2ndEntityData as invdocno_kk ) AS CAInvoicingDocument,
  cast( Correspondence1stEntityData as inv_process_kk ) AS CAInvcgProcess,
  CompanyCode,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  _BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  PersonNumber,
  BusinessPartnerAddressID,
  cast( BusinessPartner as ftr_recipient preserving type ) AS CorrespondenceRecipient,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  cast('' as address_text_kk) AS CorrespncAddrShortWthStrText,
  cast('' as number_of_duplicates_kk) AS CAInvcgDocNrOfPrntDpl,
  cast('' as date_of_last_duplicate_kk) AS CAInvcgDocLastPrintDplDate,
  cast( 'X' as xfeld ) AS CAInvcgDocDuplicateIsEnabled,
  CorrespondencePrintDate,
  _CASendControl._Text[1: Language=$session.system_language].CACorrespncDispatchControlName AS CACorrespncDispatchControlName,
  CACorrespncDispatchControl,
  _CorrespncRole._Text[1: Language=$session.system_language].CACorrespondenceRoleText AS CACorrespondenceRoleText,
  CorrespondenceRole
FROM I_CACorrespondenceHeader AS _CACorrespondenceHeader
;

Learn More