cancel
Showing results for 
Search instead for 
Did you mean: 

Relationship between tables

Former Member
0 Kudos

HI all;

I need to get the following fields into my ODS.

1. cost center

2. activity type

3. version

5. Fiscal year

6. Posting Period

7. Activity Qty1

8. Activity Qty2

.

.

9 Activity Qty12.

I see these fields are stored in the following table

1. CSKS

2. COSL

3. CSLA

when I created a view there is no relationship exits between these tables. Please guide me through how to create the relationship if I have to include another table which is the appropriate one for my scenario.

thank you.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

you also need to take into account the table cssl. This is the link between cost centers and activity types, so between csks and csla. Now have a look into the content of table cosl. I guess the objnr contains costcenter and activity type concatenated together with some other information, --> KL<co_area><cost_center><activity_type>.

regards

Siggi

Former Member
0 Kudos

HI,

use the standard one. wht ever paolo given.

it's better. u could see all the data required for u.

Nagesh.

Former Member
0 Kudos

Have a look at standard datasource 0CO_OM_CCA_3; i think that is what you need.

Hope it helps.

Regards