Adding a Selection screen parameter into ABAP Query Infoset

[Former Member]

Dear all,

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

FROM t001

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.

LEAVE LIST-PROCESSING.

ENDIF.

ENDSELECT.

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.

Kind Regards,

Senthil

Edited by: Senthilraj Selvaraj on Feb 11, 2010 3:48 PM

[Former Member]

as per my understanding:

AUTHORITY-CHECK OBJECT 'F_BKPF_BUK'
ID 'ACTVT' FIELD '02'
ID 'BUKRS' FIELD t001-bukrs.  " Change 

[Former Member]

t001-bukrs is not used in the table joins.....I want to control the data retreived in the table joins of infoset...

Hi gurus,

If you have idea about this please let me know...

Regards,

Senthil

Edited by: Senthilraj Selvaraj on Feb 11, 2010 5:26 PM

[Former Member]

The problem is resolved...

In the selection screen we just need to declare the selection parameter as LFB1-BUKRS in the infoset Format.

Best Regards,

Senthil

[Former Member]

Problem resolved.