Syntax

2. import com.sap.mw.jco.*;

3. public class Bapi2 extends Object {

4.    JCO.Client mConnection;

5.    JCO.Repository mRepository;

6.    public TutorialBapi2() {

7.       try {

8.         // Change the logon information to your own system/user

9.         mConnection =

10.           JCO.createClient("001", // SAP client

11.             "<userid>", // userid

12.             "****", // password

13.             null, // language

14.             "<hostname>", // application server host name

15.             "00"); // system number

16.         mConnection.connect();

17.         mRepository = new JCO.Repository("ARAsoft", mConnection);

18.      }

19.      catch (Exception ex) {

20.        ex.printStackTrace();

21.        System.exit(1);

22.      }

23.      JCO.Function function = null;

24.      JCO.Table codes = null;

25.        try {

26.          function = this.createFunction("BAPI_COMPANYCODE_GETLIST");

27.          if (function == null) {

28.            System.out.println("BAPI_COMPANYCODE_GETLIST" +

29.                               " not found in SAP.");

30.            System.exit(1);

31.          }

32.          mConnection.execute(function);

33.          JCO.Structure returnStructure =

34.            function.getExportParameterList().getStructure("RETURN");

35.          if (! (returnStructure.getString("TYPE").equals("") ||

36.                 returnStructure.getString("TYPE").equals("S")) ) {

37.            System.out.println(returnStructure.getString("MESSAGE"));

38.            System.exit(1);

39.          }

40.          codes =

41.            function.getTableParameterList().getTable("COMPANYCODE_LIST");

42.          codes.setRow(2);

43. codes.deleteRow();

44. codes.deleteRow(5);

45. codes.appendRow();

46. codes.setValue("XXXX", "COMP_CODE");

47. codes.setValue("Does not exist", "COMP_NAME");

48. codes.appendRows(2);

49. codes.setValue("YYYY", "COMP_CODE");

50. codes.setValue("Does not exist either", "COMP_NAME");

51. codes.nextRow();

52. codes.setValue("ZZZZ", "COMP_CODE");

53. codes.setValue("Nor does this", "COMP_NAME");

54. for (int i = 0; i < codes.getNumRows(); i++) {

55. codes.setRow(i);

56.            System.out.println(codes.getString("COMP_CODE") + '\t' +

57.                               codes.getString("COMP_NAME"));

58.          }

59.        }

60.        catch (Exception ex) {

61.          ex.printStackTrace();

62.          System.exit(1);

63.        }

64.        try {

65.          codes.firstRow();

66.          for (int i = 0; i < codes.getNumRows(); i++, codes.nextRow()) {

67.            function = this.createFunction("BAPI_COMPANYCODE_GETDETAIL");

68.            if (function == null) {

69.              System.out.println("BAPI_COMPANYCODE_GETDETAIL" +

70.                                 " not found in SAP.");

71.              System.exit(1);

72.            }

73.            function.getImportParameterList().

74.              setValue(codes.getString("COMP_CODE"), "COMPANYCODEID");

75.            mConnection.execute(function);

76.            JCO.Structure returnStructure =

77.              function.getExportParameterList().getStructure("RETURN");

78.            if (! (returnStructure.getString("TYPE").equals("") ||

79.                   returnStructure.getString("TYPE").equals("S") ||

80.                   returnStructure.getString("TYPE").equals("W")) ) {

81.              System.out.println(returnStructure.getString("MESSAGE"));

82.            }

83.            JCO.Structure detail =

84.              function.getExportParameterList().

85.              getStructure("COMPANYCODE_DETAIL");

86.            System.out.println(detail.getString("COMP_CODE") + '\t' +

87.                               detail.getString("COUNTRY") + '\t' +

88.                               detail.getString("CITY"));

89.         }

90.       }

91.       catch (Exception ex) {

92.         ex.printStackTrace();

93.         System.exit(1);

94.       }

95.       mConnection.disconnect();

96.     }

97.     public JCO.Function createFunction(String name) throws Exception {

98.       try {

99.         IFunctionTemplate ft =

100.           mRepository.getFunctionTemplate(name.toUpperCase());

101.         if (ft == null)

102.           return null;

103.         return ft.getFunction();

104.      }

105.      catch (Exception ex) {

106.        throw new Exception("Problem retrieving JCO.Function object.");

107.      }

108.    }

109.    public static void main (String args[]) {

110.      Bapi2 app = new Bapi2();

111.    }

112. }