14) LNCPRTDOC : SAP- Using BAPI

In this example, the database has the following characteristics :

• Type DB: SAP

• SAP server address: 192.168.1.7

• SAP user: DDIC

• SAP user password: aura

• BAPI name: BAPI_FLBOOKING_GETLIST

• Result table used to export to Excel: BOOKING_LIST

• Parameter of the BAPI: MAX_ROWS=7

The command LNCPRTDOC is used to generate the following Word file:
C:\temp\result.docx

String template = "C:\\temp\\template.docx";
String destination = "C:\\temp\\result.docx";

// Create a hash map
Map<String,String> hm = new HashMap<String,String>();

// Put elements to the map
hm.put("MAX_ROWS", "70");

     DataSource myDataSource = new DataSource();
     myDataSource.setType("sapbapi");
     myDataSource.setUser("DDIC");
     myDataSource.setPassword("aura");
     myDataSource.setAshostSAP("192.168.1.7");
     myDataSource.setClientSAP("001");
     myDataSource.setLangSAP("");
     myDataSource.setSysnrSAP("00");
     myDataSource.setGwhostSAP("192.168.1.7");
     myDataSource.setGwservSAP("3300");
     myDataSource.setBAPIName("BAPI_FLBOOKING_GETLIST");
     myDataSource.setBAPIResultTable("BOOKING_LIST");
     myDataSource.setParameterMap(hm);

     LNCPRTDOC myLNCPRTDOC = new LNCPRTDOC();
     myLNCPRTDOC.setDoc(template);
     myLNCPRTDOC.setSavFmt("*NORMAL");
     myLNCPRTDOC.setShowDoc("false");
     myLNCPRTDOC.setMrgType("*FILE");
     myLNCPRTDOC.setOutSave("true");
     myLNCPRTDOC.setSavDoc(destination);
     myLNCPRTDOC.setMrgSel("*LTR");
     myLNCPRTDOC.setExecMrg("true");
     myLNCPRTDOC.setEndOpt("*NONE");
     myLNCPRTDOC.setHeaderSrc("*FILE");
     myLNCPRTDOC.setSourceData(myDataSource);
     myLNCPRTDOC.setLNCSrvAddr("192.168.1.9");

myLNCPRTDOC.execute();