SAP Table PA0290

HR Master Record: Infotype 0290 - Identity card CIS

PA0290 (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 PA0290 to other SAP tables.

PA0290 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PERNR Personnel number PERSNO PA0003 NUMC 8 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

PA0290 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PA0290 AWADG PA0290 AWADG T7RUAWARDSG State Awards Groups AWADG
PA0290 AWADG SYST MANDT T7RUAWARDSG State Awards Groups MANDT
PA0290 AWADG * T7RUAWARDSG State Awards Groups MOLGA
PA0290 AWADT PA0290 AWADG T7RUAWARDS State Awards AWADG
PA0290 AWADT PA0290 AWADT T7RUAWARDS State Awards AWADT
PA0290 AWADT * T7RUAWARDS State Awards ENDDA
PA0290 AWADT SYST MANDT T7RUAWARDS State Awards MANDT
PA0290 AWADT * T7RUAWARDS State Awards MOLGA
PA0290 MANDT PA0290 MANDT T000 Clients MANDT
PA0290 PERNR SYST MANDT PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
PA0290 PERNR PA0290 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
PA0290 PREAS SYST MANDT T530E Reasons for Changes MANDT
PA0290 PREAS PSKEY INFTY T530E Reasons for Changes INFTY
PA0290 PREAS PA0290 PREAS T530E Reasons for Changes PREAS