R_ContrAcctPrtnCorrespncTP

DDL: R_CONTRACCTPRTNCORRESPNCTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 1 Associations

Contr Acct Partner Correspondence - TP

R_ContrAcctPrtnCorrespncTP is a Transactional CDS View that provides data about "Contr Acct Partner Correspondence - TP" in SAP S/4HANA. It reads from 1 data source (I_ContrAcctPrtnCorrespnc) and exposes 16 fields with key fields ContractAccount, BusinessPartner, ContrAcctPrtnCorrespncUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ContrAcctPrtnCorrespnc I_ContrAcctPrtnCorrespnc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ContractAccountTP _ContractAccount _ContractAccount.ContractAccount = $projection.ContractAccount

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Contr Acct Partner Correspondence - TP view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey ContrAcctPrtnCorrespncUUID view
ObjectModel.sapObjectNodeType.name ContrAcctPartnerCorrespondence view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount ContractAccount Contract Acct
KEY BusinessPartner BusinessPartner Issuing Authority
KEY ContrAcctPrtnCorrespncUUID ContrAcctPrtnCorrespncUUID Internal Counter as Field in Table Key
AddrIDOfCorrespncRcpnt AddrIDOfCorrespncRcpnt Address Number
CorrespncRcpntAddrIsSpecified CorrespncRcpntAddrIsSpecified Address Selected
CACorrespondenceType CACorrespondenceType Corresp. Type
CorrespondenceRole CorrespondenceRole Corresp. Role
CorrespondenceRecipient CorrespondenceRecipient Corresp. Recip.
CAOriglPartIsNotRcvgCorrespnc CAOriglPartIsNotRcvgCorrespnc Alt./Add.Recip.
CACorrespondenceActivityCode CACorrespondenceActivityCode Activity
_ContractAccount _ContractAccount
_ContractAccountPartner _ContractAccountPartner
_BusinessPartner _BusinessPartner
_CACorrespncActivityCode _CACorrespncActivityCode
_CACorrespondenceType _CACorrespondenceType
_CorrespondenceRecipient _CorrespondenceRecipient

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 R_ContrAcctPrtnCorrespncTP.
-- 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 R_ContrAcctPrtnCorrespncTP AS
SELECT
  ContractAccount,
  BusinessPartner,
  ContrAcctPrtnCorrespncUUID,
  AddrIDOfCorrespncRcpnt,
  CorrespncRcpntAddrIsSpecified,
  CACorrespondenceType,
  CorrespondenceRole,
  CorrespondenceRecipient,
  CAOriglPartIsNotRcvgCorrespnc,
  CACorrespondenceActivityCode
FROM I_ContrAcctPrtnCorrespnc
LEFT OUTER JOIN R_ContractAccountTP AS _ContractAccount ON _ContractAccount.ContractAccount = ContractAccount  -- association [1..1]
;

Learn More