select issue-not geting output

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[kesavadas_thekkillath]

Please check whether the field kukey has any conversion exit .

[Former Member]

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...