R_TRDGDOCPARTNERBASIC

CDS View

Partner of Trading Document

R_TRDGDOCPARTNERBASIC is a CDS View in S/4HANA. Partner of Trading Document. It contains 37 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_TrdgDocItemPartner view_entity from COMPOSITE Partner of Trading Document Item
R_TrdgDocPartner view_entity from COMPOSITE Partner of Trading Document

Fields (37)

KeyField CDS FieldsUsed in Views
KEY PartnerCounter PartnerCounter 1
KEY PartnerFunction PartnerFunction 1
KEY TradingDocument TradingDocument 1
_Address _Address 1
_AddressPersonName _AddressPersonName 1
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr 1
_BusinessPartnerAddress _BusinessPartnerAddress 1
_ContactPerson _ContactPerson 1
_PartnerFunction _PartnerFunction 1
_PersonWorkplaceAddrDfltRprstn _PersonWorkplaceAddrDfltRprstn 1
_SoldToParty _SoldToParty 1
_Supplier _Supplier 1
AddressID AddressID 1
AddressObjectType AddressObjectType 1
AddressPersonID AddressPersonID 1
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 1
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 1
ContactPerson ContactPerson 1
DefaultPartner DefaultPartner 1
NFPartnerIsNaturalPerson NFPartnerIsNaturalPerson 1
Personnel Personnel 1
ReferenceBusinessPartner ReferenceBusinessPartner 1
Supplier Supplier 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxNumber4 TaxNumber4 1
TaxNumberType TaxNumberType 1
TrdgDocCustHierCat TrdgDocCustHierCat 1
TrdgDocCustIsRbteRlvt TrdgDocCustIsRbteRlvt 1
TrdgDocDelivSchedUnldgPt TrdgDocDelivSchedUnldgPt 1
TrdgDocIsHierPrDetnRlvt TrdgDocIsHierPrDetnRlvt 1
TrdgDocPartAddrIsDocSpcfc TrdgDocPartAddrIsDocSpcfc 1
TrdgDocPartAddrRefType TrdgDocPartAddrRefType 1
TrdgDocPrtnHierLvlVal TrdgDocPrtnHierLvlVal 1
TrdgDocPurgIsSubjToSettlmt TrdgDocPurgIsSubjToSettlmt 1
TrdgDocSuplrHierCat TrdgDocSuplrHierCat 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Partner of Trading Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_TRDGDOCPARTNERBASIC (
    PARTNERCOUNTER,
    PARTNERFUNCTION,
    TRADINGDOCUMENT,
    _ADDRESS,
    _ADDRESSPERSONNAME,
    _BPREFADDRESSFORDOCSPCFCADDR,
    _BUSINESSPARTNERADDRESS,
    _CONTACTPERSON,
    _PARTNERFUNCTION,
    _PERSONWORKPLACEADDRDFLTRPRSTN,
    _SOLDTOPARTY,
    _SUPPLIER,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    BPADDRDETERMINATIONTRANSACTION,
    BPREFADDRESSIDFORDOCSPCFCADDR,
    CONTACTPERSON,
    DEFAULTPARTNER,
    NFPARTNERISNATURALPERSON,
    PERSONNEL,
    REFERENCEBUSINESSPARTNER,
    SUPPLIER,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBERTYPE,
    TRDGDOCCUSTHIERCAT,
    TRDGDOCCUSTISRBTERLVT,
    TRDGDOCDELIVSCHEDUNLDGPT,
    TRDGDOCISHIERPRDETNRLVT,
    TRDGDOCPARTADDRISDOCSPCFC,
    TRDGDOCPARTADDRREFTYPE,
    TRDGDOCPRTNHIERLVLVAL,
    TRDGDOCPURGISSUBJTOSETTLMT,
    TRDGDOCSUPLRHIERCAT,
    PRIMARY KEY (PARTNERCOUNTER, PARTNERFUNCTION, TRADINGDOCUMENT)
);