CVI_CUST_LINK
Assignment Between Customer and Business Partner
CVI_CUST_LINK is an SAP database table in S/4HANA. Assignment Between Customer and Business Partner. It contains 6 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SCMTMS/VE_BPCMN | view_entity | left_outer | BOPF: Business Partner Common TM Data | |
| FNDEI_CVI_CUST_LINK_BLOCKINGIN | view | from | Filter View for table CVI_CUST_LINK | |
| FNDEI_CVI_CUST_LINK_FILTER | view | from | Filter View for table CVI_CUST_LINK | |
| I_BusinessPartnerCustomer | view | inner | BASIC | Business Partner Customer |
| I_BusinessPartnerCustomerDEX | view_entity | inner | BASIC | Data Extraction for BP Customer |
| I_Customer_to_BusinessPartner | view | from | BASIC | Customer to BusinessPartner Relationship |
| I_CustomerToBusinessPartner | view | from | BASIC | Customer to BusinessPartner Relationship |
| I_CustSuplrDataControllerusge | view_entity | inner | BASIC | Customer and Supplier Datacntrlr Usge |
| p_datacontrollersdmstatus | view_entity | inner | BASIC | Utility view for MDBPCV_DC SDM status |
| P_MDChgProcCustClAssgmtWthNmbr | view | inner | BASIC | Master Data Change Process Customer Class Assignment with BP |
| P_MDChgProcCustValnWthBusPart | view | inner | BASIC | Master Data Change Process Customer Valuation with BP Number |
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.
-- Assignment Between Customer and Business Partner
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CVI_CUST_LINK (
CLIENT, -- Client [mandt]
PARTNER_GUID, -- BP GUID [bu_partner_guid]
CUSTOMER, -- Customer [kunnr]
CRUSER, -- Created by [bu_crusr]
CRDAT, -- Created On [bu_crdat]
CRTIM, -- Created at [bu_crtim]
PRIMARY KEY (CLIENT, PARTNER_GUID)
);
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