# Customer/Vendor to Business Partner (CVI) Sync Check Report for S/4HANA Conversion

> A custom ALV report that lists, before and after an S/4HANA conversion, customers and vendors not linked to a business partner, linked ones missing an expected BP role, and those whose deletion or block flags are inconsistent with the business partner. Before running the synchronization, the project team sees by account group what needs cleaning and what should be archived.

- Type: Report, Custom development, ALV report
- Module: CA
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/customer-vendor-business-partner-cvi-sync-check-report/


## Why is the standard not enough?

The synchronization cockpit (MDS_LOAD_COCKPIT) shows errors of a synchronization run and the pre-conversion checks give the number of unmatched records; but neither lists all customers and vendors for link, role and block/deletion consistency in one list with account group and a proposed action. BP and XD03 show records one by one. The custom report produces the cleanup work list directly.

### Closest standard alternatives

- BP: Shows a business partner and its roles one at a time; no list of unlinked records or missing roles.
- XD03: Shows customer master data; it does not check business partner links in bulk.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| KNA1 | Customer general data: name, account group, deletion and block flags | Read | - | ECC + S/4 |
| LFA1 | Vendor general data: name, account group, deletion and block flags | Read | - | ECC + S/4 |
| CVI_CUST_LINK | Customer-to-business partner link | Read | CVI_CUST_LINK-CUSTOMER = KNA1-KUNNR | ECC + S/4 |
| CVI_VEND_LINK | Vendor-to-business partner link | Read | CVI_VEND_LINK-VENDOR = LFA1-LIFNR | ECC + S/4 |
| BUT000 | Business partner: number, grouping, central block and archiving flag | Read | BUT000-PARTNER_GUID = CVI_CUST_LINK-PARTNER_GUID OR BUT000-PARTNER_GUID = CVI_VEND_LINK-PARTNER_GUID | ECC + S/4 |
| BUT100 | Business partner roles | Read | BUT100-PARTNER = BUT000-PARTNER | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_KUNNR | Customer | Range / multiple | KNA1-KUNNR | No |
| S_LIFNR | Vendor | Range / multiple | LFA1-LIFNR | No |
| S_KTOKD | Customer account group | Range / multiple | KNA1-KTOKD | No |
| S_KTOKK | Vendor account group | Range / multiple | LFA1-KTOKK | No |
| P_CUST | Check customers | Checkbox | - | No |
| P_VEND | Check vendors | Checkbox | - | No |
| P_DEL | Also show deletion-flagged records | Checkbox | - | No |
| P_ROLE | Check expected BP roles | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Object | Calculated: Customer or Vendor |
| Customer | KNA1-KUNNR |
| Vendor | LFA1-LIFNR |
| Name | Calculated: KNA1-NAME1 or LFA1-NAME1 |
| Account group | Calculated: KNA1-KTOKD or LFA1-KTOKK |
| Business partner | BUT000-PARTNER |
| BP grouping | BUT000-BU_GROUP |
| Existing BP role | BUT100-RLTYP |
| BP central block | BUT000-XBLCK |
| Finding | Calculated: No link / role missing / block-deletion inconsistent / deletion-flagged without link |
| Proposed action | Calculated: Proposal from the settings table by finding |

## How does the report work?

1. The selected customers are read from KNA1 and left-joined with CVI_CUST_LINK; those without a link get the finding "no business partner".
2. The same is done for LFA1 and CVI_VEND_LINK.
3. For linked records, BUT000 is read through PARTNER_GUID; the roles in BUT100 are compared with the roles expected for the account group (settings table; e.g. FLCU00/FLCU01 for customers, FLVN00/FLVN01 for vendors).
4. Consistency: the customer/vendor deletion flag (LOEVM) or central block (SPERR) is compared with the business partner's archiving flag (XDELE) and central block (XBLCK).
5. Deletion-flagged records without a link get the proposal "archive or exclude before conversion"; active ones without a link get "synchronize".
6. The result is given in ALV with subtotals by finding type and account group; double-clicking a record opens XD03/XK03 or BP.

## Authorization objects

- F_KNA1_GEN: Display customer general data
- F_LFA1_GEN: Display vendor general data
- B_BUPA_GRP: Display by business partner grouping

## Frequently asked questions

### Does the report run on ECC, before the conversion?

Yes, that is its main use. The CVI link tables also exist in ECC 6.0; it runs before CVI is activated and synchronization starts, and between synchronization rounds. After the conversion it can still be used on S/4HANA as a check.

### How do you define which roles are expected?

Expected roles are kept per account group in a settings table and aligned with the project's CVI customizing. For example, a customer with company code data needs the FI customer role, and one with sales area data needs the customer role.

### Does the report create missing business partners itself?

No. Business partners should be created with the standard synchronization cockpit; the report shows the state of each record and what needs cleaning first.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ca-customer-vendor-bp-cvi-sync-check
