SAP
S/4HANA Conversion
Business Partner
Check Consistence of link tables
SELECT * FROM cvi_cust_link WHERE NOT EXISTS ( SELECT but000c~partner_guid FROM but000 AS but000c WHERE but000c~PARTNER_GUID = cvi_cust_link~PARTNER_GUID ) SELECT but000~PARTNER_GUID, but000~partner, cvi_cust_link~CRUSER, cvi_cust_link~CRDAT, cvi_cust_link~CRTIM FROM cvi_cust_link LEFT OUTER JOIN but000 ON cvi_cust_link~customer = but000~partner WHERE NOT EXISTS ( SELECT but000c~partner_guid FROM but000 AS but000c WHERE but000c~PARTNER_GUID = cvi_cust_link~PARTNER_GUID ) SELECT COUNT(*) FROM kna1 WHERE NOT EXISTS ( SELECT * FROM cvi_cust_link WHERE CUSTOMER = kna1~kunnr ). SELECT * FROM cvi_vend_link WHERE NOT EXISTS ( SELECT but000c~partner_guid FROM but000 AS but000c WHERE but000c~PARTNER_GUID = cvi_vend_link~PARTNER_GUID ) SELECT but000~PARTNER_GUID, but000~partner, cvi_vend_link~CRUSER, cvi_vend_link~CRDAT, cvi_vend_link~CRTIM FROM cvi_vend_link LEFT OUTER JOIN but000 ON cvi_vend_link~vendor = but000~partner WHERE NOT EXISTS ( SELECT but000c~partner_guid FROM but000 AS but000c WHERE but000c~PARTNER_GUID = cvi_vend_link~PARTNER_GUID ) SELECT COUNT(*) FROM lfa1 WHERE NOT EXISTS ( SELECT * FROM cvi_vend_link WHERE VENDOR = lfa1~lifnr )