Ansicht
Dokumentation

SDMD_XPRA_REPAIR_VBPA_ADRNR - XPRA to repair missing addresses in table VBPA (deprecated)

Purpose

NOTE: this approach to fix DB inconsistencies was deprecated in favor of another approach implemented elsewhere. This report, the created messages (VPD 600, 601, 602) and the created log tables (SDBadPartnerAddr, MBadPurReqAddr, MMBadPurDocAddr) are kept in the system for reference.

This is an XPRA report that repairs missing address entries in the Sales Document Partner table, VBPA-ADRNR. Address handling had an issue that some addresses got deleted, even when still in use. This left dangling references in VBPA to nonexistent addresses in table ADRC: VBPA-ADRNR pointed to a ADRC-ADDRNUMBER that didn't exist.

This only occurred with "custom" addresses in VBPA, and so VBPA-ADRNR is repaired to point back to the customer address, KNA1-ADRNR. All repaired documents are logged in table SDBADPARTNERADDR, and partner addresses from those documents should be double-checked by the customers, since they could have been reset to an older value or could be empty.

The report also fixes similar issues in Purchasing tables EBAN and EKPO (field ADRN2).