Configuration Table for SAP Direct

Insert the below data into the /SAILPOIN/CONF table:

This is the allowed service account to be used for accessing FM.

Name of entity from which data is fetched. For now we can consider it as a table name.

Column allowed for fetching data

Type of entity such as table, join, or any other. This is for future purposes.

Data type of the column that is allowed.

Data element type of the column.

Data element type can be found by using t-code SE11 when viewing the table details under the Fields tab.

Length of the allowed column.

The Length can be found by using t-code SE11 when viewing the table’s details, under the Fields tab.

Note
Validate that the values for COLUMN_DENAME and COLUMN_LENGTH are correct as per your system. These can be validated through the t-code SE11 while viewing the table details under the Fields tab.

Setup

  • Enter t-code SE38 and then create program Z_CONFIGURE_SERVICEACCOUNT in the local object package and type as an executable program.

  • Copy and paste the script provided HERE and activate the program.

  • For better readability of the input parameters edit the selection text from Go to > Text Element > Selection Text and update it as shown in the following image.

  • Save and then activate the program.

How it works

  • Enter t-code SE38 and then search for program Z_CONFIGURE_SERVICEACCOUNT. Select execute.

  • Enter the service account and integration module to be populated respectively.

  • Once you have entered the details correctly, select execute and you will see a success message.

Enter Se16 > Table Name: /SAILPOIN/CONF > Create Entries

The option to enter the data into the table will appear.

SERVICE_ACCOUNT

NAME

COLUMNNAME

ENTITY_TYPE

COLUMN_DNAME

COLUMN_DTYPE

COLUMN_LENGTH

<your-service-account-name>

AGR_1251

AGR_NAME

TABLE

AGR_NAME

C

10

<your-service-account-name>

AGR_1251

DELETED

TABLE

TPR_ST_DEL

C

40

<your-service-account-name>

AGR_1251

FIELD

TABLE

AGRFIELD

C

40

<your-service-account-name>

AGR_1251

HIGH

TABLE

AGVAL

C

40

<your-service-account-name>

AGR_1251

LOW

TABLE

AGVAL

C

30

<your-service-account-name>

AGR_1251

OBJECT

TABLE

AGOBJECT

C

40

<your-service-account-name>

AGR_1252

AGR_NAME

TABLE

AGR_NAME

C

40

<your-service-account-name>

AGR_1252

HIGH

TABLE

AGVAL

C

40

<your-service-account-name>

AGR_1252

LOW

TABLE

AGVAL

C

30

<your-service-account-name>

AGR_1252

VARBL

TABLE

AGRORGVAR

C

30

<your-service-account-name>

AGR_DEFINE

AGR_NAME

TABLE

AGR_NAME

C

10

<your-service-account-name>

AGR_FLAGS

AGR_NAME

TABLE

AGR_NAME

C

30

<your-service-account-name>

AGR_FLAGS

FLAG_TYPE

TABLE

FLAG_TYPE

C

30

<your-service-account-name>

AGR_FLAGS

FLAG_VALUE

TABLE

AGR_ATT2

C

12

<your-service-account-name>

AGR_PROF

AGR_NAME

TABLE

AGR_NAME

C

30

<your-service-account-name>

AGR_PROF

PROFILE

TABLE

XUPROFILE

C

48

<your-service-account-name>

AGR_TCODES

AGR_NAME

TABLE

AGR_NAME

C

01

<your-service-account-name>

AGR_TCODES

TCODE

TABLE

AGXREPORT

C

02

<your-service-account-name>

AGR_TCODES

TYPE

TABLE

REPORTTYPE

C

02

<your-service-account-name>

TUTYP

LANGU

TABLE

SPRAS

C

01

<your-service-account-name>

TUTYP

USERTYP

TABLE

USERTYPEN

C

02

<your-service-account-name>

TUTYP

UTYPLONGTEXT

TABLE

SLIM_LONG_TEXT55

C

55

<your-service-account-name>

TUTYP

UTYPTEXT

TABLE

UTYPTEXT

C

30

<your-service-account-name>

TUTYPA

ACTIVE

TABLE

RSUVMFLAG

C

01

<your-service-account-name>

TUTYPA

USERTYP

TABLE

USERTYPEN

C

02

<your-service-account-name>

USR02

BNAME

TABLE

XUBNAME

C

12

<your-service-account-name>

USR02

LTIME

TABLE

XULTIME

T

06

<your-service-account-name>

USR02

PWDSTATE

TABLE

PWDCHGSTATE

B

03

<your-service-account-name>

USR02

TRDAT

TABLE

XULDATE

D

08

<your-service-account-name>

USR11

LANGU

TABLE

SPRAS

C

02

<your-service-account-name>

USR11

PROFN

TABLE

XUPROFNAME

C

12

<your-service-account-name>

USR11

PTEXT

TABLE

XUTEXT

C

60

<your-service-account-name>

USR11

TRDAT

TABLE

SPRAS

C

01

<your-service-account-name>

USRSYSACTT

AGR_NAME

TABLE

F_AGR_NAME

C

30

<your-service-account-name>

USRSYSACTT

LANGU

TABLE

LANGU

C

01

<your-service-account-name>

USRSYSACTT

SUBSYSTEM

TABLE

RFCRCVSYS

C

10

<your-service-account-name>

USRSYSACTT

TEXT

TABLE

AGR_TITLE

C

80

<your-service-account-name>

USRSYSPRF

TYP

TABLE

XUTYP

C

01

<your-service-account-name>

USRSYSPRFT

LANGU

TABLE

LANGU

C

01

<your-service-account-name>

USRSYSPRFT

PROFN

TABLE

XUPROFNAME

C

12

<your-service-account-name>

USRSYSPRFT

PTEXT

TABLE

XUTEXT

C

60

<your-service-account-name>

UST10C

PROFN

TABLE

XUPROFILE

C

12

<your-service-account-name>

UST10C

SUBPROF

TABLE

XUPROFILE

C

12

<your-service-account-name>

UST10S

PROFN

TABLE

XUPROFILE

C

12

<your-service-account-name>

USRSYSACT

SUBSYSTEM

TABLE

RFCRCVSYS

C

10

<your-service-account-name>

USRSYSACT

AGR_NAME

TABLE

F_AGR_NAME

C

30

<your-service-account-name>

USRSYSACT

COL_AGR

TABLE

XUFLAG

C

4

For Group Aggregation in CUA systems, additional permissions are required as follows:

SERVICE_ACCOUNT

NAME

COLUMNNAME

ENTITY_TYPE

COLUMN_DNAME

COLUMN_DTYPE

COLUMN_LENGTH

<your-service-account-name>

USRSYSPRF

SUBSYSTEM

TABLE

RFCRCVSYS

C

10

<your-service-account-name>

USRSYSPRF

PROFN

TABLE

XUPROFNAME

C

12