Regarding Attachment in Change Request Header

[titu4mdg]

Hi Experts,

Can anyone tell me where the "attachment file" of CR header(that we upload) go and get saved. I am looking for the actual place(may be some content repository) where these attachment files are saved physically.. I am not looking for any tables like USMD1211 and USMD1212...?

Kindly help me know it for BP, MM and FI objects.. all 3 objects

Would highly appreciate your reply.

Thanks, T

[titu4mdg]

Can anyone please help me here?

[johannes_gilbert · Accepted solution]

Hello Titu,

The DB-tables USMD1211 (Change Request: Attachments) and USMD1212 (Change Request: Content of Attachments) are the ones you are looking for. Let me explain why.

In USMD1212 the attachment's content of attachments is stored in field USMD_CONTENT (RAWSTRING). For example the development of SAP-note 3069990 MDG-AF: Search CR Using Texts Contained in Their Attachments make use of this. Via SAP HANA-Text Search (which is capable of processing binary data like .docx, .xlsx files) you can search within attachments.

It seems that you think the attachment's content is stored in some (other) repository but not in USMD1212. However, this is not the case (as explained above). Another way to find this out is by going via class CL_USMD_ATTACHMENT_GUI_WD and its method OPEN_ATTACHMENT. Following this control flow you will find, that the attachments' content is read from USMD1211 and USMD1212.

Kind regards,
Johannes

[titu4mdg · Accepted solution]

Hi Johannes,

Thanks so much for the explanation you have given. I got it now.

Regards, T

[titu4mdg · Accepted solution]

Hi Johannes,

Thanks much for your reply.

I have one more question. Kindly reply. Are these the same tables(USMD1211 and USMD1212) used for all BP, MM and FI objects CR attachments? or only for BP? The reason why I am asking this, because, I was told that, for MM Data object, SAP provides a DMS content repository to store those attachments.

And what about the FI objects?

Regards, T

[johannes_gilbert · Accepted solution]

Hello Titu,

DB-tables USMD1211 and USMD1212 are used independent of the data model. I.e. they are used for MM, BP, 0G (=FIN) etc. But please be aware that these tables store attachments of the MDG change request. They do not store attachments for a material or a business partner themselves. For custom objects refer to the documentation on how to enable attachments for the change request (Creating a UI for Attachments).

Example: Assume there is a BP without any attachments. You search for this BP in MDG. You open this BP in MDG and change it via a MDG change request. You make some change and add an attachment in the UI Building Block (UIBB) with name 'Change Request'.

This attachment will not go to BP 104981. Move on and activate the MDG change request (which contains the attachment and some changes for the BP) till you get status 'Final Check Approved'. If you now check the BP via SAPGui Transaction BP you will not find the attachment.

The attachments at the MDG change request are used in MDG only. They do not get attached to the master data object itself. There are multiple SAP technologies for attachments like GOS, KPRO, DMS. The master data objects / applications (BP, MM, FIN) might support one or more of them (independent from MDG). It is not possible to govern / maintain attachments via MDG.

Refer to the following SAP-note for MDG Material: 2504687 - MDG-M Attachments in MDG system

You might also want to check the online help for Configuring Master Data Governance for Material > Document Management System (DMS) Integration (Optional).

Kind regards,
Johannes

[titu4mdg · Accepted solution]

Thanks so much Johannes for this explanation.

Regards, T

[Mark63]

Attachment content is stored in table USMD1212. There's no additional Content Management System involved.

[titu4mdg]

Hi Markus,

Thanks much for your reply.

I have one more question. Kindly reply. Are these the same tables(USMD1211 and USMD1212) used for all BP, MM and FI objects CR attachments? or only for BP? The reason why I am asking this, because, I was told that, for MM Data object, SAP provides a DMS content repository to store those attachments.

And what about the FI objects?

Regards, T

[Mark63]

See the answer by Johannes: It answers your additional question.

[titu4mdg]

Thanks Markus.

Regards,T

[Mark63]

Please check similar questions in SAP Community. For example, this post. There's another one about optical marking.

[titu4mdg]

Hi Markus,

Thanks for your reply. I went through the link you shared, but could not find the answers I was looking for.

Kindly advise.

Regards, T