P_SALESCONTRACTPARTNER

CDS View

Sales Contract Partner

P_SALESCONTRACTPARTNER is a CDS View in S/4HANA. Sales Contract Partner. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesContractPartner view from COMPOSITE Sales Contract Partner

Fields (17)

KeyField CDS FieldsUsed in Views
KEY PartnerFunction PartnerFunction 1
KEY SalesContract SalesContract 1
KEY SDDocPartnerSequenceNumber SDDocPartnerSequenceNumber 1
AddressID AddressID 1
AddressObjectType AddressObjectType 1
AddressPersonID AddressPersonID 1
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 1
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 1
ContactPerson ContactPerson 1
Customer Customer 1
Partner Partner 1
Personnel Personnel 1
ReferenceBusinessPartner ReferenceBusinessPartner 1
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 1
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 1
Supplier Supplier 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.

-- Sales Contract Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SALESCONTRACTPARTNER (
    PARTNERFUNCTION,
    SALESCONTRACT,
    SDDOCPARTNERSEQUENCENUMBER,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    BPADDRDETERMINATIONTRANSACTION,
    BPREFADDRESSIDFORDOCSPCFCADDR,
    CONTACTPERSON,
    CUSTOMER,
    PARTNER,
    PERSONNEL,
    REFERENCEBUSINESSPARTNER,
    SDDOCPARTNERADDRESSREFTYPE,
    SDDOCPARTNERADDRISDOCSPECIFIC,
    SUPPLIER,
    VATREGISTRATION,
    PRIMARY KEY (PARTNERFUNCTION, SALESCONTRACT, SDDOCPARTNERSEQUENCENUMBER)
);