topic Re: select issue-not geting output in Application Development and Automation Discussions

select issue-not geting output

Former Member — Wed, 14 Jul 2010 06:17:57 GMT

WHAT COULD BE the problem with this query.m not getting output in it_report.

SELECT belnr

budat

valut

kwbtr

vgint

vgext

esnum

vb2ok

kukey

FROM febep INTO corresponding fields of table it_report

FOR ALL ENTRIES IN it_febko

WHERE kukey = it_febko-kukey

AND vb1ok IN s_vb1ok

AND vb2ok IN s_vb2ok

AND grpnr IN s_grpnr

AND belnr IN s_belnr

AND budat IN s_budat

AND kwbtr IN s_kwbtr

AND vgint IN s_vgint

AND vgdef IN s_vgdef

AND nbbln IN s_nbbln.

Re: select issue-not geting output

Former Member — Wed, 14 Jul 2010 06:23:14 GMT

Hi,

Please check for the entries in se16 for the given key combination. You better debug it for faster resolution. Also check the compatibility of internal table with selected fields.

Regards,

Kiran.

Re: select issue-not geting output

kesavadas_thekkillath — Wed, 14 Jul 2010 07:55:43 GMT

Please check whether the field kukey has any conversion exit .

Re: select issue-not geting output

Former Member — Wed, 14 Jul 2010 08:31:41 GMT

Hi,

First check the internal table it_report, whether structure has the same name as the field in the Database table,

Then check for the orders of the fields(you are using the corresponding fields, so there should not be any issue).Anyhow check this.

Check the kukey,whether it is having the 0000 prefix added in the database table fields....

Then try commenting where condition one by one and execute the Select query to find exactly which filed is causing the issue...