R_TrdgDocItemPartner

DDL: R_TRDGDOCITEMPARTNER Type: view_entity COMPOSITE Package: VDM_LO_GT
40 Fields 2 Data Sources 1 Associations

Partner of Trading Document Item

R_TrdgDocItemPartner is a Composite CDS View that provides data about "Partner of Trading Document Item" in SAP S/4HANA. It reads from 2 data sources (R_TrdgDocItemBasic, R_TrdgDocPartnerBasic) and exposes 40 fields with key fields TradingDocument, TradingDocumentItem, PartnerFunction, PartnerCounter. It has 1 association to related views. Part of development package VDM_LO_GT.

Data Sources (2)

SourceAliasJoin Type
R_TrdgDocItemBasic TrdgDocItemBasic inner
R_TrdgDocPartnerBasic TrdgDocPartnerBasic from

Associations (1)

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

Annotations (8)

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

Fields (40)

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

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_TrdgDocItemPartner.
-- 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_TrdgDocItemPartner AS
SELECT
  TrdgDocPartnerBasic.TradingDocument AS TradingDocument,
  TrdgDocItemBasic.TradingDocumentItem AS TradingDocumentItem,
  TrdgDocPartnerBasic.PartnerFunction AS PartnerFunction,
  TrdgDocPartnerBasic.PartnerCounter AS PartnerCounter,
  TrdgDocPartnerBasic.Supplier AS Supplier,
  cast(TrdgDocPartnerBasic.SoldToParty as wb2_sold_to_party preserving type ) AS SoldToParty,
  TrdgDocPartnerBasic.DefaultPartner AS DefaultPartner,
  TrdgDocPartnerBasic.ContactPerson AS ContactPerson,
  TrdgDocPartnerBasic.Personnel AS Personnel,
  TrdgDocPartnerBasic.AddressID AS AddressID,
  TrdgDocPartnerBasic.TrdgDocPartAddrRefType AS TrdgDocPartAddrRefType,
  TrdgDocPartnerBasic.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  TrdgDocPartnerBasic.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  TrdgDocPartnerBasic.AddressObjectType AS AddressObjectType,
  TrdgDocPartnerBasic.AddressPersonID AS AddressPersonID,
  TrdgDocPartnerBasic.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  TrdgDocPartnerBasic.TrdgDocPrtnHierLvlVal AS TrdgDocPrtnHierLvlVal,
  TrdgDocPartnerBasic.TaxNumber1 AS TaxNumber1,
  TrdgDocPartnerBasic.TaxNumber2 AS TaxNumber2,
  TrdgDocPartnerBasic.TaxNumber3 AS TaxNumber3,
  TrdgDocPartnerBasic.TaxNumber4 AS TaxNumber4,
  TrdgDocPartnerBasic.NFPartnerIsNaturalPerson AS NFPartnerIsNaturalPerson,
  TrdgDocPartnerBasic.TaxNumberType AS TaxNumberType,
  TrdgDocPartnerBasic.TrdgDocDelivSchedUnldgPt AS TrdgDocDelivSchedUnldgPt,
  TrdgDocPartnerBasic.TrdgDocCustHierCat AS TrdgDocCustHierCat,
  TrdgDocPartnerBasic.TrdgDocSuplrHierCat AS TrdgDocSuplrHierCat,
  TrdgDocPartnerBasic.TrdgDocIsHierPrDetnRlvt AS TrdgDocIsHierPrDetnRlvt,
  TrdgDocPartnerBasic.TrdgDocCustIsRbteRlvt AS TrdgDocCustIsRbteRlvt,
  TrdgDocPartnerBasic.TrdgDocPurgIsSubjToSettlmt AS TrdgDocPurgIsSubjToSettlmt,
  TrdgDocPartnerBasic.TrdgDocPartAddrIsDocSpcfc AS TrdgDocPartAddrIsDocSpcfc,
  TrdgDocPartnerBasic._Address AS _Address,
  TrdgDocPartnerBasic._AddressPersonName AS _AddressPersonName,
  TrdgDocPartnerBasic._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  TrdgDocPartnerBasic._BusinessPartnerAddress AS _BusinessPartnerAddress,
  TrdgDocPartnerBasic._ContactPerson AS _ContactPerson,
  TrdgDocPartnerBasic._PartnerFunction AS _PartnerFunction,
  TrdgDocPartnerBasic._PersonWorkplaceAddrDfltRprstn AS _PersonWorkplaceAddrDfltRprstn,
  TrdgDocPartnerBasic._SoldToParty AS _SoldToParty,
  TrdgDocPartnerBasic._Supplier AS _Supplier
FROM R_TrdgDocPartnerBasic AS TrdgDocPartnerBasic
INNER JOIN R_TrdgDocItemBasic AS TrdgDocItemBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_TrdgDoc AS _TrdgDoc ON TradingDocument = _TrdgDoc.TradingDocument  -- association [1..1]
;

Learn More