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.

/SAILPOIN/CONF
table using script:
Setup
-
Enter t-code
SE38
and then create programZ_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 programZ_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.

/SAILPOIN/CONF
table through the t-code SE16
:
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 |