R_TrdgContrPartner

DDL: R_TRDGCONTRPARTNER Type: view_entity COMPOSITE
33 Fields 1 Data Sources 1 Associations

Partner of Trading Contract

R_TrdgContrPartner is a Composite CDS View that provides data about "Partner of Trading Contract" in SAP S/4HANA. It reads from 1 data source (R_TrdgDocPartner) and exposes 33 fields with key fields TradingContract, PartnerFunction, PartnerCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_TrdgDocPartner TrdgContrPartner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_TrdgContr _TradingContract $projection.TradingContract = _TradingContract.TradingContract

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Partner of Trading Contract view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY TradingContract TradingDocument
KEY PartnerFunction PartnerFunction Partner Functn
KEY PartnerCounter PartnerCounter Partner counter
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
Supplier Supplier Supplier
SoldToParty SoldToParty Sold-to Party
DefaultPartner DefaultPartner Default Partner
ContactPerson ContactPerson Contact Person Key
Personnel Personnel Personnel No.
AddressID AddressID Ship-to address
TrdgContrPartAddrRefType TrdgDocPartAddrRefType
ReferenceBusinessPartner ReferenceBusinessPartner Busn. Partner
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
AddressObjectType AddressObjectType Address Type
AddressPersonID AddressPersonID Person Number
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
TrdgContrPrtnHierLvlVal TrdgDocPrtnHierLvlVal
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
TaxNumber4 TaxNumber4
NFPartnerIsNaturalPerson NFPartnerIsNaturalPerson
TaxNumberType TaxNumberType Tax number type
TrdgContrDelivSchedUnldgPt TrdgDocDelivSchedUnldgPt
TrdgContrCustHierCat TrdgDocCustHierCat
TrdgContrSuplrHierCat TrdgDocSuplrHierCat
TrdgContrIsHierPrDetnRlvt TrdgDocIsHierPrDetnRlvt
TrdgContrCustIsRbteRlvt TrdgDocCustIsRbteRlvt
TrdgContrPurgIsSubjToSettlmt TrdgDocPurgIsSubjToSettlmt
TrdgContrPartAddrIsDocSpcfc TrdgDocPartAddrIsDocSpcfc
_Supplier _Supplier
_TradingContract _TradingContract

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_TrdgContrPartner.
-- 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_TrdgContrPartner AS
SELECT
  TradingDocument AS TradingContract,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  SoldToParty,
  DefaultPartner,
  ContactPerson,
  Personnel,
  AddressID,
  TrdgDocPartAddrRefType AS TrdgContrPartAddrRefType,
  ReferenceBusinessPartner,
  BPAddrDeterminationTransaction,
  AddressObjectType,
  AddressPersonID,
  BPRefAddressIDForDocSpcfcAddr,
  TrdgDocPrtnHierLvlVal AS TrdgContrPrtnHierLvlVal,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  NFPartnerIsNaturalPerson,
  TaxNumberType,
  TrdgDocDelivSchedUnldgPt AS TrdgContrDelivSchedUnldgPt,
  TrdgDocCustHierCat AS TrdgContrCustHierCat,
  TrdgDocSuplrHierCat AS TrdgContrSuplrHierCat,
  TrdgDocIsHierPrDetnRlvt AS TrdgContrIsHierPrDetnRlvt,
  TrdgDocCustIsRbteRlvt AS TrdgContrCustIsRbteRlvt,
  TrdgDocPurgIsSubjToSettlmt AS TrdgContrPurgIsSubjToSettlmt,
  TrdgDocPartAddrIsDocSpcfc AS TrdgContrPartAddrIsDocSpcfc
FROM R_TrdgDocPartner AS TrdgContrPartner
LEFT OUTER JOIN R_TrdgContr AS _TradingContract ON TradingContract = _TradingContract.TradingContract  -- association [1..1]
;

Learn More