cancel
Showing results for 
Search instead for 
Did you mean: 

SRM 4 cFolders relation between contract number and documents

Former Member
0 Kudos

Dear all,

I'm not a developer, neither an SRM consultant but I'm trying to get the PHIO ID of documents related to a contract number.

I'm a bit lost in all the cFolders stuff. I'm trying to follow the code process by debug, but it won't let me know a simple way to select PHIO IDs from my contract number...

Do someone knows about stuff like this ?

The final thing is to copy only the documents selected for some contracts from production to other systems. So I need the PHIO ID since it's the name of the file in Content Repository on filesystem.

Regards,

Pierre

Edited by: Pierre Viel on Feb 23, 2011 11:29 AM

Accepted Solutions (1)

Accepted Solutions (1)

yeushengteo
Advisor
Advisor
0 Kudos

Hi,

Try this:

1. Execute the FM BBP_PD_CTR_GETDETAIL by passing in the IMPORT parameter I_OBJECT_ID = <contract number> and I_ATTACH_WITH_DOC = 'X'.

in the EXPORT parameter ET_ATTACH, you will be able to see the attachment details.

2. Execute the TC BBP_PD passing the object type = BUS2000113 and Object ID = <contract number> and execute (F8). Get into the document details and checks under the Attachments section. scrolling down.

Regards.

YS

Former Member
0 Kudos

Hi.

That is a really helping answer. But the problem is that in the 2 cases, the results show only the ID of the collaboration area.

I still need to link this to documents.

Thanks a lot anyway.

Pierre

Former Member
0 Kudos

Hi.

I figured out a solution, quite bad but I can get the IDs of my attached documents.

First I get the URL of the collaboration of a contract :

SELECT distinct URL from sap30e.BBP_PDATT B, sap30e.CRMD_LINK C WHERE B.SET_GUID = C.GUID_SET AND C.GUID_HI in (select GUID from sap30e.crmd_orderadm_h where object_id = 50013705 and object_type like 'BUS2000113') AND C.OBJTYPE_HI LIKE '05' AND C.OBJTYPE_SET LIKE '33' ;

Then I put the collaboration area id found before in the URL in the function module "CFX_API_AREA_GETDETAIL".

It gives me the root folder ID.

Then, I put the root folder ID in the function module "CFX_API_FOLDER_GETDETAIL" to get all the sub folders.

I do the same for each sub folder ID from before (CFX_API_FOLDER_GETDETAIL) to get the result table : "ET_DOC_IDS".

For every values in this table, I use the function module "CFX_API_DOC_GETDETAIL". I gives me IDs of every version of the document.

I let the thread open if someone has a better method.

Regards,

Pierre

Answers (0)