Solved: adding fields from dynamic selections

Hi SAP Gurus,

In ME2N we do not have material type field, how can i add it there from dynamic selections so that i can execute for a specific material type as well

Thanks

Anusha

Former Member · ‎2009 Jan 26

Go to SQ03 and create your user group

than go to SQ02 and create your info set means the join table which you want use for your query

then assign that info set to your user group in SQ03

now you can go to SQ01 and create the query

The whole process comprises of three steps.

Creation of user group

Creation of infoset

Creation of queries

The transaction codes associated with ABAP Query are

􀀹SQ01 - ABAP Query

􀀹SQ02 - Infoset

􀀹SQ03 - User group

Infoset creation:

Tables need to be joined under infoset creation.

The linkage between three tables LIKP, VTTK and VTTP is below

LIKP- VBELN = VTTP- VBELN

VTTK- TKNUM= VTTP- TKNUM

Selection screen:

For better performance, along with weight few more parameter should be added in the selection screen

Outputs:

For Weight - VTTK-ALLOWED_TWGT

For Delivery - VTTP-VBELN

For SP -LIKP-KUNAG

for more info please go through link below