Read Data from an ADSO in another ADSO

[former_member434654]

Hi All,

I want to read data from one ADSO into Another ADSO but when trying it in transformation

1)option "Read data from DSO (Advanced)".

2) Mapping source key Fields correctly but when assigning infoobject it is not happening.

Not throwing any error just the infoobject assigned gets erased.

Moreover when without assigning infoobject I go ahead it throws err at transformation activation saying "The field "LR_UNIVERSE" is unknown, but there is a field with the similar name "LR_UNIVERSE_ADS". ..."

SAP -BW version is 7.4. SP13.

Thanks

[shasan]

Hey Anu,

Do you mind sharing the screen shots of the error you are getting in both the cases - when you are assigning the key field and when you are not.

[former_member594385]

Hi Anu,

If my assumption is correct,

Scenario 1: you want to load data from one ADSO to another ADSO.

You can create a transformation as mentioned above if the field names are same then it will automatically create mapping to the target.

otherwise please map it manually and make sure to map it correctly.

Scenario 2: you want to use ADSO1 in as a look up in the transformation of another ADSO.

In this scenario, use routines to pull and map the fields to target in start and end routines respectively.

If you are getting any error w.r.t field names, please check the structure of RESULT_PACKAGE in End routine, START_ROUTINE in Start routine.

Please check and let me know if you need any more help.

Thanks,

Jay.