SAP Public Sector Tables

Are you looking for the right table related to SAP Public Sector Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Public Sector (PY-SG-PS) module.

Top 10 tables in Public Sector

TableDescription
T5PBSR4AAppointment type
T5RPBS8UDefine Superannuation Option
T5PBSR1GTText For Conduct Rating
PA0744HR master record infotype 0744 (Blacklist)
T5PBSR1NTText For Representation
PA0489HR-SG-PS: Voluntary Service / ECA
T5PBSR6BSalary Code
PA0488HR-SG-PS: Leave scheme
T5PBSR1MPosition Held In Voluntary Service / ECA
PA3376HR Master Record: Infotype 3376

List of tables in Public Sector

TableDescription
T5PBSR4AAppointment type
T5RPBS8UDefine Superannuation Option
T5PBSR1GTText For Conduct Rating
PA0744HR master record infotype 0744 (Blacklist)
T5PBSR1NTText For Representation
PA0489HR-SG-PS: Voluntary Service / ECA
T5PBSR6BSalary Code
PA0488HR-SG-PS: Leave scheme
T5PBSR1MPosition Held In Voluntary Service / ECA
PA3376HR Master Record: Infotype 3376
T5PBSR3BIGroup identifier for leave entilement
T5PBSR6JAnnual Wage Adjustment for MVC Component
PA0502Letter of appointment
T5PBSR6EAnnual Wage Adjustment for Basic Component
T5PBSR1JLevel Of Clearance
T5PBSR6HINPVP Increment Eligibility Group
PA0494HR-PS-SG: Employee Suggestion Scheme - Evaluation Results
T5PBSR1HTText For Mobilisation
T5PBSR3DLeave allowance and daily rate of make up vac lv - scheme 73
T5PBSR3ATText table for leave schemes
PA0495HR-PS-SG: Pensions Scheme
T5PBSR3HSalary Grouping
T5PBSR6AScheme of Services
T5PBSR4BTenure of office
T5RPBS1TWeighting of Evaluation Criteria
PB0502Letter of appointment
T5PBSR1ECommendation
T5PBSR6D(Not used, will be deleted in 4.6)
T5PBSR1OSubject
T5RPBS10DTText Table for Outcome code
T5PBSR2DSI contr. table for Govt Non-pensionable Employees
T5PBSR1AType of National Service and Unit
T5PBSR1GConduct rating for national service
T5PBSR6MAssignment between Pay Scale Types and Scheme Code
T5PBSR3BITText for group identifier for leave entilement
T5RPBS1UEvaluation Status in Staff Suggestion Scheme
T5PBSR1ATText For Type of National Service And Unit
T5PBSR2FSpecial MSO Calculation Rules
T5RPBS10JBlacklist reason
T5PBSR2AStores the employer MediSave reference number
T5RPBS11BTText Table for Type of Company
T5RPBS9BTText Table for Status
T5RPBS8BTText Table for Superannuation Scheme Payment Option
PA0490HR-PS-SG: Employee Suggestion Scheme
T5RCPF_SCHTCPF Scheme type texts
T5RPBS10ETText Table for Type of Representation
T5RPBS10GTText Table for Interdiction Type
T5PBSR1CRANK at ORD / Reservist
T5RPBS8LPensions Scheme Discount Value
T5RPBS11FTText table for Casino Places
T5RPBS11ETText for Officer Group
T5RPBS9AStatus Group
T5PBSR1KTText For Status Of Clearance
T5PBSR2BSI contr. table for Govt Pensionable Employees.
T5PBSR1NRepresentation
T5PBSR1QTText For Dialect Group
T5PBSR1MTText For Position Held In Voluntary Service / ECA
T5PBSR1LTypes Of Voluntary Services / ECA
T5PBSR3DIGroup for leave allowance
T5RPBS8ETOBSOLETE (Text Table for Pensions Scheme Constants Table)
T5PBSR6CAssignment between Scheme Code and Salary Code
T5PBSR1TLink table for absence and NS Type (No longer in use)
T5RPBS10HTText Table for Blacklist Category
T5RPBS8HAssign Options, Components, Val. Model to Elig. Grouping
T5RPBS10FTText table for Offence Grouping
T5PBSR1DVocation
PA0493HR-SG-PS: Extension of infotype 0022
T5RPBS11AType of Property
T5PBSR3ALeave scheme types
T5PBSR6FMonthly Salary Scale
T5PBSR1HMobilisation Code
PA0755HR Master Record: Infotype 0755
T5RPBS10ATText Table for Disciplinary Act
T5RPBS10CTText table for Outcome Grouping
T5RPBS8FPay Changes Reasons to be considered for Averaging of APE
T5PBSR4ATAppointment type description
PA0753HR Master Record: Infotype 0753
T5RPBS11FCasino Places Code
T5RPBS10JTText table for Blacklist Reason
T5PBSR3IDefine the maximum number of absence days w/o proration
T5RPBS8BDefine Superannuation Scheme Payment Option
T5RPBS8KPensions Scheme Option Component Code (Obsolete)
T5PBSR6HNPVP Increment Detail
T5RPBS8OTText Table for Pensions Scheme Option Component Code
T5RPBS1RTText Table for Evaluation Criteria in SSS
T5RPBS10IExit Mode
T5PBSR3JGuideline for proration
T5PBSR3GTDivision text
T5PBSR1FTText For Performance Rating
T5RPBS1WEvaluation Authority and Weighting Based on Evaluator
T5RPBS11HCustomizing Table for SG Public Sector Declaration
T5RPBS8ATText Table for Superannuation Scheme
T5RPBS1PTText Table for Staff Suggestion Category
PA0487HR-SG-PS: Security / medical Clearance
T5RPBS1UTText Table for Evaluation Status in SSS
T5PBSR1PTText For Asset Type
T5PBSR2CPR contr. table for govt. pensionable employees.
T5RPBS8ITText Table for Pensions Scheme Eligibility Grouping
T5RPBS11GTText table for Casino Pass Type
T5RPBS10GInterdict/Stop pay type
PB0744HR Master Record: Infotype 0744
T5PBSR6BTText for Salary Code
T5RPBS10ADisciplinary Act
PB0488HR-SG-PS: Leave scheme
T5RPBS10EType of Representation
T5PBSR1DTText For Vocation
T5RPBS1PStaff Suggestion Category
T5RPBS10DOutcome Code
T5PBSR3BLeave entitlement
T5PBSR6GBasic Component
T5RPBS8TMaintain Pensions Act
T5PBSR1ETText For Commendation
T5RPBS10FOffence Grouping
PA3379HR Master Record: Infotype 3379
T5PBSR6IGuideline for Salary Components
T5RPBS8WTText Table for Approval of Retirement
T5PBSR1JTText For Level Of Clearance
T5PBSR2EPR contr. table for Govt. non-pensionable employees.
T5PBSR1LTText For Voluntary Services / ECA
T5RPBS8MInterest Rates
T5PBSR6NAssignment between Pay scale area and division
T5RPBS9CAssignment of Status to Status Group
T5RPBS8SMaintain Formula Module for Average APE Calculation
T5PBSR1BTText For National Service Status
T5RPBS9ATText Table for Status Group
T5RPBS1REvaluation Criteria For Staff Suggestion Scheme
T5RPBS8WMaintain Approval of Retirement
T5PBSR3CITText for group for leave quota
PA0486HR-SG-PS: Master Data (National Service)
PA0752HR Master Record: Infotype 0752
T5PBSR3GDivision
T5RPBS11CTText Table for Type of Business Firm
PA0742HR Master Record: Infotype 0742
T5RPBS9BStatus
PB0493HR-SG-PS: Extension of infotype 0022
T5PBSR1FPerformance rating for national service
T5PBSR6HITText for Eligibility Group for NPVP Adjustment
T5RPBSG0GNP Code for GNP
T5RPBS11GCasino Pass Type Code
T5PBSR1BNational Service Status
T5R0P_PSPlant section/Singapore for PS Employees
T5RPBS8UTText Table for Superannuation option
T5PBSR1KStatus Of Clearance
T5RPBS8NPensions Scheme Eligibility Grouping
T5RPBSE2Priority of ERA Deductions
T5RPBS10HBlacklist category
T5RPBS11ATText Table for Type of Property
PA0754HR Master Record: Infotype 0754
T5RPBS8DOBSOLETE (Absences not counted as Pensionable Service)
T5RPBS8ADefine Superannuation Scheme
PA3375HR Master Record: Infotype 3375
T5RPBS10COutcome Grouping
T5PBSR3DITText for group for leave allowance
T5PBSR1CTText For Rank at ORD / Reservist
T5PBSR1OTText For Subject Code
T5RPBS8EOBSOLETE (SG Public Sector Pensions Scheme Constants Tab)
T5RPBS11EOfficer Group Code
T5RPBS11BType of Company
T5RPBS8VAssign Superannuation Option to Superannuation Scheme
T5RCPF_SCHCPF Scheme types for Public sector
T5PBSR1PAsset Type
T5PBSR3CLeave Quota Entitlement
T5RPBS8KTText Table for Pensions Scheme Option Comp. Code(Obsolete)
T5RPBS1QEvaluator Identification
T5RPBS8QAbsence type for proration of Past salary for CPF refund
T5PBSR3CIGroup for leave quota
T5RPBS1YDefinition of Rank Table
T5RPBS11CType of Business Firm
T5RPBSE1To define Standard Divisional Ratios for ERA.
T5PBSR4BTTenure of office description
T5RPBS8OPensions Scheme Option Component Code
T5RPBSG1Salary Conversions for GNP
T5RPBS8NTText Table for Pensions Scheme Eligibility Grouping
T5PBSR1QDialect Group
T5PBSR6ATText for Scheme of Services
PA0743HR master record infotype 0743 (Discipline)
T5RPBS1XStaff Suggestion Scheme Ranking Table
T5RPBS8JPensions Scheme Constant Value (TO BE OBSOLETED)
T5RPBS1XTText Table for Staff Suggestion Ranking Table
T5RPBS8TTText Table for Pensions Act
T5RPBS8PExit Modules for Pension Calculations
T5RPBS8RMaintain Formula Module for Generic APE Calculation
T5RPBS10BOffences Code
T5RPBS8COBSOLETE(Pensions Scheme Payment Option Eligibility Crite)
T5RPBS8GOBSOLETE (Specify Calculation Process for LOS Calculation)
T5RPBS8IDefine Eligibility Grouping for Superannuation Scheme
T5RPBS10BTText table for Offences Code
T5RPBSG2Golden Number for GNP
T5RPBS10ITText table for Exit mode