Skip to Content
0
Former Member
Jan 04, 2008 at 11:46 AM

Select Query

49 Views

hi all,

I have the data declared as per below:

DATA : BEGIN OF wa_dfkk.

INCLUDE STRUCTURE dfkkcrh.

DATA: datum LIKE dfkkcrp-datum,

bonit LIKE dfkkcrp-bonit,

END OF wa_dfkk.

and have the below query

SELECT SINGLE b~gpart

b~kjahr

b~bon01

b~bon02

b~bon03

b~bon04

b~bon05

b~bon06

b~bon07

b~bon08

b~bon09

b~bon10

b~bon11

b~bon12

b~bonma

b~bonvh

b~bmadt

b~lfdnr

b~bonfr

b~bfrdt

b~brldt

b~bnext

b~bexdt

b~bcmtf

a~datum

a~bonit

FROM dfkkcrp AS a

INNER JOIN dfkkcrh AS b

ON agpart = bgpart

AND akjahr = bkjahr

INTO CORRESPONDING FIELDS OF wa_dfkk

WHERE a~gpart EQ p_gpart

AND a~kjahr EQ p_kjahr

AND a~lfdnr EQ p_lfdnr.

the execution leads to dump for mismatch target fields.whereas the fields are in the same order in the declaration as well.

What can be the reason?Appreciate your inputs.

Regards,

Stock