Move attachments

[sergi_maudet2]

Hi,

Before SBO accepted attachments in Business Partners and Marketing docs, we created user fields to include attached files.

Now that we've moved to 9.0, we want to move all the data from the user fields to the right 'regular SBO' tables. Files do not need to be moved as they are in the same path as the 'regular' files and path is also stored in the DB.

There were documents before in OATC and ATC1.

It is just one file (or none) per Business Partner or Marketing document, so I guess we have to create records in OATC and then in ATC1, but not sure how to run an UPDATE query for this...

Any ideas, experience?

[Former Member]

Hi,

Direct update B1 table through SQL is not supported. You are risking to not get support from SAP.

Try DTW instead.

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi,

Please refer SAP note:

1239019 - Attachments folder changed

Thanks & Regards,

Nagarajan

[sergi_maudet2]

Hi,

I am not trying to move the file location, but the database info from one user field to a system field.

[kothandaraman_nagarajan]

As said by Mr.Gordon, update of B1 table is not supported by SAP. If less records, manually change file location.