Enhance Function Module EXIT_SAPLRRS0_001

[Former Member]

I have a requirement where I need to get Workbook ID to populate a customer exit variable. The standard import parameters deliverd for EXIT_SAPLRRS0_001 do not provide this information and I would like to enhance this function module by adding workbook ID fields.

Is this recommended? and can it be done?

Your inputs would really be helpful

Thank you

[Former Member]

Hi Varun and Gopi,

Thank you for your inputs. Based on this,I know that I_S_RKB1D has something called GENUNIID that gives me the query ID. But I still need to figure out the workbook ID and the worksheet # to get the unique combination of the worksheet.

I searched for relevant function modules and found that RRMX_QUERY_WHERE_USED_GET gives me the workbook ID based on Query ID. But it is possible that 1 query ID is found in more than 1 worksheet. So I need to know the Workbook ID and also Worksheet # to make it unique.

In other words, I need a function module that can give me WORKBOOKID and SUBNR (ref. table RSRWORKBOOK) based on GENUNIID.

Any clues about this?

Thank you

[Former Member]

Hi Arun,

I am aware of the procedure to create customer exit variables and write code for them. But my requirement for a customer exit variable is slightly different.

I have to fill up a customer exit variable based on the workbook it is being used in. For that I need WorkBook ID in the input parameters of the Function Module EXIT_SAPLRRS0_001 so that during run time I can compare the workbook ID in which the query is running to entries in a custom table (The custom table has workbook IDs and version values...the customer exit variable is of type version). If an entry is found, then the version from the custom table is filled up in the customer exit variable dynamically.

[former_member184494]

Deepthi,

then the issue is to find out the workbook ID being used currently .. and you could use that within the user exit to find the version from the custom table.. why do you want to modify the main function for that.

Assuming that you are able to find the current workbook ( you could look into something that is maintaines for the user sessions or maybe there is a standard BW function for the same...

Use that to have a simple select statement in the user exit code... and you would not have to modify the function.. moresoever , you are not calling the function module directly , alll that you do is to add your code to the include and the user exit will anyway get called for when the query is executed.

Arun

[former_member184494]

Deepthi,

What you are looking for is a customer exit to fill a variable .. for that

go to CMOD -> create an enhancement project -> assign enhamcement component rsr00001 to the same and then you will see the function module in the source tab. There you will find an include by the name of ZXSRU01 and you will need to write your user exit code within that include. you cannot modify the function module directly.

Hope this helps..

Arun

Assign points if useful

[Former Member]

Deepthi,

I found some useful links for the Workbook id

Regs

Gopi

Assign points if it helps ...