SAP Table Q0002 stores Screen Fields: Infotype 0002 (Personal Data)data

  

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!


SAP Q0002 dictionary attributes

Object Name: Q0002
Dictionary Type: Structure
Description: Screen Fields: Infotype 0002 (Personal Data)


Q0002 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
ANREXANREXCHAR5(0) Form of address textANREXPSTA
FATXTFATXTCHAR6(0) Marital StatusFATXTPSTA
KITXTKITXTCHAR4(0) Religious DenominationKITXTPSTA
NATTXNATTXCHAR15(0) Nationality (long text)TEXT15PINF
NA2TXNATTXCHAR15(0) Nationality (long text)TEXT15PINF
NA3TXNATTXCHAR15(0) Nationality (long text)TEXT15PINF
LANDXLANDXCHAR15(0) Country NameTEXT15FB
GBPASQGBPSCHAR10(0) Date of Birth According to PassportCHAR10PINF
GBDATGBDATDATS8(0) Date of BirthGBDATPINF
GESCHGESC1CHAR1(0) Gender keyCHAR1PNU
ENAMEEMNAMCHAR40(0) Formatted Name of Employee or ApplicantTEXT40PINF
PERIDPRDNICHAR20(0) Personnel ID NumberCHAR20PSTA
GESC1GESC1CHAR1(0) Gender keyCHAR1PNU
GESC2GESC2CHAR1(0) Gender keyCHAR1
GESC3GESC3CHAR1(0) Gender keyCHAR1
BMPTRP14_BMPTRCHAR1(0) Bumiputera status - MalaysiaXFELD
FNAMEP14_FNAMECHAR50(0) Full name for infotype 0002 - MalaysiaCHAR50
CURPPMX_CURPCHAR18(0) Individual registration numberCHAR18
CCUILPAR_CCUILCHAR13(0) Worker identification codeCHAR13
ID_TYPEPES_IDTYPECHAR1(0) Identity document typePES_ID
BLTYPP48_BLTYPCHAR3(0) Employee Blood TypeP48_BTYPE
AGEP48_AGENUMC3(0) Employee AgeNUM03
PEREGP12_PRDNICHAR20(0) Personnel register numberCHAR20
NUMSSNUMSSCHAR13(0) Social insurance numberNUMSSPNF
CLESSCLESSNUMC2(0) Verification key for the SI numberNUM2PNF
BSNCDP05_BSNNUMC9(0) Citizen Service Number [BSN]NUM9PNN
POINTP06P_POINTNUMC6(0) NUMC6
INSTYP06P_TG_INSTYCHAR1(0) Provisional INSEE number: typeP06P_TG_INSTY


View list of all tables