S/4HANA Conversion – Business Partner

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
  )