PB0290 SAP table for – HR Master Record: Infotype 0290 – Identity card CIS

Here we would like to draw your attention to PB0290 table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). PB0290 is a SAP standard transp table used for storing HR Master Record: Infotype 0290 – Identity card CIS related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB33.

SAP PB0290 table

Table PB0290 technical data

TablePB0290
Data storingHR Master Record: Infotype 0290 – Identity card CIS
ModulePA
Sub ModulePA-PA-RU
SAP PackagePB33
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCRU
Table CategoryTRANSP

SAP PB0290 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in PB0290 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for HR Master Data
    Its a key field.
  • PERNR : Personnel number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • SUBTY : Subtype
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OBJPS : Object Identification
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SPRPS : Lock Indicator for HR Master Data Record
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEQNR : Number of Infotype Record With Same Key
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : HR Master Record: Control Field
  • AEDTM : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • HISTO : Historical Record Flag
    Its data type is CHAR (Character String) with field length 1
  • ITXEX : Text Exists for Infotype
    Its data type is CHAR (Character String) with field length 1
  • REFEX : Reference Fields Exist (Primary/Secondary Costs)
    Its data type is CHAR (Character String) with field length 1
  • ORDEX : Confirmation Fields Exist
    Its data type is CHAR (Character String) with field length 1
  • ITBLD : Infotype Screen Control
    Its data type is CHAR (Character String) with field length 2
  • PREAS : Reason for Changing Master Data
    Its data type is CHAR (Character String) with field length 2
  • FLAG1 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG2 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG3 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG4 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • RESE1 : Reserved Field/Unused Field of Length 2
    Its data type is CHAR (Character String) with field length 2
  • RESE2 : Reserved Field/Unused Field of Length 2
    Its data type is CHAR (Character String) with field length 2
  • GRPVL : Grouping Value for Personnel Assignments
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : HR Master Record: Infotype 0290 – Identity card CIS
  • SERIA : Series Code of Document
    Its data type is CHAR (Character String) with field length 8
  • SERI0 : Series
    Its data type is CHAR (Character String) with field length 2
  • NOMER : Document Number for Personal Identification
    Its data type is CHAR (Character String) with field length 15
  • PASSL : Issuing Authority
    Its data type is CHAR (Character String) with field length 100
  • DATBG : Issue Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATEN : Expiry Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PCODE : Subunit Code
    Its data type is CHAR (Character String) with field length 10
  • TEXT1 : Additional Information
    Its data type is CHAR (Character String) with field length 50
  • TEXT2 : Additional Information
    Its data type is CHAR (Character String) with field length 50
  • TEXT3 : Additional Information
    Its data type is CHAR (Character String) with field length 50
  • RACKY : Ethnic origin
    Its data type is CHAR (Character String) with field length 2
  • DRCAT : Driving Category
    Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : HR Master Record: Infotype 0294 – WehrDienst CIS
  • WDBHD : Military Registration and Enlistment Office
    Its data type is CHAR (Character String) with field length 100
  • WDGRP : Group
    Its data type is CHAR (Character String) with field length 100
  • WDKAT : Category
    Its data type is CHAR (Character String) with field length 100
  • WDSTV : Staff
    Its data type is CHAR (Character String) with field length 100
  • WDSTF : Rank
    Its data type is CHAR (Character String) with field length 100
  • WDUSP : Speciality
    Its data type is CHAR (Character String) with field length 100
  • WDSPU : Special Registration
    Its data type is CHAR (Character String) with field length 100
  • WDPFL : Fit for Military Service
    Its data type is CHAR (Character String) with field length 1
  • CDGRP : Group Code
    Its data type is CHAR (Character String) with field length 10
  • CDKAT : Category Code
    Its data type is CHAR (Character String) with field length 10
  • CDSTV : Staff Code
    Its data type is CHAR (Character String) with field length 10
  • CDSTF : Rank Code
    Its data type is CHAR (Character String) with field length 10
  • CDUSP : Registration Speciality Code
    Its data type is CHAR (Character String) with field length 10
  • CDSPU : Special Registration Code
    Its data type is CHAR (Character String) with field length 10
  • CDPFL : Release Reason Code
    Its data type is CHAR (Character String) with field length 10
  • CDBHD : Military Registration and Enlistment Office Code
    Its data type is CHAR (Character String) with field length 10
  • WDUFF : Release Reason
    Its data type is CHAR (Character String) with field length 100
  • WDSPO : General Registration
    Its data type is CHAR (Character String) with field length 100
  • CDSPO : General Registration Code
    Its data type is CHAR (Character String) with field length 10
  • CDDRA : Draft Code
    Its data type is CHAR (Character String) with field length 2
  • WDDRA : Name of Draft Code
    Its data type is CHAR (Character String) with field length 100
  • .INCLUDE : The Insurance Certificate Personal Data
  • NACHN : Last Name
    Its data type is CHAR (Character String) with field length 40
  • VORNA : First Name
    Its data type is CHAR (Character String) with field length 40
  • MIDNM : Middle Name
    Its data type is CHAR (Character String) with field length 40
  • GESCH : Gender Key
    Its data type is CHAR (Character String) with field length 1
  • GBDAT : Date of Birth
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SBPDT : Special Birth Date
    Its data type is CHAR (Character String) with field length 1
  • SBPDD : Day
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SBPDM : Month
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SBPDY : Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SBPMM : Month Name
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : The Insurance Certificate – Birthplace Data
  • SPCPF : Special Birthplace
    Its data type is CHAR (Character String) with field length 1
  • MSTRANA : Country of Birth
    Its data type is CHAR (Character String) with field length 40
  • MREGION : Region of Birth
    Its data type is CHAR (Character String) with field length 40
  • MRAION : Area of Birth
    Its data type is CHAR (Character String) with field length 40
  • MPLACE : City of Birth
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes