topic Re: select into table in Application Development and Automation Discussions

select into table

Former Member — Thu, 12 Apr 2007 06:13:40 GMT

Hi every one.,

let me anybody know,

1. in table zx1 i am having fields VBELN , POSNR, VTWEG, SPART

( ex 900001 11 de 50 , 900001 ,12 ,de 50)

2. in table zx2 i am having fields KNUMA VTWEG SPART

( 122 de 50 , 234 de 50, 345 de 50).

But i want to pass into final table with six records.

i.e

VBELN POSNR KNUMA

900001 11 122

900001 11 234

900001 11 345

900001 12 122

900001 12 234

900001 12 345

But iam not able to fetch the data , please anybody let me know

how to select the data .

Re: select into table

Former Member — Thu, 12 Apr 2007 06:19:17 GMT

hi,

use inner join on two tables.

select zx1_{vbeln zx1}posnr zx2~knuma

from zx1 as zx1

inner join zx2 as zx2

on zx1_{vtweg eq zx2}vtweg

and zx1_{spart eq zx2}spart

into table itab.

reward points if helpful

Re: select into table

Former Member — Thu, 12 Apr 2007 06:22:00 GMT

Hi..

select zx1_{VBELN zx1}POSNR zx2~KNUMA

from zx1 inner join zx2

on zx1_{SPART = zx2}SPART and

zx1_{vtweg = zx2}vtweg

into itab

up to 6 rows

where zx1~posnr eq '000011' or

zx1~posnr eq '000012'.

Re: select into table

Former Member — Thu, 12 Apr 2007 06:23:29 GMT

select vbeln posnr vtweg spart from zx1 into table itab1 where....

if not itab1[] is initial.

itab2[] = itab1[].

sort itab2 by vtweg spart.

delete adjacent duplicates from itab2 comparing vtweg spart.

select knuma

vtweg spart from zx2 into table itab3

for all entries in itab2

where vtweg = itab2-vtweg

and spart = itab2-spart.

endif.

sort itab3 by vtweg spart.

loop at itab1.

move-corresponding itab1 to itabfinal.

read table itab3 with key vtweg = itab1-vtweg spart = itab1-spart.

if sy-subrc = 0.

move itab3-knuma to itabfinal-knuma.

endif.

append itabfinal.

clear itabfinal.

endloop.

now the itabfinal contains the required data.

Re: select into table

Former Member — Thu, 12 Apr 2007 06:23:39 GMT

For this application, the tables zx1 and zx2 should have atleast one field in common (apert from MANDT).

Once the above requirement is fuilfilled, you can use JOIN to get the data.

If you wish to select data into two tables and build final internal table (without join), then both the internal tables should have the common field defined. After the selection:

LOOP AT itab1.

LOOP or READ itab2 with the condition

APPEND Final Table

endloop.

Re: select into table

Former Member — Thu, 12 Apr 2007 06:24:08 GMT

Hi..,

u can use Inner join for this..

SELECT VBELN POSNR KNUMA

INTO TABLE ITAB

FROM ZX1 AS ZX1 INNER JOIN ZX2 AS ZX2

ON ZX1_{VTWEG EQ ZX2}VTWEG AND

ZX1_{SPART EQ ZX2}SPART.

regards,

sai ramesh

Re: select into table

Former Member — Thu, 12 Apr 2007 06:27:19 GMT

Hi,

I hope you are talking about the Billing Tables VBRK and VBRP:

Based on the data it is clear because the fields

VBELN , POSNR, VTWEG, SPART are in VBRP .

and the fields KNUMA VTWEG SPART are in VBRK .

You can join the header and Item tables VBRK and VBRP

select a_{vbeln b}posnr a_{vtweg a}spart a~knuma into table ITAB

from VBRK as a join VBRP as b on

a_{vbeln = b}vbeln

where a~vbeln in S_vbeln (or = p_vbeln).this is the right method. use it.

reward points if useful

regards,

ANJI

Re: select into table

former_member784222 — Thu, 12 Apr 2007 06:27:47 GMT

Hi,

I think you code should look like this:

loop at zX1.

loop at zx2 where vtweg = zx1-vtweg and

spart = zx1-spart.

final-vbeln = zx1-vbeln.

final-posnr = zx1-posnr.

final-knuma = zx2-knuma.

append final.

endloop.

Thanks and regards,

S. Chandra Mouli.