retrieving data from 2 tables

[Former Member]

Hi,

I have to develop a report in which I have to retrieve data from 2 tables knvv((loevm) and knvp(kunnr,vkorg,parvw,kunn2).Without joining these 2 tables how can I retrieve data from these 2 tables?

Regards,

Hema

[Former Member]

select *

into table itab_KNVV

from KNVV.

select *

into table itab_KNVP

for all entries in itab_KNVV

where XXXXX = itab_KNVV-XXXX

and XXXXX = itab_KNVV-XXXXX.

Loop itab_KNVP.

READ TABLE itab_KNVV with key XXXXX = XXXXX.

itab_KNVP-xxxxx = itab_KNVV-xxxx.

MODIFY itab_KNVP.

ENDLOOP.

[Former Member]

u can use the views to combine data from differen tables..

[Former Member]

Retrieve data form knvv and use for all enteries of knvv to retrieve datta from knvp

[Former Member]

if u dont want to go for join..U can use this code..

select kunnr loevm

into (itab-kunnr, itab-loevm)

from KNVV.

select single kunnr vkorg parvw kunn2

into (itab-kunnr, itab-vkorg, itab-parvw,itab-kunn2)

from KNVP

where KUNNR= itab-KUNNR.

append itab.

clear itab.

endselect.

[Former Member]

Hi

by using FOR ALL ENTRIES YOU CAN GET THE DATA FROM 2 TABLES WITH OUT USEING JOINS

AND THE PERFORMANCE IS ALSO BETTERCOMPARED TO JOINS

FOR ALL ENTRIES CAN BE WROTE LIKE THIS

SELECT DATA FROM TABLE INTO TABLE ITAB WHERE CONDITION

SELECT DATA FROM TABLE2 INTO TABLE ITAB2 FOR ALL ENTRIES WHERE CONDITION ( PRIMARY FILED = ITAB - PRIMARY FIELD)

REWARD IF USEFULL