How to capture IBP User Email ID ?

[prasad_mandre]

Hello Experts,

I would like to fetch Email ID associated with each user in the table. This email id will be used as unique key in our further process. I would like to know if there is standard table and fields from where I can fetch email id?

I tried below communication scenario to fetch email id but no luck -

SAP_COM_0143 Generic Data Extractor for Master Data and Key Figure Data Integration Extracting and Importing Key Figure and Master Data

Thanks in advance.

[prabhu_muthiah · Accepted solution]

Hi,

If you want to make it fully automated easy way, try the below steps:

1. Scenario ID: SAP_COM_0093 - Identity Management Integration setup in IBP.

2. Use UNIX command curl to get the XML file.

3. Use xmlstarlet to parse the xml file into csv file (required fields).

4. Use the lookup based on user id, fill the required field.

step 2 to 3 can be shell script which can be called in CPI task pre-loading .

Hope this helps.

-Prabhu.

[prasad_mandre · Accepted solution]

Thanks for your inputs Prabhu. I will try this to use in our CPI task preloading.

[lingaiahvanam]

Hi,

You can download the list of business users in to CSV file from Maintain Business User Fiori App.

User download file contains status, user name, email address, first name, and last name for each user.

Best Regards,

Lingaiah

[prasad_mandre]

Thanks for your inputs Lingaiah.

We have already tried this option. We would like to automate whole process in CPI so this wont be of much help.

Thanks.