Routine to fill fields

[Former Member]

Hi

I have one dso DSO3 which gets data from two dsos DSO1 and DSO2.

DSO3 has characteristic infoobjects CH1,CH2,CH3,CH4 and keyfigures KF1,KF2,KF3,KF4 where characteristics CH1,CH2,CH3,CH4 and keyfigures KF1,KF2 are mapped to DSO1.CH1 ,CH2 characteristics,KF3,KF4 keyfigures are mapped to DSO2.

Now I have few questions about this scenario:

1.Lets say my user wants to see a report on CH1,CH2,CH3,CH4,KF3,KF4 on DSO3--since CH3,CH4 are not mapped from DSO2 to DSO3,I am thinking of writing a routine which copies these characteristics CH3,CH4 from DSO1 when the keys match...how and where can I write this routine?I heard that people write a routine using global variables...any ideas about how to do it...

Thanks...

[sachinjakkaria]

Hi,

You need to update data from DSO2 data by doing look up while Data is moved from DSO1 to DSO3.

For doing Look-up you have 2 options.

1. Start routine and Infoobject routine. - Select all data from DS02 with help of data from DSO1 in start routine and assigned/updated KF3 and KF4(assuming that CH1 and CH2 are common between DSO1 and 2) in infoobject routine.

2. Infoobject Routine - Fetch the Data from DSO2 with help CH1 and CH2 for KF3 and KF4 directly

Hope it helps...

Regards,

Sachin.

[Former Member]

Hello guys

I think I didnot explain my question in detail.

My user wants to run a report on DSO3 and the fields he want to see in report are CH1,CH2,CH3,CH4,KF3,KF4.

Here only CH1,CH2,KF3,KF4 are being updated from DSO2.So when we see report result,I guess CH3,CH4 will be shown empty or zero.Inorder to show these characteristics also in report,I am thinking of copying them by using a look up on DSO1.Logic will be written in transformation between DSO2->DSO3 which says that when CH1,CH2 are same as in DSO1,Then copy CH3,CH4 values from DSO1 to dataflow between DSO2-->DSO3....will this work?If yes,how and where can I write this logic..?

Thanks...

[sachinjakkaria]

Hi,

U need write abap routines(Start Routine and Infoobject Routine). You need to take help of abper.

Logic is sumthing like dis:

Select all records from DSO2 using the CH1 CH2 from data of DSO1 in start routine.

Assign relevant value using "Read" Statement.

Regards,

Sachin.

[ravi_chandra3]

Hi ,

U can write the code at the return table .With the help of the return table u can get the values from any target.

"I am thinking of writing a routine which copies these characteristics CH3,CH4 from DSO1"

In the data target u have all the characteristic still why u are trying to write the code to extract the data of ch3 and ch4.

Thanx & Regards,

RaviChandra