SAP Q0002 Table in S/4 HANA - Screen Fields: Infotype 0002 (Personal Data)
Q0002 is a standard SAP Table which is used to store Screen Fields: Infotype 0002 (Personal Data) data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the Q0002 table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type)
Dictionary Type: Structure
Database Table: Q0002
Q0002 table structure field list
Below is the full Q0002 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| ANREX | Form of address text | ANREX | CHAR | 5(0) | ANREX | |||||
| FATXT | Marital Status | FATXT | CHAR | 6(0) | FATXT | |||||
| KITXT | Religious Denomination | KITXT | CHAR | 4(0) | KITXT | |||||
| NATTX | Nationality (long text) | NATTX | CHAR | 15(0) | TEXT15 | |||||
| NA2TX | Nationality (long text) | NATTX | CHAR | 15(0) | TEXT15 | |||||
| NA3TX | Nationality (long text) | NATTX | CHAR | 15(0) | TEXT15 | |||||
| LANDX | Country Name | LANDX | CHAR | 15(0) | TEXT15 | |||||
| GBPAS | Date of Birth According to Passport | QGBPS | CHAR | 10(0) | CHAR10 | |||||
| GBDAT | Date of Birth | GBDAT | DATS | 8(0) | PDATE | GBDAT | ||||
| GESCH | Gender key | GESC1 | CHAR | 1(0) | CHAR1 | |||||
| ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40(0) | TEXT40 | |||||
| PERID | Personnel ID Number | PRDNI | CHAR | 20(0) | CHAR20 | |||||
| GESC1 | Gender key | GESC1 | CHAR | 1(0) | CHAR1 | |||||
| GESC2 | Gender key | GESC2 | CHAR | 1(0) | CHAR1 | |||||
| GESC3 | Gender key | GESC3 | CHAR | 1(0) | CHAR1 | |||||
| BMPTR | Bumiputera status - Malaysia | P14_BMPTR | CHAR | 1(0) | XFELD | |||||
| FNAME | Full name for infotype 0002 - Malaysia | P14_FNAME | CHAR | 50(0) | CHAR50 | |||||
| CURP | Individual registration number | PMX_CURP | CHAR | 18(0) | CHAR18 | |||||
| CCUIL | Worker identification code | PAR_CCUIL | CHAR | 13(0) | CHAR13 | |||||
| ID_TYPE | Identity document type | PES_IDTYPE | CHAR | 1(0) | PES_ID | |||||
| BLTYP | Employee Blood Type | P48_BLTYP | CHAR | 3(0) | P48_BTYPE | |||||
| AGE | Employee Age | P48_AGE | NUMC | 3(0) | NUM03 | |||||
| PEREG | Personnel Register Number | P12_PRDNI | CHAR | 20(0) | CHAR20 | |||||
| NUMSS | Social insurance number | NUMSS | CHAR | 13(0) | NUMSS | |||||
| CLESS | Verification key for the SI number | CLESS | NUMC | 2(0) | NUM2 | |||||
| BSNCD | Citizen Service Number [BSN] | P05_BSN | NUMC | 9(0) | NUM9 | |||||
| POINT | P06P_POINT | NUMC | 6(0) | NUMC6 | ||||||
| INSTY | Provisional INSEE number: type | P06P_TG_INSTY | CHAR | 1(0) | P06P_TG_INSTY |
Search for further information about these or an SAP related objects