Configuration Table For SAP HR/HCM

Insert the following data into the '/SAILPOIN/CONF' table:

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

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

The column allowed for fetching data.

The type of entity such as table, join, or any other. This is for a future purpose.

The data type of the column that is allowed.

Data element type of the column.

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

The 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_DTYPE

COLUMN_DNAME

COLUMN_LENGTH

<your-service-account-name>

PA0000

PERNR

TABLE

N

PERSNO

8

<your-service-account-name>

PA0000

STAT2

TABLE

C

STAT2

1

<your-service-account-name>

PA0000

BEGDA

TABLE

D

BEGDA

8

<your-service-account-name>

PA0000

ENDDA

TABLE

D

ENDDA

8

<your-service-account-name>

PA0000

AEDTM

TABLE

D

AEDAT

8

<your-service-account-name>

PA0000

MASSN

TABLE

C

MASSN

2

<your-service-account-name>

PA0000

MASSG

TABLE

C

MASSG

2

<your-service-account-name>

HRP1001

OTYPE

TABLE

C

OTYPE

2

<your-service-account-name>

HRP1001

PLVAR

TABLE

C

PLVAR

2

<your-service-account-name>

HRP1001

SUBTY

TABLE

C

SUBTYP

4

<your-service-account-name>

HRP1001

OBJID

TABLE

N

HROBJID

10

<your-service-account-name>

HRP1001

SOBID

TABLE

C

SOBID

45

<your-service-account-name>

HRP1001

BEGDA

TABLE

D

BEGDATUM

8

<your-service-account-name>

HRP1001

ENDDA

TABLE

D

ENDDATUM

8

<your-service-account-name>

HRP1001

RELAT

TABLE

C

RELAT

3

<your-service-account-name>

HRP1001

ISTAT

TABLE

C

ISTAT_D

1

<your-service-account-name>

HRP1001

RSIGN

TABLE

C

RSIGN

1

<your-service-account-name>

HRP1001

SCLAS

TABLE

C

SCLAS

2

<your-service-account-name>

HRP1001

AEDTM

TABLE

D

AEDTM

8

<your-service-account-name>

PA0002

PERNR

TABLE

N

PERSNO

16

<your-service-account-name>

PA0002

NACHN

TABLE

C

PAD_NACHN

40

<your-service-account-name>

PA0002

BEGDA

TABLE

D

BEGDA

8

<your-service-account-name>

PA0002

AEDTM

TABLE

D

AEDAT

8

<your-service-account-name>

HRP1000

STEXT

TABLE

C

STEXT

40

<your-service-account-name>

HRP1000

OTYPE

TABLE

C

OTYPE

2

<your-service-account-name>

HRP1000

PLVAR

TABLE

C

PLVAR

2

<your-service-account-name>

HRP1000

OBJID

TABLE

N

HROBJID

8

<your-service-account-name>

HRP1000

ENDDA

TABLE

D

ENDDATUM

8

<your-service-account-name>

HRP1000

LANGU

TABLE

C

LANGU

1

<your-service-account-name>

PA0001

ORGEH

TABLE

N

ORGEH

8

<your-service-account-name>

PA0001

VDSK1

TABLE

C

VDSK1

14

<your-service-account-name>

PA0001

ABKRS

TABLE

C

ABKRS

2

<your-service-account-name>

PA0001

SACHA

TABLE

C

SACHA

3

<your-service-account-name>

PA0001

SACHP

TABLE

C

SACHP

3

<your-service-account-name>

PA0001

WERKS

TABLE

C

PERSA

4

<your-service-account-name>

PA0001

PLANS

TABLE

N

PLANS

8

<your-service-account-name>

PA0001

GSBER

TABLE

C

GSBER

4

<your-service-account-name>

PA0001

BUKRS

TABLE

C

BUKRS

4

<your-service-account-name>

PA0001

KOSTL

TABLE

C

KOSTL

10

<your-service-account-name>

PA0001

PERSG

TABLE

C

PERSG

1

<your-service-account-name>

PA0001

PERSK

TABLE

C

PERSK

2

<your-service-account-name>

PA0001

STELL

TABLE

N

STELL

8

<your-service-account-name>

PA0001

JUPER

TABLE

C

JUPER

4

<your-service-account-name>

PA0001

ENAME

TABLE

C

EMNAM

40

<your-service-account-name>

PA0001

BTRTL

TABLE

C

BTRTL

4

<your-service-account-name>

PA0001

ANSVH

TABLE

C

ANSVH

2

<your-service-account-name>

PA0001

SACHZ

TABLE

C

SACHZ

3

<your-service-account-name>

PA0001

SBMOD

TABLE

C

SBMOD

4

<your-service-account-name>

PA0001

KOKRS

TABLE

C

KOKRS

4

<your-service-account-name>

PA0001

BEGDA

TABLE

D

BEGDA

8

<your-service-account-name>

PA0001

ENDDA

TABLE

D

ENDDA

8

<your-service-account-name>

PA0001

PERNR

TABLE

N

PERSNO

8

<your-service-account-name>

PA0001

AEDTM

TABLE

D

AEDAT

8

<your-service-account-name>

T529T

MASSN

TABLE

C

MASSN

2

<your-service-account-name>

T529T

MNTXT

TABLE

C

MNTXT

30

<your-service-account-name>

T529T

SPRSL

TABLE

C

SPRAS

1

<your-service-account-name>

T530T

MASSN

TABLE

C

MASSN

2

<your-service-account-name>

T530T

MGTXT

TABLE

C

MGTXT

30

<your-service-account-name>

T530T

SPRSL

TABLE

C

SPRAS

1

<your-service-account-name>

T530T

MASSG

TABLE

C

MASSG

2

<your-service-account-name>

PA0105

AEDTM

TABLE

D

AEDAT

8

<your-service-account-name>

PA0105

BEGDA

TABLE

D

BEGDA

8

<your-service-account-name>

PA0105

PERNR

TABLE

N

PERSNO

8

<your-service-account-name>

PA0006

AEDTM

TABLE

D

AEDAT

8

<your-service-account-name>

PA0006

BEGDA

TABLE

D

BEGDA

8

<your-service-account-name>

PA0006

PERNR

TABLE

N

PERSNO

8

<your-service-account-name>

PA0709

AEDTM

TABLE

D

AEDAT

8

<your-service-account-name>

PA0709

BEGDA

TABLE

D

BEGDA

8

<your-service-account-name>

PA0709

PERNR

TABLE

N

PERSNO

8

<your-service-account-name>

PA0709

PERSONID_EXT

TABLE

C

PERSONID_EXT

20