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.