SAP table P0290 (HR Master Record: Infotype 0290 - Identity card CIS)

Field Description Data Type Length Decimals Checktable Data Element
PERNR Personnel Number NUMC 8 0 PERNR_D
INFTY Infotype CHAR 4 0 T582A INFTY
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
SERIA Series Code of Document CHAR 8 0 P33_SERIE
SERI0 Series (part 2) CHAR 2 0 P33_SERI0
NOMER Document Number for Personal Identification CHAR 15 0 P33_NUMER
PASSL Issuing Authority CHAR 100 0 P33_PASSL
DATBG Issue Date DATS 8 0 P33_ISSDT
DATEN Expiry Date DATS 8 0 P33_ISSEX
PCODE Subunit Code CHAR 10 0 P33_PCODE
TEXT1 Additional Information CHAR 50 0 P33_ADDIN
TEXT2 Additional Information CHAR 50 0 P33_ADDIN
TEXT3 Additional Information CHAR 50 0 P33_ADDIN
RACKY Ethnic origin CHAR 2 0 * RACKY
DRCAT Driving Category CHAR 5 0 P33_DRCAT
WDBHD Military Registration and Enlistment Office CHAR 100 0 P33_WDBHD
WDGRP Group CHAR 100 0 P33_WDGRP
WDKAT Category CHAR 100 0 P33_WDKAT
WDSTV Staff CHAR 100 0 P33_WDSTV
WDSTF Rank CHAR 100 0 P33_WDSTF
WDUSP Speciality CHAR 100 0 P33_WDUSP
WDSPU Special Registration CHAR 100 0 P33_WDSPU
WDPFL Fit for Military Service CHAR 1 0 P33_WDPFL
CDGRP Group Code CHAR 10 0 P33_CDGRP
CDKAT Category Code CHAR 10 0 P33_CDKAT
CDSTV Staff Code CHAR 10 0 P33_CDSTV
CDSTF Rank Code CHAR 10 0 P33_CDSTF
CDUSP Registration Speciality Code CHAR 10 0 P33_CDUSP
CDSPU Special Registration Code CHAR 10 0 P33_CDSPU
CDPFL Release Reason Code CHAR 10 0 P33_CDPFL
CDBHD Military Registration and Enlistment Office Code CHAR 10 0 P33_CDBHD
WDUFF Release Reason CHAR 100 0 P33_WDUFF
WDSPO General Registration CHAR 100 0 P33_WDSPO
CDSPO General Registration Code CHAR 10 0 P33_CDSPO
CDDRA Draft Code CHAR 2 0 P33_CDDRA
WDDRA Name of Draft Code CHAR 100 0 P33_WDDRA
NACHN Last Name CHAR 40 0 PAD_NACHN
VORNA First Name CHAR 40 0 PAD_VORNA
MIDNM Middle Name CHAR 40 0 PAD_MIDNM
GESCH Gender Key CHAR 1 0 GESCH
unknown
1 Male
2 Female
GBDAT Date of Birth DATS 8 0 GBDAT
SBPDT Special Birth Date CHAR 1 0 P33_SPBDT
SBPDD Day NUMC 2 0 P33_DAY
SBPDM Month NUMC 2 0 P33_MONTH
SBPDY Year NUMC 4 0 P33_YEAR
SBPMM Month Name CHAR 20 0 P33_MONTH_NAME
SPCPF Special Birthplace CHAR 1 0 P33_SPCPF
MSTRANA Country of Birth CHAR 40 0 P33_STRANA
MREGION Region of Birth CHAR 40 0 P33_REGION
MRAION Area of Birth CHAR 40 0 P33_RAION
MPLACE City of Birth CHAR 40 0 P33_PLACE
AWADG Award Group CHAR 4 0 T7RUAWARDSG P33_AWADG
AWADT Award CHAR 4 0 T7RUAWARDS P33_AWADT
AWANR Award Number NUMC 7 0 P33_AWANR
AWAHD Award Receipt Date DATS 8 0 P33_AWAHD
AWADN Decree Number CHAR 6 0 P33_AWADN
AWADD Decree Date DATS 8 0 P33_AWADD
PASSL2 Issuing authority (part 2) CHAR 50 0 P33_PASSL2
SUBNUMBER Additional Document Number for Personal Identification CHAR 24 0 HRPAD99RU_SUBNUMBER

P0290 foreign key relationships

Table Field Check Table Check Field
0 P0290 AWADG T7RUAWARDSG State Awards Groups MANDT
0 P0290 AWADG T7RUAWARDSG State Awards Groups MOLGA
1 P0290 AWADT T7RUAWARDS State Awards MANDT
1 P0290 AWADT T7RUAWARDS State Awards MOLGA
1 P0290 AWADT T7RUAWARDS State Awards AWADG
1 P0290 AWADT T7RUAWARDS State Awards ENDDA
0 P0290 INFTY T582A Infotypes: Customer-Specific Settings MANDT
0 P0290 INFTY T582A Infotypes: Customer-Specific Settings INFTY
1 P0290 PREAS T530E Reasons for Changes MANDT
1 P0290 PREAS T530E Reasons for Changes INFTY
1 P0290 PREAS T530E Reasons for Changes PREAS