Have you ever wondered how the customer master and vendor master tables in SAP are connected to the new business partner tables?
Below, you'll find a short technical explanation of SAP's Customer Vendor Integration (CVI) model. Screenshots were taken from an SAP S/4HANA 1809 system.
Customer Vendor Integration CVI
Table KNA1 (General Data in Customer Master) is linked via table CVI_CUST_LINK (Assignment Between Customer and Business Partner) to table BUT000 (BP: General data I) by using field PARTNER_GUID (Business Partner GUID).
Similarly, table LFA1 (Supplier Master (General Section)) is linked via table CVI_VEND_LINK (Assignment Between Vendor and Business Partner) to table BUT000 (BP: General data I) again by using field PARTNER_GUID (Business Partner GUID).
You could either connect the relevant tables in SAP, for example by using QuickViewer (transaction SQVI) or by creating a view in the ABAP dictionary (transaction SE11) or you could simply install below OSS note.
OSS Note 2798554 - CVI_OTH: Views for tables CVI_CUST_LINK and CVI_VEND_LINK with BP ID
Once you installed note 2798554, two views are created in the system:
- V_CVI_CUST_LINK View for Link between BP and Customer
- V_CVI_VEND_LINK View for Link between BP and Supplier
Now you can display the business partner number (PARTNER) and the corresponding customer master number (KUNNR) or vendor master number (LIFNR), e.g., by using transaction SE16 or SE16N.
How to display a single customer master/business partner or vendor master/business partner
If you only want to display the connection between a single customer or vendor to its business partner or vice versa, you could use transaction MDS_LINKS (Program CVI_MAPPING_BP_CUST_VEND).
Business Partner Entity Relationship Diagram ERD
Please refer to this very helpful and complete business partner entity relationship diagram that contains all customer master, vendor master, business partner and address tables in PDF format for further details.
BP000 is a standard SAP Table which is used to store Business Partner Master (General Data) data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP BP000 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance
via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
SAP BP000 Table fields within data Dictionary
BP000 relationships with other tables
BP000-Business Partner Master (General Data)
BP011-Business Parnter Master (Employment Data)
BP021-Business Partner Master (Fiscal Year Information)
BP030-BP: Business Partner - Address
BP1000-BP: Business Partner - Role
BP1010-BP: Credit Standing Data
BP1020-BP: Business Partner - Fiscal Data
BP1030-BP: Business Partner - Reporting Data
BP1040-Business partner: Reporting data in company code
BP1050-Business Partner: General Control Data
BP1060-Business Partner: CoCd Control Data
BP2000-BP: Business Partner - Business Partner Relation
BP3000-BP: Additional Data (from Darwin BP)
BPDMAHN-BP Structure: Dunning Data (Company Code)
BPDKNA1-BP: Business Partner-Relevant Fields in KNA1
BPDKNB1-BP: Business Partner-Relevant Fields in KNB1
BPDBANK-BP Structure: Business Partner Bank Details
VTBSTC1-Payment Connection Components for Standing Instr.
VTBSTA1-Payment Connection Assignment as Standing Instr.
VTBSTA2-Standing Instructions for Correspondence
VTBSTA3-Standing Instructions for Business Partners
VTBSTA4-Standing Instructions for Business Partners
VIGSMT-Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
JEST-Individual Status per Object
VZGPO-Partner/Role Object Relationship
BP000-Business Partner Master (General Data)
BPDADR-BP Structure: Address
BP030-BP: Business Partner - Address
VIEIGE-Owners of Real Estate Objects
VIOB38-Relationship between Real Estate Objs and SAP-PS
VIOB39-Relationship between Real Estate objs and SAP-PM
VZSORT-Sort Values for Object
SANO1-Address-Object Relationship
SANS1-Address Table
VIOB01-Business Entities
VIOB24-Rental Units per Usage Type (plan)
VIOB27-Relationship between Properties and Buildings
VIOB07-Business Entity Option Rate
VIOB02-Property Master Data
VIOB40_PY-Property Area
VIOB06-Property Option Rate
VIGBUCH-Land
Register
VIGBSTD-Real Estate Register of Land Register
VIGBFLS-Parcels of Land for Property
VIGBZAB-Appreciation/Depreciation in Real Estate Register
VIGBA1-Section 1 of Land Register
VIGBA2-Section 2 of Land Register
VIGB2A-Changes in Section 2 of Land Register
VIGBA3-Section 3 of Land Register
VIGB3A-Changes/Deletions in Section 3 of Land Register
VIOB03-Real Estate Building Master
VIOB40_BD-Areas of Building
VIOB04-Buildings: Fixtures and Fittings Characteristics
VIOB20-Fixtures and Fittings Objects for Building
VIOB05-Building Option Rate
VIOB22-Rooms
VIOB11-Allocation of Rooms to Rental Units
VIOB21-Fixtures and Fittings Objects for Room
VIOB23-Area per Room
VIMI01-Rental Unit - Real Estate
VIMI03-Occupancy Type History for Rental Unit
VIMI08-Apportionment Units per Rental Unit
VIOB40-Rental Unit Area
RMEDAT-Rental Unit Area Data for Reference Area
VIOB10-Number of Rooms per Rental Unit
VIMI38-Cost Centers (RU / LO) Real Estate
VIKOKO-Real Estate Condition Header
VZZKOPO-Condition Items Table
RBEZFLART-Result Structure Reference Area for Condition Type
VIMIMV-Lease-Out
VIBEPP-Transaction Data - Plan Items for Real Estate Mgmt
VIMI54-Real Estate: Time-Dependent Adjustment Data
VIMI55-Index Data for Lease-Out, Time-Dependent
VIMI07-Reported Sales for Sales-Based Lease-Out
VIMI23-Determination of Year and Percent for Sls-Bsd LO
VIMI24-Percentage for Sales for Sales-Based Lease-Out
VIMI25-Sales Reports
VIMI28-Sales Settlement Histories
VIMI16-Rent adjustments buffer
VIMI18-Rent Adjustment History for Lease-Out
VIMI56-LO: Adjustment Block for Condition Types
VIMI26-Notice of rental agreement
VIAK03-Settlement Unit Master Record
VIAK05-Assign Rental Units to Settlement Unit
VIAK23_DB-Participant ID, Validity Period Not Adapted for DB
VIAK23-Service Charge Stt.: Participant ID (No. of Part.)
VIAK24-Service Charge Settl.: Assign RUs to part.RUs
VIAKME-Rental Units for SU (for Logical Database)
VIAK04-Assign Settlement Variant to Settlement Unit
VIAK21-Split Heating Costs into Fixed and Variable Parts
VIAK25-Cost Collector for SU (per Settlement Period)
RFVILSP-Parameters Statement in Lists for Documentation
VIVW01-Management Contract: General Data
VIVW02-Management Contract: Periodic Fee Types
VIVW03_P-Management Contract: Periodic Fee Calc. Form
VIVW06-Management Contract: Event-Driven Fee Types
VIVW03_E-Management Contract: Event-Driven Fee Calc. Form
VIVW05-Management Contract: Managed Objects
VIVW07-Management Contract: Real Estate Obj.Assign.Times
VIVW08-Management Contract: Related Events
VIVW09-Management Contract: Flow Record/Postings