SAP S/4Hana table Q0002 stores Screen Fields: Infotype 0002 (Personal Data)data

  

So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like Q0002 look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.

Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.


S4 Hana Q0002 dictionary attributes

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


Field list for Q0002 table on an S/4 SAP system

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 S4 Hana tables