ERP連携モジュールチュートリアル

ERP SAP R/3 API 2 2004 12 17

2004/10/08 2004/12/17 SAP

SAP 1...1 1.1...1 1.2...1 1.3 SAP API...2 1.4...3 1.4.1...3 1.4.2...6 1.5...7 1.6...8 1.6.1 sap_auth_info.properties Key...8 1.6.2 sap_auth_info.properties...9 1.6.3 sap_auth_info.properties...10 1.6.4 sap_auth_info.properties...11 1.7...12 2 API...13 2.1 API BAPI...13 2.2 API...14 2.2.1 BusinessAreaController...14 2.2.2...15 2.3 API...19 2.3.1 ControllingAreaController...19 2.3.2...20 2.4 API...24 2.4.1 CostCenterController...24 2.4.2...25 2.5 API...30 2.5.1 ProfitCenterController...30 2.5.2...31 2.6 API...36 2.6.1 CompanyController...36 2.6.2...37 2.7 G/L API...41 2.7.1 GlAccController...41 2.7.2...42 2.8 API...47 2.8.1 BankController...47 2.8.2...48 2.9 API...52 2.9.1 AccEmployeePayPostController...52 2.9.2...55 2.10...60 2.10.1...60 2.10.2...61 3 API...64 3.1 API...64 3.2...65 Page i

SAP 1 1.1 SAP R/3 API SAP R/3 API intra-mart Web SAP R/3 Java JavaScript JSP Servlet ServerSideJava ( UML) J2EE SAP R/3 SAP R/3 SAP R/3 BAPI RFC SAP R/3 API 1.2 SAP R/3 API Java API J2EE JavaScript Java Java SAP R/3 SAP R/3 SAP R/3 t-cd SE37 BAPI RFC ( ) SAP R/3 FI CO API API SAP R/3 FI CO Page 1

intra-mart SAP SAP R/3 API intra-mart ver4.3.3 ver4.3.3 1.3 SAP API SAP JCo SAP SAP Service Marketplace SAP JCo OS SAP JCo SAP JCo 2.1.3 OS SAP sapjco.jar 1.5 Page 2 Copyright 2004 NTT All rights Reserved.

SAP 1.4 intra-mart Ver4.3.3 SAP API SAPR/3 SAP Jco SAP Jco SAP SAP Service Marketplace JCo SAP SAP R/3 GUI SAP R/3 GUI SAP R/3 GUI 1.4.1 intra-mart intra-mart StorageService intra-mart storage/basemodule/sample/sapmenu.txt Page 3

SAP G/L API API API API Page 5

intra-mart SAP 1 1.4.2 API SAP R/3 SAP R/3 im_sapapi.js objcon = new CostCenterController("JP10") JP10 im_sapapi.js objcon = new ProfitCenterController ("JP10") JP10 SAP R/3 im_sapapi.js objcon = new GlAccController ("JP10") JP10 G/L SAP R/3 im_sapapi.js objcon.set SAP R/3 FI/CO im_sapapi.js objcon.set SAP R/3 FI/CO objcon.setdoccompcode("test") SAP R/3 Page 6 Copyright 2004 NTT All rights Reserved.

SAP 1.5 intra-mart BaseModule Ver4.3.3 Page 7

intra-mart SAP 1.6 1.6.1 sap_auth_info.properties Key intra-mart Web SAP R/3 SAP R/3 sap_auth_info.properties sap_auth_info.properties intra-mart C:/imart43/doc/imart /WEB-INF/classes Key No Key 1 jco.client.client R/3 2 jco.client.user R/3 3 jco.client.passwd R/3 4 jco.client.lang R/3 ja 5 jco.client.ashost R/3 IP 6 jco.client.sysnr R/3 00 7 jco.client.poolsize R/3 5 8 jco.client.poolname R/3 default 9 jco.client.waittime 30000 10 jco.client.connectiontimeout 600000 11 jco.client.timeoutcheckperiod 60000 Page 8 Copyright 2004 NTT All rights Reserved.

SAP 1.6.2 sap_auth_info.properties SAP R/3 IP Page 9

SAP 1.6.4 sap_auth_info.properties Key Key SAP R/3 properties client Client JCO ID = user001 = null IP = erpsv01 Key poolsize waittime connectiontimeout timeoutcheckperiod SAP R/3 API properties Key jco.client.poolsize=test jco.client.poolname=poola jco.client.waittime=20000 jco.client.connectiontimeout=600000 jco.client.timeoutcheckperiod=60000 1.6.1 KEY SAP R/3 properties jco.client.poolsize=5 #jco.client.poolname=poola jco.client.waittime=20000 JCO ID = user001 = 210 IP = erpsv01 Page 11

intra-mart SAP 1.7 SAP R/3 API import BAPI SAP R/3 NUMC BAPI 0 API NUMC 10 import 5 BAPI 0000000005 NUMC 0 import BAPI SAP R/3 DATS YYYYMMDD YYYY/MM/DD YYYY-MM-DD API API API BAPI export SAP R/3 DATS YYYY-MM-DD SAP R/3 API Windows2000 Solaris8 SAP JCo 2.1.3 Page 12 Copyright 2004 NTT All rights Reserved.

SAP 2 API 2.1 API BAPI API API BAPI intra-mart C:/imart43/doc/imart /WEB-INF/classes API sap_auth_info.properties servertype API servertype 3.2.2 3.2.4 servertype No 1 API bapi_businessarea_getlist.properties 2 API bapi_controllingarea_getlist.properties 3 API bapi_costcenter_getlist1.properties 4 API bapi_profitcenter_getlist.properties 5 API bapi_companycode_getlist.properties 6 G/L API bapi_gl_acc_getlist.properties 7 API bapi_bank_getlist.properties 8 API bapi_acc_employee_pay_post.properties Page 13

intra-mart SAP 2.2 API 2.2.1 BusinessAreaController SAP R/3 API SAP R/3 API BusinessAreaController BusinessAreaController API No 1 BusinessAreaController JA ISO 639 JA No23 2 getbusinessarealist JA ISO 639 JA 3 getbusardes Page 14 Copyright 2004 NTT All rights Reserved.

SAP 2.2.2 Page 15

SAP Page 17

SAP 2.3 API 2.3.1 ControllingAreaController SAP R/3 API SAP R/3 API ControllingAreaController ControllingAreaController API No 1 ControllingAreaController 2 getcontrollingarealist ( ) 3 getname Page 19

SAP Page 21

SAP API Page 23

intra-mart SAP 2.4 API 2.4.1 CostCenterController SAP R/3 API SAP R/3 API CostCenterController CostCenterController API No 1 CostCenterController No35 2 CostCenterController 2 No35 3 getcostcenterlist ( ) 4 getname 5 getdescript Page 24 Copyright 2004 NTT All rights Reserved.

SAP 2.4.2 Page 25

SAP Page 27

SAP API JP10 API Page 29

intra-mart SAP 2.5 API 2.5.1 ProfitCenterController SAP R/3 API SAP R/3 API ProfitCenterController ProfitCenterController API No 1 ProfitCenterController No36 2 ProfitCenterController 2 No36 3 getprofitcenterlist ( ) 4 getvalidto 5 getpctrname 6 getincharge Page 30 Copyright 2004 NTT All rights Reserved.

SAP 2.5.2 Page 31

SAP Page 33

SAP API ProfitCenterController JP10 API ProfitCenterController getprofitcenterlist ProfitCenterController ProfitCenterController getvalidto ProfitCenterController getpctrname ProfitCenterController getincharge ProfitCenterController getprofitcenterlist Page 35

intra-mart SAP 2.6 API 2.6.1 CompanyController SAP R/3 API SAP R/3 API CompanyController CompanyController API No 1 CompanyController 2 getcompanylist ( ) 3 getcompname Page 36 Copyright 2004 NTT All rights Reserved.

SAP 2.6.2 Page 37

SAP Page 39

SAP 2.7 G/L API 2.7.1 GlAccController SAP R/3 API SAP R/3 API GlAccController GlAccController API No 1 GlAccController JA ISO 639 JA No24 2 getglacclist JA ISO 639 JA ( G/L ()) 3 getshorttext G/L G/L () 4 getlongtext G/L () Page 41

SAP Page 43

SAP Page 45

SAP 2.8 API 2.8.1 BankController SAP R/3 API SAP R/3 API BankController BankController API No 1 BankController JP No24 2 getbanklist JP ( ) 3 getbankname 4 getcity Page 47

SAP Page 49

SAP API BankController BankController getbanklist BankController getbankname BankController getcity BankController getbanklist Page 51

