SAP Table HCMT_BSP_PA_CA_R0094
Infotype 0094 (Residence status)
HCMT_BSP_PA_CA_R0094 (Infotype 0094 (Residence status)) 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_CA_R0094 to other SAP tables.
HCMT_BSP_PA_CA_R0094 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 | |||
| RESIS | Residence status | RESIS | T505U | CHAR | 1 | 0 | ||
| FPNCD | Personal ID and work permit (USA) | IDCOD | T509F | CHAR | 2 | 0 | ||
| AUTH1 | Issuing authority | AUTH1 | CHAR | 30 | 0 | |||
| DOCN1 | Document number for personal identification | DOCN1 | CHAR | 20 | 0 | |||
| DATE1 | Date of issue for personal ID | FPDAT | DATS | 8 | 0 | |||
| EXPID | ID expiry date | EXPID | DATS | 8 | 0 | |||
| FWOCD | Type of Work Permit | WPCOD | T509H | CHAR | 2 | 0 | ||
| AUTH2 | Issuing authority | AUTH1 | CHAR | 30 | 0 | |||
| DOCN2 | Document number for work permit | DOCN2 | CHAR | 20 | 0 | |||
| DATE2 | Date of issue for work permit | FWDAT | DATS | 8 | 0 | |||
| EXPDT | Expiry date of work permit | EXPDT | DATS | 8 | 0 | |||
| MOLGA | Country Grouping | MOLGA | T500L | CHAR | 2 | 0 | ||
HCMT_BSP_PA_CA_R0094 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| HCMT_BSP_PA_CA_R0094 | FPNCD | SYST | MANDT | T509F | ID type | MANDT |
| HCMT_BSP_PA_CA_R0094 | FPNCD | HCMT_BSP_PA_CA_R0094 | MOLGA | T509F | ID type | MOLGA |
| HCMT_BSP_PA_CA_R0094 | FPNCD | HCMT_BSP_PA_CA_R0094 | FPNCD | T509F | ID type | IDCOD |
| HCMT_BSP_PA_CA_R0094 | FWOCD | SYST | MANDT | T509H | Type of work permit | MANDT |
| HCMT_BSP_PA_CA_R0094 | FWOCD | HCMT_BSP_PA_CA_R0094 | MOLGA | T509H | Type of work permit | MOLGA |
| HCMT_BSP_PA_CA_R0094 | FWOCD | HCMT_BSP_PA_CA_R0094 | FWOCD | T509H | Type of work permit | WPCOD |
| HCMT_BSP_PA_CA_R0094 | MOLGA | HCMT_BSP_PA_CA_R0094 | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| HCMT_BSP_PA_CA_R0094 | RESIS | SYST | MANDT | T505U | Residence Status | MANDT |
| HCMT_BSP_PA_CA_R0094 | RESIS | HCMT_BSP_PA_CA_R0094 | MOLGA | T505U | Residence Status | MOLGA |
| HCMT_BSP_PA_CA_R0094 | RESIS | HCMT_BSP_PA_CA_R0094 | RESIS | T505U | Residence Status | RESIS |
