Auto change an object-type of a CSV file

[Former Member]

Hi gurus,

I am new in SAP Sourcing.

We are required to write a script that fetches a CSV file from a directory, auto change the object type of the file and upload the file into SAP Sourcing.

Tried doing it using the schedule tasks but the file gave an error since the schedule task doesn't change the object-type of the file.

Your assistance will be highly appreciated.

Kind regards,

Sabelo.

[former_member190023 · Accepted solution]

Hello Sabelo,

The best option for your case is to update the program that generates the CSV file, and add the corresponding information on 1st row. Example for exchange rates:

#DataType[masterdata.CurrencyConversion]

If it's absolutely impossible to do this at generation time on the CSV, this might prove to be a very difficult task to implement. I can share some steps on how to achieve this, but I feel it would be the last possible option.

Bogdan

[Former Member · Accepted solution]

Thanks a lot Bogdan. I'll try it out if there's anything else I'll keep you posted.

Kind regards,

Sabelo.