SAP Netherlands Tables

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

Top 10 tables in Netherlands

TableDescription
T77PRNL_ICPParticularization of Income Relationship
PA0408HR Master Record: Infotype 0408 (CBS NL)
T5N1ASocial Insurance Indicator (NL)
T5N2VNational Insurance Contributions (NL)
PA0317HR Master Record: Infotype 0317 (Special Provisions)
T5N5WProfessional Group Code
T5N74Insurance Obligation Influence Code
T5N13TText Table for Risk Group Sector
T5N72Indicator of Type of Work Relationship for Wage Return
T5N5HCorrect Combinations of Social Security Schemes (NL)

List of tables in Netherlands

TableDescription
T77PRNL_ICPParticularization of Income Relationship
PA0408HR Master Record: Infotype 0408 (CBS NL)
T5N1ASocial Insurance Indicator (NL)
T5N2VNational Insurance Contributions (NL)
PA0317HR Master Record: Infotype 0317 (Special Provisions)
T5N5WProfessional Group Code
T5N74Insurance Obligation Influence Code
T5N13TText Table for Risk Group Sector
T5N72Indicator of Type of Work Relationship for Wage Return
T5N5HCorrect Combinations of Social Security Schemes (NL)
T5N2EText: Wage Tax [Loonheffing] Table (NL)
T5N2SSpecial Indicator Codes (Tax Authority)
P05FBN_PLTYP_EIGCharacteristics of Plan Type
T5N15TText Table for Risk Group Sector
P05FBN_BSTGRPSpending Group
T5N9PRepresenting Legal Persons (for External Agencies)
T5N1NText: Social Insurance Schemes (NL)
PA0127HR Master Record: Infotype 0127 (Commuter Traffic NL)
T5N11Short and Long Texts for Social Insurance Schemes (NL)
T5NM2TDescription of Signals (not used)
T5N3ASocial Fund Decisions (NL)
T5N73TText Table for Collective Agreement Indicator
P05T_JWN_SPINDSpecial Indicator Codes (to hide in the yearly statmnt form)
T5NM3Assignment of Signal to Signal Grouping
T5N9BText: Authority Text (NL)
T5N9DExecutive Authority and Tax Office Notification (NL)
T5N14Additional Legal Person Data for Wage Return
P05EIR_ADDRESSElectronic Illness Reporting: Employee's Address Data
T5NI4PW Absence Types
T5N1TNSI: Created Data Records (Retroactive)
T5N1RText: Pensions (NL)
T77EIRNLTGRTYPETElectronic Illness Reporting (NL): Trigger Types Text
P05EIR_ADM_UNITElectronic Illness Reporting: Administrative Unit Data
PA0063HR Master Record: Infotype 0063 (Social Fund - NL)
T5N2DTax Table Category (NL)
T5N9EText: Authority Notifications (NL)
P05EIR_TMP_RECOBSOLETE: EIllness Reporting: temporary records (due to SIS)
T5N2NText: Tax Table Periods (NL)
P05EIR_ABSENCEElectronic Illness Reporting: Absence Data
T5N1YRevision Reason
P05FBN_KMOD_OMSDescription Programs
P05EIR_MSG_PAYLOElectronic Illness Reporting: Message Payloads
T5N71Flexibility and Security Phase Categorization Code/Obsolete
T5NI2TDescription of 'Permanent Invalidity Benefit' plan
T5N2YConversion Table for Final Levy
P05EIR_MTY_STATElectronic Illness Reporting: Status Table
T5N5GPrimary Insurance Cover/Capacity of the Insured (NL) (New)
PA0060HR Master Record: Infotype 0060 (Fiscal Data - NL)
T5N9HAssign Events to Pers. Actions and Reasons f. Pers. Actions
T5N1EHealth Insurance Contr. for Privately Insured Employees (NL)
P05EIR_TAB_TOELElectronic Illness Reporting: Additional Explanations
T5NI1TDescriptions PW Activities
P05FBN_BSTG_OMSDescription Spending Group
PA3274HR Master Record: Infotype 3274
T5NM2Signals for MOMI
P05FBN_DLVR_EIGCharacteristics of Target Variants
T77EIRNL_MSGPRXElectronic Illness Reporting NL: Message proxies
T5N1BSocial Insurance Indicator Texts (NL)
T77PRNL_CAOTCollective Agreement Indicator Text Table
T5N5GTText: Primary Insurance Cover/Capacity of the Insured (NL)
T5N4CTransportation Indicators for Commuter Traffic (NL)
T5N5SText: Professional Group Code (NL)
T77EIRNL_MSGTGRElectronic Illness Reporting NL: Message triggers
T77EIRNL_BCK_PRXElectronic Illness Reporting NL: Association Backend & Proxy
P05FBN_ACGRP_OMSDescription Absence Quota Groups
PA0897HR Master Record Infotype 0897
PA0059HR Master Record: Infotype 0059 (Social Insurances - NL)
T5N82Employer Contribution to Life-Course Savings Scheme
P05FBN_DVRT_OMSDescription Target Variant
T77EIRNL_MSGFLDElectronic Illness Reporting NL: Fields per Message
T5NI5PW Activities
T5N1SSocial Insurance Contribution Data
P05FBN_CMB_CONTRCombination Checks
T5N81TEE Grouping for ER Contrib. to Life-Course Savings Scheme
T5N2WSpecial Indicator Codes (to hide in the yearly statmnt form)
T77PRNL_OCCCode Occupation
T5N81EE Grouping for ER Contrib. to Life-Course Savings Scheme
P05FBN_DOELVRTTarget Variant
PA0110HR Master Record: Infotype 0110 (Pensions NL)
T5N12Social Insurance Groups (NL)
T5N1OIndustrial Insurance Board [Bedrijfsvereniging] Data (NL)
PA0854HR Master Record for Infotype 0854
P05FBN_ADD_PLANFlexible Benefits NL: Additional Data Benefit Plans
T5N19Check Table for Group
T5N05Registration of Countries of Birth [Wet SAMEN]
T5N5TText: Primary Insurance Cover/Capacity of Insured (NL)
T5N9FTab. f. Comb. of Pers. Actions and Reasons for Pers. Actions
P05FBN_WZR_PLANSet Changeable Plans for Adjustment Reasons
P05FBN_WZR_VOLGAdjustment Reason: Additional Details for Update IT0378
P05FBN_CATEG_OMSDescription Benefits Categories
T5N9GText Table for Comb. of Type of Pers. Action and Reason
T5N2JConversion Rules for Wage Tax [loonheffing] (NL)
T5N2AWage tax [loonheffing] Conversion Rule Indicators (NL)
T5N2HSpecial Payments Table [Bijzondere Beloningen] (NL)
P05FBN_KEUZEMODPrograms
PA0409HR Master Record: Infotype 0409 (External Agencies NL)
T5NIIIncome Indicators (NL)
T5N9AAuthority Addresses (NL)
PA0525Childcare
P05EIR_AANGIFTEElectronic Illness Reporting: Data for Wage Information
T5NM1TDscription of Signal Grouping for MOMI
T5N2TText: Special Indicators (Tax Authority)
T5N73Indicator of Collective Agreement for Wage Return
T77PRNL_ICRType of Income Relationship
T5NM1Signal Grouping for MOMI
T5N5BProfessional Group Code (NL)
T5N9RRelationship Repr. Legal Person and External Agencies
T5N5DNSI: Created Data Records
P05EIR_IKVElectronic Illness Reporting. Work Relationship Data
P05EIR_MSG_STATElectronic Illness Reporting : Status (Obsolete)
P05FBN_AFWPLAdditional Data Absence Plans
T5N15Sectors
P05FBN_BRON_EIGCharacteristics of Sources
P05EIR_ILLNESSElectronic Illness Reporting: Illness Data
PA3200HR Master Record for Infotype 3200
PA0879Personnel Master Record Infotype 0879
T5N1CHealth Insurance Companies (NL)
P05FBN_VERRCancellation
P05FBN_BRON_BSTAmounts to spend per Source
P05EIR_MSG_ADMElectronic Illness Reporting: Status Administration
PA0303HR Master Record: Infotype 303 (Premium Reductio NL)
P05EIR_WAZOElectronic Illness Reporting: WAZO Data
T77PRNL_OCCTCode Occupation Text Table
T5N9IExternal Agencies
T5N2FIncome Indicators (NL)
T5N5FText: Special Indicators (UVI)
T5N2QWage Tax [Loonheffing] Exemptions (NL)
T5NRERetirement Age (AOW Age)
T5NI2Eligibility for Perm. Inv. Benefit (Restrictions) Act plan
T5N5APrimary Insurance Cover/Capacity of the Insured (NL)
T77PRNL_CAOCollective Agreement Indicators
T5N2XFinal Levy Percentage
T5N5UText: Pay Scale [CAO] Indicator
T77EIRNL_BCKPRXNElectronic Illness Reporting NL: Association Backend & Proxy
T5N4ALump Sum Commuter Allowance (NL)
T5N2GTax Classes for Wage Tax [loonheffing] (NL)
T5N9CText: Authorities (NL)
T77EIRNL_MTYPE_TElectronic Illness Reporting NL: Message Types Text Table
P05FBN_DOEL_EIGCharacteristics of Targets
T5N1Y_TRevision Reason - Text table
T5N2MTax Table Periods (NL)
PA3250HR Master Record: Infotype 3250
P05FBN_CATEGORIEBenefits Categories
PA0764Personnel Master Record Infotype 0764
T5N9JText: External Agencies
T5N1MText: Social Insurance Groups (NL)
P05EIR_CH_PARTYElectronic Illness Reporting: Chain Party Data
T5N5CPay Scale Indicator
T5N75TFlexibility and Security Phase Categorization Indic. Text
T5N2ICompens. Allowance [OT] Table for Special Payments (NL)
T5N1QPension Accounting (NL)
T77EIRNL_MTYPEElectronic Illness Reporting NL: Message Type
T5N1PSI Deduction [Vereveningsbijdrage] for Civil Servants (NL)
T5N9ORepresenting Legal Person Text
T77PRNL_ICPTParticularization of Income Relationship Text Table
P05FBN_AC_GROEPAbsence Quota Groups
T77EIRNLTGRTYPEElectronic Illness Reporting NL: Trigger Types
T5N2CMarital Status for Wage Tax [Loonheffing] (NL)
P05EIR_MSG_TYPEElectronic Illness Reporting: Status Table Administration
P05EIR_PERSOONElectronic Illness Reporting: Natural Person Data
HRPADNLP_CPHRRClaim Payee and HCM Person Relation
P05FBN_KMOD_PRGRProgram assignment
T5N71TFlexib. and Security Phase Categorization Code Text/Obsolete
T5N4BText: Transportation Indicators for Commuter Traffic (NL)
T5N75Flexibility and Security Phase Categorization Code
PA0264HR Master Record: Infotype 0264 View for Infotype 0021
PA0808HR Master Record Infotype 0808
T5NI3Default PW Plan
T5N4DCommuter Allowance (NL)
PA3210HR Master Record: Infotype 3210
T5N0AGeneral Data (NL)
PA0177HR Master Record: Infotype 0177 (Reg. Country of Birth NL)
T5N2RText: Wage Tax [Loonheffing] Exemptions (NL)
T5N72TText Table Indicator of Type of Work Relationship
T5N74Tnsurance Obligation Influence Code Text
T5N1FText: Health Insurance for Privately Insured Persons (NL)
T5N5ESpecial Indicator Code (UVI)
T5N13Risk Group Sector Code
T77PRNL_ICRTType of Income Relationship Text Table
T5N2BText: Conversion Rules (NL)
PA3249HR Master Record: Infotype 3249
T5N22Final levy conversion table for special employee groups
T5N1DEmployer's HI Contrib. for Privately Insured Employees (NL)
P05FBN_AFWPL_INDEntry Factor Absence Plans