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_DNAME

COLUMN_DTYPE

COLUMN_LENGTH

<your-service-account-name>

PA0000

PERNR

TABLE

PERSNO

N

8

<your-service-account-name>

PA0000

STAT2

TABLE

STAT2

C

1

<your-service-account-name>

PA0000

BEGDA

TABLE

BEGDA

D

8

<your-service-account-name>

PA0000

ENDDA

TABLE

ENDDA

D

8

<your-service-account-name>

PA0000

AEDTM

TABLE

AEDAT

D

8

<your-service-account-name>

PA0000

MASSN

TABLE

MASSN

C

2

<your-service-account-name>

PA0000

MASSG

TABLE

MASSG

C

2

<your-service-account-name>

HRP1001

OTYPE

TABLE

OTYPE

C

2

<your-service-account-name>

HRP1001

PLVAR

TABLE

PLVAR

C

2

<your-service-account-name>

HRP1001

SUBTY

TABLE

SUBTYP

C

4

<your-service-account-name>

HRP1001

OBJID

TABLE

HROBJID

N

10

<your-service-account-name>

HRP1001

SOBID

TABLE

SOBID

C

45

<your-service-account-name>

HRP1001

BEGDA

TABLE

BEGDATUM

D

8

<your-service-account-name>

HRP1001

ENDDA

TABLE

ENDDATUM

D

8

<your-service-account-name>

HRP1001

RELAT

TABLE

RELAT

C

3

<your-service-account-name>

HRP1001

ISTAT

TABLE

ISTAT_D

C

1

<your-service-account-name>

HRP1001

RSIGN

TABLE

RSIGN

C

1

<your-service-account-name>

HRP1001

SCLAS

TABLE

SCLAS

C

2

<your-service-account-name>

HRP1001

AEDTM

TABLE

AEDTM

D

8

<your-service-account-name>

PA0002

PERNR

TABLE

PERSNO

N

16

<your-service-account-name>

PA0002

NACHN

TABLE

PAD_NACHN

C

40

<your-service-account-name>

PA0002

BEGDA

TABLE

BEGDA

D

8

<your-service-account-name>

PA0002

AEDTM

TABLE

AEDAT

D

8

<your-service-account-name>

HRP1000

STEXT

TABLE

STEXT

C

40

<your-service-account-name>

HRP1000

OTYPE

TABLE

OTYPE

C

2

<your-service-account-name>

HRP1000

PLVAR

TABLE

PLVAR

C

2

<your-service-account-name>

HRP1000

OBJID

TABLE

HROBJID

N

8

<your-service-account-name>

HRP1000

ENDDA

TABLE

ENDDATUM

D

8

<your-service-account-name>

HRP1000

LANGU

TABLE

LANGU

C

1

<your-service-account-name>

PA0001

ORGEH

TABLE

ORGEH

N

8

<your-service-account-name>

PA0001

VDSK1

TABLE

VDSK1

C

14

<your-service-account-name>

PA0001

ABKRS

TABLE

ABKRS

C

2

<your-service-account-name>

PA0001

SACHA

TABLE

SACHA

C

3

<your-service-account-name>

PA0001

SACHP

TABLE

SACHP

C

3

<your-service-account-name>

PA0001

WERKS

TABLE

PERSA

C

4

<your-service-account-name>

PA0001

PLANS

TABLE

PLANS

N

8

<your-service-account-name>

PA0001

GSBER

TABLE

GSBER

C

4

<your-service-account-name>

PA0001

BUKRS

TABLE

BUKRS

C

4

<your-service-account-name>

PA0001

KOSTL

TABLE

KOSTL

C

10

<your-service-account-name>

PA0001

PERSG

TABLE

PERSG

C

1

<your-service-account-name>

PA0001

PERSK

TABLE

PERSK

C

2

<your-service-account-name>

PA0001

STELL

TABLE

STELL

N

8

<your-service-account-name>

PA0001

JUPER

TABLE

JUPER

C

4

<your-service-account-name>

PA0001

ENAME

TABLE

EMNAM

C

40

<your-service-account-name>

PA0001

BTRTL

TABLE

BTRTL

C

4

<your-service-account-name>

PA0001

ANSVH

TABLE

ANSVH

C

2

<your-service-account-name>

PA0001

SACHZ

TABLE

SACHZ

C

3

<your-service-account-name>

PA0001

SBMOD

TABLE

SBMOD

C

4

<your-service-account-name>

PA0001

KOKRS

TABLE

KOKRS

C

4

<your-service-account-name>

PA0001

BEGDA

TABLE

BEGDA

D

8

<your-service-account-name>

PA0001

ENDDA

TABLE

ENDDA

D

8

<your-service-account-name>

PA0001

PERNR

TABLE

PERSNO

N

8

<your-service-account-name>

PA0001

AEDTM

TABLE

AEDAT

D

8

<your-service-account-name>

T529T

MASSN

TABLE

MASSN

C

2

<your-service-account-name>

T529T

MNTXT

TABLE

MNTXT

C

30

<your-service-account-name>

T529T

SPRSL

TABLE

SPRAS

C

1

<your-service-account-name>

T530T

MASSN

TABLE

MASSN

C

2

<your-service-account-name>

T530T

MGTXT

TABLE

MGTXT

C

30

<your-service-account-name>

T530T

SPRSL

TABLE

SPRAS

C

1

<your-service-account-name>

T530T

MASSG

TABLE

MASSG

C

2

<your-service-account-name>

PA0105

AEDTM

TABLE

AEDAT

D

8

<your-service-account-name>

PA0105

BEGDA

TABLE

BEGDA

D

8

<your-service-account-name>

PA0105

PERNR

TABLE

PERSNO

N

8

<your-service-account-name>

PA0006

AEDTM

TABLE

AEDAT

D

8

<your-service-account-name>

PA0006

BEGDA

TABLE

BEGDA

D

8

<your-service-account-name>

PA0006

PERNR

TABLE

PERSNO

N

8

<your-service-account-name>

PA0709

AEDTM

TABLE

AEDAT

D

8

<your-service-account-name>

PA0709

BEGDA

TABLE

BEGDA

D

8

<your-service-account-name>

PA0709

PERNR

TABLE

PERSNO

N

8

<your-service-account-name>

PA0709

PERSONID_EXT

TABLE

PERSONID_EXT

C

20