Table which contains relationship between SC attahment guid and SC guid

[Former Member]

Hello Experts,

Can anyone tell table which contains SC attachment guid and SC guid.

There is a table BBP_PDATT which contains attachment guid i.e. parent guid. When this guid is put in TC- BBP_PD, it provides SC guid and SC no. But I want to know the table which contains this relationship.

Help is highly appreciated.

Regards,

Ankita Bhagat

[former_member526044 · Accepted solution]

Hi Ankita Bhagat,

there is no separate table for this.

The table crmd_link is containing all the links between SRM documents and line items.

For attachments, the OBJTYPE_SET value is 33.

Regards

Gergo

[Former Member · Accepted solution]

Hi Gergo,

Thanks a lot for your reply.

I have already checked the table crmd_link.

In this we need to input guid set from table bbp_pdatt to crmd_link with objtype_set = 33. But this table does not return SC guid. I want SC guid or any table having relationship of SC guid & SC attachment guid.

Regards,

Ankita Bhagat

[former_member526044 · Accepted solution]

Hi,

You cannot do this directly.

Attachment in SC is linked to the item line.

First You need to get the item line GUID, than You can query the same table for the parent of the item.

The parent will be the SC header GUID.

Regards

Gergo

[oliver_wurm · Accepted solution]

Hi Ankita Bhagat,

CRMD_LINK gives you the item GUID of the SC. In table CRMD_ORDERADM_I you will find a record for it and column "HEADER" contains the SC GUID.

Please do not use PARENT instead - if you have external Service Requisition from an ECC System PARENT is a Hierarchy Node but HEADER is in both cases the SC GUID.

Hope that helps.

Regards

Oliver