Skip to Content

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

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)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on 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?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.