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 purpose.

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 column that is allowed.

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.

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

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

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.

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>

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