topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 27 Aug 2007 10:30:47 GMT

How to write select statement for 3 tables mvke vbak vbap using FOR ALL ENTRIES

Thanks & Regards

Kavitha

Re: select statement

Former Member — Mon, 27 Aug 2007 10:33:19 GMT

Hi,

Forall entries is used to compare an internal table with the database table..I will give u a example..

SELECT VBRK_{VBELN VBRK}FKDAT VBRK_{ERDAT VBRK}KUNRG VBRK~KUNAG

VBRK_{NETWR VBRK}VKORG VBRK_{VTWEG VBRP}SPART VBRP_{POSNR VBRP}MATNR

VBRP_{ARKTX VBRP}FKIMG INTO CORRESPONDING FIELDS OF TABLE ITAB FROM VBRK

AS VBRK INNER JOIN VBRP AS VBRP

ON VBRP_{VBELN = VBRK}VBELN

WHERE VBRK~VKORG = VKORG AND

VBRK~VTWEG IN VTWEG AND

VBRK~SPART IN SPART AND

VBRP~MATNR IN MATNR AND

VBRK~FKDAT IN FKDAT AND

VBRK~KUNRG IN KUNNR AND

VBRK~ERDAT IN ERDAT.

ITAB1[] = ITAB[].

SORT ITAB BY VBELN.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING VBELN.

SELECT VTWEG VTEXT FROM TVTWT INTO CORRESPONDING FIELDS OF TABLE DISCH

FOR ALL

ENTRIES IN ITAB WHERE vtweg = ITAB-VTWEG AND SPRAS = 'EN'.

SELECT KUNNR NAME1 FROM KNA1 INTO CORRESPONDING FIELDS OF TABLE CUST FOR

ALL ENTRIES IN ITAB WHERE KUNNR = ITAB-KUNRG.

reward if useful

Re: select statement

Former Member — Mon, 27 Aug 2007 10:39:39 GMT

Hi,

My Question is this

Get the material pricing group (field MVKE-KONDM) from the material master of the current material (MVKE where MVKE-VKORG = VBAK-VKORG and MVKE-VTWEG = VBAK-VTWEG and MVKE-MATNR = VBAP-MATNR).

Thanks & Regards

Kavitha

Re: select statement

Former Member — Mon, 27 Aug 2007 10:40:36 GMT

good

You have to write with respect to VBAK,

If not l_t_vbak[] is initial.

Select vbeln posnr .... from vbap in to l_t_vbap

for all entries in l_t_vbak

where vbeln = l_t_vbak-vbeln.

endif.

thanks

mrutyun^

Re: select statement

Former Member — Mon, 27 Aug 2007 10:43:35 GMT

Hi,

Where is mvke table.

Thanks & regards

Kavitha

Re: select statement

Former Member — Mon, 27 Aug 2007 10:50:18 GMT

Hi ,

3 tables r there vbak,vbap,mvke please help me out.I will give good points to you.

Re: select statement

Former Member — Mon, 27 Aug 2007 11:19:10 GMT

Hi kavitha,

As per ur explaination, i have written the select query.

Hope this will help u.

select x_{kondm y} z~ into corresponding fields of table itab from mvke as x inner join vbak as y on x_{vkorg = y}vkorg and x_{vtweg = y}vtweg inner join vbap as z on x_{matnr = z}matnr.

Regards...

Arun.

Re: select statement

Former Member — Mon, 27 Aug 2007 11:50:36 GMT

Hi Kavitha,

try it.

"sorry, corrections"

Select HONDM

from MVKE

into table TI_TABLE

for all entries in MVKE(use a "TI_MVKE")

where

VKORG = VBAK-VKORG and

VTWEG = VBAK-VTWEG and

MATNR = VBAP-MATNR.

Regards

Allan Cristian

Message was edited by:

Allan Cristian