Unable to load date data to PSA

[former_member184624]

Hi BW experts,

I am facing the problem while loading the DATE data from flat file to PSA. Please find the attached snapshot of csv data and PSA data. Is there any setting i need to perform in SU01 Tcode. Please help.

Thanks.

[abdullahqureshi · Accepted solution]

Hi Jalina,

Try if YYYYMMDD format in CSV file works for you.

Regards,

Abdullah

[former_member184624]

Thank you. It is working now.

[former_member184624]

Hi Sam,

Thanks for your reply. I am sure, it is not possible to change from Internal to external.

Can you suggest me is there any settings, that i can do to make this load success.

Thanks.

[sgassem]

I'm assuming you have a "Generic" data source created for this. You should be able to change the datsource in the Dev system, test, and prompte.

[sgassem]

In your DataSource, make sure the date is in the "External" format not internal.

Also in SU01, make sure the currency and date are in the correct format.

[former_member184624]

Thank you Sam for the quick reply.

As i checked the DATE field in the data source, it is in Internal format. As we are loading data in Production, it is not possible to change from Internal to external. Can you please suggest, how to proceed on this.

Thanks.