I_SDDOCUMENTCOMPLETEPARTNERS

CDS View

SD Document Complete Partners

I_SDDOCUMENTCOMPLETEPARTNERS is a CDS View in S/4HANA. SD Document Complete Partners. It contains 14 fields. 37 CDS views read from this table.

CDS Views using this table (37)

ViewTypeJoinVDMDescription
A_InbDeliveryPartner view from BASIC CDS View for Business Partner
A_InbDeliveryPartner_1 view from BASIC CDS View for Business Partner
A_OutbDeliveryPartner view from BASIC CDS view for API exposure
A_OutbDeliveryPartner_1 view from BASIC CDS view for API exposure
A_ReturnsDeliveryPartner view from BASIC Returns Delivery Partner
A_ReturnsDeliveryPartner_1 view from BASIC Returns Delivery Partner
ARun_ValAddedSrvcSDItmBsc view left_outer P_ARunValAddedSrvcSDItmBsc
C_SDDocumentPartnerCard view from CONSUMPTION Business Partner for Fact Sheets
C_SlsDocFlfmtSDDocContacts view from CONSUMPTION Sales Doc Fulfillment: Contacts
C_SlsDocNonStdPartner view from CONSUMPTION SD Document Non Std Complete Partners
FAC_AUDIT_Z3_SDPARTNER view from Sales Document Partner
FAC_AUDIT_Z3_SDPARTNER view union_all Sales Document Partner
I_ARunOvwSDItem view left_outer BASIC Basic View for Sales Document Item
I_CFinSalesDocumentPartner view from COMPOSITE Central Finance Sales Document: Partner
I_DeliveryDocumentAddress view_entity from COMPOSITE Delivery Document Address
I_DeliveryPartnerAddress view from COMPOSITE Delivery Partner Address
I_MyProjectBillingElements view_entity inner COMPOSITE Project Billing Elements by UserID
I_PT_SAFTBillingOneTimeAddr view_entity inner COMPOSITE One Time Customer Addr for Billing Docs
I_PT_SAFTDeliveryPartner view_entity from COMPOSITE SAFT Delivery OneTimeCustomers
I_PT_SAFTOneTimeCustBillg view_entity inner COMPOSITE One Time Customer from Billing Document
I_SAFTBillingOneTimeCustomer view inner COMPOSITE SAF-T Billing OneTimeCustomers
I_SAFTDeliveryOneTimeCustomer view inner COMPOSITE SAF-T Delivery OneTimeCustomers
I_SDDocCompltPartWthAddlData view from COMPOSITE Complete Partners with Additional Data
I_SDDocumentItemPartner view from BASIC SD Document Item Partner
I_SDDocumentPartner view from BASIC SD Document Partner
I_SlsDocNonStdPartner view from COMPOSITE SD Document Non Std Complete Partners
I_SupDmndAllDocRetSlsOrd view left_outer BASIC View for Return Sales Orders
I_SupDmndOvwSD view left_outer COMPOSITE Basic View for Sales Document
P_MyPrelimBillingDocumentItem view_entity inner COMPOSITE My Preliminary Billing Document Item
P_MyProjectBillingElements2 view_entity inner COMPOSITE Project Billing Elements by UserID (2)
P_MyProjectBillingRequests view_entity inner COMPOSITE Project Billing Requests by UserID
P_RU_SDPartnerData1 view from CONSUMPTION SD Partner Data
P_SDDocItemPartnerComplete view from CONSUMPTION SD Document Item Complete Partner
P_SlsDocFlfmtCountryName view from CONSUMPTION Full Name
P_SlsDocFlfmtFullName view from CONSUMPTION Full Name
P_SlsDocFlfmtSDDocContacts1 view from CONSUMPTION P_SlsDocFlfmtSDDocContacts1
P_StRpBillingDocumentItem view left_outer COMPOSITE Billing Document Item with Tax for Statutory Reporting

Fields (14)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,AddressNumber 10
KEY ContactPerson ContactPerson 3
KEY Customer Customer 7
KEY PartnerFunction PartnerFunction 10
KEY Personnel Personnel 3
KEY SDDocument DeliveryDocument,SalesDocument,SDDocument 7
KEY SDDocumentItem SDDocumentItem 4
_Address _Address 2
_DfltAddrRprstn _DfltAddrRprstn 4
_PartnerFunction _PartnerFunction 3
AddressObjectType AddressObjectType 1
AddressPersonID AddressPersonID 7
PartnerIsOneTimeAccount IsOneTimeAccount,PartnerIsOneTimeAccount 5
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 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.

-- SD Document Complete Partners
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SDDOCUMENTCOMPLETEPARTNERS (
    ADDRESSID,
    CONTACTPERSON,
    CUSTOMER,
    PARTNERFUNCTION,
    PERSONNEL,
    SDDOCUMENT,
    SDDOCUMENTITEM,
    _ADDRESS,
    _DFLTADDRRPRSTN,
    _PARTNERFUNCTION,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    PARTNERISONETIMEACCOUNT,
    SDDOCPARTNERADDRESSREFTYPE,
    PRIMARY KEY (ADDRESSID, CONTACTPERSON, CUSTOMER, PARTNERFUNCTION, PERSONNEL, SDDOCUMENT, SDDOCUMENTITEM)
);