How to write the quires using into corresponding fields?

[Former Member]

Hi,

How can i write the below quires using into corresponding fields statement.

DATA :ws_d_budat TYPE bkpf-budat,

ws_c_artnr TYPE ce10001-artnr,

1) SELECT SINGLE budat

INTO ws_d_budat

FROM bkpf

WHERE awtyp = 'VBRK'

AND awkey = wa_vbeln-vbeln.

2)SELECT vbeln posnr matnr

FROM vbrp

INTO TABLE i_matnr

FOR ALL ENTRIES IN i_vbeln

WHERE vbeln = i_vbeln-vbeln

AND matnr = ws_c_artnr

AND posnr NE ' '.

3) SELECT bukrs belnr gjahr budat awkey

INTO TABLE i_budat

FROM bkpf

FOR ALL ENTRIES IN i_awkey

WHERE awtyp = 'VBRK'

AND awkey = i_awkey-awkey.

Sudhakar

[Former Member]

Hi,

How can i write the below quires using into corresponding fields statement.

DATA :ws_d_budat TYPE bkpf-budat,

ws_c_artnr TYPE ce10001-artnr,

1) SELECT SINGLE budat

INTO ws_d_budat

FROM bkpf

WHERE awtyp = 'VBRK'

AND awkey = wa_vbeln-vbeln.

2)SELECT vbeln posnr matnr

FROM vbrp

INTO TABLE i_matnr

FOR ALL ENTRIES IN i_vbeln

WHERE vbeln = i_vbeln-vbeln

AND matnr = ws_c_artnr

AND posnr NE ' '.

3) SELECT bukrs belnr gjahr budat awkey

INTO TABLE i_budat

FROM bkpf

FOR ALL ENTRIES IN i_awkey

WHERE awtyp = 'VBRK'

AND awkey = i_awkey-awkey.

Sudhakar

[Former Member]

use into corresponding fields of table itab.

reward points to all helpful answers

kiran.M

[Former Member]

Hi,

SELECT vbeln posnr matnr

FROM vbrp

INTO <b>CORRESPONDING FIELDS OF</b> TABLE i_matnr

FOR ALL ENTRIES IN i_vbeln

WHERE vbeln = i_vbeln-vbeln

AND matnr = ws_c_artnr

AND posnr NE ' '.

SELECT bukrs belnr gjahr budat awkey

INTO <b>CORRESPONDING FIELDS OF</b> TABLE i_budat

FROM bkpf

FOR ALL ENTRIES IN i_awkey

WHERE awtyp = 'VBRK'

AND awkey = i_awkey-awkey.

[Former Member]

1) SELECT SINGLE budat

INTO ws_d_budat

FROM bkpf

WHERE awtyp = 'VBRK'

AND awkey = wa_vbeln-vbeln. -

---

> <b>Not possible</b>

2)SELECT vbeln posnr matnr

FROM vbrp

INTO corresponding fields of TABLE i_matnr

FOR ALL ENTRIES IN i_vbeln

WHERE vbeln = i_vbeln-vbeln

AND matnr = ws_c_artnr

AND posnr NE ' '.

3) SELECT bukrs belnr gjahr budat awkey

INTO corresponding fields of TABLE i_budat

FROM bkpf

FOR ALL ENTRIES IN i_awkey

WHERE awtyp = 'VBRK'

AND awkey = i_awkey-awkey.

Reward points if helpful.

Regards.

Srikanta Gope

[Former Member]

Why not possiable to select single?

Thanks & regards,

sudhakar

[Former Member]

its a work area not a table

reward points to all helpful answers

kiran.M

[Former Member]

Hi,

Just use it this way:

select single budat

from bkpf

into corresponding fields of table itab

where cond.

Thanks,

Sandeep.

[Former Member]

hi

REWARD IF USEFULL

1) SELECT SINGLE budat

INTO <b>CORRESPONDING FIELDS OF TAB</b>LE ws_d_budat

FROM bkpf

WHERE awtyp = 'VBRK'

AND awkey = wa_vbeln-vbeln.

2)SELECT vbeln posnr matnr

FROM vbrp

INTO <b>CORRESPONDING FIELDS OF TABLE</b> i_matnr

FOR ALL ENTRIES IN i_vbeln

WHERE vbeln = i_vbeln-vbeln

AND matnr = ws_c_artnr

AND posnr NE ' '.

3) SELECT bukrs belnr gjahr budat awkey

INTO <b>CORRESPONDING FIELDS OF TABLE</b> i_budat

FROM bkpf

FOR ALL ENTRIES IN i_awkey

WHERE awtyp = 'VBRK'

AND awkey = i_awkey-awkey.

[Former Member]

Is there any alternative for select single statement using into corresponding fileds?

-sudhakar

[Former Member]

Thanks for all replies.

sudhakar