Have you ever wondered how the customer master and vendor master tables in SAP are connected to the new business partner tables? Show
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 CVITable 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 IDOnce you installed note 2798554, two views are created in the system:
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 partnerIf 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 ERDPlease 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 SAP BP000 Table fields within data DictionaryBP000 relationships with other tables What is business partner master data in SAP?Business partner master data from Financial Accounting and Logistics is stored in shared master records that can be accessed from both views. This function lets you create and change master records for business partners centrally, that is, including the following data: Customer master records and vendor master records.
What is the table for business partner in SAP?SAP Business Partner Tables. What is the business partner master data table in S 4hana?It is the single point of entry to create, edit, and display the master data for business partners, customers and vendors. A Business Partner consists of general data like name, address, bank information, etc. as well as role specific information i.e. customer/vendor/employee data.
What is BUT000 table in SAP?BUT000 is a standard Use AP-MD-BP* Components Transparent Table in SAP Basis application, which stores BP: General data I data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for BUT000.
|