How do you see all objects using objects within a package.

[#1]

We are upgrading to S4 HANA, one of the packages we use has hundreds of objects within it, and this package is being removed by SAP during the upgrade. We need to identify all our custom objects that use objects within this package. We can go into SE80 and bring up the package, then one by one we can do a where used list on each of the objects in the package. This will be incredibly time consuming however and we could easily miss a piece of our code due to user error in checking. Ideally we want a piece of code that will drill down on all objects in the package, do the where used, identify all Z* named objects that are using the package objects. It would need to go down multiple levels of objects. Alternatively we need to know the tables in the SAP database that hold the where-used relationships, so we can write SQL to do the interigation.

We have already tried looking in the following tables but had no luck

_sys_repo.Active_Object

_sys_repo.Active_Objectcrossref

sys.OBJECT_DEPENDENCIES

We can identify all the objects in the package using Table TADIR, but do not knw what tables to link this off to to find the objects that are dependent on the objects in the package.

I've searched the internet for an answer to this question but had no luck. I found one other asking the same question some while back, but no answer was provided that solved this issue.

[stephenl1]

Hi Joachim, and thanks. We managed to do the task manually using reports from the readiness checks as you suggesed. The package was FKKBI. Thanks for taking time to provide some detailed advice, and hopefully will help others in future.

[joachimrees1]

Another thought just occurred to me: Shouldn’t S/4HANA readiness checks help in this very situation?

[joachimrees1]

Hi Stephen,

I can't give you the answer you ask for, but maybe some other ideas to still help you:

( 1. This might not be possible, sorry, I have limited basis knowhow;

couldn’t you just go through the upgrade (maybe on a sandbox-system (copy)), an then afterwards identify all the Z*-Objects you're looking for by them now having an syntax error?! (run SGEN on Z* or something?)

2. If you have a "vanilla" (e.g. without Z*-coding) version of your target S/4HANA-System available (e.g. via S/4HANA 1809 FAA: https://blogs.sap.com/2018/12/12/sap-s4hana-fully-activated-appliance-create-your-sap-s4hana-1809-sy... ), you could do a remote syntax check on it:

-> it would take your Z-Coding in your legacy-system, and perform syntax-checks on the objects as if they were in the target (S4HANA) system.

-> Should give you exactly the list you are looking for!

Blog on it:

https://blogs.sap.com/2014/11/28/remote-syntax-check-for-abap-developers/

best

Joachim

PS: just out of curiosity: which package is it that SAP removes?