adding fields from dynamic selections

[Former Member]

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 · Accepted solution]

Hello,

In ME2N, you can use dynamic selections on PO header and line item fields. Since material type is not in PO header/line item tables, you cannot use dynamic selections on this field. You may create a query (SQVI/SQ01) based on join of EKKO, EKPO & MARA.

Thanks,

Venu

[Former Member · Accepted solution]

Hi Venu,

Thanks for the informatiom. can you please give me a step by step procedure of query creation

Thanks

Anusha

[former_member192897 · Accepted solution]

Go to ME2N and Click on Dynamic Selections and Select Purchase Document item Folder and Select Material type and input other Values and Execute.

For Query you can follow Mr.charlie.

[Former Member · Accepted solution]

when i go to the dynamic selections. whatever field i choose from the two folders that appear there, they do not come properly with list of appearing fields over there . the chosen field appears to the extreme top right hand corner of screeen. and when i exit the transaction and come back in again, i have to slect it again. how can we make it to automatically appear with the list of fields that appear right now in ME3n. for ex, selection parameters, document type, account assignment category, pur grp etc

[Former Member · Accepted solution]

Hi,

If you comfortable with the dynamic selection display then save it as variant.

Goto->Variant->Save

Give variant name and short text.

Save....

Once you have done this your screen variant will be saved for dynamic selection.

So when you enter the transaction next time a variant icon will be displayed in the application toolbar. Click on that and then click on the dynamic selection icon.

This will display the material type field in the dynamic selection form only (as displayed earlier).

By doing this you will be able to do away only with a few steps.

Now to permanently add material type field to your list you should contact your ABAPer or maybe ask for a user exit.

Regards,

Prithviraj

[Former Member]

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

http://help.sap.com/saphelp_47x200/helpdata/en/e2/74c1ec206711d6b1d500508b6b8b11/frameset.htm