Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to write select statement

HI,

I am adding an additional tab in Plant maintenance Notification, which is called as Y-Y Analysis,

actually what it does is in notification when we enter an activity for that particular activity it will analyzes the activity

in deep. My problem is its working for only single activity when i select second in activities and click yy analysis its not showing the selected instead of that its showing previous(1st activity) activity.

my code where the values are

select single kurztext from qpct into text_i_4

where katalogart = 'A'

and codegruppe = e_viqmma-mngrp

and code = e_viqmma-mncod

and sprache = sy-langu.

if text_i_4 is initial.

text_i_4 = e_viqmma-matxt.

endif.

if ( cust_aktyp = 'V' or cust_aktyp = 'A' ) and text_i_4 is initial.

"Notifn Change/Display

select single * from qmma into viqmma

where qmnum = viqmel-QMNUM and kzloesch = ''.

&----


  • loop at t_tc.

select single kurztext from qpct into text_i_4

where katalogart = 'A'

and codegruppe = viqmma-mngrp

and code = viqmma-mncod

and sprache = sy-langu.

from here this select statements its collecting the the values of activity tab,

my requirement is it must show what ever i select in activity tab it should display in yy analysis Tab

Thanks in Advance

Rajesh

Tags:
Not what you were looking for? View more on this topic or Ask a question