Enhancing DSO with new infoobject

[dinesh_balakrishnan]

Hi friends,

  I have 2 DSOs  ZSD_IO10 and ZSD_IO24.  I need to add ZIRDATE  from ZSD_IO10  into ZSD_IO24 and Populate it all the way upto Infocube. I dont hav common keyfields. But infoobject ZSRNUM (Serial number) exist in both the DSO under Data fields.

I appreciate your responses

Thanks

B.Dinesh

[Former Member]

Hi Dinesh,

This is what you can do....

Add that date ZIRDATE field in ZSD_IO24, but its not necessary that you need to populate it from  ZSD_IO10. But instead populate it through a lookup in a start/end routine i.e. in the start/end routine of transformation (ZSD_IO10 -> ZSD_IO24) you write a lookup based on whatever appropriate keys u feel & pick it up from where ever it exists. There's no hard rule that the date value should come from ZSD_IO10 transformation, right? This way you need not worry abt the keys of  ZSD_IO10 & ZSD_IO24 also either.

Rgds,

Priya.

[Former Member]

Dinesh,

You will need a common key field between both the DSOs to write a start routinein in a TRFN of DSO and Cube to accomplish a read to compare both DSOs and populate data in that field.

Hope u got it.

~Pp

[Former Member]

Hello,

I have two DSO's.

First DSO has fields:

Company Code,

Material Number(Keyfield).

Second DSO has fields:

Material Number(KeyField)

Material Group

Material Name

First DSO need to be populated with the fileds Material Group and Material Name(of second DSO) by creating a look up on Material Number of Second DSO.

The problem that I am facing is my first DSO is not getting populated with the data..

I have created the Start Routine and End routine and then further executed the DTP, but in no vain.

Can anyone please suggest me the step by step process in loading the data to first DSO

[Former Member]

Dinesh,can you be more specific !

[Former Member]

do u want the data to be loaded in the cube to be common on both dso or one dso that macthes both?

what i mean is if you got 

ZSRNUM  = 1 in ZSD_io10

ZSRNUM =   1 in ZSD_IO24  then load data in cube

if they dont match then dont load data in the cube..?

or you want even if they dont match then load the data?

which scenario?

[dinesh_balakrishnan]

Syed,

I wanna load data only from   ZSD_IO24(dso)------>ZSD_DC03( Infocube).

But i want to add field ZIRDATE to ZSD_IO24 and to populate that field from ZSD_IO10.

if we hav common key field in both dso we can populate it but i dont hav keyfield in common.

thanks

bdinesh

[Former Member]

Hi Dinesh,

Logically You will not able to lookup based on data fields, because that is not unique value across the data. Is there any way like you can maintain mapping of ZIRDATE and ZSRNUM in another DSO or master data and then while loading in ZSD_DC03 have a lookup there.

Regards,

Ganesh

[Former Member]

i dont think thats possible for you to add field in a DSO as you cannot look it up, you will have to find something to look it up to add that fields data in .. see if there any comman field you could find, look at both of its data..or you might have to find another table that have them in common.