topic Re: Adding a Selection screen parameter into ABAP Query Infoset in Application Development and Automation Discussions

Adding a Selection screen parameter into ABAP Query Infoset

Former Member — Thu, 11 Feb 2010 14:44:25 GMT

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

Re: Adding a Selection screen parameter into ABAP Query Infoset

Former Member — Thu, 11 Feb 2010 14:50:11 GMT

as per my understanding:


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

Re: Adding a Selection screen parameter into ABAP Query Infoset

Former Member — Thu, 11 Feb 2010 15:06:50 GMT

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

Re: Adding a Selection screen parameter into ABAP Query Infoset

Former Member — Thu, 11 Feb 2010 17:01:00 GMT

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

Re: Adding a Selection screen parameter into ABAP Query Infoset

Former Member — Thu, 11 Feb 2010 17:01:26 GMT

Problem resolved.