1. SAP Tutorial
  2. HR Module

PA0718 SAP table for – HR Master Record: Infotype 0718

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

SAP PA0718 table

Table PA0718 technical data

TablePA0718
Data storingHR Master Record: Infotype 0718
ModulePA
Sub ModulePA-BN-BP
SAP PackagePBEN_BPS
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCKR
Table CategoryTRANSP

SAP PA0718 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 PA0718 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 : Benefit point system request
  • BAREA : Benefit area
    Its data type is CHAR (Character String) with field length 2
  • RQTYP : Benefit request type
    Its data type is CHAR (Character String) with field length 4
  • RQOPT : Benefit request type option
    Its data type is CHAR (Character String) with field length 4
  • RQDAT : Benefit request date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RQSTA : Request status
    Its data type is CHAR (Character String) with field length 1
  • RQPYD : Date of origin
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • APPDA : Request approved date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RQAMT : Request amount
    Its data type is CURR (Currency Field) with field length 13
  • RQCUR : Benefit Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RDPTS : Deduction points
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • RBAMT : Reimbursement amount
    Its data type is CURR (Currency Field) with field length 13
  • RDAMT : Deduction amount
    Its data type is CURR (Currency Field) with field length 13
  • RBPTS : Purchase points
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • CURRE : Benefit Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXAMT : Excess amount
    Its data type is CURR (Currency Field) with field length 13
  • EXPTS : Excess points
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Request detail common part
  • RQDTY : Family member subtype of infotype 0021
    Its data type is CHAR (Character String) with field length 4
  • RQDID : Family member subtype object of infotype 0021
    Its data type is CHAR (Character String) with field length 2
  • RDPUR : Benefit request purpose
    Its data type is CHAR (Character String) with field length 4
  • RDBEG : Request benefit begin date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RDEND : Request benefit end date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RDSTA : Benefit request status
    Its data type is CHAR (Character String) with field length 1
  • RDASU : The subtype of infotype 0006 address(TC=1/2)
    Its data type is CHAR (Character String) with field length 4
  • RDBSU : The subtype of External Bank Transfers infotype (0011)
    Its data type is CHAR (Character String) with field length 4
  • RDLSU : Benefit point system absence type
    Its data type is CHAR (Character String) with field length 4
  • REFER : Reference text
    Its data type is CHAR (Character String) with field length 128
  • .INCLUDE : Education fee structure
  • RDESY : School year
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • RDESP : School period
    Its data type is CHAR (Character String) with field length 1
  • RDEPN : School period number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • .INCLUDE : Resort structure
  • RDRNP : Number of persons
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • RDRNR : Number of rooms
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • RDRRS : Room size
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • RDRES : Employee staying or not
    Its data type is CHAR (Character String) with field length 1
  • RDRCN : Confirmation number
    Its data type is CHAR (Character String) with field length 10
  • RDRIA : Invoice amount
    Its data type is CURR (Currency Field) with field length 13
  • RDRCU : Invoice amount currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Gifts structure in BPS
  • RDGNG : Number of gifts
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • .INCLUDE : Medical examination structure
  • RDMPD : Preferred examination date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RDMCD : Confirmed examination date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Medical claim structure
  • RDLPR : Benefit Name of Benefit Provider
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • PA0718 related tables

    • T74_BPS16 : Benefit request type eligibility rule
    • T74_BPS15T : Benefit request employee eligibility grouping text
    • T74_BPS14 : Benefit request employee eligibility grouping
    • T74_BPS13 : Benefit point conversion rule
    • T74_BPS16T : Benefit request type eligibility rule text
    • T74_BPS12 : Benefit request type option
    • T74_BPS02 : Benefit point account attributes entity
    • PA0718 : HR Master Record: Infotype 0718
    • T74_BPS06 : Benefit point account attribute
    • T74_BPS21 : Benefit request type allowed absence types
    • T74_BPS09 : Benefit request type limit grouping
    • T74_BPS03 : Benefit additional point rule variant
    • T74_BPS17 : Benefit request type catalog
    • T74_BPS11 : Benefit request type attributes
    • T74_BPS03T : Benefit additional point rule variant text
    • T74_BPS20 : Benefit request detail status
    • T74_BPS14T : Benefit request employee eligibility grouping text
    • PA0717 : HR Master Record: Infotype 0717
    • T74_BPS15 : Benefit request dependent eligibility grouping
    • T74_BPS08 : Benefit request type limit rule variant

    PA0718 related transaction codes under SAP package PBEN_BPS

    • HRBPS0001 : Generate benefit point account(IT717
    • S_EH1_67000060 : IMG activity: OHBPSUSEREXIT1
    • S_EH1_67000063 : IMG activity: OHBPSESS
    • S_EH1_67000061 : IMG activity: OHBPSUSEREXIT2
    • PZ60 : ESS benefit requests
    • S_EH1_67000062 : IMG activity: OHBPSUSEREXIT3
    • S_EH1_67000059 : IMG activity: OHBPSASSWTRT
    • HRBPS0003 : Create obligatory request
    • PZ61 : Benefit request query report
    • S_EH1_67000058 : IMG activity: OHBPSWTTRT
    • HRBPS0002 : Display general request information

    Related References

    Related Tutorials

    PA0717 SAP table for – HR Master Record: Infotype 0717

    PA0717 table in SAP HR PA (Benefits in PA) module. This table is used for storing data of HR Master...

    PA0236 SAP table for – HR Master Record: Infotype 0236 (Credit Plans)

    PA0236 table in SAP HR PA (Benefits in PA) module. This table is used for storing data of HR Master...

    PA0172 SAP table for – HR Master Record: Infotype 0172 (FSA Claims)

    PA0172 table in SAP HR PA (Benefits in PA) module. This table is used for storing data of HR Master...

    PA0170 SAP table for – HR Master Record: Infotype 0170 (Flexible Spending Accounts)

    PA0170 table in SAP HR PA (Benefits in PA) module. This table is used for storing data of HR Master...

    PA0167 SAP table for – HR Master Record: Infotype 0167 (Health Plans)

    PA0167 table in SAP HR PA (Benefits in PA) module. This table is used for storing data of HR Master...

    PA0379 SAP table for – HR Master Record: Infotype 0379 (Stock Purchase Plans)

    PA0379 table in SAP HR PA (Benefits in PA) module. This table is used for storing data of HR Master...

    PA0168 SAP table for – HR Master Record: Infotype 0168 (Insurance Plans)

    PA0168 table in SAP HR PA (Benefits in PA) module. This table is used for storing data of HR Master...

    «
    »