R_TrdgDocPartner

DDL: R_TRDGDOCPARTNER Type: view_entity COMPOSITE
41 Fields 1 Data Sources 1 Associations

Partner of Trading Document

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

Data Sources (1)

SourceAliasJoin Type
R_TrdgDocPartnerBasic TrdgDocPartnerBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_TrdgDoc _TrdgDoc $projection.TradingDocument = _TrdgDoc.TradingDocument

Annotations (9)

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

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY TradingDocument TradingDocument Trading Contract
KEY PartnerFunction PartnerFunction Partner Functn
KEY PartnerCounter PartnerCounter Partner counter
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
Supplier Supplier Supplier
SoldToParty Sold-to Party
DefaultPartner DefaultPartner Default Partner
ContactPerson ContactPerson Contact Person Key
Personnel Personnel Personnel No.
AddressID AddressID Ship-to address
TrdgDocPartAddrRefType TrdgDocPartAddrRefType Adress ind.
ReferenceBusinessPartner ReferenceBusinessPartner Busn. Partner
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
AddressObjectType AddressObjectType Address Type
AddressPersonID AddressPersonID Person Number
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
TrdgDocPrtnHierLvlVal TrdgDocPrtnHierLvlVal
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3 Tax Number 3
TaxNumber4 TaxNumber4 Tax Number 4
NFPartnerIsNaturalPerson NFPartnerIsNaturalPerson Natural person
TaxNumberType TaxNumberType Tax number type
TrdgDocDelivSchedUnldgPt TrdgDocDelivSchedUnldgPt Unloading Point
TrdgDocCustHierCat TrdgDocCustHierCat
TrdgDocSuplrHierCat TrdgDocSuplrHierCat
TrdgDocIsHierPrDetnRlvt TrdgDocIsHierPrDetnRlvt Price determin.
TrdgDocCustIsRbteRlvt TrdgDocCustIsRbteRlvt Rebate
TrdgDocPurgIsSubjToSettlmt TrdgDocPurgIsSubjToSettlmt Subseq. Settlmt
TrdgDocPartAddrIsDocSpcfc TrdgDocPartAddrIsDocSpcfc
_CreatedByUser _CreatedByUser
_Address _Address
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr
_BusinessPartnerAddress _BusinessPartnerAddress
_ContactPerson _ContactPerson
_PartnerFunction _PartnerFunction
_PersonWorkplaceAddrDfltRprstn _PersonWorkplaceAddrDfltRprstn
_SoldToParty _SoldToParty
_Supplier _Supplier
_TrdgDoc _TrdgDoc

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_TrdgDocPartner.
-- 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_TrdgDocPartner AS
SELECT
  TradingDocument,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  cast(SoldToParty as wb2_sold_to_party preserving type ) AS SoldToParty,
  DefaultPartner,
  ContactPerson,
  Personnel,
  AddressID,
  TrdgDocPartAddrRefType,
  ReferenceBusinessPartner,
  BPAddrDeterminationTransaction,
  AddressObjectType,
  AddressPersonID,
  BPRefAddressIDForDocSpcfcAddr,
  TrdgDocPrtnHierLvlVal,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  TaxNumber4,
  NFPartnerIsNaturalPerson,
  TaxNumberType,
  TrdgDocDelivSchedUnldgPt,
  TrdgDocCustHierCat,
  TrdgDocSuplrHierCat,
  TrdgDocIsHierPrDetnRlvt,
  TrdgDocCustIsRbteRlvt,
  TrdgDocPurgIsSubjToSettlmt,
  TrdgDocPartAddrIsDocSpcfc
FROM R_TrdgDocPartnerBasic AS TrdgDocPartnerBasic
LEFT OUTER JOIN R_TrdgDoc AS _TrdgDoc ON TradingDocument = _TrdgDoc.TradingDocument  -- association [1..1]
;

Learn More