SAP Accounting Consulting

Symptom

There are inconsistent partners that have address references in ADRC, ADCP or ADRV but the corresponding BUT020 entries do not exist.
Other terms

BUT020 ADRC ADRV ADCP REPORT ADDRESS INCONSISTENCY
Reason and Prerequisites

Database Inconsistency
Solution

Create and run the attached Z_BUT020_GENERATE report as a local object in your system through transaction SE38.
There is a parameter testrun in the report.
If this parameter is set, the report runs in test mode. The
complete log is displayed but no changes are made to the database.
This report generates BUT020 entries from address references that exist in table ADRV. In scenarios where there is an inconsistency such that a partner has an address maintained for it in ADRC,ADCP or ADRV but the address is no longer present in BUT020 owing to an inconsistency,this report can be used to generate the BUT020 records for the partner.
The report sets the validity dates of the generated address as the total duration across which a standard address usage exists for the address, in case this information is available from BUT021_FS. Else the validity is set from 01.01.0001 to 31.12.9999. The address move date is set to space.
This report is not recommended for normal use. It is more advisable to delete the inconsistent partners. However, in critical scenarios
where the partner deletion is inadmissible, this report could be used.
*******************************************************************
PLEASE CONSULT DEVELOPMENT SUPPORT BEFORE RUNNING THIS REPORT
*******************************************************************