1. Home
  2. Resources
  3. SAP Tables
  4. P0290 - HR Master Record: Infotype 0290 - Identity card CIS

SAP Table P0290

HR Master Record: Infotype 0290 - Identity card CIS

P0290 (HR Master Record: Infotype 0290 - Identity card CIS) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link P0290 to other SAP tables.

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

P0290 table fields

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

P0290 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P0290 AWADG SYST MANDT T7RUAWARDSG State Awards Groups MANDT
P0290 AWADG * T7RUAWARDSG State Awards Groups MOLGA
P0290 AWADG P0290 AWADG T7RUAWARDSG State Awards Groups AWADG
P0290 AWADT SYST MANDT T7RUAWARDS State Awards MANDT
P0290 AWADT * T7RUAWARDS State Awards MOLGA
P0290 AWADT P0290 AWADG T7RUAWARDS State Awards AWADG
P0290 AWADT P0290 AWADT T7RUAWARDS State Awards AWADT
P0290 AWADT * T7RUAWARDS State Awards ENDDA
P0290 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0290 INFTY P0290 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0290 PREAS SYST MANDT T530E Reasons for Changes MANDT
P0290 PREAS P0290 INFTY T530E Reasons for Changes INFTY
P0290 PREAS P0290 PREAS T530E Reasons for Changes PREAS