intra-mart SAP 2.9 API 2.9.1 AccEmployeePayPostController SAP R/3 API intra-mart Web SAP R/3 API AccEmployeePayPostController AccEmployeePayPostController API No 1 AccEmployeePayPostController 2 setdocobjtype() 3 setdocobjkey() 4 setdocusername() 5 setdocheadertxt() 6 setdoccompcode() 7 setdocacdocno() 8 setdocfiscyear() 9 setdocdocdate() 10 setdocpstngdate() 11 setdocfisperiod() 12 setdocdoctype() 13 setdocrefdocno() 14 setpaitemnoacc() 2 15 setpavendorno() 2 2 2 Page 52 Copyright 2004 NTT All rights Reserved.

SAP No 16 setpaglaccount() 2 17 setpablinedate() 2 18 setpapymtmeth() 2 19 setpaallocnmbr() 2 20 setpaitemtext() 2 21 setglitemnoacc() 2 22 setglglaccount() 2 23 setglcompcode() 2 24 setglpstngdate() 2 25 setgldoctype() 2 26 setglfiscyear() 2 27 setglrefkey1() 2 28 setglitemtext() 2 29 setgltaxcode() 2 30 setglallocnmbr() 2 31 setglbusarea() 2 32 setglcostcenter() 2 33 setglorderid() 2 34 setglwbselement() 2 35 settaitemnoacc() 2 36 settaglaccount() 2 2 2 2 2 2 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L 2 G/L WBS 2 2 Page 53

intra-mart SAP No 37 settataxcode() 2 38 setcuitemnoacc() 2 39 setcucurrency() 2 40 setcuamtdoccur() 2 41 setcuamtbase() 2 2 2 2 2 2 ( ) 42 executebapi() No241 SAP R/3 Page 54 Copyright 2004 NTT All rights Reserved.

SAP 2.9.2 Page 55

SAP Page 57

SAP API API structure table SAP R/3 t-cd SE37 BAPI Page 59

intra-mart SAP 2.10 2.10.1 SAP API API Java SAP API API Object[ ] KEY ERR_CODE ERR_MSG 1: 2: 3: 4: 5: 6: ( ) ERR_DESC SAP API J2EE API Exception catch throws SAPAuthSystemException SAPAuthAppException SAPGeneralAppException SAPGeneralAppException SAPAccountingSystemException SAPAccountingAppException Object[ ] Object[ ERR_CODE ] Object[ ERR_MSG ] Object[ ERR_DESC ] J2EE getmessage() tostring () Object objerr [ ERR_CODE ] Page 60 Copyright 2004 NTT All rights Reserved.

SAP 2.10.2 API 2.9.2 sap_auth_info.properties Page 61

SAP im_sapapi.js 2-9-2 Page 63

intra-mart SAP 3 API 3.1 API API API API API SAP R/3 / SAP R/3 BAPI API API API API API API API intra-mart SAP R/3 FI CO API HR SDMM intra-mart API FI CO API SAP R/3 Java Java SAP R/3 BAPI SAP R/3 API SAP R/3 Page 64 Copyright 2004 NTT All rights Reserved.

SAP 3.2 3.2.1 API SAP R/3 BAPI BAPI 3.2.2 Java.properties KEY NO KEY 1 2 3 4 5 6 7 8 9 Page 65

SAP bapi_profitcenter_getlist.properties servertype= commit=false bapiname=bapi_profitcenter_getlist #import import.import.controllingarea=controllingarea import.import.personincharge=personincharge import.import.date=date #table export.table.profitcenter_list.profit_ctr=profit_ctr export.table.profitcenter_list.valid_to=valid_to export.table.profitcenter_list.pctr_name=pctr_name export.table.profitcenter_list.in_charge=in_charge sap_auth_info.properties servertype value BAPI value false BAPI_PROFITCENTER_GETLIST import BAPI value Java HashMap key value BAPI_PROFITCENTER_GETLIST export table PROFITCENTER_LIST PROFIT_CTR VALID_TO PCTR_NAME IN_CHARGE table value Java HashMap key value Page 67

SAP bapi_acc_employee_pay_post.properties servertype=accounting commit=true bapiname=bapi_acc_employee_pay_post #import # import.structure.documentheader.obj_type=doc_obj_type import.structure.documentheader.obj_key=doc_obj_key import.structure.documentheader.username=doc_username import.structure.documentheader.header_txt=doc_header_txt import.structure.documentheader.comp_code=doc_comp_code #table # import.table.accountpayable.itemno_acc=pa_itemno_acc import.table.accountpayable.vendor_no=pa_vendor_no import.table.accountpayable.gl_account=pa_gl_account import.table.accountpayable.bline_date=pa_bline_date import.table.accountpayable.pymt_meth=pa_pymt_meth import.table.accountpayable.alloc_nmbr=pa_alloc_nmbr import.table.accountpayable.item_text=pa_item_text seryvertype value sap_auth_info.properties servertype BAPI value true BAPI_ACC_EMPLOYEE_PAY_POST import structure DOCUMENTHEADER OBJ_TYPE OBJ_KEY structure value Java HashMap key value BAPI_ACC_EMPLOYEE_PAY_POST import table ACCOUNTPAYABLE ACCOUNTGL ACCOUNTTAX CURRENCYAMOUNT table value Java HashMap key value Page 69

intra-mart SAP 3.2.4 Java Key servertype sap_auth_info.properties servertype servertype servertype value sap_auth_info.properties servertype servertype= sap_auth_info.properties servertype # servertype= sap_auth_info.properties servertype Key commit value true false value BAPI false commit=true commit=true commit=false commit=false Key bapiname value BAPI Key import export structure table import.structure.documentheader.obj_type=doc_obj_type Import.structure.DOCUMENTHEADER.OBJ_TYPE=doc_obj_type IMPORT.structure.DOCUMENTHEADER.OBJ_TYPE=doc_obj_type import.structure. DOCUMENTHEADER.OBJ_TYPE=doc_obj_type import.structure.document HEADER.OBJ_TYPE=doc_obj_type import.structure. DOCUMENTHEADER.Obj_Type=doc_obj_type import export structure table value Java import.structure. DOCUMENTHEADER.OBJ_TYPE=obj_type import.structure. DOCUMENTHEADER.OBJ_TYPE= hash1_key1 Page 70 Copyright 2004 NTT All rights Reserved.

SAP BAPI SAP R/3 t-cd SE37 IMPORT EXPORT TABLE CHANGING CHANGING BAPI export structure table RETURN RETURN API RETURN BAPI 3.3 BAPI 3.3 No6,7,11,12 Page 71

intra-mart SAP 3.3 BapiController SAP R/3 API API BapiController API API BapiController BapiController API No 1 BapiController 2 putimportparam() import value BAPI 3 putstructparam() import structure value BAPI sturucture 4 puttableparam() import table value BAPI table table 5 executebapi() BAPI 6 issuccess() BAPI BAPI RETURN Type S true false 7 geterrmessage() BAPI Type S RETURN 8 getexportparam() export value 9 getstructureparam() export structure structure export 10 gettableparam() export table 1 2 table 1 export 2 11 getreturnlist() BAPI table RETURN 12 getreturn() BAPI structure RETURN Page 72 Copyright 2004 NTT All rights Reserved.

SAP 3.4 3.4.1 BAPI BAPI_COMPANYCODE_GETDETAIL sapapi_tutorial.properties 2.6.2 API Page 73

intra-mart SAP 3.4.2 t-cd SE37 BAPI_COMPANYCODE_GETDETAIL sapapi_tutorial.properties intra-mart C:/imart43/doc/imart /WEB-INF/classes sapapi_tutorial.properties # servertype= commit=false # (BAPI) bapiname=bapi_companycode_getdetail #import import.import.companycodeid=imp_key1 #structure export.structure.companycode_detail.comp_code=imp_str_key1 export.structure.companycode_detail.comp_name=imp_str_key2 export.structure.companycode_detail.city=imp_str_key3 export.structure.companycode_detail.country=imp_str_key4 export.structure.companycode_detail.currency=imp_str_key5 export.structure.companycode_detail.chrt_accts=imp_str_key6 export.structure.companycode_detail.fy_variant=imp_str_key7 Page 74 Copyright 2004 NTT All rights Reserved.

SAP 3.4.3 Page 75

SAP Page 77

SAP Page 79

intra-mart SAP structure BAPI_COMPANYCODE_GETDETAIL structure KEY export.structure. COMPANYCODE_DETAIL.COMP_CODE=imp_str_key1 COMPANYCODE_DETAIL table KEY export.structure.companycode_detail. COMP_CODE=imp_str_key1 value Page 80 Copyright 2004 NTT All rights Reserved.