internal table

[Former Member]

Hi all,

i have three tables (suppose lfa1,kna1,vbak).i want to get all the data in to an internal table based on lifnr(select-option).can any body provide sample piece of code for this.

Thanks in advance

[Former Member]

Sorry Venkat,

There is no field as LIFNR in VBAK table so slight alteration in the query is:

SELECT <required fields> from LAF1 AS a

INNER JOIN KNA1 AS b ON a_{lifnr = b}lifnr

INNER JOIN VBAK AS c ON b_{kunnr = c}kunnr

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE a~lifnr IN s_lifnr.

P.S. Reward for the useful answers.

Susanth

[Former Member]

You know how to write the join conditions then you can do it.

like

SELECT DISTINCT a_{vbeln a}matnr b_{exdat b}rdoc b~kunwe FROM vbrp AS a

INNER JOIN j_1iexchdr AS b

ON a_{vbeln = b}rdoc

INTO CORRESPONDING FIELDS OF TABLE i_exchdr

WHERE b~exdat IN s_exdat

AND TRNTYP = 'DLFC'

AND pstyv NE 'L2N'.

hope it will help you

[Former Member]

hi Venkat,

do this way ..

 select a~lifnr 
      INTO CORRESPONDING FIELDS OF TABLE itab          
          from lfa1 as a
             INNER JOIN kna1 AS b
             on<common fields>
             INNER JOIN vbak AS c
             on<common fields>
    where a~lifnr in s_lifnr.

But it is not advisable to use joins when you are mainitaining a huge data so use for all entries statement instead of joins

Regards,

Santosh

[Former Member]

Try this:

SELECT <required fields> from LAF1 AS a

INNER JOIN KNA1 AS b ON a_{lifnr = b}lifnr

INNER JOIN VBAK AS c ON a_{lifnr = c}lifnr

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE a~lifnr IN s_lifnr.

P.S. Reward for the useful answers.

Susanth

[Former Member]

Sorry Venkat,

There is no field as LIFNR in VBAK table so slight alteration in the query is:

SELECT <required fields> from LAF1 AS a

INNER JOIN KNA1 AS b ON a_{lifnr = b}lifnr

INNER JOIN VBAK AS c ON b_{kunnr = c}kunnr

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE a~lifnr IN s_lifnr.

P.S. Reward for the useful answers.

Susanth

[Former Member]

SELECT A_{LIFNR B}KUNNR C_{VBELN INTO CORRESPONDING FIELDS OF TABLE ITAB FROM LFA1 AS A INNER JOIN KNA1 AS B ON A}LIFNR = B_{LIFNR INNER JOIN VBAK AS C ON B}KUNNR = C_{KUNNR WHERE A}LIFNRIN S_LIFNR.

S_LIFNR IS SELECT-OPTION...

REGARDS

SHIBA DUTTA