Authorization and Permissions - EcoSys - Help - Hexagon

EcoSys SAP Adapter Help

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
9.1

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