topic Re: data not getting displayed thru query in Application Development and Automation Discussions

data not getting displayed thru query

Former Member — Thu, 06 Aug 2009 11:48:11 GMT

Hi,

i have created a query for sd. but after executation no data is displayed.

the data is getting fetched , but no values displayed.

can there be any authorizations for display.What is rtmode in queries ?

Former Member — Thu, 06 Aug 2009 11:51:54 GMT

Hi,

Chk the joins you using in infosets.

Data will get fetched but because of incorrect joins the query is not getting executed.

Can you tell me which tables you are using.

Rgrds,

Nikhil.

Former Member — Thu, 06 Aug 2009 11:59:57 GMT

hi,

i'm using vbak vbap and vbpa tables.

linking the tables with vbeln. i guess der is no issue with the joins.

Thanks

siddhi

Former Member — Thu, 06 Aug 2009 12:23:01 GMT

Hi,

I tried to use the tables which you have used and I getting the output report.

Have you selected all the fields from sq01 from list fields.

chk the data in your tables also.

I will tell you what procedure I have used.

I have made a infoset zsd_test in sq02 selected some fields from all the 3 tables.

Than I have assigned this infoset to a usergroup say suppose zsd.

Than I have generated the infoset.

Go to sq01 and create a query name and select the proper infoset(zsd_infoset) go to basic list and select the fields which you want to display.

Regrds,

Nikhil.

Former Member — Thu, 06 Aug 2009 12:37:01 GMT

Hi,

i have tried d same. m able to see the ouput nw.

Thanks