06-06-2008 8:26 AM
Hi Experts....
Please try to under stand my problem..
I have to devolop one report, but that is with BW tables...
here i hav to fetch no.of actions for pertoculer employee...that i hav to display for each month...
like...
jan feb mar april may june july
100 123 121 123 432 756 129
these 100, 123 .... are no. of actions... for one perticuler emlpoyee...
in technical view...
no.of actions F1 from T1 table,
employee code F2 from T2 table,
month F3 from T3 table,
all these are BW tables...
There is no links for those tables.. with i received initially..of corse iam not found...
So can i devolop this with logic... or Is it mandatory to find links...
my cuurent stage...
finally i got succeed to find links for T1, T2 and T1, T3... so there is no link for T2 and T3...
and important thing is T1 table which having link with T2 and T3 is not same... but both the tables contains F1 field.... But here i have to fetch data of F1 for F2 wrt F3....
how can i write logic...???
and finally...
Suggest me a good way to solve this problem....
Thanks,
Naveen.I
Edited by: Naveen Inuganti on Jun 6, 2008 12:56 PM
Edited by: Naveen Inuganti on Jun 6, 2008 2:02 PM
Edited by: Naveen Inuganti on Jun 6, 2008 2:16 PM
06-06-2008 9:51 AM
Hi,
The first thing I would suggest you is to find a relation in the form of a primary keys, i.e. a relation where you can uniquely identify one particular row.
Goto SE11. most probably your tables would be like /BIC/T1...
You can wirte it in your routine using a normal select statement. Go for F1 help if you do not know much about the syntax.
Let me know if this satisfies your initial queries.
Thanks,
Arnab
06-06-2008 9:50 AM
If there is no link for T2 and T3. Then you cannot use these tables together. Simple as that.
06-06-2008 9:51 AM
Hi,
The first thing I would suggest you is to find a relation in the form of a primary keys, i.e. a relation where you can uniquely identify one particular row.
Goto SE11. most probably your tables would be like /BIC/T1...
You can wirte it in your routine using a normal select statement. Go for F1 help if you do not know much about the syntax.
Let me know if this satisfies your initial queries.
Thanks,
Arnab