SAP Query Report miss fields while executing

[Former Member]

Dear Experts,

I have created User group and assign users to it , then i craete Infoset with Join tables (EKPO - EKKO - EKBE) then i created aquery with SQ01

But when i tried to execute the report it does not display any numbers just text .. for example the field "EKKO-EBELN" is the PO number but when I execute the query it does not display the number it display the a Text like vendor name or some thing

Please Advice

[Former Member]

Hi,

It seems, there exists no data for the selected criteria. manually check it in tables.

You can check in debugging, what could be the exact problem.

Regards,

Santhosh.

[Former Member]

No there is data but instead of displaying the Plant number it displays the plant text

[Former Member]

Hi,

may be the fields taken in the incorrect way or mapping problem.

So check in the internal table before displaying, in debugging mode.

Regards,

Santhosh.

[Former Member]

Hi,

May be the field taken for plant number in the incorrect. Try to select plant number as well as its text from sq01 tcode for the select output options.

Regards,

Nikhil.

[Former Member]

Please map the fields properly. Try to maintain order of fields same as in tables while creating infoset.