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]

Hi Shruti,

Is this data which you posted is from PRODUCTION environment? 

This is JUNK data, best practice is to get the data corrected in source and then extract the same into BW info providers.

Even though you create a ERROR DTP you need to correct the entries every time you get the junk data and then make them available for reporting. Which is not a good practice.

Regards

KP

[Former Member]

Hi Prashanth ,

The data is not from Production Environment.

And yes I agree with you that its better to correct the data in source system itself.

But I was suggested to correct the data at DSO level.

Here, m again confused about the settings which I need to follow while loading records into DSO.

I have to create 2 DTPs, Right ?

First DTP to load the correct records. In update tab - what setting should I choose ?

Second DTP i.e ERROR DTP to load the corrected records of wrong date. Here again, in update tab - what setting should I choose ?

Have referred many docs and scn posts.

But m confused.

Could u please guide me the step by step flow.

Thanks & Regards,

Shruti Yendigeri

[Former Member]

Hi Shruti,

You have already created on DTP which is Delta/Full. Just goto alredy created DTP and click on Creating Error DTP and Errors Per Pack. as per requirement like 1000.

Please check below DTP,

It will create automatically error DTP. Then, Set Error Handling based on requirement.

You can set Valid Records Update, Reporting Possible ( Request Green).

Edit the records and error stack and run the Error DTP.

Hope this helps.

Chandresh