1. SAP Tutorial
  2. HR Module

PA0465 SAP table for – HR master record infotype 0465

Here we would like to draw your attention to PA0465 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). PA0465 is a SAP standard transp table used for storing HR master record infotype 0465 related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB37.

SAP PA0465 table

Table PA0465 technical data

TablePA0465
Data storingHR master record infotype 0465
ModulePA
Sub ModulePA-PA-BR
SAP PackagePB37
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCBR
Table CategoryTRANSP

SAP PA0465 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 PA0465 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 0465 (Documents)
  • TPDOC : Document Type
    Its data type is CHAR (Character String) with field length 4
  • DT_EMIS : Document’s Issue Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ES_EMIS : State (FU)
    Its data type is CHAR (Character String) with field length 3
  • CPF_NR : Sole Proprietor’s Registry number (CPF)
    Its data type is CHAR (Character String) with field length 15
  • IDENT_NR : Identification Document number
    Its data type is CHAR (Character String) with field length 16
  • IDENT_ORG : Identification Document Issuer
    Its data type is CHAR (Character String) with field length 8
  • CTPS_NR : Worker’s Card for Social Welfare number – WCSW
    Its data type is CHAR (Character String) with field length 10
  • CTPS_SERIE : Worker’s Card series number – WCSW
    Its data type is CHAR (Character String) with field length 6
  • CREG_NR : Regional Council register number
    Its data type is CHAR (Character String) with field length 15
  • CREG_NAME : Regional Council name
    Its data type is CHAR (Character String) with field length 90
  • CREG_INIT : Regional Council abbreviation
    Its data type is CHAR (Character String) with field length 10
  • ELEC_NR : Voter Registration Card number
    Its data type is CHAR (Character String) with field length 15
  • ELEC_ZONE : Voter Registration Card area
    Its data type is CHAR (Character String) with field length 5
  • ELEC_SECT : Voting Section
    Its data type is CHAR (Character String) with field length 5
  • PIS_NR : SIP/PSHFP number
    Its data type is CHAR (Character String) with field length 20
  • MIL_NR : Military Certificate number
    Its data type is CHAR (Character String) with field length 12
  • MIL_TYPE : Military Certificate type
    Its data type is CHAR (Character String) with field length 8
  • MIL_CAT : Military Certificate category
    Its data type is CHAR (Character String) with field length 3
  • IDFOR_NR : Foreign Identification Document number
    Its data type is CHAR (Character String) with field length 20
  • VISA_NR : Visa series number
    Its data type is CHAR (Character String) with field length 6
  • VISA_TYPE : Type of Visa
    Its data type is CHAR (Character String) with field length 20
  • MARRY_BR : Brazilian spouse
    Its data type is CHAR (Character String) with field length 1
  • DT_ARRV : Date of arrival in Brazil
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DRIVE_NR : Professional Driver’s License number
    Its data type is CHAR (Character String) with field length 12
  • DRIVE_CAT : Driver’s License category
    Its data type is CHAR (Character String) with field length 3
  • PASSP_NR : Passport number
    Its data type is CHAR (Character String) with field length 15
  • NIT_NR : Employee Identification Number – EIN
    Its data type is CHAR (Character String) with field length 11
  • CARTO : Name of public notary
    Its data type is CHAR (Character String) with field length 40
  • CDEAT : Death certificate
    Its data type is CHAR (Character String) with field length 10
  • DEATH : Date of death notification
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CAUDE : Cause of death
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • PA0465 related tables

    • T7BRFP : SAWF code
    • T7BR1B : Union
    • T7BRGR : SIB table – Self-employed
    • T7BR0P : Personnel areas assignment to branches/c.sites groups
    • T7BREC : Marital status description
    • T7BRQT : Absence quota type
    • PB0398 : Infotype 0016 – Corporation and contract agreements
    • T7BRC1 : Construction site information
    • T7BRX1 : Labor Debits
    • T7BRT2 : Transportation type
    • T7BRB8 : SEFIP: other informations per site
    • T7BR98 : Employee grouping for calculation of severance pay
    • T7BR07 : Parameters Responsible branch – SEFIP
    • T7BRDT : Withholding Income Tax Decl.withholding code description
    • T7BRFT : SAWF code description
    • T7BRSB : Exclusion of movement code for FGTS withdrawal
    • T7BRCB : Brazilian Job Occupation Code (by position)
    • T7BRSS : SS Relation between value type (BRSOC) and wage type
    • T7BRB1 : Branch – general information
    • T7BRAS : IAI percentage for special retirement

    PA0465 related transaction codes under SAP package PB37

    • PBR1 : Responsible persons’ addresses
    • S_PH9_13000021 : Issue of Leave Notice

    Related References

    Related Tutorials

    PB0465 SAP table for – HR master record infotype 0465

    PB0465 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PB0734 SAP table for – HR master record infotype 0734

    PB0734 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PA0264 SAP table for – HR Master Record: Infotype 0264 View for Infotype 0021

    PA0264 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PA0183 SAP table for – HR Master Record: Infotype 0183 [Awards] (SG)

    PA0183 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PA0712 SAP table for – HR Master Record: Infotype 0712

    PA0712 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PA0182 SAP table for – HR Master Record: Infotype 0182 [Alternative Names] (SG)

    PA0182 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PA0185 SAP table for – HR Master Record: Infotype 0185 [Identification] (SG)

    PA0185 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    «
    »