Select statement - Please correct

[Former Member]

DATA : wa_awkey LIKE bkpf-awkey.

SELECT awkey FROM bkpf

UP TO 1 ROWS

INTO wa_awkey

WHERE bukrs = gt_regup-bukrs

AND belnr = gt_regup-belnr

AND gjahr = gt_regup-gjahr.

ENDSELECT.

What wsa wrong in this.

the error is "the data object 'wa_awkey' has no structure and therefore no component called 'awkey' ".

[Former Member]

data: wa_awkey like bkpf-awkey.

SELECT singe awkey FROM bkpf

INTO wa_awkey

WHERE bukrs = gt_regup-bukrs

AND belnr = gt_regup-belnr

AND gjahr = gt_regup-gjahr.

- Raj

[Former Member]

This query is working fine for me.

can you post ur code completely just to see whats going wrong?

[Former Member]

Hello Sam,

this program compiled and runs fine:

<b>TABLES: bkpf.

DATA : wa_awkey LIKE bkpf-awkey.

PARAMETERS: p_bukrs LIKE bkpf-bukrs,

p_belnr LIKE bkpf-belnr,

p_gjahr LIKE bkpf-gjahr.

START-OF-SELECTION.

SELECT awkey FROM bkpf

UP TO 1 ROWS

INTO wa_awkey

WHERE bukrs = p_bukrs

AND belnr = p_belnr

AND gjahr = p_gjahr.

ENDSELECT.

WRITE:/ wa_awkey.</b>

[Former Member]

Hi Sam,

which release do you have.

I have tried your code and have no problems.

But normaly select ... endselect gives more than

one record, therefore try it with an internal table.

otherwise you can use select single ...

Regards, Dieter

[Former Member]

Which SAP verion are you on?

Regards

[Former Member]

Check the below code:

DATA : wa_awkey LIKE bkpf-awkey.

SELECT SINGLE awkey FROM bkpf

INTO wa_awkey

WHERE bukrs = gt_regup-bukrs

AND belnr = gt_regup-belnr

AND gjahr = gt_regup-gjahr.

Regards,

Prakash.

[Former Member]

Hi sam

May be u have include the line Tables BKPF, in the starting. May be that is the problem. Otherwise it is running very fine.

Regards

Haritha