Accessing a ABAP Database table from IDM
In customer project I ran into such HR process for joining that we couldn’t use SAP’s Standard HCM extract interface.
Instead we needed to access some Z tables where information came from workflow of Prehire.
Question raised How I am able to access Z table on ABAP server?
Thanks to Chris Snyder for a tip where I can find an example for that. 😎
Answer: look example from IDM default jobs – ABAP Read Help Values job reads information from ABAP tables.
You can find it by running Job wizard
And Choose Job / SAP Netweaver / ABAP Read Help Values
Job contains plenty of fromABAP passes which contain the actual answer how to import table from ABAP.
Below you see that this pass read information from Table called TSAD3 and reads fields TITLE, PERSON and ***. Fields are separated with | (pipe)
On destination tab you can choose which temporary table you like save information and how to map fields.
And how you can make value out of this one?
Re-use idea someone already have invented 🙂
- Create new Job folder for new job
- Create empty job and name it as you like – attach to ABAP repository
- Copy a Pass above to empty job you created
- Rename it as you like
- Modify copied pass settings to it to fit your needs.
- Destination table name
- Destination mappings
- Consume data for your needs in following passes.
Remember to add authorizations to User which is used to connect ABAP repository to have authorization to read the Table you need.