I_SALESORDERPARTNER

CDS View
29 Fields 4 CDS Views

Sales Order Partner

I_SALESORDERPARTNER is a CDS View in S/4HANA. Sales Order Partner. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_SalesOrderWrkflwInbox view left_outer CONSUMPTION Sales Order Workflow Inbox
I_CustProjSlsOrdPartner view from COMPOSITE Sales Order Partner for Customer Project
R_SalesOrderPartnerTP view_entity from TRANSACTIONAL Sales Order Partner - TP
R_SalesOrderShipToPartyTP view_entity from TRANSACTIONAL Sales Order Ship-to Party - TP

Fields (29)

KeyField CDS FieldsUsed in Views
KEY PartnerFunction PartnerFunction 1
_Address _Address 1
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr 2
_BusinessPartnerAddress _BusinessPartnerAddress 2
_DfltAddrRprstn _DfltAddrRprstn 2
_PartnerFunction _PartnerFunction 1
AddressID AddressID 3
AddressObjectType AddressObjectType 3
AddressPersonID AddressPersonID 3
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 2
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 2
ContactPerson ContactPerson 2
CorrespondenceLanguage CorrespondenceLanguage 2
Customer Customer,Partner,ShipToParty 3
EmailAddress EmailAddress 2
FormOfAddress FormOfAddress 2
FullName FullName 2
InternationalFaxNumber InternationalFaxNumber 2
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 2
InternationalPhoneNumber InternationalPhoneNumber 2
Partner Partner 2
Personnel Personnel 1
ReferenceBusinessPartner ReferenceBusinessPartner 3
SalesOrder SalesOrder 1
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 2
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 2
Supplier Supplier 1
UnloadingPointName UnloadingPointName 2
VATRegistration VATRegistration 2

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

Learn More