Skip to Content
avatar image
Former Member

Move attachments

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 14, 2015 at 01:22 AM

    Hi,

    Please refer SAP note:

    1239019 - Attachments folder changed

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 01:25 AM

    Hi,

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

    Try DTW instead.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded