ABAP Query Report

[Former Member]

Hi all,

Am running a querry report (SQ01) for generating a stock list for all materials in a Plant. I have combined the MARD, MSEG & MKPF tables. My input would be the Plant and Storage loc name. And the Output would contain the material no and the stock details (unrestricted, blocked and quality inspection stocks)..

The issue is my Material No (even though i have selected the MATNR field) is not getting diplayed when i get the output instead it shows the material description. similar is the case for Storage location.

Expecting yours help at the earliest !

Thanks in advance !!

[Former Member]

Hi,

In Query when you select a field MATNR of MARA table or LGORT

You can display both the Number and TEXT of that field

You might have selected only the TEXT for display

double click on that field and

select both the number and Text

Reward points if useful

Regards

Anji

[Former Member]

hey thanks,

i actually did that before but i didnt refresh it !

[Former Member]

Hi,

Go to "Basic List" and check whether u r selecting the MATNR for display (its on Right side of the screen where u can select MATNR for Display).

Regards,

Ranjit Thakur.

<b>Please Mark The Helpful Answer.</b>