09-26-2008 6:04 AM
Hi friends,
I have to fetch the data from d below tables.
vbkd, vbak, kna1, addr1_data, knvv, lips, j_1lmocust,
v_t683s, v51ve
So i require to do mapping among all those tables to get d data.
in VBKD<VBAK,LIPS i will do mapping between the tables based on VBELN
and in KNA1, KNVV i will do mapping based on KUNNR.
But how to link all those tables based on 1 perticular field.
Plz give me clear idea.
Correct answers will be appriciated.
Thanks.
09-26-2008 6:08 AM
Hi...
For reporting,
Customer number kunnr Or sales area ( Sales organization, Distribution Channel, And Division ) is the link between these tables.
KUNNR in the vabk is the sold to party, So consider the partner function of sold to party in KNVV table.
Thanks,
Naveen.I
09-26-2008 6:08 AM
Hi...
For reporting,
Customer number kunnr Or sales area ( Sales organization, Distribution Channel, And Division ) is the link between these tables.
KUNNR in the vabk is the sold to party, So consider the partner function of sold to party in KNVV table.
Thanks,
Naveen.I
09-26-2008 6:10 AM
>
> Hi friends,
>
> I have to fetch the data from d below tables.
> vbkd, vbak, kna1, addr1_data, knvv, lips, j_1lmocust,
> v_t683s, v51ve
>
> So i require to do mapping among all those tables to get d data.
>
> in VBKD<VBAK,LIPS i will do mapping between the tables based on VBELN
> and in KNA1, KNVV i will do mapping based on KUNNR.
>
> But how to link all those tables based on 1 perticular field.
>
> Plz give me clear idea.
>
> Correct answers will be appriciated.
>
> Thanks.
Hi,
first write the select statement using vbkd,vbak,lips
then use kunnr which is available in vbak. You canuse this to link with kna1,knvv
09-26-2008 6:14 AM
Hi
from kna1 you can find kunnr and from there you can link vbak table as in vbak table also kunnr is there.
otherwise you can find kunnr from vbak and you can proceed to kna1.Actually it depends upon requirement.
tanks
venkat
09-26-2008 6:14 AM
Hi
Before going to develop reports , u and ur concern functional must be through about functional flow of report .
this help u to consider correct data and relation b/w tables.
Regards
Sachin
09-26-2008 6:39 AM
Hi,
in all the tables you will find one or other fields which will be commonin all tables.If not all tables,suppose between T1 and T2 if you have common field f1 and b/n t2 and t3 you may have common filed f2.
Then select data from t1 based on slection parameters.
Then you will have data in t1-f1 field .So collect data from t2 based on t1-f1.now t2-f2 will have data.
so select data from t3 based on t2-f2.
Here you need to declare all internal tables related to those tables and one final table containing fields from all other tables.
after getting the data into individual table populate final table.
Please let me know if you need further clarification