get infotype data in e-mail/sapscript - Dynamic action-

[Former Member]

Hello,

we developed a dynamic action sending a mail if an employee leave the company.

We can catch data in infotype 0000 and 0001 in the sapscript used in the mail, but we would like also fetch data from other infotypes.

We tried to generate an ABAP code from an ad hoc query, but it was impossible to get the return tables in the sapscript.

Are there other solutions to get infotype data in saps scripts?

Kr,

[former_member203501]

Hi ,

you can follow the below solution .

1. Create a custom report for the leaving/terminated employees by using the action in infotype 0000 with field massn, massg.

2. you will get all the employees from table pa0000 who are laving between a date interval .

3. by using the personnel numbers from pa0000 get other infotypes information.

4. create a smartform/script for your requirement.

5. using the program you can send the data to the employees.

another way .

if you know the name of the script you can create some variables for the other fields from other infotypes in that script and you can populate the variable values using perform in program command using a custom program in that script.

[Former Member]

Hello venkat,

thanks for your reply, but unlucky with dynamic actions, we cannot call directly a program; it is just

a sapscript called.