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-DE-PS) module.

Top 10 tables in Public Sector

TableDescription
P01_KGID_HISTID No. Control Proc. Child Allowance: History Status Change
P01_BSAP_ZEITRMEntitlement Periods
T5D8DEWork Indicator
PA0237HR Master Record: Infotype 0237 / View for 0052 (PSG)
PA0595HR Master Record Infotype 0595
PA0329HR Master Record: Infotype 0329 (Sideline Job)
T5D5DSupplementary Pension Public Sector: Notification Fields
PA0326HR Master Rec.: Infotype 0326 (Imputation to Pension Payts)
T510QNGuaranteed Payments: COLA/Family-Related Bonus
PDPBSZVABMDereg. from Compulsory Insurance (Record Type 40), ZVE-PBS

List of tables in Public Sector

TableDescription
P01_KGID_HISTID No. Control Proc. Child Allowance: History Status Change
P01_BSAP_ZEITRMEntitlement Periods
T5D8DEWork Indicator
PA0237HR Master Record: Infotype 0237 / View for 0052 (PSG)
PA0595HR Master Record Infotype 0595
PA0329HR Master Record: Infotype 0329 (Sideline Job)
T5D5DSupplementary Pension Public Sector: Notification Fields
PA0326HR Master Rec.: Infotype 0326 (Imputation to Pension Payts)
T510QNGuaranteed Payments: COLA/Family-Related Bonus
PDPBSZVABMDereg. from Compulsory Insurance (Record Type 40), ZVE-PBS
PA0304Additional Information: Basic Pay
PA0321Employee Accommodation
PDPBSTVOED_UEBTransfer to TVoeD: Personnel Master Record Before Transfer
PA0051HR Master Record Infotype 0051 (VBL/SPI Data)
PDPBSZVANMReg. for Compulsory Insurance (Record Type 30), ZVE-PBS
P01O_ZVB_RRTrigger of RA for Deferred Processing of Irregular Payments
PA0122HR Master Record: Infotype 0122 (Child Allowance Bonus D)
T510QCost-of-Living Allowances
P01_KGID_FILEINFNotification File ID with Creation Info. ID No. Control Proc
PDPBSZVDCARRIERSZVE-PBS Notification Procedure for Data Medium Admin.
PDPBSZVADRAddress (Record Type 81), ZVE-PBS
T77PAYDE_EO05Bonuses
T77PAYDE_KHST4Hospital Statistics: Non-Med.Function
T5DPBS_VA_AGRetirement Payment: Required Field for Pension Entry Reason
PDPBSDNEUG_UEBCarried Over to DNeuG: General HR Master Record
PA0320Official Housing
PA0271HR Master Record: Infotype 0271 (Public Sector Statistics)
T5DPBSZVAVTRing-Fencing of Supplementary Pension Institute
P01_BSAP_HISTHistory Table of Status Conversions
P01ZFA_NN_KIDSZfA: Notifications Not Assigned - Child Data
P01_BSAP_KINDTable Children of a Child Allowance Case
T77PAYDE_EO04Case Groups
P01ZFA_NN_STATUSZfA: Status Management for ZKNN Notifications
T5DPBSZVBGSP Assessment and Other Thresholds
PA0265HR Master Record Infotype 0265/Special Regulations PSG
PDPBSZVLOG_RSPI Confirmation: Log Table
T5D8EAccommodation, Infotype 30 (payments in kind)
T77PAYDE_EO06Bonus Evaluation
PA0118HR Master Record: Infotype 0118 (Child Allowance D)
T5DPBSZVSTTNotification Record Structures for Data Medium: Text
T5DPBS1BTText for Decision Value for Higher Duty
T5DPBS01Models for Special Payments and Non-Recurring Payments
T5D90Events at Start of Calc. Period for Leave/Sick Pay Premium
T5DPBS_VA_UBMaint. Payment (Req. Entry) for Entry Reason/Pension Scheme
PA0330Infotype 0330 (Non-Monetary Remuneration)
T77PAYDE_EO07Bonus Assignment
T5D5FCase groups
T5DPBS02Entitlement Prerequisites for Special and Non-Recurr. Payts
T5D5IAssgmt: Contract Model -> Ins. Feature for Voluntary Ins.
T5D8IAssignment of Exception Indicator to Position
P01_BSAP_BSMITPayment Office Notifications
T5DPBS1BDecision Value for Higher Duty
T5DPBS02TEntitlement Prerequisites for Special and Non-Recurr. Payts
T5D7XAssignment of Exception Indicator to Variable Key
PDPBSZV363Estimated Tax-Free Contributions (Acc. to Sec.3 No.63)
T5DPBS3GAssignment of Absence to Absence Category
T5DPBS0CCalculation Modules for Special and Non-Recurring Payments
T77PAYDE_KHST1_THospital Statistics: MedicalAreaFocus Text Table
PA0231HR Master Record: Infotype 0231 / View 0001 (PSG)
P01ZFA_STATUSZfA: Status Management for Notifications
PDPBSZVMDCARRSGrouped Data Medium Administration, SP Reporting
T5D7MValue of Remuneration Groups
T77PAYDE_KGBA0Ch.All. Dataset Handover: Institution No. and Relevant Data
PDPBSZVANM_RSPI Confirmation: Registration (Record Type 30)
PA0592HR Master Record: Infotype 0592 (Foreign Public Sector)
T77PAYDE_EO12TPay Grade Group Texts
T5D5TCase Group Catalog - Texts
T5D93Employment Locations
T77PAYDE_KGID2IDNo. Cntrl Proc. Child All.: FamEQF -> BZSt No./AccountID
T5DPBSZVABTemporal Validity of Deregistration Reasons
T5DPBS3ETVoeD: COLA Class for Guaranteed Payment (Children)
T510OCost-of-Living Allowances -BAT-
T5D5HTSP Tax Models
P01ZFA_NN_ATTRZfA: Attributes of Unassigned ZK01 Notifications
T5D5RSupp. Pension Pub. Sector: Customizing fr Contrib. Statement
T5D74Employee Accommodation
T5D5ESupplementary Pension Public Sector: Table of Notfctn Reason
T5DPBSZVAGEEmployer-Specific Settings: Entity
T5DPBSZVSTNotification Record Structures for Data Medium
T5DPBSZVZGEDefinition of SPI Group: Entity
T5D73Official Housing
T5D92Models for Start of New Premium Calculation Period
T5DPBS1GValidity of Variable Key for Each Pay Scale Group
T5DPBS08Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp
HRPADDE_D_DN_ZFADest. Reporting Data: ZfA: "business complete" Information
P01ZFA_NN_DATAZfA: Notifications Not Assigned
T5D5ZSupplementary Pension Public Sector: SPI Data
T5D8S_ZAVTPayroll Numbers with Connection to BAS (TEXT)
T5DPBS05TGroupings for Model Assignment for SNrP
P01ZFA_ATTRAttributes of ZfA Notifications
T5D79Wage Type Control for Official Housing Gross Amount
T5D7FService Category Texts
T5D7EService Categories
P01_KGID_ANTWID No. Control Proc. Child Allowance: Responses to Notifs
PDPBSZVSUMTotals Record (Record Type 90), SPI
T5D71TFunction Model Texts for Period Calculation
PA0322HR Master Record: Infotype 0322 (Pensions and Rel. Ben.)
T5D7HSpouse Component - Exception and Reason -
T5D7LAuxiliary Table for Higher Grouping and Promotion
T5D97Supplement for Child Living Abroad
T5D7VDefinition of Exceptions in Statistics
T77PAYDE_KHST4_THospital Statistics: Non-Med.Function
T5D8ORegional Board
T5D7LNNext Pay Scale Group for Higher/Lower Grouping
T5DPBSZVRZTData Center Information: Text
T77PAYDE_KHST1Hospital Statistics: MedicalAreaFocus
T5D5KCase Group Catalog
T77PAYDE_KHST5_THospital Statistics: SpecialDepartmentNursingStaff_KH
T5DPBS07Special and Non-Recurring Payments: Constants
T5D90TEvents at Start of Calc. Period for Leave/Sick Pay Premium
T77PAYDE_EO10Assignment Occupation/Case Group -> Level Rule
T5D8AName of Activity
T5D8BUse of Organizations
T5DPBS06Spec. and Non-Rec. Payts: Percentages for Cumul. Wage Types
T5D8FNon-Monetary Remuneration: Meals, Infotype 0330
T5DPBS1ERepayment Wage Types for Gross Overpayment
T5DPBS05Groupings for Model Assignment for SNrP
T5DPBS1FVariable Key for Step Increase
T5D89TWage Type Models for Leave and Sick Pay Premium (Texts)
PA0406HR-PSG: Infotype 0406 (Pension Information)
T5D8PPrograms for Rehabilitation
P01_KGID_CHANGEMaster Data Changes Relevant for Child Allowance ID Proced.
T5D8RLogging of Technical Conversions
T5D8NTable of Employment Offices
T5DA8TText Table Type of Dynamic Modification of Value Credit
T77PAYDE_EO13Assignment Pay Scale Group -> Pay Grade Group
T5D8VFunction Models
T5D8KAssignment of Exception Indicator to Organizational Unit
T77PAYDE_EO12Pay Grade Groups (Internal)
T5DPBS1ADecision Value for Own Position
T77PAYDE_EO03Occupational Features (Part/Section.Subsection)
PDPBSZVNAM_RSPI Confirmation: Name (Record Type 80)
T5DPBSZVMEAssignment of Notification Events/Notification Type
P01_BSAP_ADMINAdministration Table for Notifications
T5DPBS2AZfA Error Messages
T77PAYDE_KGID0IDNo. Cntrl Proc. Child Allowance: Family Equalization Funds
T5D7OGrouping Company Code/Service Type Catalog
T5D7RTFunction Model Texts: Vacation Bonus
T5D71Period Calculation
T5D7NDetermination of Hiring Level Model 8
T5D7ISpouse Component -Text-
T5D7CService Types
T5DPBSZVERTValid Events Relevant for Notification: Entity
T5D85Wage Types for Non-Rec. Payts of Maternity Pay Supplement
T5DPBSZVAGTEmployer-Specific Settings: Text
T77PAYDE_HS01TUniversity Statistics: Description of Fields of Studies
T5D7GVariants for Different Pay Scale Elements
T5D88Function Models for Leave and Sick Pay Premium
T5DPBSZVRZData Center Information
T5D84TFunction Model Texts: Supplement to Maternity Pay
T5DPBS3CTransfer to TVoeD: Assignment EEGrp/Subgrp Old/New
T5D76Official Housing Rule - Modifiers
T77PAYDE_HS01University Statistics: Fields of Studies
T5D8LAssignment of Exception Indicator to Supervisor Area
T5DA8Type of Dynamic Modification of Value Credit
T5DPBS3BAssignment to Internal Pay Scale Group
T5D7KParameters for Determining Proposed Pay Seniority
T77PAYDE_EO09Differing Level Increases According to Pay Grade Regulation
P01_KGID_MELDID No. Control Proc.: Notifications and Status Management
T77PAYDE_KHST9Assignment of Statistics Characteristics to Org. Key
T5DPBSZVZGTValid Reasons for Notification for SPI Group: Text
T5D7SUMDefinition of Assignment of Statistics Rows to Totals Row
PA0266HR Master Record: Infotype 0266 / View 0027 (PSG)
PDPBSDNEUG_UEB_TCarried Over to DNeuG: Personnel Pay Scale Information
PA0230Personnel Master Data Infotype 0230/View 0008 PSG
T5D78Official Housing Rule
T5DPBS0BEntitlements for Special and Non-Recurring Payments
T5DA7Dynamic Modification of Value Credit
P593RApplication Status: SI Reimbursement for Rehabilitants
T5D93TEmployment Locations (Texts)
T5D86Public Sector Functions
P01_KGID_EINGID No. Control Procedure: Incoming Notification
T5D8HColleges
T5DPBSZVPYTPayroll Control: Text
T5D5BSupplementary Pension Public Sector: Employer Table
PA0119HR Master Record: Infotype 0119 (Annual Income CA D)
P01ZFA_TRANSZfA: Status Table for Transfer
T5DPBSZVAGEmployer-Specific Settings
T5D8BEUtilization of Organizations
T5DPBSZVTYTValid Notification Types: Texts
T5D7YAssignment of Exception Indicator(s) to Service Types
T77PAYDE_KHST5Hospital Statistics: SpecialDepartmentNursingStaff_KH
HRPAYDEPBS_D_DNZDest. Rep. Data: Suppl.Pens. "Business Complete" Information
T77PAYDE_KHST2Hospital Statistics: Medical Function
T5D8S_BANKBank Details for Payroll Numbers
PA0363Prev.Emp.Period
T5DPBSZVBGTSP Assessment and Other Thresholds: Text
T5DPBS1ATText for Decision Value of Own Position
T5D7RModels for Controlling Vacation Bonus
PDPBSZVADMAdministration Table for ZVE-PBS Notification Procedure
PDPBSZVABSPeriods (Record Type 60), ZVE-PBS
T5DPBS09Spec. and Non-Rec. Payts, Cumul. WTs for Each Pay Scale Grp
PDPBSZV_PA0051ZVMP Employer to Be Overridden in IT0051 (Before ZVMP)
T5DPBSZVMTSAEvents Relevant for Notif. -> Reasons for Notif., Rec. Types
T77PAYDE_KHST2_THospital Statistics: Med. Function Text Table
T5D8QProperties of Rehabilitation Programs
PDPBSZVNAMName (Record Type 80), ZVE-PBS
PA0593Rehabilitants
T5DPBS03Modules for Calculating Special and Non-Recurring Payments
T77PAYDE_KGID1ID No. Control Proc. Child Allowance: BZSt Number (BOP)
T5D7BTexts for Catalog of Service Types
T5D72Houses
T77PAYDE_KHST6_THospital Statistics: Further Training (Texts)
T77PAYDE_TRF03Pay Scale Group Changes (Transfers)
T77PAYDE_KHST8Assignment of Statistics Characteristics to Service Types
PDPBSZVADM_RSPI Confirmation: Administration Table
T5D8VTFunction Models (Text Table)
T5D7QModels for Control of Contribution
T5D75Employee Accommodation - Price per Square Meter
T5DPBS0DFilter-Dependent Models of Special/Non-Recurring Payments
T5D5AOBSOLETE: Check Table for COLA Level/Partner Indicator
T5D7ZAssignment of Exception Indicator to Job
T77PAYDE_EO01Pay Grade Regulations
PA0368Rehabilitants
PA0745ZFA Notifications in Public Sector
T5DPBS2MQZfA: Settings for WebSphere MQ
T5DPBSZVZVESupplementary Pension Institute
T5D5CSupplementary Pension Public Sector: Payroll Table
T77PAYDE_EO08TLevel Rules
PDPBSZVLOGLog Table for ZVE-PBS Notification Procedure
T77PAYDE_EO05TBonuses
T5D88TFunction Model Texts: Leave and Sick Pay Premium
T5DPBS04Reduction Variants for Special and Non-Recurring Payments
T5D87Assignment of Public Sector Function Models
T77PAYDE_KHST7Assignment of Characteristics to Job, Position, Org. Unit
T5DPBS0FModels for Control of Annual Special Payment (TVoeD/TV-L)
T5DPBS1CBasis for Activity with Higher Rate of Pay
T535VCF Texts
T5D91Models for Events at Start of Premium Calculation Period
P01O_TVOED_SZ_RREarlier December Data for RA Trigger: ASP TVoeD/TVAoeD
T5D96Basic Amounts: Bonus for Foreign Service Bonus
T5D8GNon-Monetary Remuneration: Meals, Infotype 0330
T77PAYDE_KHST3Hospital Statistics: Non-Med.Profession
T5DPBS0ESpec. and Non-Rec. Payments: Pay Scale-Dependent Percentages
T5D7DService Type Texts
T5D77Maximum Remuneration for Official Housing
T77PAYDE_EO08Level Rules
T5D8DWork Indicator
T5DPBS3ATransfer to TVoeD: Assignment Pay Scale Type Old/New
T5DPBS1DSelective Activation of Gross Overpayment
T5D7QTFunction Model Texts: Special Payment
T77PAYDE_TRF02Pay Scale Adjustments
T5D7ACatalogs of Service Types
T5DPBSZVPYPayroll Control
T5D80_ABRSTAddress Data of Accounting Offices
T5D84Models for Maternity Pay Supplement
T5D8S_ZAVPayroll Numbers with Connection to UWL
T5D7JControl of BDA and COLA Relevance (Basic Pay)
T5DPBS3FTAbsence Categories for Pay Scale Level Increase (Texts)
T5D8SPayroll Numbers
T5D5GTInsurance Types for Supplementary Pension in Public Sector
T5D8CSubject to Approval
T5D5HSupplementary Pension Public Sector: Taxing Features
T5D82Pay Scale Information for Calculation of Minimum Pension
T5D7WException Indicator Texts in Statistics -PSG-
T5DPBSZVAVRing-Fencing of Supplementary Pension Institute
T5DPBS03TModules for Calculating Special and Non-Recurring Payments
T5D92TModels for Events at Start of Premium Calculation Period
T5D5GSupplementary Pension Public Sector: Combination Table
T5DPBSZVPZTPercentages and Contract Models: Text
T77PAYDE_KHST6Hospital Statistics: Further Training
T5D95Foreign Service Bonus
T5D5LFamily-Related Bonus Classes and Career Assignment
T5D82TFunction Model Texts: Minimum Pension
T5D5LNPay Scale Assign. for Guaranteed Payts: COLA/Fam.-Rel Bonus
T5D5NSupplementary Pension Public Sector: Account Number Table
T5D89Wage Type Models for Leave and Sick Pay Premium
T5D8JAssignment of Exception Indicator to Org. Key
T77PAYDE_EO11Subcase Groups
T5D83Payroll Number - Pension Insurance Institution (D)
T5D81Control Indicator Pension - Texts
T5DPBS04TReduction Variants for Special and Non-Recurring Payments
T5D7SEvaluation Areas in Statistics
T5D8PTPrograms for Rehabilitation (Texts)
T5D94Assignment of Country Level to Employment Location
T5DPBSZVPZPercentages and Contract Models
T5DPBS3FAbsence Categories for Pay Scale Level Increase
T77PAYDE_EO02Assignment Pay Scale Type -> Pay Grade Regulation
T77PAYDE_EO03TOccupational Features (Part/Section.Subsection)
T5DPBS01TModels for Special Payments and Non-Recurring Payments
T5D8AEName of Activity
T5D86TPublic Sector Functions (Texts)
T5D7MNValue of Pay Scale Groups
T77PAYDE_KHST3_THospital Statistics: Non-Med.Profession
T5D7UAssignment of Evaluation Area to Internal Key
T5DPBS3DTVoeD: Structural Adjustment
T5D7TEvaluation Areas - Texts -PSG-
T5DPBSZVABTValid Deregistration Reasons: Texts
T5DPBSZVTYValid Notification Types: Entity
T5DPBS1FTVariable Key for Step Increase (Texts)
T5DPBS0AAssignment of Models for Special and Non-Recurring Payments
T5DPBS2ATZfA: Error Text
T5D80Tax Table Benefits Payment
T5DPBSZVERValid Events Relevant for Notification: Entity
T5D8CEApproval obligation
PDPBSZVDIFDifference (Record Type 70), ZVE-PBS
T5D8MPosition Table for College Statistics