I_SALESDOCUMENTPARTNER

CDS View
35 Fields 12 CDS Views

Sales Document Partner

I_SALESDOCUMENTPARTNER is a CDS View in S/4HANA. Sales Document Partner. It contains 35 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_ChmlCmplncReqCustomerCntct view from CONSUMPTION Chemical Compliance Request Customer Contact Card (ship to)
CIC_SalesDocumentPartner view_entity from Projection on Sales Doc. Partner (Industry Cloud Solutions)
I_CreditMemoReqPartner view from COMPOSITE Credit Memo Request Partner
I_CustomerReturnPartner view from COMPOSITE Returns Order Partner
I_DebitMemoReqPartner view from COMPOSITE Debit Memo Request Partner
I_SalesOrderPartner view from COMPOSITE Sales Order Partner
I_SalesQuotationPartner view from COMPOSITE Sales Quotation Partner
I_SalesSchedgAgrmtPartner view from COMPOSITE Sales Scheduling Agreement Partner
I_SlsOrdWthoutChrgPartner view from COMPOSITE Partner for Sales Order Without Charge
P_SalesContractPartner view from COMPOSITE Sales Contract Partner
P_SalesDocItemInheritedPartner view inner COMPOSITE
R_SalesContractShipToPartyTP view_entity from TRANSACTIONAL Sales Contract Ship-to Party - TP

Fields (35)

KeyField CDS FieldsUsed in Views
KEY Partner Partner 2
KEY PartnerFunction PartnerFunction 3
KEY SalesDocument SalesDocument 2
_Address _Address 2
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr 2
_BusinessPartnerAddress _BusinessPartnerAddress 2
_ContactPerson _ContactPerson 2
_DfltAddrRprstn _DfltAddrRprstn 2
_OrganizationAddress _OrganizationAddress 1
_OrgNamePostalAddress _OrgNamePostalAddress 1
_PartnerFunction _PartnerFunction 2
_PersonAddress _PersonAddress 1
_PersonName _PersonName 1
_SalesDocument _SalesDocument 2
AddressID AddressID 3
AddressObjectType AddressObjectType 4
AddressPersonID AddressPersonID 3
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 2
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 2
ContactPerson ContactPerson 2
CorrespondenceLanguage CorrespondenceLanguage 2
Customer Customer,Partner 3
EmailAddress EmailAddress 3
FormOfAddress FormOfAddress 2
FullName FullName 2
InternationalFaxNumber InternationalFaxNumber 3
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 3
InternationalPhoneNumber InternationalPhoneNumber 3
Personnel Personnel 2
ReferenceBusinessPartner ReferenceBusinessPartner 3
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 2
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 2
Supplier Supplier 2
UnloadingPointName UnloadingPointName 3
VATRegistration VATRegistration 3

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 Document Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCUMENTPARTNER (
    PARTNER,
    PARTNERFUNCTION,
    SALESDOCUMENT,
    _ADDRESS,
    _BPREFADDRESSFORDOCSPCFCADDR,
    _BUSINESSPARTNERADDRESS,
    _CONTACTPERSON,
    _DFLTADDRRPRSTN,
    _ORGANIZATIONADDRESS,
    _ORGNAMEPOSTALADDRESS,
    _PARTNERFUNCTION,
    _PERSONADDRESS,
    _PERSONNAME,
    _SALESDOCUMENT,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    BPADDRDETERMINATIONTRANSACTION,
    BPREFADDRESSIDFORDOCSPCFCADDR,
    CONTACTPERSON,
    CORRESPONDENCELANGUAGE,
    CUSTOMER,
    EMAILADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    PERSONNEL,
    REFERENCEBUSINESSPARTNER,
    SDDOCPARTNERADDRESSREFTYPE,
    SDDOCPARTNERADDRISDOCSPECIFIC,
    SUPPLIER,
    UNLOADINGPOINTNAME,
    VATREGISTRATION,
    PRIMARY KEY (PARTNER, PARTNERFUNCTION, SALESDOCUMENT)
);

Learn More