topic Re: retrieving data into internal table in Application Development and Automation Discussions

retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:16:05 GMT

Hi,

I am struck at a point where i have to retrieve data from 4 database table to a single internal table with some conditions. can anyone please help me in resolving this issue. your help will be highly appreciated.

some details are: tables used are-linv,mch1,makt,ausp.

data: begin of t_outtab,--

final internal table.---output to be displayed

lgnum LIKE linv-lgnum,

ivnum LIKE linv-ivnum,

werks LIKE linv-werks,

lgtyp LIKE linv-lgtyp,

matnr LIKE linv-matnr,

bestq LIKE linv-bestq,

charg LIKE linv-charg,

maktx LIKE makt-maktx,

vfdat LIKE mch1-vfdat,

atwrt LIKE ausp-atwrt,

END OF t_outtab.

input parameters:-- linv-lgnum and linv-ivnum.

conditions:1. Where MAKT-MATNR = LINV-MATNR and MAKT-SPRAS = ‘logon language user’

2. Where MCH1-CHARG = LINV-CHARG AND MCH1-MATNR = LINV-MATNR)

3. SELECT AUSP-ATWRT Where AUSP-OBJEK = MCH1- CUOBJ_BM and MCH1-CHARG = LINV-CHARG AND MCH1-MATNR = LINV-MATNR

Regards

Victor

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:20:33 GMT

Hi,

Try using Join statement..but do take care of performance in that case.

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:23:17 GMT

Hi,

What is your problem..

The way you wrote the issues seems not much useful for replying your question..

Be more clear ..

One thing I can say is..

First you have to collect data into four different internal tables and the depending on the key you can finally put them into one internal table..You can use For all entries when retrieving data ..

Using inner join may effect the performance..

reward points if useful

Regards

nazeer

null

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:23:53 GMT

Use Inner join statement if only one select query has to be written.

But try to split into two itab & then use them, otherwise it will affect performance

Thanks

Sandeep

Reward if helpful

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:27:25 GMT

hi,

i have to use all the conditions to retrive the data in the outtab table using lgnum and ivnum as parameters given by the user.

can u please help me in resolving this issue.

regards

Victor

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:29:10 GMT

Hi,

thankyou a lot in trying to resolve my issue. can u please write the code for retrieving data in outtab using all the conditions.

thanks & regards

Victor

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:30:03 GMT

Hi,

select linv~lgnum

linv~ivnum

linv~werks

linv~lgtyp

linv~matnr

linv~bestq

linv~charg

makt~maktx

mch1~vfdat

ausp~atwrt

from linv as linv inner join makt as makt

inner join mch1 as mch1 inner join ausp as ausp

into table t_outtab

where MAKT_{MATNR = LINV}MATNR

and MAKT-SPRAS eq sy-uname

and MCH1_{CHARG = LINV}CHARG

AND MCH1_{MATNR = LINV}MATNR

and AUSP_{OBJEK = MCH1}CUOBJ_BM and MCH1_{CHARG = LINV}CHARG AND MCH1_{MATNR = LINV}MATNR.

regards,

kiran kumar k

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:31:44 GMT

Hi Victor,

data: begin of t_outtab,--

final internal table.---output to be displayed

lgnum LIKE linv-lgnum,

ivnum LIKE linv-ivnum,

werks LIKE linv-werks,

lgtyp LIKE linv-lgtyp,

matnr LIKE linv-matnr,

bestq LIKE linv-bestq,

charg LIKE linv-charg,

maktx LIKE makt-maktx,

vfdat LIKE mch1-vfdat,

atwrt LIKE ausp-atwrt,

END OF t_outtab.

SELECT

linv~lgnum,

linv~ivnum,

linv~werks,

linv~lgtyp,

linv~matnr,

linv~bestq,

linv~charg,

makt~maktx,

mch1~vfdat,

ausp~atwrt,

FROM ( ( ( LINV JOIN MAKT ) ON

MAKT_{MATNR = LINV}MATNR

INNER JOIN MCH1 ) ON

MCH1_{CHARG = LINV}CHARG AND

MCH1_{MATNR = LINV}MATNR

INNER JOIN AUSP ) ON

AUSP_{OBJEK = MCH1} CUOBJ_BM

MCH1_{CHARG = LINV}CHARG

MCH1_{MATNR = LINV}MATNR

where MAKT-SPRAS = ‘logon language user’.

Re: retrieving data into internal table

Former Member — Mon, 16 Apr 2007 10:35:31 GMT

select <data fields> into it_linv from LINV where LGNUM = linv-lgnum and IVNUM = linv-ivnum.

select <data fields> into it_mch1 from mch1 as a inner join makt as b on a_{MATNR = b}MATNR for all entries of it_linv where a_{matnr = it_linv-matnr and a}charg = it_linv-charg and b~langu = sy-langu.

select <data fields> into it_ausp from ausp for all entries of it_mch1 where AUSP-OBJEK = it_mch1- CUOBJ_BM.

now loop it_linv and use read statement for it_mch1, it_ausp and move data to final table..

Reward and close duplicate threads.