SAP

• SCN-WIKI: Cross Platform Performance

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
  )

• SAP CRM Wiki
• How to publish user saved search to all users in a business Role
• CRM One Order Model Redesign in S/4HANA for Customer Management 1.0 – Part 1
• CRM One Order Model Redesign in S4HANA for Customer Management 1.0 – Part 2

• Debugging popup screen