For EcoSys to access SAP, you must create a service account in SAP for the EcoSys interface to use when connecting to SAP. When configuring EcoSys to connect to SAP, the following information is required:
Parameter Description |
Parameter Name |
Example Value |
---|---|---|
Login user name for the SAP service account |
username |
ECOSYS |
Password for the SAP service account |
password |
secretPassword123 |
Client number for SAP connection |
sapClient |
300 |
Language specifier for SAP API |
language |
EN |
Host name or IP address of SAP BAPI server |
hostName |
192.168.20.20 |
System number for SAP connection |
systemNumber |
00 |
Metadata repository to use when connecting |
repository |
EcoSys |
Alias for RFC_READ_TABLE function (optional) * |
rfcReadTableAlias |
ZRFC_READ_TABLE |
* This parameter is optional. You only need to specify it for configurations requiring an alias for the built-in RFC_READ_TABLE function call. Otherwise, you may omit it..
The account permissions that this service requires are listed below.
RFC_READ_TABLE for tables:
-
AFKO (Order header)
-
AFPO (Order Item)
-
AFVC (Activity)
-
AUFK (Network)
-
BPVG (Budget Line Item)
-
BPVJ (Budget Line Item)
-
CAUFV (Order Header)
-
COVP (CO Document header)
-
COEJ (CO Line Item)
-
COVP (Actual line item)
-
COOI (Commitment)
-
COSS (Cost Totals for Internal Postings)
-
COSP (Cost Totals for External Postings)
-
EKKO (Purchasing Document Header)
-
EKPO (Purchasing Document Item)
-
LFA1 (Vendor)
-
M_AUKOF (Network/Order Matchcode)
-
PA0001 (HR Master)
-
PROJ (Project Definition)
-
PRPS (WBS)
-
T001 (Company Code)
-
TCJED (Project Mask)
-
TKA01 (Controlling Area)
-
CATSDB (Timesheets)
-
CATSCO (Timesheets Approved for WBS and Networks)
-
CATSPS (Timesheets Approved for Activities)
-
CATSMM (External/Materials Management Hours for WBS)
-
T554T (Attendance/Absence Types)
-
EKKN(Account Assignment in Purchasing Document)
-
CDHDR (Change Document Header)
-
T052U (Own Explanations for Terms of Payment)
BAPI calls:
-
BAPI_BUS2054_SET_STATUS
-
BAPI_PS_PRECOMMIT
-
BAPI_TRANSACTION_COMMIT
-
BAPI_BUS2054_GET_STATUS
-
BAPI_COSTELEM_GETLIST
-
BAPI_PROJECT_GETINFO
-
BAPI_COSTACTPLN_POSTPRIMCOST
-
BAPI_PROJECT_MAINTAIN
-
BAPI_NETWORK_MAINTAIN
-
BAPI_BUS2001_GET_STATUS
-
BAPI_BUS2002_GET_STATUS
-
BAPI_PS_INITIALIZATION
-
RFC_READ_TEXT
-
RSA0_CONVERSION_EXIT
The following section lists the specific BAPIs and tables used by each interface operation:
Import Cost Objects (WBS):
-
BAPI_PROJECT_GETINFO
-
BAPI_BUS2054_GET_STATUS
-
BAPI_BUS2001_GET_STATUS
-
BAPI_BUS2002_GET_STATUS
-
RFC_READ_TABLE: M_AUKOF, AFKO, AUFK, AFVC, AFPO, CAUFV, TCJED, TKA01,PRPS,IHPA
Import Actuals, Posted Line Items:
-
RFC_READ_TABLE: COVP, COVP, EKKO, LFA1, PRPS, M_AUKOF, AFKO, AUFK, AFVC, AFPO, CAUFV, TCJED, TKA01
-
BAPI_PROJECT_GETINFO
Import Actuals, CATS Timesheets:
-
RFC_READ_TABLE: PRPS, M_AUKOF, AFKO, AUFK, AFVC, AFPO, CAUFV, TCJED, TKA01, CATSDB, CATSCO, CATSPS, CATSMM, T554T
-
BAPI_PROJECT_GETINFO
Import Forecast, Commitments:
-
RFC_READ_TABLE: EKPO, COOI, M_AUKOF, AFKO, AUFK, AFVC, AFPO, CAUFV, TCJED, TKA01, EKPO, EKKO, EKKN, CDHDR, T052U
-
BAPI_PROJECT_GETINFO
-
RFC_READ_TEXT
Import Forecast, Planned Cost Totals:
-
BAPI_COSTELEM_GETLIST
-
BAPI_PROJECT_GETINFO
-
RFC_READ_TABLE: M_AUKOF, AFKO, AUFK, AFVC, AFPO, CAUFV, TCJED, TKA01, T001, COSS, COSP
Import Forecast, Planned:
-
BAPI_COSTELEM_GETLIST
-
RFC_READ_TABLE: COEJ, T001, TKA01
Export Cost Objects:
-
BAPI_PROJECT_MAINTAIN
-
BAPI_NETOWRK_MAINTAIN
-
BAPI_BUS2054_SET_STATUS
-
BAPI_COSTACTPLN_POSTPRIMCOST
-
BAPI_TRANSACTION_COMMIT
-
BAPI_PS_INITIALIZATION
-
BAPI_PS_PRECOMMIT
Export Forecast:
-
BAPI_COSTACTPLN_POSTPRIMCOST