This is related to ABAP Query. User group, Infoset and ABAP Query are already desinged and developed. The problem is related to the addition of authority check for the selection screen parameters in the Query.
I have added my own selection screen parameter as s_bukrs into the infoset created in SQ02. I want to do the authority check for this s_bukrs. I have added the code into the at selection-screen section.
AT SELECTION-SCREEN ON s_bukrs.
Select from the check table based on the selection
SELECT bukrs INTO t001-bukrs
WHERE bukrs IN s_bukrs.
AUTHORITY-CHECK OBJECT 'F_BKPF_BUK'
ID 'ACTVT' FIELD '02'
ID 'BUKRS' FIELD s_bukrs.
IF sy-subrc NE 0.
MESSAGE i100(zhemfi) WITH t001-bukrs.
This authorisation check is working fine in the system. But This selection screen parameter s_bukrs is not controlling the data from the joined tables. for eg : the tables joined in the infoset are LFA1 LFB1. LFB1 has got the bukrs field. this s_bukrs should control the data coming out of this LFB1. Please help how to add this s_bukrs into the Query without changing the generated ABAP code or how to use this LFB1-Bukrs field for authority check section. There is a Section "Standard Selection" in the selections of infoset. But it is disabled.
Thank you very much.
Edited by: Senthilraj Selvaraj on Feb 11, 2010 3:48 PM