Configuration Table For SAP HR/HCM
Insert the following 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> |
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 |