topic Re: SAP Query Report miss fields while executing in Application Development and Automation Discussions

SAP Query Report miss fields while executing

Former Member — Wed, 20 May 2009 13:29:15 GMT

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

Re: SAP Query Report miss fields while executing

Former Member — Wed, 20 May 2009 14:44:19 GMT

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.

Re: SAP Query Report miss fields while executing

Former Member — Wed, 20 May 2009 14:47:04 GMT

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

Re: SAP Query Report miss fields while executing

Former Member — Thu, 21 May 2009 06:08:31 GMT

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.

Re: SAP Query Report miss fields while executing

Former Member — Thu, 21 May 2009 06:14:51 GMT

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.

Re: SAP Query Report miss fields while executing

Former Member — Thu, 21 May 2009 06:40:30 GMT

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