data not getting displayed thru query

[Former Member]

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]

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]

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]

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]

Hi,

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

Thanks