SAP Table PS0185
Personnel Master Record Infotype 0185 (Identification SEA)
PS0185 (Personnel Master Record Infotype 0185 (Identification SEA)) 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 PS0185 to other SAP tables.
Source: PS0185 (Personnel Master Record Infotype 0185 (Identification SEA))
PS0185 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
ICTYP | Type of identification (IC type) | ICTYP | T5R05 | CHAR | 2 | 0 | ||||||
ICNUM | Identity Number | PSG_IDNUM | CHAR | 30 | 0 | |||||||
ICOLD | Old IC number | ICOLD | CHAR | 20 | 0 | |||||||
AUTH1 | Issuing authority | P25_AUTH1 | CHAR | 30 | 0 | |||||||
DOCN1 | Document issuing number | ISNUM | CHAR | 20 | 0 | |||||||
FPDAT | Date of issue for personal ID | PSG_FPDAT | DATS | 8 | 0 | |||||||
EXPID | ID expiry date | EXPID | DATS | 8 | 0 | |||||||
ISSPL | Place of issue of Identification | P25_ISSPL | CHAR | 30 | 0 | |||||||
ISCOT | Country of issue | P25_ISCOT | T005 | CHAR | 3 | 0 | ||||||
IDCOT | Country of ID | P25_IDCOT | T005 | CHAR | 3 | 0 | ||||||
OVCHK | Indicator for overriding consistency check | P25_OVCHK | CHAR | 1 | 0 | |||||||
ASTAT | Application status | PCN_ASTAT | CHAR | 1 | 0 | |||||||
AKIND | Single/multiple | P25_AKIND | CHAR | 1 | 0 |
Possible values
|
||||||
REJEC | Reject reason | P25_REJEC | CHAR | 20 | 0 | |||||||
USEFR | Used from -date | P25_USEFR | DATS | 8 | 0 | |||||||
USETO | Used to -date | P25_USETO | DATS | 8 | 0 | |||||||
DATEN | Valid length of multiple visa | P25_DATEN | DEC | 3 | 0 | |||||||
DATEU | Time unit for determining next payment | DZEINZ | T538A | CHAR | 3 | 0 | ||||||
TIMES | Application date | P25_TIMES | DATS | 8 | 0 |
PS0185 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
PS0185 | DATEU | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
PS0185 | DATEU | PS0185 | DATEU | T538A | HR Time/Measurement Units | ZEINH |
PS0185 | ICTYP | SYST | MANDT | T5R05 | Types of Identification | MANDT |
PS0185 | ICTYP | T001P | MOLGA | T5R05 | Types of Identification | MOLGA |
PS0185 | ICTYP | PS0185 | ICTYP | T5R05 | Types of Identification | ICTYP |
PS0185 | IDCOT | SYST | MANDT | T005 | Countries | MANDT |
PS0185 | IDCOT | PS0185 | IDCOT | T005 | Countries | LAND1 |
PS0185 | ISCOT | SYST | MANDT | T005 | Countries | MANDT |
PS0185 | ISCOT | PS0185 | ISCOT | T005 | Countries | LAND1 |