I_SDDOCUMENTCOMPLETEPARTNERS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA