07-28-2007 11:12 PM
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 ????
07-28-2007 11:40 PM
07-28-2007 11:40 PM
07-28-2007 11:51 PM
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
07-28-2007 11:58 PM
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 ...
07-29-2007 12:03 AM
Hi,
If you need more info on attachments pl. take a close look at class CL_GOS*
aRs
07-29-2007 1:54 AM
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
07-29-2007 4:52 PM
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
07-29-2007 5:22 PM