topic Re: Select statement - Please correct in Application Development and Automation Discussions

Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:01:39 GMT

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

Re: Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:05:31 GMT

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

Re: Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:06:37 GMT

This query is working fine for me.

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

Re: Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:15:08 GMT

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>

Re: Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:22:24 GMT

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

Re: Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:23:37 GMT

Which SAP verion are you on?

Regards

Re: Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:24:34 GMT

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.

Re: Select statement - Please correct

Former Member — Thu, 31 Aug 2006 10:34:59 GMT

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