topic ABAP Query Report in Application Development and Automation Discussions

ABAP Query Report

Former Member — Thu, 17 May 2007 07:34:21 GMT

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 !!

Re: ABAP Query Report

Former Member — Thu, 17 May 2007 07:38:18 GMT

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

Re: ABAP Query Report

Former Member — Thu, 17 May 2007 07:42:58 GMT

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>

Re: ABAP Query Report

Former Member — Thu, 17 May 2007 08:52:05 GMT

hey thanks,

i actually did that before but i didnt refresh it !