SAP Non Profit Organizations Tables

Are you looking for the right table related to SAP Non Profit Organizations 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 Non Profit Organizations (PY-NPO) module.

Top 10 tables in Non Profit Organizations

TableDescription
T7UNPAD_PA2001EXExtract of PA2001 fields; for use by sick leave combined
T7UNESS_WFWorkflow Customization for HR Administrator Desk
T7UNPAD_IDNRPOOLNumber Pool for NPO Index Numbers
T7UNPF_HR_SALSalary details
T7UNOM_P_TITLEPosition Title
T7UNAAP_ADDTABPAAP additional tables
T7UNPF_HR_RELMRelation Mapping Table
T7UNPAD_RS502_TRental Subsidy Marital Status Key Text
T7UNCMT_NNRMCMT Interface: Non-Removal Element
HRP1081DB Table for Infotype 1081

List of tables in Non Profit Organizations

TableDescription
T7UNPAD_PA2001EXExtract of PA2001 fields; for use by sick leave combined
T7UNESS_WFWorkflow Customization for HR Administrator Desk
T7UNPAD_IDNRPOOLNumber Pool for NPO Index Numbers
T7UNPF_HR_SALSalary details
T7UNOM_P_TITLEPosition Title
T7UNAAP_ADDTABPAAP additional tables
T7UNPF_HR_RELMRelation Mapping Table
T7UNPAD_RS502_TRental Subsidy Marital Status Key Text
T7UNCMT_NNRMCMT Interface: Non-Removal Element
HRP1081DB Table for Infotype 1081
T7UNAPP_TYPMasterview: Application Type
T7UNPAD_RSACRRental Subsidy Average Commercial Rent Amounts
T7UNPF_MI_CHLDRUNJSPF Monthly Interface Children Table
T7UNPAD_RGSTRepatriation Grant Number Translation
T7UNPAD_DSSC_TText for Duty Station Security Classification
PA3244HR Master Record: Infotype 3244
T7UNPAD_PFST_TText for Pension Fund Status
T7UNPAD_SLQUNPO: Sick Leave Quota Values
T7UNPF_HR_SEPMSeparation Mapping Table
T7UNCMT_SACIDTCMT Category ID for Staff and Salary Assessment
T7UNAAP_T529APAAP Actiontype
T7UNAAP_CLUSTPaap Cluster
PA3399HR Master Record: Infotype 3399
HRP1080DB Table for Infotype 1080
T7UNPF_FI_MISCEFinancial Interface Misc. Transactions
T7UNPAD_PFUNPension Fund Scheme
T7UNPF_HR_CNTRCContract details
PA0960HR Master Record: Infotype 0960
T7UNPAD_DSDuty Station
T7UNPF_MI_ACTCOUNJSPF Monthly Interface Activity Control Table
T7UNPAD_CSRVT_TText table for Contract Service Type
T7UNPF_HR_MARMMarital Status Mapping Table
T7UNPAD_EGCTR_TNPO: EG Entitlement countries text
T7UNPAD_PFSTPension Fund Status
PA0961HR Master Record: Infotype 0961
T7UNPF_LANGMLanguage Code Mapping Table
T7UNPAD_DSCADuty Station Hardship Classification
PA0959HR Master Record: Infotype 0959
T7UNPAD_EGADCRReasons to Overwrite Advance Payment for EG
T7UNCMT_RNSECMT Interface: Subsidy/Deduction Entitlement
T7UNPF_HR_DEPNDDependent details
PA0962HR Master Record: Infotype 0962
P2UN_HTPayroll Results: Results Table
T7UNESS_APPSCRWorkflow Customization for HR Administrator Desk
T7UNOM_OCCGTNPO internal OCCG Functional Code Text
T7UNPAD_DSMEDuty Station Mobility Element
T7UNPF_FI_ADDETAdditional Details
PA0963HR Master Record: Infotype 0963
T7UNPAD_RSDARental Subsidy Entitlements (Amount)
T7UNOM_CCOG_TICSC CCOG Functional Code
T7UNPAD_EGSG_TNPO: EG School Grade Text
T7UNPF_HR_ORGMMapping for UN Organization Id to Organization Name
T7UNOM_CCOCCGRelationship Between CCOG and OCCG
T7UN_ESS_ATTCHNPO : Details of attachments for ESS Scenarios
T7UNAAP_ATTRIBSPAAP General Attributes
T7UNPAD_PFUN_TText for Pension Fund Scheme
T7UNPAD_EGAMTNPO: EG Entitlements
T7UNPF_PFLANGPF Language Code
T7UNPAD_DSRR_TDuty Station of RR Text Table
T7UNPF_FI_OPRHDOperation Header
T7UNPF_CNTPY-NPO: UNJSPF Country code table
T7UNPAD_EGEXPAPLNPO: Expense Management Application
P2UN_NTPayroll Results: Results Table
T7UNPAD_RSMARental Subsidy Maximum Amount
T7UNCMT_RNTECMT Interface: Subsidy/Deduction Entitlement
T7UNPF_FI_ADJUSAdjustments
T7UNPF_HR_GETREGet Reports Response
T7UNPAD_QT_KTARTNPO Quota Types Attributes
T7UNPF_HR_EMLMEmail Mapping Table
T7UNPAD_RULES_CTNPO: Rules Series Relationship to CTTYP
T7UNPF_FI_REMSGResponse Message
T7UNPF_MI_PARTTUNJSPF Monthly Interface Part Time Table
HRP1082DB Table for Infotype 1082
T7UNOM_FUNDTFunding Type
T7UNPAD_SLGRNPO: Sick Leave Quota Grouping
T7UNPAD_EGSTEG School Types
T7UNPAD_EXPELGMaintain Expenses Eligibility for EG
P2UN_DSBPDuty Station basic pay split extension
T7UNOM_OCCGNPO internal OCCG Functional Code
T7UNPAD_EG_GSSMaintain Reimbursement Percentage for EG Brackets as per GSS
T7UNPAD_RULESSERNPO: Rule Series for Infotype 0016
P2UN_QDDCONAustralia Public Sector: Payroll
T7UNPAD_DS0PDuty Station Relation to SAP Entities Personel Area/Subarea
T7UN_T52BBTexts for Function Parameter Values
T7UNPAD_PSGRPY-NPO: Pay Grade Groupings
PA0958HR Master Record: Infotype 0958
T7UNCMT_CONFTConfiguration of Valid Types for CMT Import
T7UNOM_FUNDT_TFunding Type
T7UNCMT_PADJCMT Interface: Post Adjustment
T7UNOM_CCOGICSC CCOG Functional Code
T7UNESS_INITUIBBNPO: EG Initial screen uibb data
T7UNPAD_RSMAGRental Subsidy Maximum Amount Grade Grouping
T7UNPAD_EGRSNPO: EG Boarding reasons
T7UNPAD_DSDADuty Station Dependency Allowance
T7UNCMT_MBLTCMT Interface: Mobility Element
PA3429HR Master Record: Infotype 3429
T7UNPAD_RSRRRental Subsidy Reimbursement Rate
T7UNPAD_MBFAMobility Flat amounts
T7UNOM_FUND_POSMap Funding Type to Position Type
T7UNOM_OUTYPEOrganisational Unit Type
T7UNCMT_DUTXCMT Interface: Duty Station
P2UN_PKPension Fund, Payroll United Nations
T7UNCMT_DSHLCMT Interface: Duty Station Holiday
T7UNPAD03Employee Group/Subgroup
T7UNPAD_PSGRTPay Grade Grouping Texttable(NPO)
T7UNPAD_DSPFDuty Station Annex UNJSPF
T7UNCMT_TRFAR_GBCustomizing table for Payscale Area and Payscale Type
PA3341HR Master Record: Infotype 3341
T7UNCONV_MATRIXUnified Sallary Scale Conversion Matrix
T7UNCMT_SACIDMCMT Map Staff and Salary Assessment Category Code
T7UNCMT_XREFDutystation Crossreference
T7UN_T52B5Assignment of Values to Objects (NPO Extensions)
T7UNPAD_GAGrade Adjustment for Mobility Allowances
T7UNPF_FI_GRESPGet Response
T7UNCMT_PENRCMT Interface: Pensionable Renumeration
T7UNPAD_EG30NPO: Reasons for Changes
T7UNPAD_ORGAUN Organizations / Programme
T7UNPAD_EGCA_TNPO: Text for EG Category Class
T7UNPF_MI_PRTCIUNJSPF Monthly Interface Participant Table
T7UNPF_HR_SEPStaff Member Separation details
T7UNPAD_EGCOSNPO: Education Grant Cost Types
T7UNPAD_AGENCY_TText for Agency
T7UNPAD_EVE_GAGrade Adjustment for Allowances in EVE
T7UNPAD_CTSTA_TNPO: Text table for Contract status for Infotype 0016
P2UN_QHDAHR-UN: Payroll structure for Higher Duty Allowance
T7UNPF_FI_RESPResponse
T7UNPAD_REIN_TRecruitment Indicator
T7UNPAD_DSHEDuty Station Hardship Element
T7UNPAD_EGPSHNPO: Education Grant Cost Flat rates
T7UNCMT_PCATMCMT Payscale Category Mapping
T7UNCMT_DUTYCMT Interface: Duty Station
T7UNPAD_TEIDTermination Indemnity Number Translation
PA0964HR Master Record: Infotype 0964
T7UNCMT_EGENCMT Interface: Education Grant Entitlement
T7UNPF_HR_ADRMAddress Mapping Table
T7UNCMT_DEPACMT Interface: Dependency Allowed
T7UNCMT_CURRCMT Interface: Country
T7UNPF_HR_LWOPLeave Without Pay
T7UNAAP_TSTCPAAP relevant Transaction(s)
T7UNPAD_EGCL_TNPO: Text for EG Category Class
PA0965HR Master Record: Infotype 0965
T7UNPF_CATMCategory Code Mapping
T7UNPAD_DMSADuty Station MSA Rates (Mission Subsistence Allowance)
T7UNPF_HR_REMSGResponse Message
T7UNPAD_DS_TDuty Station Text Table
T7UNBEN_T5UBINPO Benefit Cost Rule Settings
T7UNOM_POSITNPO Position Type
T7UNPF_CNTTPY-NPO: UNJSPF Country code text table
T7UNPF_HR_LANGLanguage Allowance
T7UNPAD_PFSVPension Fund Schema Values
P2UN_RSUN Rental Subsidy internal structure
T7UNPAD_EGGSSNPO: EG Global Sliding Scale
T7UNPAD_STATUS16NPO: Status for Infotype 0016
T7UNPAD_EGCAQ_TPY-NPO: Text for EG CCAQ Category Class
T7UNPF_HR_STAFFStaff Member Table
T7UNPF_HR_EMAILEmail Information
P2UN_QSPRHR-UN: Payroll structure for Superannuation
T7UNEG_PROCTXTNPO: EG Table for Process Type ID and Text on ESS Screen
T7UNPAD_SLGR_TNPO: Sick Leave Quota Grouping Text
T7UNPF_HR_LANGMLanguage Mapping Table
T7UNPAD_DSPTDuty Station PTA Personnel Transition Allowance
T7UNESS_CATEGHR Admin Desk Category
T7UNBEN_T5UBHNPO Benefit Cost Rule
T7UNPAD_DSLCDuty Station Home Leave Cycle
PA3407HR Master Record: Infotype 3407
T7UNCMT_DSSGCMT Interface: Staff Assessment Grade Range
T7UNPF_HR_DSDuty Station details
T7UNESS_PDF_EGNPO ESS: Customizing table for preview in Eductaion Grant
T7UN_T52BOOperation Parameters
T7UNPF_HR_COMRECommon Response
T7UNAAP_INFOAAP Table for not relevant Infotype(s)
T7UNPAD_NRFARemoval/Non Removal Flat amounts
T7UNPAD_CEBDSPY-NPO: EG CEB Duty Station table
T7UNPAD_T502_TMarital Status Designators Relation to Rental Subsidy MarSta
T7UNPAD_RS502Rental Subsidy Marital Status Key
T7UNTRV_T554VDefaults for Absence Types
T7UNPAD_EGCLNPO: EG Category Classes
T7UNPAD_CEBGRDEG CCAQ Staff Grade Mapping table
T7UNPAD_DSPFTDuty Station Text Table
T7UNCMT_HSFACMT Interface: Hardship Element
T7UNPAD_ACTIONSCustomizing: Additional Functions for Actions
T7UNPAD_DEGRDeath Grant
T7UNPF_MARSTMMarital Status Mapping
PA3417HR Master Record: Infotype 3417
T7UNAAP_CO_PERNRPAAP copied Persons
T7UNPAD_REINRecruitment Indicator
T7UNOM_FUND_FLGMap Funding Type to Position Type
T7UN_ATTRIBSNPO: General Attributes
T7UNCMT_SACIDCMT Category ID for Staff and Salary Assessment
T7UNTRV_PLCSNPO+ : Origin/Destination Types table
T7UNPAD_AREA_TText for Duty Station Area/Zone
T7UNBEN_T5UBANPO Benefit Plan Cost Rule Variant
T7UNPAD_DS0_PFDuty Station Relation to Pension Fund UNJSPF Duty Stations
P2UN_EGRTNPO: EG Internal summary structure
T7UNPF_YI_SCHEUNJSPF Yearly Interface data table
P2UN_DPSTATUN Dependency Status internal table
P2UN_SUPCOMSuperable salary components For NPO
T7UNPF_FI_CONTRContributions
T7UNPAD_DSSCDuty Station Security Classification
T7UNCMTC_TRFGBCustomizing table for Personnel SubArea and Employee Group
T7UNPAD_CEBCNT_TPY-NPO: EG CEB Country table name
T7UNPF_MI_BISTAUNJSPF Monthly Interface Break in Service
T7UNPAD_DSRRDuty Station of RR
T7UNPAD_GA_IMPDTImplementation date for GA changes
T7UNPAD_CEBDS_TEG CEB Duty Station Text Table
T7UN_T52B7Valid Function Parameter Values
T7UNPF_MI_DEPNDUNJSPF Monthly Interface Export key
T7UNPF_DSPFMDuty Station Mapping
T7UNPAD_ARPTCDAirport codes
T7UNCMT_EXCHCMT Interface: Exchange Rate
T7UNPAD_DSPADuty Station Post Adjustment
T7UNPF_CNTMNPO: UNJSPF Country Code Mapping
T7UNPAD_EGCAQPY-NPO: EG Expense Type Classes for CCAQ
T7UNPAD_RSDR_TRental Subsidy Dwelling Rent Type Text Table
T7UNPAD_CS_SCRScreen fields customizing table
T7UNPF_FI_GREMSGResponse Message
T7UNPAD_CEBCNTEG CEB Country table
T7UNPAD_CTERM_TNPO: Text table for Contract Term ID for Infotype 0016
T7UNPAD_EGCOS_TNPO: Education Grant Cost Types text
T7UNPAD_RSCHRental Subsidy Schema
T7UNPAD_EGTCURPY-NPO: EG Settings for Currency
T7UNPAD_DSCA_TText for Duty Station Hardship Classification
T7UNPF_HR_SECONStaff Secondment details
T7UNPAD_AWARTNPO Aspects for Attendance/Absence Types
T7UNPAD_DSLGNPO: Map Language key to Language group
T7UNPAD_DS0GDuty Station Relation to SAP Entities Payscale Area
T7UNCMT_RMBRCMT Interface: Reimbursible Percentage
T7UNPAD_EGRS_TNPO: EG Reasontext for Boarding
T7UNPF_FI_STFHDStaff Member Header Table
T7UNPAD_EGCEBDuty Station CEB Relation to SAP Entity Duty Station
T7UNPF_HR_ADDRAddress
T7UNCMT_RGNTCMT Interface: Repatriation Grant
T7UNCMT_HRDCCMT Hardship Classification
T7UNOM_POSIT_TNPO Position Type
T7UNPAD_HSFAHardship flat amounts
T7UNOM_P_TITLE_TText table for T7UNOM_P_TITLE
T7UNPAD_EGADCR_TText of Reasons to Overwrite Advance Payment for EG
T7UNPF_HR_OPRHDOperation Header
T7UNCMT_LNGACMT Interface: Language Allowance
T7UNPF_FI_AMENDFinancial Interface Amendment
T7UN_ESS_WFLOWNPO : Details of workflows triggered from ESS
T7UNPF_HR_PHONEPhone Information
T7UN_T52CD_TText Table for Schema Directory
T7UNPAD_EGSNNPO: Education Grant Schools / Colleges
T7UNCMT_MBFACMT Interface: Mobility Element
T7UNPAD_DPACCounries for dependency allowance amount calculation
T7UNCMT_RET_PERPernr that needs Retrocalculation
T7UNPF_PFLANGTPF Language Code Text Table
T7UNPF_HR_PHNMPhone Mapping Table
T7UNPAD_RSDERental Subsidy Entitlements (Percentage)
T7UNPF_ATTRIBAttributes
T7UNCMT_DSUnited Nations CMT Duty Station
T7UNPAD_EG03NPO: Employee Group/Subgroup Eligibility
T7UNCMT_LOGLog Table
T7UNCMT_CITYCMT Interface: Country
T7UNCMT_RNGRCMT Interface: Rental Subsidy Global Reference
T7UNPAD_EGCTRNPO: EG Entitlement countries
T7UN_T52BPTexts for Operation Parameters
T7UNPAD_EGCANPO: EG Category Classification
T7UNPAD_DSREDuty Station Removal/Non-Removal Element
T7UNPAD_EG05NPO: EG Settings for Country
T7UNPF_HR_PARTParttime Details
T7UNCMT_HDSCCMT Hardship Classification
T7UNPAD_DDSADuty Station DSA Rates (Daily Subsistence Allowance)
T7UNPAD_UNISOLADuty Station Unified SOLA Rates
T7UNCMT_STFACMT Interface: Salary and Staff Assessment
T7UNBEN_T5UBI1NPO Benefit cost rule Dependents
T7UNPAD_CTERMNPO: COntract Term ID for Infotype 0016
T7UNBEN_T5UCHNPO Benefit Cost Rule Text
T7UNCMT_HDSPCMT Hardship Element
T7UNPAD_EGST_TNPO: EG School Types Text
T7UNPF_HR_CHILDChild details
T7UNPAD_AREADuty Station Area/Zone
T7UNPAD_AGENCYSAgencies
T7UNPAD_EGEXPMGTNPO: Expense Management Table
T7UNPAD_RSCH_TRental Subsidy Calculation Scheme Description
T7UNSLWOP_RCSLWOP periods to be ignored for next reclassification date
T7UNPF_HR_CATMMapping table for Pay scale type to Salary Category
T7UNTRV_SHIP_OPTNPO+ : Shipment Options for Travel value table
T7UNPF_HR_STFHDStaff Member Header Table
T7UNCMT_CNTYCMT Interface: Country
T7UNCMT_NRFACMT Interface: Non Removal Element
T7UNPAD_RSDRRental Subsidy Dwelling Rent Type
T7UN_ESS_PROPSNPO: Field Properties of Approver screen
T7UNCMT_RMXRCMT Interface: Rental Subsidy Maximum Rent
T7UNPAD_CTSTANPO: Contract Status ID for Infotype 0016
T7UNCMT_DS1PCMT Interface : Duty Station
T7UNOM_OUTYPE_TOrganisational Unit Type
T7UNPAD_CSRVTContract Service Type
T7UNPAD_DPDSDependency Allowance: Lowest Entry Level Determinatio
T7UNCMT_RETROTriggers for Retrocalculation
T7UNPAD_DSLC_TText for Duty Station Home Leave Cycle
T7UNPAD_ARPTCD_TAirport Code Text
T7UNPF_FI_TRANSAdditional Details
T7UNPAD_EGSGNPO: EG School Grade
T7UNPAD_ORGA_TUN Organizations / Programme Text
T7UNPAD_DS1PDuty Station Main Time-Dependent Information
T7UNCMT_LOADSCMT Deliveries Loads Executed
T7UNOBJASObject of assistance (local copy of NPO table)
T7UNCMT_MAPMapping of XML Names