SAP Table HCMT_BSP_PA_SG_R0181
Screen 2000 for Singapore additional funds
HCMT_BSP_PA_SG_R0181 (Screen 2000 for Singapore additional funds) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link HCMT_BSP_PA_SG_R0181 to other SAP tables.
Source: HCMT_BSP_PA_SG_R0181 (Screen 2000 for Singapore additional funds)
HCMT_BSP_PA_SG_R0181 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OBJECT_KEY | HCM Object Key | HCM_OBJECT_KEY | CHAR | 100 | 0 | |||||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||
| AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||
| UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
| SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||
| SPRTX | Lock indicator for HR master record (text) | SPRPSTEXT | CHAR | 40 | 0 | |||||||
| ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||
| BEGDA | Valid-From Date | PAD_BEGDA | DATS | 8 | 0 | |||||||
| ENDDA | Valid To Date | PAD_ENDDA | DATS | 8 | 0 | |||||||
| SIGRP | Institution of soc. provident funds SG | P25M_SIGRP | T5R1A | CHAR | 2 | 0 | ||||||
| SISRT | Short text for the institution of social insurance | P25M_SISRT | CHAR | 3 | 0 | |||||||
| SIGTX | Text for SI-institution SG | P25M_SIGTX | CHAR | 25 | 0 | |||||||
| ADID1 | Fund type | P25M_FUNTY | T5R1S | CHAR | 2 | 0 | ||||||
| ADNA1 | Fund name | P25M_FUNDN | CHAR | 5 | 0 | |||||||
| FUNTX1 | Text not found | P25M_ENTTX | CHAR | 30 | 0 | |||||||
| BETR1 | Amount | BETRG | CURR | 9 | 2 | |||||||
| WAER1 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| ADID2 | Fund type | P25M_FUNTY | T5R1S | CHAR | 2 | 0 | ||||||
| ADNA2 | Fund name | P25M_FUNDN | CHAR | 5 | 0 | |||||||
| FUNTX2 | Text not found | P25M_ENTTX | CHAR | 30 | 0 | |||||||
| BETR2 | Amount | BETRG | CURR | 9 | 2 | |||||||
| WAER2 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| ADID3 | Fund type | P25M_FUNTY | T5R1S | CHAR | 2 | 0 | ||||||
| ADNA3 | Fund name | P25M_FUNDN | CHAR | 5 | 0 | |||||||
| FUNTX3 | Text not found | P25M_ENTTX | CHAR | 30 | 0 | |||||||
| BETR3 | Amount | BETRG | CURR | 9 | 2 | |||||||
| WAER3 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| ADID4 | Fund type | P25M_FUNTY | T5R1S | CHAR | 2 | 0 | ||||||
| ADNA4 | Fund name | P25M_FUNDN | CHAR | 5 | 0 | |||||||
| FUNTX4 | Text not found | P25M_ENTTX | CHAR | 30 | 0 | |||||||
| BETR4 | Amount | BETRG | CURR | 9 | 2 | |||||||
| WAER4 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| ADID5 | Fund type | P25M_FUNTY | T5R1S | CHAR | 2 | 0 | ||||||
| ADNA5 | Fund name | P25M_FUNDN | CHAR | 5 | 0 | |||||||
| FUNTX5 | Text not found | P25M_ENTTX | CHAR | 30 | 0 | |||||||
| BETR5 | Amount | BETRG | CURR | 9 | 2 | |||||||
| WAER5 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| BETR6 | Mendaki fund | PSG_UI_FUND_MENDAKI | CURR | 9 | 2 | |||||||
| WAER6 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| BETR7 | Mosque Building fund | PSG_UI_FUND_MOSQUE | CURR | 9 | 2 | |||||||
| WAER7 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| PYAL1 | Pay alternative (wage-dependant) | PSG_UI_PWAGE_DEP | CHAR | 1 | 0 |
Possible values
|
||||||
| PYAL3 | Pay alternative (wage-dependant) | PSG_UI_PWAGE_DEP | CHAR | 1 | 0 |
Possible values
|
||||||
| PYAL5 | Pay alternative (wage-dependant) | PSG_UI_PWAGE_DEP | CHAR | 1 | 0 |
Possible values
|
||||||
| PYAL7 | Pay alternative (wage-dependant) | PSG_UI_PWAGE_DEP | CHAR | 1 | 0 |
Possible values
|
||||||
| PYAL9 | Pay alternative (wage-dependant) | PSG_UI_PWAGE_DEP | CHAR | 1 | 0 |
Possible values
|
||||||
HCMT_BSP_PA_SG_R0181 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| HCMT_BSP_PA_SG_R0181 | ADID1 | HCMT_BSP_PA_SG_R0181 | ADID1 | T5R1S | Text for fund indicator /SG | FUNTY |
| HCMT_BSP_PA_SG_R0181 | ADID1 | '2' | T5R1S | Text for fund indicator /SG | FUNCL | |
| HCMT_BSP_PA_SG_R0181 | ADID1 | HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1S | Text for fund indicator /SG | SIGRP |
| HCMT_BSP_PA_SG_R0181 | ADID1 | * | T5R1S | Text for fund indicator /SG | SPRSL | |
| HCMT_BSP_PA_SG_R0181 | ADID1 | SYST | MANDT | T5R1S | Text for fund indicator /SG | MANDT |
| HCMT_BSP_PA_SG_R0181 | ADID2 | * | T5R1S | Text for fund indicator /SG | SPRSL | |
| HCMT_BSP_PA_SG_R0181 | ADID2 | SYST | MANDT | T5R1S | Text for fund indicator /SG | MANDT |
| HCMT_BSP_PA_SG_R0181 | ADID2 | HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1S | Text for fund indicator /SG | SIGRP |
| HCMT_BSP_PA_SG_R0181 | ADID2 | '2' | T5R1S | Text for fund indicator /SG | FUNCL | |
| HCMT_BSP_PA_SG_R0181 | ADID2 | HCMT_BSP_PA_SG_R0181 | ADID2 | T5R1S | Text for fund indicator /SG | FUNTY |
| HCMT_BSP_PA_SG_R0181 | ADID3 | HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1S | Text for fund indicator /SG | SIGRP |
| HCMT_BSP_PA_SG_R0181 | ADID3 | SYST | MANDT | T5R1S | Text for fund indicator /SG | MANDT |
| HCMT_BSP_PA_SG_R0181 | ADID3 | * | T5R1S | Text for fund indicator /SG | SPRSL | |
| HCMT_BSP_PA_SG_R0181 | ADID3 | '2' | T5R1S | Text for fund indicator /SG | FUNCL | |
| HCMT_BSP_PA_SG_R0181 | ADID3 | HCMT_BSP_PA_SG_R0181 | ADID3 | T5R1S | Text for fund indicator /SG | FUNTY |
| HCMT_BSP_PA_SG_R0181 | ADID4 | SYST | MANDT | T5R1S | Text for fund indicator /SG | MANDT |
| HCMT_BSP_PA_SG_R0181 | ADID4 | * | T5R1S | Text for fund indicator /SG | SPRSL | |
| HCMT_BSP_PA_SG_R0181 | ADID4 | HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1S | Text for fund indicator /SG | SIGRP |
| HCMT_BSP_PA_SG_R0181 | ADID4 | '2' | T5R1S | Text for fund indicator /SG | FUNCL | |
| HCMT_BSP_PA_SG_R0181 | ADID4 | HCMT_BSP_PA_SG_R0181 | ADID4 | T5R1S | Text for fund indicator /SG | FUNTY |
| HCMT_BSP_PA_SG_R0181 | ADID5 | HCMT_BSP_PA_SG_R0181 | ADID5 | T5R1S | Text for fund indicator /SG | FUNTY |
| HCMT_BSP_PA_SG_R0181 | ADID5 | SYST | MANDT | T5R1S | Text for fund indicator /SG | MANDT |
| HCMT_BSP_PA_SG_R0181 | ADID5 | * | T5R1S | Text for fund indicator /SG | SPRSL | |
| HCMT_BSP_PA_SG_R0181 | ADID5 | HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1S | Text for fund indicator /SG | SIGRP |
| HCMT_BSP_PA_SG_R0181 | ADID5 | '2' | T5R1S | Text for fund indicator /SG | FUNCL | |
| HCMT_BSP_PA_SG_R0181 | SIGRP | SYST | MANDT | T5R1A | Institution of Soc. Provident Funds SG | MANDT |
| HCMT_BSP_PA_SG_R0181 | SIGRP | HCMT_BSP_PA_SG_R0181 | SIGRP | T5R1A | Institution of Soc. Provident Funds SG | SIGRP |
| HCMT_BSP_PA_SG_R0181 | SIGRP | * | T5R1A | Institution of Soc. Provident Funds SG | SIOFC | |
| HCMT_BSP_PA_SG_R0181 | SIGRP | HCMT_BSP_PA_SG_R0181 | AEDTM | T5R1A | Institution of Soc. Provident Funds SG | ENDDA |
| HCMT_BSP_PA_SG_R0181 | WAER1 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| HCMT_BSP_PA_SG_R0181 | WAER1 | HCMT_BSP_PA_SG_R0181 | WAER1 | TCURC | Currency Codes | WAERS |
| HCMT_BSP_PA_SG_R0181 | WAER2 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| HCMT_BSP_PA_SG_R0181 | WAER2 | HCMT_BSP_PA_SG_R0181 | WAER2 | TCURC | Currency Codes | WAERS |
| HCMT_BSP_PA_SG_R0181 | WAER3 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| HCMT_BSP_PA_SG_R0181 | WAER3 | HCMT_BSP_PA_SG_R0181 | WAER3 | TCURC | Currency Codes | WAERS |
| HCMT_BSP_PA_SG_R0181 | WAER4 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| HCMT_BSP_PA_SG_R0181 | WAER4 | HCMT_BSP_PA_SG_R0181 | WAER4 | TCURC | Currency Codes | WAERS |
| HCMT_BSP_PA_SG_R0181 | WAER5 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| HCMT_BSP_PA_SG_R0181 | WAER5 | HCMT_BSP_PA_SG_R0181 | WAER5 | TCURC | Currency Codes | WAERS |
| HCMT_BSP_PA_SG_R0181 | WAER6 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| HCMT_BSP_PA_SG_R0181 | WAER6 | HCMT_BSP_PA_SG_R0181 | WAER6 | TCURC | Currency Codes | WAERS |
| HCMT_BSP_PA_SG_R0181 | WAER7 | HCMT_BSP_PA_SG_R0181 | WAER7 | TCURC | Currency Codes | WAERS |
| HCMT_BSP_PA_SG_R0181 | WAER7 | SYST | MANDT | TCURC | Currency Codes | MANDT |
