topic Report writer Authorization on selection screen in Application Development and Automation Discussions

Report writer Authorization on selection screen

Former Member — Thu, 29 Oct 2009 06:52:21 GMT

Hi All,

In transaction GR55 (to execute the report group), when the user enters the selection criteria for the report group, I want to validate the

'Profit Center group' and 'Profit center values' fields. The way it should be validated is, it should check the entry for the 'profit center group' or 'values' entered against the 'user name' in a Ztable for that user. If there is no entry in the Ztable matching that 'User name' and 'profit center group or values' , it should give an error message. I have seen that there is a user exit 'EXIT_SAPFGRWX_001' (Authorization check on initial screen).

But my problem is, in this functional module (code is shown below), the table 'I_T_SELSCREEN_PARAMS' has only one filed for both 'Profit center Group' and 'profit center values'.

1. when I enter 'Profit center group' 'ABC' in my selection criteria, I_T_SELSCREEN_PARAMS has following values.

I_T_SELSCREEN_PARAMS - selname = '%8A-PCHI'.

I_T_SELSCREEN_PARAMS-low = '01061000ABC'.

2. When I enter 'Profit Center Values' as some '3001000' to '3001020' inn the selection criteria, I_T_SELSCREEN_PARAMS has following fields,

I_T_SELSCREEN_PARAMS-selname = '%8A-PCHI'

I_T_SELSCREEN_PARAMS-low = '0002$ZSLP&8A-PCHI'.

here ZSLP is the report group name.

I don't understand how to get the values '3001000' to '30001020' into my user-exit in case 2.

Is there any other way of doing this? has anyone used this user-exit? Please help me.

Thanks,

Krishna

FUNCTION EXIT_SAPFGRWX_001.

Re: Report writer Authorization on selection screen

Former Member — Thu, 29 Oct 2009 12:39:33 GMT

Hi Krishnakumar Ramadoss,

For your requirement to have authorization, SAP provides facility in report writer/painter to give authorization groups.

Go to GR52.

Input your report group name.

Click on Header (Cap symbol) or F5.

At this header screen , you can see a field where you can provide Authorization group.

Try this. It may help you.

As a note:

Report writer / Report painter reports are reports which are created with zero percent coding.

The SAP generated program (E.g: GP3ICYT39FHJLOYBA2025DBAE1V213) cannot be changed or modified.

The only coding that you can do in a report writer are the formula's and logic that you can write in variables of the report writer / painter.

Regards,

Subin John

Re: Report writer Authorization on selection screen

Former Member — Thu, 29 Oct 2009 16:21:15 GMT

Hi Subin,

Thanks for your reply.

I think you have understood my question wrong.

SAP has provided some user exits exclusively for report writer to check authorizations on selection screen .

My question is on how to use the exit for my case-2 that I have mentioned in the earlier post...

Thanks,

Krishna