I_SALESDOCITEMCOMPLETEPARTNER

CDS View
34 Fields 13 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 34 fields. 13 CDS views read from this table.

CDS Views using this table (13)

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_ProjBillgElmntPartnerCount view_entity from TRANSACTIONAL partner count for proj billing elelemt
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_SlsOrdWthoutChrgItmPartnerTP view_entity from TRANSACTIONAL Sls Ord Without Charge Item Partner - TP
R_SlsSchedgAgrmtItemPartnerTP view_entity from TRANSACTIONAL Partner for Sls Sched Agr Item - TP

Fields (34)

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

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,
    _WORKFORCEPERSONMAPPINGS,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    BPADDRDETERMINATIONTRANSACTION,
    BPREFADDRESSIDFORDOCSPCFCADDR,
    CONTACTPERSON,
    CORRESPONDENCELANGUAGE,
    CUSTOMER,
    EMAILADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    PARTNER,
    PARTNERISONETIMEACCOUNT,
    PARTNERISSPECIFICFORSDDOCITEM,
    PERSONNEL,
    REFERENCEBUSINESSPARTNER,
    SDDOCPARTNERADDRESSREFTYPE,
    SDDOCPARTNERADDRISDOCSPECIFIC,
    SUPPLIER,
    UNLOADINGPOINTNAME,
    VATREGISTRATION,
    PRIMARY KEY (SALESDOCUMENT, SALESDOCUMENTITEM)
);

Learn More