SAP ABAP Table PB0185 (HR Master Record: Infotype 0185 (Personal ID))
Hierarchy
☛
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
⤷ PA-PA-SG (Application Component) Singapore
⤷ P99_INFTY0185 (Package) Infotype 0185
⤷ PA-PA-SG (Application Component) Singapore
⤷ P99_INFTY0185 (Package) Infotype 0185
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | PB0185 | Table Relationship Diagram |
Short Description | HR Master Record: Infotype 0185 (Personal ID) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | .INCLUDE | 0 | 0 | Key for applicant data | |||||
3 | PERNR | APLNO | APLNO | NUMC | 8 | 0 | Applicant number | PB4004 | |
4 | SUBTY | SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
5 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
6 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
7 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
8 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
9 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
10 | .INCLUDE | 0 | 0 | HR Master Record: Control Field | |||||
11 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
12 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
13 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
14 | ITXEX | ITXEX | XFELD | CHAR | 1 | 0 | Text Exists for Infotype | ||
15 | REFEX | PRFEX | XFELD | CHAR | 1 | 0 | Reference Fields Exist (Primary/Secondary Costs) | ||
16 | ORDEX | ORDEX | XFELD | CHAR | 1 | 0 | Confirmation Fields Exist | ||
17 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
18 | PREAS | PREAS | PREAS | CHAR | 2 | 0 | Reason for Changing Master Data | T530E | |
19 | FLAG1 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
20 | FLAG2 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
21 | FLAG3 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
22 | FLAG4 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
23 | RESE1 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
24 | RESE2 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
25 | GRPVL | PCCE_GPVAL | PCCE_GPVAL | CHAR | 4 | 0 | Grouping Value for Personnel Assignments | ||
26 | .INCLUDE | 0 | 0 | Personnel Master Record Infotype 0185 (Identification SEA) | |||||
27 | ICTYP | ICTYP | ICTYP | CHAR | 2 | 0 | Type of identification (IC type) | T5R05 | |
28 | ICNUM | PSG_IDNUM | CHAR30 | CHAR | 30 | 0 | Identity Number | ||
29 | ICOLD | ICOLD | ICOLD | CHAR | 20 | 0 | Old IC number | ||
30 | AUTH1 | P25_AUTH1 | TEXT30 | CHAR | 30 | 0 | Issuing authority | ||
31 | DOCN1 | ISNUM | CHAR20 | CHAR | 20 | 0 | Document issuing number | ||
32 | FPDAT | PSG_FPDAT | DDATE | DATS | 8 | 0 | Date of issue for personal ID | ||
33 | EXPID | EXPID | DDATE | DATS | 8 | 0 | ID expiry date | ||
34 | ISSPL | P25_ISSPL | TEXT30 | CHAR | 30 | 0 | Place of issue of Identification | ||
35 | ISCOT | P25_ISCOT | LAND1 | CHAR | 3 | 0 | Country of issue | T005 | |
36 | IDCOT | P25_IDCOT | LAND1 | CHAR | 3 | 0 | Country of ID | T005 | |
37 | OVCHK | P25_OVCHK | CHAR1 | CHAR | 1 | 0 | Indicator for overriding consistency check | ||
38 | ASTAT | PCN_ASTAT | PCN_ASTAT | CHAR | 1 | 0 | Application status | * | |
39 | AKIND | P25_AKIND | P25_AKIND | CHAR | 1 | 0 | Single/multiple | ||
40 | REJEC | P25_REJEC | TEXT20 | CHAR | 20 | 0 | Reject reason | ||
41 | USEFR | P25_USEFR | DATUM | DATS | 8 | 0 | Used from -date | ||
42 | USETO | P25_USETO | DATUM | DATS | 8 | 0 | Used to -date | ||
43 | DATEN | P25_DATEN | DEC3 | DEC | 3 | 0 | Valid length of multiple visa | ||
44 | DATEU | DZEINZ | RPMSH | CHAR | 3 | 0 | Time unit for determining next payment | T538A | |
45 | TIMES | P25_TIMES | DATUM | DATS | 8 | 0 | Application date | ||
46 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PB0185 | DATEU | T538A | ZEINH | 1 | CN | |
2 | PB0185 | ICTYP | T5R05 | ICTYP | |||
3 | PB0185 | IDCOT | T005 | LAND1 | |||
4 | PB0185 | ISCOT | T005 | LAND1 | |||
5 | PB0185 | PERNR | PB4004 | PERNR | KEY | 1 | CN |
6 | PB0185 | PREAS | T530E | PREAS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |