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

Size: px

Start display at page:

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

きのこりゅうとう
5 years ago
Views:

1 ERP SAP R/3 API

3 2004/10/ /12/17 SAP

5 SAP SAP API sap_auth_info.properties Key sap_auth_info.properties sap_auth_info.properties sap_auth_info.properties API API BAPI API BusinessAreaController API ControllingAreaController API CostCenterController API ProfitCenterController API CompanyController G/L API GlAccController API BankController API AccEmployeePayPostController API API Page i

7 SAP 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

9 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 intra-mart intra-mart StorageService intra-mart storage/basemodule/sample/sapmenu.txt Page 3

11 SAP G/L API API API API Page 5

12 intra-mart SAP 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.

13 SAP 1.5 intra-mart BaseModule Ver4.3.3 Page 7

14 intra-mart SAP 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/ jco.client.poolsize R/3 5 8 jco.client.poolname R/3 default 9 jco.client.waittime jco.client.connectiontimeout jco.client.timeoutcheckperiod Page 8 Copyright 2004 NTT All rights Reserved.

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

17 SAP 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= jco.client.timeoutcheckperiod= 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

18 intra-mart SAP 1.7 SAP R/3 API import BAPI SAP R/3 NUMC BAPI 0 API NUMC 10 import 5 BAPI 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 Page 12 Copyright 2004 NTT All rights Reserved.

19 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 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

20 intra-mart SAP 2.2 API 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.

21 SAP Page 15

23 SAP Page 17

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

27 SAP Page 21

29 SAP API Page 23

30 intra-mart SAP 2.4 API 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.

31 SAP Page 25

33 SAP Page 27

35 SAP API JP10 API Page 29

36 intra-mart SAP 2.5 API 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.

37 SAP Page 31

39 SAP Page 33

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

42 intra-mart SAP 2.6 API 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.

43 SAP Page 37

45 SAP Page 39

47 SAP 2.7 G/L API 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

49 SAP Page 43

51 SAP Page 45

53 SAP 2.8 API 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

55 SAP Page 49

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

58 intra-mart SAP 2.9 API 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() Page 52 Copyright 2004 NTT All rights Reserved.

59 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() 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

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

61 SAP Page 55

63 SAP Page 57

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

66 intra-mart SAP 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.

67 SAP API sap_auth_info.properties Page 61

69 SAP im_sapapi.js Page 63

70 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.

71 SAP API SAP R/3 BAPI BAPI Java.properties KEY NO KEY Page 65

73 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

75 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

76 intra-mart SAP 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.

77 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

78 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.

79 SAP BAPI BAPI_COMPANYCODE_GETDETAIL sapapi_tutorial.properties API Page 73

80 intra-mart SAP 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.

81 SAP Page 75

83 SAP Page 77

85 SAP Page 79

86 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.

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

ERP連携モジュールチュートリアル ERP 連携モジュール (SAP R/3 リアルタイム連携 API) チュートリアルガイド第 2 版 2006 年 12 月 6 日 SAP SAP R/3 SAP JCo 製品内に記載する SAP の製品 / サービス名はすべてドイツおよびその他の国における SAP AG の商標または登録商標です > 変更年月日変更内容 2006/09/29 初版 2006/12/06 第