Scribd
Upload
14 views5 pages

Key SAP HR Database Tables Guide

Uploaded by

mounir7107
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views5 pages

Key SAP HR Database Tables Guide

Uploaded by

mounir7107
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

THE BEST RUN SAP

SAP
HR Important
Database Tables
1

PREPARED BY SONU JANGIR +91 9729751248


SONUJAMES005@[Link]
THE BEST RUN SAP

All ABAPers Useful Below is a step-by-step summary of standard


tables in the HR (Human Resources) data is stored in several standard
tables and fields. These tables and fields are used to manage and
process employee data, payroll, benefits, time management, and other
HR-related functions. Below are some of the commonly used HR
standard tables and their key fields:
1. PA0000 - Ac ons (Infotype 0000)
 Purpose: Stores informa on about personnel ac ons (e.g., hire,
termina on, promo on).
 Key Fields:
 PERNR: Personnel Number
 OBJPS: Object ID
 ACTIO: Ac on (e.g., hire, promo on)
 ACTTY: Ac on Type
 BEGDA: Start Date
 ENDDA: End Date
2. PA0001 - Organiza onal Assignment (Infotype 0001)
 Purpose: Contains organiza onal assignment data such as employee's
posi on, department, and repor ng structure.
 Key Fields:
 PERNR: Personnel Number
 ORGEH: Organiza onal Unit
 PLANS: Posi on
 STATU: Status
 BEGDA: Start Date
 ENDDA: End Date
3. PA0002 - Personal Data (Infotype 0002)
 Purpose: Contains personal data such as name, date of birth, na onality,
marital status, etc.
 Key Fields:
 PERNR: Personnel Number
 NACHN: Last Name
 VORNA: First Name
2

PREPARED BY SONU JANGIR +91 9729751248


SONUJAMES005@[Link]
THE BEST RUN SAP
 GESCH: Gender
 GBDAT: Date of Birth
 STELL: Marital Status
4. PA0006 - Addresses (Infotype 0006)
 Purpose: Contains the employee's address details.
 Key Fields:
 PERNR: Personnel Number
 ADDR: Address Type (e.g., home, office)
 STRAS: Street Address
 PLZ: Postal Code
 ORT01: City
 LAND1: Country
5. PA0014 - Recurring Payments/Deduc ons (Infotype 0014)
 Purpose: Used to store recurring payments and deduc ons for an
employee, such as monthly bonuses, deduc ons, etc.
 Key Fields:
 PERNR: Personnel Number
 BETRG: Amount
 ZTERM: Payment Terms
 BEGDA: Start Date
 ENDDA: End Date
6. PA0015 - Addi onal Payments (Infotype 0015)
 Purpose: Stores informa on about one- me payments, such as bonuses,
over me, etc.
 Key Fields:
 PERNR: Personnel Number
 BETRG: Amount
 ZTERM: Payment Terms
 BEGDA: Start Date
 ENDDA: End Date
7. PA0027 - Family/Related Person (Infotype 0027)
 Purpose: Contains informa on about the employee's family members or
related persons.
 Key Fields:
 PERNR: Personnel Number
3

PREPARED BY SONU JANGIR +91 9729751248


SONUJAMES005@[Link]
THE BEST RUN SAP
 VORNA: First Name
 NACHN: Last Name
 GEBDT: Date of Birth
 VERSN: Rela onship Type
8. T518A - Pay Scale Type/Area
 Purpose: Stores data related to the employee’s pay scale, salary
grouping, and wage type.
 Key Fields:
 T518A: Pay Scale Area
 Payscale: Pay Scale Group
 Level: Pay Scale Level
9. T001P - Company Codes
 Purpose: Contains informa on about the company codes for which the
HR data is maintained.
 Key Fields:
 BUKRS: Company Code
 NAME1: Company Name
 ORT01: City
 LAND1: Country
10. HRP1000 - HR Master Data (Infotype 1000)
 Purpose: Holds HR master data related to the organiza onal structure.
 Key Fields:
 OBJID: Object ID (e.g., posi on, job)
 SOBJID: Superior Object ID
 OTYPE: Object Type (e.g., posi on, person)
 BEGDA: Start Date
 ENDDA: End Date
11. PA0032 - Cumula ve Time Evalua on Results (Infotype 0032)
 Purpose: Stores results from me evalua on, including work mes,
over me, and absence data.
 Key Fields:
 PERNR: Personnel Number
 BTRTL: Time Evalua on Type
 AENDT: Date of Evalua on
 INDAA: Absence Days
4

PREPARED BY SONU JANGIR +91 9729751248


SONUJAMES005@[Link]
THE BEST RUN SAP
 INREV: Over me Hours
12. T512W - Work Schedule Rules
 Purpose: Defines work schedule rules (e.g., shi pa erns, weekly
working hours).
 Key Fields:
 SPLIT: Work Schedule Rule
 ABKRS: Absence Type
 WKRCD: Work Schedule Code
13. T570 - Employee Groups/Subgroups
 Purpose: Defines different employee groups (e.g., full- me, part- me,
pensioners) and subgroups.
 Key Fields:
 PERSG: Employee Group
 PERSK: Employee Subgroup
14. T77S0 - SAP Organiza onal Management
 Purpose: Manages organiza onal structures, posi ons, and jobs.
 Key Fields:
 SOBJID: Object ID
 OTYPE: Object Type
 BEGDA: Start Date
 ENDDA: End Date

These tables and fields form the core data model for HR processes in SAP,
allowing companies to manage everything from personal and
organizational data to compensation, payroll, and time management.

PREPARED BY SONU JANGIR +91 9729751248


SONUJAMES005@[Link]

You might also like