In this post, I will try and describe everything you need to know about the SAP q0002 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for Q0002 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from Q0002....Right lets get started!
Object Name: Q0002
Dictionary Type: Structure
Description: Screen Fields: Infotype 0002 (Personal Data)
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| ANREX | ANREX | CHAR | 5(0) | Form of address text | ANREX | PSTA | ||||||
| FATXT | FATXT | CHAR | 6(0) | Marital Status | FATXT | PSTA | ||||||
| KITXT | KITXT | CHAR | 4(0) | Religious Denomination | KITXT | PSTA | ||||||
| NATTX | NATTX | CHAR | 15(0) | Nationality (long text) | TEXT15 | PINF | ||||||
| NA2TX | NATTX | CHAR | 15(0) | Nationality (long text) | TEXT15 | PINF | ||||||
| NA3TX | NATTX | CHAR | 15(0) | Nationality (long text) | TEXT15 | PINF | ||||||
| LANDX | LANDX | CHAR | 15(0) | Country Name | TEXT15 | FB | ||||||
| GBPAS | QGBPS | CHAR | 10(0) | Date of Birth According to Passport | CHAR10 | PINF | ||||||
| GBDAT | GBDAT | DATS | 8(0) | Date of Birth | GBDAT | PINF | ||||||
| GESCH | GESC1 | CHAR | 1(0) | Gender key | CHAR1 | PNU | ||||||
| ENAME | EMNAM | CHAR | 40(0) | Formatted Name of Employee or Applicant | TEXT40 | PINF | ||||||
| PERID | PRDNI | CHAR | 20(0) | Personnel ID Number | CHAR20 | PSTA | ||||||
| GESC1 | GESC1 | CHAR | 1(0) | Gender key | CHAR1 | PNU | ||||||
| GESC2 | GESC2 | CHAR | 1(0) | Gender key | CHAR1 | |||||||
| GESC3 | GESC3 | CHAR | 1(0) | Gender key | CHAR1 | |||||||
| BMPTR | P14_BMPTR | CHAR | 1(0) | Bumiputera status - Malaysia | XFELD | |||||||
| FNAME | P14_FNAME | CHAR | 50(0) | Full name for infotype 0002 - Malaysia | CHAR50 | |||||||
| CURP | PMX_CURP | CHAR | 18(0) | Individual registration number | CHAR18 | |||||||
| CCUIL | PAR_CCUIL | CHAR | 13(0) | Worker identification code | CHAR13 | |||||||
| ID_TYPE | PES_IDTYPE | CHAR | 1(0) | Identity document type | PES_ID | |||||||
| BLTYP | P48_BLTYP | CHAR | 3(0) | Employee Blood Type | P48_BTYPE | |||||||
| AGE | P48_AGE | NUMC | 3(0) | Employee Age | NUM03 | |||||||
| PEREG | P12_PRDNI | CHAR | 20(0) | Personnel register number | CHAR20 | |||||||
| NUMSS | NUMSS | CHAR | 13(0) | Social insurance number | NUMSS | PNF | ||||||
| CLESS | CLESS | NUMC | 2(0) | Verification key for the SI number | NUM2 | PNF | ||||||
| BSNCD | P05_BSN | NUMC | 9(0) | Citizen Service Number [BSN] | NUM9 | PNN | ||||||
| POINT | P06P_POINT | NUMC | 6(0) | NUMC6 | ||||||||
| INSTY | P06P_TG_INSTY | CHAR | 1(0) | Provisional INSEE number: type | P06P_TG_INSTY |