How is key of table SOOD related to PHIO_ID in SOFFPHIO?

[Former Member]

Here is a SOOD row:

MANDT         030                          
OBJTP         EXT                          
OBJYR         32                           
OBJNO         000000001320                 
                                           
OBJLA         EN                           
OBJSRT                                     
OBJNAM        MESSAGE                      
OBJDES        abapwbb    
FILE EXT      bmp     
OWNTP         USR                          
OWNYR         31                           
OWNNO         000000000304                 
OWNNAM        HALITSKYDAVI                 
CROTP         USR                          
CROYR         31                           
CRONO         000000000304                 
CRONAM        HALITSKYDAVI                 
CRDAT         07/28/2007                   
CRTIM         14:00:43                     
CHOTP                                      
CHOYR                                      
CHONO                                      
CHONAM                                     
CHDAT         07/28/2007                   
CHTIM         14:00:43                     

How and where is the key of this row related to the PHIO_ID that you actually use to get the binary contents of "abbapwbb.bmp" from SOFFCONT1?

Is the PHIO_ID a hash of something ????

[former_member194669]

Hi,

Check Table SRGBTBREL ( I am not 100% sure about this)

aRs

[former_member181923]

God bless you!!! I mean seriously - may you walk in fields of your favorite flowers forever and ever amen.

That's it -

CLIENT      030                                                                           
BRELGUID    46AB6A696021005A020000000A2A0866                                                                                
RELTYPE     ATTA                                                                          
INSTID A    000200266362                                                                  
TYPEID A    BUS2038                                                                       
CATID A     BO                                                                            
INSTID B    FOL23000000000004EXT32000000001320                                            
TYPEID B    MESSAGE                                                                       
CATID B     BO                                                                            

[former_member181923]

By the way, the actual field INSTID_B in SRGBTBREL is returned by BAPI_REL_GETRELATIONS, so no need even to construct it ...

And yes - there is a good secondary index on SRGBTREL involving INSTID_B !!!!

Thanks very much again ...

[former_member194669]

Hi,

If you need more info on attachments pl. take a close look at class CL_GOS*

aRs

[former_member181923]

I've been working with CL_GOS* but apparently not close enough.

Also, it seems to depend very much on whether you're running a content server (in which case SOFFPHIO has the storage categoyr SOFFHTTP) or not (in which case SOFFPHIO has the storage category SOFFDB.)

In the former case, cl_bds_document_set->get_with_urls returns actual urls for ALL attachments that you can pass to picture controls.

In my case, the customer is still using SOFFDB, so I've got to go around the long way.

Anyway, thanks very much again for the pointer to the table.

Regards

djh

[former_member181923]

Actually, SRGBTBREL-BREELGUID is not quite the end of the story ... you have to perform a subtraction of 4 on the hex in positions 5-7 (offset 0) of srgbtbrel-brelguid in order to get the correct phio_id in SOFFCONT1 (and SOFFPHIO and SOFFPHF).

Here are three examples:

          1         2         3
01234567890123456789012345678901
     ||| 
46AC9DEB9ABF0075000000000A2A0866 SRGBTBREL
46AC9DE79ABF0075000000000A2A0866 SOFFCONT1
     ||| 
46AC9DF79ABF0075000000000A2A0866 SRGBTBREL
46AC9DF39ABF0075000000000A2A0866 SOFFCONT1
     ||| 
46AC9E039ABF0075000000000A2A0866 SRGBTBREL 
46AC9DFF9ABF0075000000000A2A0866 SOFFCONT1

[former_member194669]

Hi,

Its new info for me.

Thanks for sharing this

a®