Data visible in PSA but not in DSO

[Former Member]

Hi All,

I've enhance a LO extractor with a KF and the values for this KF is visible in PSA but when I run the DTP to load to DSO the values of this KF is dipalyed as 0.

Note in PSA there are 4 records and they should be summed up and displayed.

I've set the rule to summation.(tried with overwrite also but didnt work)

Please suggest.

Thanks

Madhavi

[Former Member]

Hi Latha,

Can you please check the transformation. Is there any routine at transformation level?

If not check mapping this might be mapping issue.

Thanks

[Former Member]

There's no routine written and its a direct one to one for amount.

I've mapped amount to tranformation added it in infosource and mapped the same in transformation.

when I try to debug data is visible in the first level transformation but in the second level it is picking 0.

any suggestions pls help.

[Former Member]

Hi

Ok you are saying that its a dirrect mapping for all the fields.

Make sure you have mapped all the key fields at transformation level.

Can you pls provide the screenshot of  the Ttransformation.

Thanks

[former_member182470]

Have you observed "Display Generated Program" in Transformation and "Generate Program for error Handling" in DTP-->Extras..?

Regards,

Suman

[Former Member]

Hi Akash,

Yes I've mapped all the key fields in the ODS.

Pls find the screen shot.

I've also checked generated program and program for error handling but it looks messy for me(non abaper).

Regards

[former_member182470]

Did you check any transfer routine is there in your Infosource level? Because, the data is getting filetred from Infosource to DSO only? Check any Start/end routine in the Tranasformation between IS and DSO.

[Former Member]

Hi,

As suggested  please check is there any start/End routine.

Thanks

[RamanKorrapati]

Hi ,

There might be something wrong at transformation levels, please check again and please share t/f screen.

Thanks