Skip to Content

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

Dec 29, 2017 at 11:40 AM


avatar image

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.

error.png (8.2 kB)
ds-setting.png (15.6 kB)
psa.png (15.3 kB)
ip-error.png (4.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Dec 29, 2017 at 12:07 PM

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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,


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


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,