Configuration Table for SAP Direct

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

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.

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

<your-service-account-name>

AGR_TEXTS

AGR_NAME

TABLE

AGR_NAME

C

30

<your-service-account-name>

AGR_TEXTS

LINE

TABLE

MENU_NUM_S

N

5

<your-service-account-name>

AGR_TEXTS

SPRAS

TABLE

MENU_SPRAS

C

1

<your-service-account-name>

AGR_TEXTS

TEXT

TABLE

AGR_TITLE

C

80

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