SAP Reporting Tables

Are you looking for the right table related to SAP Reporting 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 Reporting (PY-NL-RP) module.

Top 10 tables in Reporting

TableDescription
P2RN_FBPayroll Results: Flexible benefits
P05T_IRS_WTYPEWage Type Trigger IR Split
P05T_XML_KENTWage Return: XML Tags Mapping Indicator
P05T_UITS_KENTIndicator Exclusion
P05T_KENT_CUSTWage Return: Customizing Indicators for Customers
P05T_IV_RG_CUMWage Return: Income Relationship: Sect./Riskgrp. cumulated
P05T_LL_SPLITAangifte LH: Splitting of life-course saving scheme payments
P05T_RESP_LINEWage Return: Table for Response Message Errors
P05T_NUMIV_ATTRWage Return: Current IR Number
P05T_WCR_SYSIDWork Cost Regulation: System ID

List of tables in Reporting

TableDescription
P2RN_FBPayroll Results: Flexible benefits
P05T_IRS_WTYPEWage Type Trigger IR Split
P05T_XML_KENTWage Return: XML Tags Mapping Indicator
P05T_UITS_KENTIndicator Exclusion
P05T_KENT_CUSTWage Return: Customizing Indicators for Customers
P05T_IV_RG_CUMWage Return: Income Relationship: Sect./Riskgrp. cumulated
P05T_LL_SPLITAangifte LH: Splitting of life-course saving scheme payments
P05T_RESP_LINEWage Return: Table for Response Message Errors
P05T_NUMIV_ATTRWage Return: Current IR Number
P05T_WCR_SYSIDWork Cost Regulation: System ID
P05T_WCR_FLWCR: Final Levy and Final Settlement
P05T_LOB_STORAGETable to store large objects for testing and check purposes
P05T_WCR_SYSID_TWork Cost Regulation: System ID Descriptions
P05T_MAX_NUMIVWage Return: highest assigned IR number so far
P05T_WAB_EXCLWAB: Exclude Employees From Revision
P05TPRNL_PR_OUTPension Return: PR - Output Data
P05T_RESP2LAWage Return: Rel. between Response Message and Wage Return
P05T_IRS_DEFIncome Relationship Split Types Defaults
P05T_WCR_PROTWCR Protocol Table
P05T_IV_AANG_CUMWage Return: Cumulated Values per Income Relationship
P05T_KENT_TXTWage Return: Indicator Text Table
P2RN_NBPayroll results: Adjustments and Arrears Payments (NL)
P05T_RESPONSEWage Return: Table for Response Messages
P05TPRNL_EE_ADMSPension Return: Admin of Status Income Relationship - Pers L
P05T_CURR_VOLGNRWage Return: Current Sequence Number
T77PRNL_MUMPension Return UPA: Conversion of Marital Status Key
T5N6ATDescription of Regulations
T77PRNL_PUOJUPPension Return: Assignment of Legal Person to PUO
T5N2PPeriod Type (NL)
T5N16TText Table for SI Types
P05T_IV_AANGIFTEWage Return: Income Relationship - Nominative Return
T5N6ECalculation Data for Entitlements
T77PRNL_PUO_APPLPension Return: Assignment of PUO to Subapplication
P05T_AE_AANG_CUMWage Return: Cumulated Values Collective
T5N5MCalculation Methods for Pensions (NL)
P05TPRNL_PR_RSPPension Return: PR - Output Data - Response Data
P05T_IRS_TYPEIncome Relationship Split Types
P2RN_NTDGHR Master Record: Infotype Planned Working Time (0007)
P05T_CVZ_HEADERHCIB transfer file headerlines
T5N9MAssign Actions and Reasons to code reason ending Employment
P05TPRNL_M_NUMIRPension Return: Highest Assigned IR Number so far
P05T_IV_DAWage Return: Income Relationship - Return Data
T5NTBDetermine Calculation Base for Transition Allowance
T77PRNL_FILLPension Return: Fill Table APG
T5N5OText: Pension Schemes (NL)
P05T_IV_DA_BSNWage Return: Other Cumulated Return Data
T5N6BTDescription of Calculation Components of Regulation
P05T_IV_DA_CUMWage Return: Other Cumulated Return Data
P05_TTFM_TTYPETCSV Tax Table Check Report: Tax Table Type Text Table
T5N9U_TReason for Ending Employment Contract Pens Return Text Table
T5N2ZTaxable Allowance for Childcare
P05TPRNL_EE_PRPIPension Return: Income Rel - Pens/Ins Rel Period Indic PL
T77PRNL_IN_SUMPension Return: Sum up indicators
P05T_AE_WGFWage Return: Administrative Unit - Redundancy Pay Scheme
P05T_CURR_VNR_JRWage Return: Current sequence number per year
P05T_IV_ADMWage Return: Income Relationship - Admin. Table
P05T_IV_SAWage Return: Income Relationship - Special Indicators
T5N2UPremium Reduction Type
P05T_JWN_STC_TXTAnnual Employee's Statement: Statoc Texts
P05TPRNL_SYCHIRPension Return: System Change - IR Number per PERNR
T77PRNL_JUPREPPension Return: Assignment of Legal Pers to Repr Legal Pers
T77PRNL_XML_INPension Return: XML Tags Mapping Indicator
P2RN_LAPayroll Results: Wage Return
P05TPRNL_EE_RGPension Return: Income Relationship - Sector Risk Group
P05_TTFM_TTYPECSV Tax Table Check Report: Table Types
P2RN_STPayroll Results: Wage Tax (NL)
P05TPRNL_C_NUMIRPension Return: current IR number
P05T_JLO_FIELDSUse of table fields for Annual Wage Return
P05T_NO_XML_TAGWage Return: Text Table Feature without XML Tags
T5NTEDetermine Employment Start for Transition Allowance
T5N5RText: Pension Indicators (NL)
T5N76Municipal Personal Records Database [GBA] Code Countries
P05T_IV_AA_BSNWage Return: Cumulated Values for BSN Changers
P05T_TIMEFRAMETimeframe About Which a Response Message Contains Data
P05T_JLO_HEADERData and heading for Annual Wage Return CSV transfer file
P05TPRNL_LP_COLLPension Return: Collective Return - Legal Pers Level
P05TPRNL_C_SEQNOPension Return: Current sequence number per period
T77PRNL_MSTPension Return AGP: Conversion of Marital Status Key
T5N6CLink between Regulations and Calculation Components
T5N9LReason for Ending Employment Contract
T77PRNL_ADDLPDPension Return: Additional Legal Person Data
P05T_IRS_TYPE_TIncome Relationship Split Types (Texts)
P05T_CURR_NUMIVWage Return: current IR number
P2RN_HBMWHBMH Recalculation Method Wages
T77PRNL_IN_CUMPension Return: Assignment of Cumulative Wage Types
P2RN_SRPayroll Results: Life-Course Savings Scheme
T77PRNL_IN_CPRPension Return: Assignment of Ind. to CumWTs Prod. Related
T5N9TReason for Ending Employment Contract Wage Return
P2RN_NNAMPersonal Data
T77PRNL_SELPension Return: Product Selection Table
T5N5QCalculation Table for Pensions (NL)
T5N2OPremium Reductions (NL)
T5N9UReason for Ending Employment Contract Pens Return
P05T_AE_AANGIFTEWage Return: Administrative Unit - Collective Return
P05TPRNL_EE_PDPension Return: Personal Data - Pers Level
P2RN_SVPayroll Results: Social Insurance (NL)
P05T_WCR_SIMUWCR Simulation
P05TPRNL_EE_IRPPension Return: Income Relationship ΓÇô Income Period - Pers L
P05T_T_WCR_CODECodes for the Work Cost Regulation
T77PRNL_BEGRELPension Return: Determination of Pension Rel. Start Date
T5N5PPension Schemes (NL)
P05T_CVZ_REG_DAT(De)registration data for HCIB
T5N18Control Table for Mapping SI Variables to Wage Types
P05T_CORR_RELWage Return: Indicators Relevant for Corrections
T5N6FCalculation Data for Reservations
P05T_AE_CORSALDOWage Return: Administrative Unit - Balance Adjustments
T5N6DTDescription of Calculation Codes
T5N6ARegulations
T5N16Social Security Types
T5N6DCalculation Codes for Regulations
T5N1WControl Information for WAS
P2RN_CBPayroll results: Wage Adjustments for payroll calc. (NL)
P05T_JWN_LOGOAnnual Tax Statement Logo for PDF Form
P05T_EDM_PERSOONPersonal data for Day-one-announcement (EDM)
T5N20Payroll Parameters for Employment Rebate and Tax (NL)
P2RN_SPPayroll Results: Special Payments
P05T_IV_PERSOONWage Return: Income Relationship - Personal Data
P05T_WCR_CWTWCR Code for wage type
P05T_IRS_CWTIncome Relationship Split Types CWT Split
P2RN_NSR0Payroll Results: Special Provisions (NL)
P05T_WCR_ER_INFOWCR Info on Employer Level
P05TPRNL_LP_ADMSPension Return: Administration of Status - Legal Pers Level
T77PRNL_SYCHNGPension Return: System Change
P2RN_NADRAddress Data
P05T_CVZ_UITWCVZ: Tabel voor uitwisselingsbestand
P05T_RESP_LINE_AWage Return: Table for Resp. Message Errors (Add. Fields)
P05_TTFM_TEXTNL Tax Table Description
P2RN_PKPayroll Result: Pension Module
T5N0ELink Between Difference Wage Types and Wage Types
T5N24Additional Amount Percentage Private Use of Car
P05T_WCR_ER_DATAWCR Data on Employer Level
T5N5VMarital Status for Evaluations
P05T_A_EXTWage Return: Collective Employer Data - Wage Return
P05T_LA_PREDMEWage Return: Pre-DME for payment of Wage Tax
T5N0_FEATUREReturn matrix for table transfer features
P2RN_NARGPayroll Results: Add. Terms of Employment
T5N6GCalculation Data for Pay-out and Forwarding
P2RN_INFDData Evaluation (NL)
T5NTATransition Allowance Payment
P2RN_HBMRHBMH Recalculation Method Results
T5N5NCheck Table for Pension Schemes (NL)
T5NTWInclude Work Relationship Types
P05_TTFMMapping: Tax Table - Function Module
T5N6BCalculation Components of Regulation
P05T_MFTPNominative Contribution May Be Incorrect
P05T_CVZ_REGHCIB: Registration table
P05T_JWN_INDICAnnual Employee's Statement: Indicators to be displayed
P05T_JLO_STATAnnual Wage Return status
T77PRNL_UCHECKPension Return: Check Table for Fill Table UPA
P05TPRNL_EE_ADMPension Return: Admin Income Relationship - Pers Level
P05TPRNL_LP_SALDPension Return ΓÇô Saldo Return on Legal Person level
T5N1UCheck Table for Employer
T5NTDCalculation Base for Remaining Days
P05_TTCM_TEXTNL Tax Table Column Description
P2RN_ABPDeltas for National Table Cluster PC
P2RN_AKPayroll Results: Premium Reduction (NL)
T5NTITransition Allowance Groups
T5N9T_TReason for Ending Employment Contract Wage Return Text Table
T77PRNL_IN_TXTPension Return: Indicator Text Table
P05T_IV_INKPERSAWage Return: Income Relationship - Income Period SI
T77PRNL_EMKTPension Return AGP: External Marital Status Key
P05T_T_WCR_CODETWCR Code Description
P05T_LA_SYCHNGWage Return: System Transfer
P05T_WCR_STATWCR Status Table
P05TPRNL_PR_RSPMPension Return: PR - Output Data - Response Data - Messages
P05T_KENTEKENWage Return: Indicator
T77PRNL_EMKPension Return AGP: External Marital Status Key
T5N21Final levy
T77PRNL_XML_VPension Return: XML Versions
P2RN_NKOPayroll Results: Childcare (NL)
P05TPRNL_EE_IRIPension Return: Income Relationship Indicators
P05T_CUM_KENTWage Return: Indicator Cumulation Wage Types
T5N25Payroll Parameters for Tax Rebates (NL)
T5N2KText: Premium Reduction Type (NL)
P05_TTCMMapping: Tax Table Column - Function Module Parameter
P05T_NOM_ERRORErrors in Nominative Wage Returns
P05T_IV_ADM_STATWage Return: Income Relationship - Status Table
T5N77Fiscal Area (NL)
T5N0FLink back-payment wage types to difference wage types
P05TPRNL_EE_PRPension Return: Income Relationship Pens/Ins Relationship PL
P05T_NUMIV_2015Wage Return: Usage of P05T_NUMIV_ATTR in 2015
P05TPRNL_LP_ERPension Return: Employer Return on Legal Person Level
T5N17TDescription of Social Insurance Calculation Methods
P2RN_NWVPayroll Results: Commuter Traffic (NL)
P2RN_PSPayroll Results: Pensions (NL)
P05TPRNL_EE_PRPPension Return: Income Rel ΓÇô Pens/Ins Relation Period - PL
T5N0GControl Table for Guaranteed Net Amounts
P05TPRNL_LP_ADMPension Return: Administration - Legal Pers Level
P2RN_PRAPPension Return
P2RN_HBMHPayroll Results: HBMH Recalculation Method History
T77PRNL_UFILLPension Return: Fill Table UPA
P05T_AE_ADMWage Return: Administrative Unit - Admin. Table
T77PRNL_INPension Return: Indicator
P05T_AE_ADM_STATWage Return: Administrative Unit - Status Table
P2RN_LAIRWPayroll Results: Wage Return
T5N9SReason for Ending Employment Contract SAP Code
P05T_AE_WGF_CUMWage Return: Administrative Unit: Sect/Risk Group Cumulated
P05T_XML_VERSIONWage Return: Versions
P05T_WCR_EE_DATAWCR Data on Employee Level
P05T_WSCC_ATTRSBR Default Connection Attributes
T5N17Social Insurance Calculation Methods
T5N2LText: Period Type (NL)
T5NTVVacation Allowance Percentage for Transition Allowance
T77PRNL_SELWTPension Return: Selection Table APG for Wage Types
T5N1LSocial Insurance Contribution Data
P05T_IV_INKPERWage Return: Income Relationship - Income Period
P05T_CR_CUSTWage Return: Indicators Relevant for Corrections (Customer)
T5N1GValuation of Absences
P05T_IV_RGWage Return: Income Relationship - Risk Group Sector
T5N5LText: Calculation Methods (NL)
P05T_CR_TABSWage Return: Tables with Correction Relevant Fields
P05T_JLO_DATAData for Annual Wage Return
T5N23Assign Wage Tax Return Indicator to Annual Employee Statem.
T77PRNL_PUOTPension Return: PUO Description
P05T_SOM_KENTWage Return: Indicators