topic Re: Read in Application Development and Automation Discussions

Read

Former Member — Mon, 08 Jan 2007 16:21:16 GMT

Say i am retrieving data from VBAK

select * from vbak

retrieving data from vbap

select * from vbap

retreiving from likp

select * from likp

retrieving from lips

select * from lips

retrieving from kna1

select * from kna1...

i want to pass all data to final internal table..

which table we loop first ....why is that so..

How read works on these tables??

Thanks in advance

Re: Read

Former Member — Mon, 08 Jan 2007 16:24:18 GMT

Why don't you JOIN them? It would be better -:)

Greetings,

Blag.

Re: Read

Former Member — Mon, 08 Jan 2007 16:26:12 GMT

Use Join as these tables ahve key fields...

regards,

barath.

Re: Read

Former Member — Mon, 08 Jan 2007 16:31:19 GMT

Hi RK,

better join VBAK & VBAP,

LIKP & LIPS.

SELECT * FROM VBAK & VBAP

SELECT * FROM LIKP & LIPS

SELECT KNA1.

This will be easy for you to read the data

Thanks

Vikranth khimavath

Re: Read

Former Member — Mon, 08 Jan 2007 16:32:25 GMT

Re: Read

Former Member — Mon, 08 Jan 2007 16:36:56 GMT

Hi,

better join VBAK & VBAP,

LIKP & LIPS.

SELECT * FROM VBAK & VBAP

SELECT * FROM LIKP & LIPS

SELECT KNA1.

This will be easy for you to read the data

<b>LOOP at IT_VBAK_VBAP.

READ TABLE IT_LIKP_LIPS WITH KEY VBELN = IT_LIKP_LIPS-VBELN.

IF SY-SUBRC = 0.

ENDIF.

READ TABLE IT_KNA1 WITH KEY KUNNR = IT_VBAK_VBAP-KUNNR.

IF SY-SUBRC = 0.

ENDIF.

ENDLOOP.</b>

Thanks

Vikrtanth Khimavath