topic Re: get file from dms in Application Development and Automation Discussions

get file from dms

Former Member — Wed, 15 Jul 2009 11:25:06 GMT

hi,

can anyone help me to get the data for a file in dms with a specific doknr? i need to get the binary data to send them per mail.

I searched in function group cv120 (i tried cv120_read_file2table but it doesn't work for me) but wasn't able find a solution!

can anyone help me?

regards,

jacko

Re: get file from dms

Former Member — Wed, 15 Jul 2009 11:39:12 GMT

Try this code

SELECT lo_objid

INTO TABLE it_lo_objid

FROM dms_doc2loio

WHERE dokar = documenttype

AND doknr = documentnumber

AND dokvr = documentversion.

SELECT SINGLE phio_id

ph_class

INTO (wa_object_id-objid ,wa_object_id-class)

FROM dms_ph_cd1

WHERE loio_id = wa_lo_objid.

This function module will give the content in binary format

CALL FUNCTION 'SDOK_PHIO_LOAD_CONTENT'

EXPORTING

object_id = wa_object_id

client = sy-mandt

AS_IS_MODE =
RAW_MODE =
TEXT_AS_STREAM =

TABLES

FILE_ACCESS_INFO =
FILE_CONTENT_ASCII =

file_content_binary = it_file_content_binary

EXCEPTIONS

not_existing = 1

not_authorized = 2

no_content = 3

bad_storage_type = 4

OTHERS = 5

But the lenght of the output will be of 1022 .

Hence you need to change it to 255 to send it by mail.

Thanks

Papiya

Re: get file from dms

Former Member — Wed, 15 Jul 2009 14:19:15 GMT

thanks a lot this looks nice!

is there a fuba for converting that to length 255?

regards,

jacko

Re: get file from dms

Former Member — Wed, 15 Jul 2009 15:01:51 GMT

Hi,

Go through this wiki of mine and check if it helps. I guess this is the exact functionality you require.

https://www.sdn.sap.com/irj/scn/wiki?path=/display/snippets/codetogetthecontentofanattachmentinDMandmailittoexternalemailid

Thanks

Papiya

Re: get file from dms

Former Member — Mon, 20 Jul 2009 13:30:20 GMT

thanks for your example but i have to work with FUBA SO_NEW_DOCUMENT_ATT_SEND_API1 and therefore i need a solution to attach my file from dms.

i used your solution:

SELECT lo_objid INTO TABLE it_lo_objid

FROM dms_doc2loio

WHERE dokar EQ 'Z01'

AND dokvr EQ '00'

AND doknr LIKE srch_str.

LOOP AT it_lo_objid INTO wa_lo_objid.

SELECT SINGLE phio_id ph_class INTO (wa_object_id-objid ,wa_object_id-class)

FROM dms_ph_cd1

WHERE loio_id = wa_lo_objid.

CALL FUNCTION 'SDOK_PHIO_LOAD_CONTENT'

EXPORTING

object_id = wa_object_id

client = sy-mandt

AS_IS_MODE =
RAW_MODE =
TEXT_AS_STREAM =

TABLES

FILE_ACCESS_INFO =
FILE_CONTENT_ASCII =

file_content_binary = it_file_content_binary

EXCEPTIONS

not_existing = 1

not_authorized = 2

no_content = 3

bad_storage_type = 4

OTHERS = 5.

DATA: act_length TYPE i.

DATA: act_diff TYPE i.

DATA: act_rest_length TYPE i.

DATA: act_line TYPE string.

DATA: act_rest TYPE string.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

DATA: count TYPE i,

data_string TYPE xstring.

DATA: "it_CONTENT_BINARY TYPE solix_tab,

it_content_binary TYPE solix_tab,

it_line TYPE LINE OF solix_tab,

it_content_binary_solix TYPE solix,

wa_content_binary TYPE solix.

TEMP START

DESCRIBE TABLE it_file_content_binary LINES count.

count = count * 1022.

CALL FUNCTION 'SCMS_BINARY_TO_XSTRING'

EXPORTING

input_length = count

FIRST_LINE = 0
LAST_LINE = 0

IMPORTING

buffer = data_string

TABLES

binary_tab = it_file_content_binary[]

EXCEPTIONS

failed = 1

OTHERS = 2

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'

EXPORTING

buffer = data_string

APPEND_TO_TABLE = ' '
IMPORTING
OUTPUT_LENGTH =

TABLES

binary_tab = it_content_binary[].

but I can't use it_content_binary[] in SO_NEW_DOCUMENT_ATT_SEND_API1 without getting an CX_SY_DYN_CALL_ILLEGAL_TYP

it says the actual given field has the right type but not the right length! (CONTENTS_BIN)

what's my foult!

big thanks to you!

greets, jacko

Edited by: Jacko1986 on Jul 20, 2009 3:30 PM

Re: get file from dms

m4abrams — Thu, 17 Oct 2013 04:57:32 GMT

HI Jacob,

I know I am 4 years too late to ask this question , but did you find the solution to this problem you were facing in trying to load data from the DMS ?

Thanks.

Re: get file from dms

Former Member — Thu, 17 Oct 2013 05:41:40 GMT

Use FM 'CVAPI_DOC_GETDETAIL' & 'CVAPI_DOC_CHECKOUTVIEW'

Re: get file from dms

VijayaKrishnaG — Thu, 17 Oct 2013 05:47:19 GMT

Hi Jacob,

Have a look at the following document, that says how to download or print the DMS Attachment but after getting data you can convert it and mail instead download or print.

Thanks & Regards,

- Vijay