topic Re: regarding fields in Application Development and Automation Discussions

regarding fields

Former Member — Fri, 26 Sep 2008 05:04:57 GMT

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.

Re: regarding fields

naveen_inuganti2 — Fri, 26 Sep 2008 05:08:16 GMT

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

Re: regarding fields

Former Member — Fri, 26 Sep 2008 05:10:15 GMT


> 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

Re: regarding fields

Former Member — Fri, 26 Sep 2008 05:14:02 GMT

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

Re: regarding fields

Former Member — Fri, 26 Sep 2008 05:14:42 GMT

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

Re: regarding fields

Former Member — Fri, 26 Sep 2008 05:39:17 GMT

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