SAP table HCMT_BSP_PA_SG_R0181 (Screen 2000 for Singapore additional funds)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| OBJECT_KEY | HCM Object Key | CHAR | 100 | 0 | HCM_OBJECT_KEY | ||||||
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||||||
| AEDTM | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||
| UNAME | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||
| SPRPS | Lock Indicator for HR Master Data Record | CHAR | 1 | 0 | SPRPS | ||||||
| SPRTX | Lock indicator for HR master record (text) | CHAR | 40 | 0 | SPRPSTEXT | ||||||
| ITBLD | Infotype Screen Control | CHAR | 2 | 0 | ITBLD | ||||||
| ITXEX | Text Exists for Infotype | CHAR | 1 | 0 | ITXEX | ||||||
| BEGDA | Valid-From Date | DATS | 8 | 0 | PAD_BEGDA | ||||||
| ENDDA | Valid To Date | DATS | 8 | 0 | PAD_ENDDA | ||||||
| SIGRP | Institution of soc. provident funds SG | CHAR | 2 | 0 | T5R1A | P25M_SIGRP | |||||
| SISRT | Short text for the institution of social insurance | CHAR | 3 | 0 | P25M_SISRT | ||||||
| SIGTX | Text for SI-institution SG | CHAR | 25 | 0 | P25M_SIGTX | ||||||
| ADID1 | Fund type | CHAR | 2 | 0 | T5R1S | P25M_FUNTY | |||||
| ADNA1 | Fund name | CHAR | 5 | 0 | P25M_FUNDN | ||||||
| FUNTX1 | Text not found | CHAR | 30 | 0 | P25M_ENTTX | ||||||
| BETR1 | Amount | CURR | 9 | 2 | BETRG | ||||||
| WAER1 | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||
| ADID2 | Fund type | CHAR | 2 | 0 | T5R1S | P25M_FUNTY | |||||
| ADNA2 | Fund name | CHAR | 5 | 0 | P25M_FUNDN | ||||||
| FUNTX2 | Text not found | CHAR | 30 | 0 | P25M_ENTTX | ||||||
| BETR2 | Amount | CURR | 9 | 2 | BETRG | ||||||
| WAER2 | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||
| ADID3 | Fund type | CHAR | 2 | 0 | T5R1S | P25M_FUNTY | |||||
| ADNA3 | Fund name | CHAR | 5 | 0 | P25M_FUNDN | ||||||
| FUNTX3 | Text not found | CHAR | 30 | 0 | P25M_ENTTX | ||||||
| BETR3 | Amount | CURR | 9 | 2 | BETRG | ||||||
| WAER3 | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||
| ADID4 | Fund type | CHAR | 2 | 0 | T5R1S | P25M_FUNTY | |||||
| ADNA4 | Fund name | CHAR | 5 | 0 | P25M_FUNDN | ||||||
| FUNTX4 | Text not found | CHAR | 30 | 0 | P25M_ENTTX | ||||||
| BETR4 | Amount | CURR | 9 | 2 | BETRG | ||||||
| WAER4 | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||
| ADID5 | Fund type | CHAR | 2 | 0 | T5R1S | P25M_FUNTY | |||||
| ADNA5 | Fund name | CHAR | 5 | 0 | P25M_FUNDN | ||||||
| FUNTX5 | Text not found | CHAR | 30 | 0 | P25M_ENTTX | ||||||
| BETR5 | Amount | CURR | 9 | 2 | BETRG | ||||||
| WAER5 | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||
| BETR6 | Mosque Building fund | CURR | 9 | 2 | PSG_UI_FUND_MOSQUE | ||||||
| WAER6 | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||
| BETR7 | Mendaki fund | CURR | 9 | 2 | PSG_UI_FUND_MENDAKI | ||||||
| WAER7 | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||
| PYAL1 | Pay alternative (wage-dependant) | CHAR | 1 | 0 | PSG_UI_PWAGE_DEP |
|
|||||
| PYAL3 | Pay alternative (wage-dependant) | CHAR | 1 | 0 | PSG_UI_PWAGE_DEP |
|
|||||
| PYAL5 | Pay alternative (wage-dependant) | CHAR | 1 | 0 | PSG_UI_PWAGE_DEP |
|
|||||
| PYAL7 | Pay alternative (wage-dependant) | CHAR | 1 | 0 | PSG_UI_PWAGE_DEP |
|
|||||
| PYAL9 | Pay alternative (wage-dependant) | CHAR | 1 | 0 | PSG_UI_PWAGE_DEP |
|
HCMT_BSP_PA_SG_R0181 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 HCMT_BSP_PA_SG_R0181 | ADID1 | T5R1S | Text for fund indicator /SG | SPRSL |
| 0 HCMT_BSP_PA_SG_R0181 | ADID1 | T5R1S | Text for fund indicator /SG | SIGRP |
| 0 HCMT_BSP_PA_SG_R0181 | ADID1 | T5R1S | Text for fund indicator /SG | FUNTY |
| 1 HCMT_BSP_PA_SG_R0181 | ADID2 | T5R1S | Text for fund indicator /SG | SPRSL |
| 1 HCMT_BSP_PA_SG_R0181 | ADID2 | T5R1S | Text for fund indicator /SG | SIGRP |
| 1 HCMT_BSP_PA_SG_R0181 | ADID2 | T5R1S | Text for fund indicator /SG | FUNTY |
| 0 HCMT_BSP_PA_SG_R0181 | ADID3 | T5R1S | Text for fund indicator /SG | SPRSL |
| 0 HCMT_BSP_PA_SG_R0181 | ADID3 | T5R1S | Text for fund indicator /SG | SIGRP |
| 0 HCMT_BSP_PA_SG_R0181 | ADID3 | T5R1S | Text for fund indicator /SG | FUNTY |
| 1 HCMT_BSP_PA_SG_R0181 | ADID4 | T5R1S | Text for fund indicator /SG | SPRSL |
| 1 HCMT_BSP_PA_SG_R0181 | ADID4 | T5R1S | Text for fund indicator /SG | SIGRP |
| 1 HCMT_BSP_PA_SG_R0181 | ADID4 | T5R1S | Text for fund indicator /SG | FUNTY |
| 0 HCMT_BSP_PA_SG_R0181 | ADID5 | T5R1S | Text for fund indicator /SG | SPRSL |
| 0 HCMT_BSP_PA_SG_R0181 | ADID5 | T5R1S | Text for fund indicator /SG | SIGRP |
| 0 HCMT_BSP_PA_SG_R0181 | ADID5 | T5R1S | Text for fund indicator /SG | FUNTY |
| 1 HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1A | Institution of Soc. Provident Funds SG | SIGRP |
| 1 HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1A | Institution of Soc. Provident Funds SG | SIOFC |
| 1 HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1A | Institution of Soc. Provident Funds SG | ENDDA |
| 0 HCMT_BSP_PA_SG_R0181 | WAER1 | TCURC | Currency Codes | MANDT |
| 0 HCMT_BSP_PA_SG_R0181 | WAER1 | TCURC | Currency Codes | WAERS |
| 1 HCMT_BSP_PA_SG_R0181 | WAER2 | TCURC | Currency Codes | MANDT |
| 1 HCMT_BSP_PA_SG_R0181 | WAER2 | TCURC | Currency Codes | WAERS |
| 0 HCMT_BSP_PA_SG_R0181 | WAER3 | TCURC | Currency Codes | MANDT |
| 0 HCMT_BSP_PA_SG_R0181 | WAER3 | TCURC | Currency Codes | WAERS |
| 1 HCMT_BSP_PA_SG_R0181 | WAER4 | TCURC | Currency Codes | MANDT |
| 1 HCMT_BSP_PA_SG_R0181 | WAER4 | TCURC | Currency Codes | WAERS |
| 0 HCMT_BSP_PA_SG_R0181 | WAER5 | TCURC | Currency Codes | MANDT |
| 0 HCMT_BSP_PA_SG_R0181 | WAER5 | TCURC | Currency Codes | WAERS |
| 1 HCMT_BSP_PA_SG_R0181 | WAER6 | TCURC | Currency Codes | MANDT |
| 1 HCMT_BSP_PA_SG_R0181 | WAER6 | TCURC | Currency Codes | WAERS |
| 0 HCMT_BSP_PA_SG_R0181 | WAER7 | TCURC | Currency Codes | MANDT |
| 0 HCMT_BSP_PA_SG_R0181 | WAER7 | TCURC | Currency Codes | WAERS |