I_SALESDOCITEMCOMPLETEPARTNER

CDS View
31 Fields 11 CDS Views

Sales Doc Item and Inherited Partners

I_SALESDOCITEMCOMPLETEPARTNER is a CDS View in S/4HANA. Sales Doc Item and Inherited Partners. It contains 31 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_ProjBillgElmntPartnerDetails view_entity from CONSUMPTION Project Billing Element Partner Details
C_SlsDocItmNonStdPartner view from CONSUMPTION Sls Doc Item Non Std Complete Partners
I_SlsDocItmNonStdPartner view from COMPOSITE Sls Doc Item Non Std Complete Partners
P_SlsDocItemNonStdPartnerCount view from CONSUMPTION Count of non Std Partners in Sls Doc Item
R_CreditMemoReqItemPartnerTP view_entity from TRANSACTIONAL Credit Memo Request Item Partner - TP
R_CustomerReturnItemPartnerTP view_entity from TRANSACTIONAL Returns Order Item Partner - TP
R_DebitMemoReqItemPartnerTP view_entity from TRANSACTIONAL Debit Memo Request Item Partner - TP
R_SalesContractItemPartnerTP view_entity from TRANSACTIONAL Sales Contract Item Partner - TP
R_SalesOrderItemPartnerTP view_entity from TRANSACTIONAL Partner for Sales Order Item - TP
R_SalesQuotationItemPartnerTP view_entity from TRANSACTIONAL Sales Quotation Item Partner - TP
R_SlsSchedgAgrmtItemPartnerTP view_entity from TRANSACTIONAL Partner for Sls Sched Agr Item - TP

Fields (31)

KeyField CDS FieldsUsed in Views
KEY SalesDocument SalesDocument 2
KEY SalesDocumentItem SalesDocumentItem 2
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr 7
_BusinessPartnerAddress _BusinessPartnerAddress 7
_ContactPerson _ContactPerson 6
_DfltAddrRprstn _DfltAddrRprstn 9
_PartnerFunction _PartnerFunction 2
_SalesDocument _SalesDocument 2
_SalesDocumentItem _SalesDocumentItem 2
AddressID AddressID 9
AddressObjectType AddressObjectType 7
AddressPersonID AddressPersonID 9
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 7
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 7
ContactPerson ContactPerson 9
CorrespondenceLanguage CorrespondenceLanguage 5
Customer Customer 9
EmailAddress EmailAddress 5
FormOfAddress FormOfAddress 5
FullName BusinessPartnerFullName,FullName 8
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 5
InternationalPhoneNumber InternationalPhoneNumber 5
Partner BusinessPartner,Partner 8
PartnerIsSpecificForSDDocItem PartnerIsSpecificForSDDocItem 7
Personnel Personnel 9
ReferenceBusinessPartner ReferenceBusinessPartner 7
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 7
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 5
Supplier Supplier 9
UnloadingPointName UnloadingPointName 5
VATRegistration VATRegistration 5

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 Doc Item and Inherited Partners
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCITEMCOMPLETEPARTNER (
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    _BPREFADDRESSFORDOCSPCFCADDR,
    _BUSINESSPARTNERADDRESS,
    _CONTACTPERSON,
    _DFLTADDRRPRSTN,
    _PARTNERFUNCTION,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    BPADDRDETERMINATIONTRANSACTION,
    BPREFADDRESSIDFORDOCSPCFCADDR,
    CONTACTPERSON,
    CORRESPONDENCELANGUAGE,
    CUSTOMER,
    EMAILADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    PARTNER,
    PARTNERISSPECIFICFORSDDOCITEM,
    PERSONNEL,
    REFERENCEBUSINESSPARTNER,
    SDDOCPARTNERADDRESSREFTYPE,
    SDDOCPARTNERADDRISDOCSPECIFIC,
    SUPPLIER,
    UNLOADINGPOINTNAME,
    VATREGISTRATION,
    PRIMARY KEY (SALESDOCUMENT, SALESDOCUMENTITEM)
);

Learn More