on 06-16-2015 12:26 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.