Code to correct Invalid date to correct date format.

[#1]

Hi Experts,

I'm loading the data from datasource to DSO and then from DSO to Infocube.

While loading the data from datasource to DSO, I was getting error during DSO Activation. The error was "Activation of M records from DSO  terminated" .

After changing the DSO Setting as "No SID Generation", I was able to load it into DSO.

So here is the issue m facing--

While loading from DSO to infocube, I got the error "Exception in Substep Write to Fact Table" . Then I found that this error was due to some wrong entry of date in Date column - /OBIZ/LAEDA

Some date values are empty. Some are in correct format- DD.MM.YYYY.

But some are in wrong format like Example - 20.2..15.1

So could anyone please help me in writing the ABAP Code in start routine of Transformation between DSO and Infocube.

Requesting  ABAP and BW experts to help me out in successfully loading into Infocube.

Thanks & Regards,

Shruti Yendigeri

[former_member214415]

Hi Shruti,

Settings for error stack in dtp in update mode should be "update valid records, No reporting(Request Red)" or "update valid records, Reporting possible(Request Green)". Once you do error handling like this so erroneous record will be in error stack, after correcting save them. Then you can create error DTP. So execute it and its not like that you can create error DTP only after correcting records in error stack. Better you correct the error in date at DSO level only. So you can create ERROR DTP or correct at PSA level(error handling is - No update, No reporting). so activation of M records in DSO will not be terminated.Then load data from dso to cube.

Thanks,

Swapna Jain