topic Re: Help on Query. in Application Development and Automation Discussions

Help on Query.

former_member224405 — Thu, 29 Apr 2010 17:35:13 GMT

hi,

I am fetching teh required data from the below queries i am able to execute the first query

after which it is going into dump saying conversion not possible.

Can any one help.

Types:BEGIN OF i_reversal,

uniquekey like bsak-belnr,

lifnr like bsak-lifnr,

inv_doc_no LIKE bsak-xblnr,

doc_date LIKE bsak-bldat,

END OF i_reversal.

Types:BEGIN OF i_reversal2,

uniquekey like bsak-belnr,

lifnr like bsak-lifnr,

inv_doc_no LIKE bsak-xblnr,

doc_date LIKE bsak-bldat,

doc_time LIKE bkpf-cputm,

reversenum like bkpf-stblg,

END OF i_reversal2.

Data: i_reversal2 TYPE STANDARD TABLE OF i_reversal WITH HEADER LINE,

i_reversal3 TYPE STANDARD TABLE OF i_reversal2 WITH HEADER LINE.

SELECT belnr lifnr xblnr bldat from bsak

into table i_reversal2

where bldat in date_rng.

if sy-subrc is initial.

Select belnr cputm from bkpf

into table i_reversal3

for all entries in i_reversal2

where belnr = i_reversal2-uniquekey

and stblg <> ''.

endif.

Thanks,

Re: Help on Query.

former_member189420 — Thu, 29 Apr 2010 17:44:35 GMT

Please share the table structure of i_reversal3.Usually this error occurs b'coz of mismatch in the selected fields with that of the fileds defined in the table.

P.S: Suggest you to check for i_reversal2 initial before using it in for all entries.

Best regards,

Anand Patil

Re: Help on Query.

Former Member — Thu, 29 Apr 2010 17:46:47 GMT

This is extremely basic.

Just look at the fields you are selecting and the structure you are putting them into.

Rob

Re: Help on Query.

former_member224405 — Thu, 29 Apr 2010 17:49:14 GMT

Yes i got it right!!!

thanks.