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 Member]

Shruti,

What is the format of date in the source... ? How is it coming across

In your data source - you might find a conversion exit against the field - what is it ...? is there one currently ? ( usually PERIV ... or something of that sort )

Then the best way is to convert it to YYYYMMDD in the routine and it will get updated - but if we are going to guess the date format by looking at what is available in the DSO / Cube - you will have a tough time trying to deduce the format...

My 0.02

Arun