Tom's notes

Table of Contents

Inhaltsverzeichnis

  • S/4HANA Conversion
    • Business Partner
  • Grantor for SAP CRM
  • Development
    • Debugging

Sidebar

  • About me
Tom's notes
Sie befinden sich hier: Home » SAP
Edit this page

SAP

  • SCN-WIKI: Cross Platform Performance

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
  )

Grantor for SAP CRM

  • 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

Development

Debugging

  • Debugging popup screen
Previous Next