I_CUSTOMERTOBUSINESSPARTNER
Customer to BusinessPartner Relationship
I_CUSTOMERTOBUSINESSPARTNER is a CDS View in S/4HANA. Customer to BusinessPartner Relationship. It contains 3 fields. 21 CDS views read from this table.
CDS Views using this table (21)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_NL_SAFTJournalItemBP | view_entity | inner | CONSUMPTION | Audit File NL Journal Item BP |
| C_NL_SAFTSubLedgerLine | view | left_outer | CONSUMPTION | SAFT NL Sub Ledger Line |
| I_BPCustomerTaxGroupingTP | view | inner | TRANSACTIONAL | BO view for Customer Tax Grouping |
| I_BusinessPartnerCustomerVH | view | from | COMPOSITE | Bussiness Partner VH for Customers |
| I_BusinessPartnerCustSuplrVH | view | union | COMPOSITE | Business Partner VH for Cust and Supp |
| I_CO_BPRelationshipRole | view_entity | inner | COMPOSITE | |
| I_Fr_Strpwhldgtaxitem | view_entity | inner | COMPOSITE | WHT Item For Statutory Reporting France |
| I_MX_BPRelationshipRole | view_entity | inner | COMPOSITE | Provides Business Partners Roles |
| I_NL_SAFTBusinessPartner | view | inner | COMPOSITE | SAF-T NL Business Partner |
| I_NL_SAFTBusinessPartnerCA | view | inner | COMPOSITE | SAFT-T NL Business Partner FICA |
| I_NO_SAFTCustomerMasterData | view_entity | inner | COMPOSITE | Master data of customers for SAFT |
| I_NO_SAFTCustomersInPeriod | view_entity | inner | COMPOSITE | List of all customers in report period |
| I_RblsMgmtBPToCustomer | view_entity | inner | COMPOSITE | Business Partner to Customer Mapping |
| P_BPCreditRiskClass | view | inner | COMPOSITE | |
| P_CollsAcctColl | view_entity | inner | COMPOSITE | Collections Account - FI |
| P_CollsAcctFI | view_entity | inner | COMPOSITE | Collections Account - FI |
| P_CustomerBPDeliveryAddr | view_entity | from | COMPOSITE | |
| P_IN_CustomerTaxNumber | view_entity | inner | COMPOSITE | |
| P_NO_SAFTJournalCustSupMD | view | inner | COMPOSITE | SAF-T Norway Journal Item BP Master Data |
| P_SAFTJournalItemBP | view | inner | COMPOSITE | |
| SHSM_BusinessPartnerCustomer | view | from | Business partner customer search help |
Fields (3)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartnerUUID | BusinessPartnerUUID | 2 |
| KEY | Customer | Customer | 4 |
| _BusinessPartner | _BusinessPartner | 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.
-- Customer to BusinessPartner Relationship
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTOMERTOBUSINESSPARTNER (
BUSINESSPARTNERUUID,
CUSTOMER,
_BUSINESSPARTNER,
PRIMARY KEY (BUSINESSPARTNERUUID, CUSTOMER)
);
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