P_SALESDOCITEMCOMPLETEPARTNER

CDS View

P_SALESDOCITEMCOMPLETEPARTNER is a CDS View in S/4HANA. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesDocItemCompletePartner view from COMPOSITE Sales Doc Item and Inherited Partners

Fields (24)

KeyField CDS FieldsUsed in Views
KEY PartnerFunction PartnerFunction 1
KEY SalesDocument SalesDocument 1
KEY SalesDocumentItem SalesDocumentItem 1
_Address _Address 1
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr 1
_BusinessPartnerAddress _BusinessPartnerAddress 1
_DfltAddrRprstn _DfltAddrRprstn 1
_PartnerFunction _PartnerFunction 1
_SalesDocument _SalesDocument 1
_SalesDocumentItem _SalesDocumentItem 1
AddressID AddressID 1
AddressObjectType AddressObjectType 1
AddressPersonID AddressPersonID 1
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 1
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 1
ContactPerson ContactPerson 1
Customer Customer 1
PartnerIsSpecificForSDDocItem PartnerIsSpecificForSDDocItem 1
Personnel Personnel 1
ReferenceBusinessPartner ReferenceBusinessPartner 1
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 1
Supplier Supplier 1
UnloadingPointName UnloadingPointName 1
VATRegistration VATRegistration 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SALESDOCITEMCOMPLETEPARTNER (
    PARTNERFUNCTION,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    _ADDRESS,
    _BPREFADDRESSFORDOCSPCFCADDR,
    _BUSINESSPARTNERADDRESS,
    _DFLTADDRRPRSTN,
    _PARTNERFUNCTION,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    BPADDRDETERMINATIONTRANSACTION,
    BPREFADDRESSIDFORDOCSPCFCADDR,
    CONTACTPERSON,
    CUSTOMER,
    PARTNERISSPECIFICFORSDDOCITEM,
    PERSONNEL,
    REFERENCEBUSINESSPARTNER,
    SDDOCPARTNERADDRESSREFTYPE,
    SUPPLIER,
    UNLOADINGPOINTNAME,
    VATREGISTRATION,
    PRIMARY KEY (PARTNERFUNCTION, SALESDOCUMENT, SALESDOCUMENTITEM)
);