cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with the flat file load involving date values in the format of dd/mm/yyyy

sasidhar_pannala
Explorer
0 Kudos

Hi experts,

I need to do a flat file load from datasource to an ADSO. A transformation with some formulas is in place in between.

The flat file is having dates in the external format i;e DD/MM/YYYY and hence at the datasource level, i put the format as EXTERNAL.

At this stage, when i ran the infopackage, it failed with the following error message. (Note that the preceding zero of the date got removed in the error message. In flat file the value was 06/05/2015 whereas the error message says 6/05/2015)

Hence i checked the "PSA in CHAR format" at the data source level and then i successfully got the data into PSA in the external format itself.

Now the issue is precipitating as below when i run the DTP from the datasource to the ADSO yielding the same message as of the earlier one at the infopackage.

I have tried using the conversion exits like RSDAT, PDATE and many more at the datasource itself but none of them are accepting an input format like DD/MM/YYYY. Since the conversion exits are not working and also for the reason that the error is evolving at the DTP level, I have written field level routines to convert the date values from the external format to the SAP internal format. But still im getting the same error when i execute the DTP. Any tips to resolve this ?

for sure you will be rewarded with points. Thanks to do the help.

Accepted Solutions (0)

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

Hi - with BW, I always convert the dates in the flat file itself to YYYMMDD and then it works. Can you try that?

sasidhar_pannala
Explorer
0 Kudos

Hi Tammy,
Thanks for the quick response. But the date into the flat file is coming through an automated third party tool/system and in future we will not have any control to modify. It is supposed to be automated.

Best Regards,
Sasidhar.

TammyPowlas
Active Contributor
0 Kudos

If it were me, I would ask the 3rd party to change the flat file to YYYYMMDD

sasidhar_pannala
Explorer
0 Kudos

Of course, that will be my final action even. But before that, im trying my level best to find solution for this rather than work arounds 🙂

Best Regards,
Sasidhar.