Issue with document retrieval using BAPI_DOCUMENT_CHECKOUTVIEW2

It should be created on the MII Server. I would check the destinations and see if you can point the destination to one of the following depending upon your usage: web://, db://, server://

[web vs db|difference-between-accessing-'web'-and-'db']

Regards,

Mike

You can try using SDOK_PHIO_LOAD_CONTENT to get files from DMS instead of BAPI_DOCUMENT_CHECKOUTVIEW2

This snippet from here:

[Sdn Code Example|http://wiki.sdn.sap.com/wiki/display/Snippets/CodetogetthecontentofanattachmentinDMandmailittoexternalemailid] shows how to get the id and class for a document:

SELECT  lo_objid 
             INTO TABLE it_lo_objid 
             FROM dms_doc2loio 
            WHERE dokar = documenttype 
              AND  doknr = documentnumber 
              AND dokvr  = documentversion 
              AND doktl = '000'. 

    v_counter = 1. 

    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 SDOK_PHIO_LOAD_CONTENT via JCo action an concatenate all of the FILE_CONTENT_BINARY LINE items into one string.

Because the Binary data gets base64 encoded when formatted into the return XML use the Http Post Action to post the string (with content type multipart/form-data) to a jsp like this one:

<%@ page import="java.util.*" %> 
<%@ page import="java.io.*" %> 
<%@ page import="java.lang.Exception"; %> 
<%@ page import="java.lang.String"; %> 
<%@ page import="com.sap.xmii.Illuminator.security.User"; %> 
<%@ page import="com.sap.xmii.Illuminator.common.*" %> 
<%@ page import="com.sap.xmii.Illuminator.content.ContentManager"; %> 
<%@ page import="com.sap.xmii.system.SessionHandler"; %> 
<%@ page import="com.sap.security.api.IUser"; %> 
<%@ page import="com.sap.security.api.UMFactory"; %> 
<%@ page import="com.sun.org.apache.xerces.internal.impl.dv.util.Base64"; %> 

<% 

//get our user and check against a custom file upload role. 
IUser user = UMFactory.getUserFactory().getUserByUniqueName(SessionHandler.getUser(request).getName()); 
              
if(user.isMemberOfRole("ROLE.UME_ROLE_PERSISTENCE.un:CUSTOM_FILE_LOAD_ROLE", true)){ 

BufferedReader bRead = request.getReader(); 
String line = null; 
StringBuffer theText = new StringBuffer(); 

while((line=bRead.readLine())!=null){ theText.append(line); } 

String base64 = theText.toString(); 
byte decoded[] = new sun.misc.BASE64Decoder().decodeBuffer(base64); 

try { 
// FileUpload/FileStore/ will save uploaded file to the MII web container - FileUpload/WEB/FileStore 
ContentManager.save("FileUpload/FileStore/" + request.getParameter("FILENAME") , decoded , SessionHandler.getUser(request), false,null, false); 
out.println("<BR> File " + request.getParameter("FILENAME") + " Loaded"); 

} catch (Exception e) { out.println("ERROR: "  + e.getMessage()  );} 

}else { out.println("ERROR: USER HAS NO AUTHORY TO UPLOAD FILES ");} 
%>