Select data from sap tables T5G_
Display SAP table details
T5G01 - Tax Rates
T5G02 - Special Tax Code
T5G03 - Tax Increase and Limit
T5G05 - NIC Limits (obsolete: contains NI rates up to 1998)
T5G06 - NIC Percentages (obsolete: contains NI % up to 1998)
T5G08 - NI Control Data Texts
T5G09 - NI Categories (GB) OBSOLETE !!!
T5G0A - Employee Group/Subgroup
T5G10 - Pension Fund: OBSOLETE
T5G15 - Court Order Deductions
T5G16 - Court Order Indicator
T5G17 - Court Order CMEC (Obsolete)
T5G18 - Court Order CMEC
T5G1T - Pension Fund Texts
T5G20 - SSP System Data (GB)
T5G21 - SMP System Data
T5G22 - SSP Qualifying Day Pattern
T5G23 - Time Models for SSP Qualifying Day Patterns
T5G24 - SSP Qualifying Day Pattern Calendars
T5G25 - Occupational Sick Pay Schemes
T5G26 - OSP-Related Data for SSP Offsetting
T5G27 - SSP Rates Payable (GB)
T5G28 - SMP Rates Payable
T5G2E - SSP/SMP Exclusion Reason Texts
T5G2F - SSP/SMP Exclusion Reasons
T5G2F_DATED - SxP Exclusion Reasons
T5G2T - Text for Occupational Sick Pay Schemes
T5G30 - Pension Schemes
T5G31 - Pension Contribution Calculation Rules
T5G32 - Pension Holidays
T5G33 - Pension Contribution Calculation Rule Bands
T5G34 - Pension Contribution Calculation Rule - Flat Rates
T5G35 - Pension Contribution Calculation Rule - Percentages
T5G35F - P35: XML tag structure
T5G35P - HR-GB: Checklist fields for P35
T5G35V - P35: XML tag and attribute values
T5G35VT - P35: XML tag and attribute values - texts
T5G36 - Pension Contribution Calculation Rule - Mix
T5G37 - Pension Scheme Types
T5G38 - Minimum Pension Contribution Percentage - PAE
T5G3T - Pension Scheme Names
T5G40 - National Insurance Earnings Ranges (obsolete: old NI)
T5G41 - National Insurance Percentage Rates (obsolete: old NI)
T5G42 - HR-GB: National Insurance Categories
T5G43 - HR-GB: National Insurance Number Prefixes
T5G44 - HR-GB: National Insurance Number Prefixes (after 06.04.2017)
T5G4T - Text for Court Order Indicator
T5G50 - Tax Districts
T5G51 - Payroll Area PAYE Reference
T5G52 - Tax District and Reference Details
T5G53 - Permit Numbers
T5G54 - End Of Year Processing Stamp
T5G55 - HR-GB: Default Tax Code
T5G56 - HR-GB: Offshore employer details
T5G57 - HR-GB: Supplementary fields for P35
T5G5T - Tax District Name
T5G61 - Business Mileage Bands
T5G62 - Payment of Petrol Costs (Based on Engine Size)
T5G63 - Payments for Private Fuel (Basis: Car List Price)
T5G64 - Unavailability Reasons
T5G67 - Company car taxable percentage based on CO2 emissions
T5G68 - Company car taxable percentage based on engine size
T5G69 - Company car taxable percentage for ULEV/WHLV based on CO2
T5G6T - Unavailability Reasons Text
T5G70 - Official Rates for Beneficial Loans
T5G71 - Loan Categories
T5G80 - HR-GB: Payee Keys
T5G9A - Gross to net control report options
T5GASHE1 - ASHE Pension Type
T5GASHE2 - ASHE Collective Agreement Type
T5GBGC_XML - Link Correlation ID to Global B2A ID
T5GC3 - GB Company car C02 emmissions
T5GDT - Disability Type
T5GDTT - Disability Type Text
T5GEF01 - HR-GB: filing - Store parsed recording coming in from GG
T5GEFCREDENTIALS - HR:GB eFiling : User Credentials
T5GEFDATA - HR-GB: filing - Store Infotype data coming in from GG
T5GEFHWM - efiling infcoming forms (Hiigh Water Mark ) register
T5GEFMSGID - HR:GB eFiling : Temporary storage of Message IDs
T5GEFSTPE - HR GB: Employment Starter (P45,P46) and Pension Details
T5GMAP_XML - Schema info for parsing xml doc into abap structure
T5GPBS1 - CLASS CPX Pension Scheme Cross Reference
T5GPBS20 - Absence Evaluation: Check Window End Definition
T5GPBS20T - Absence Evaluation: Texts for Check Window End Definition
T5GPBS21 - Absence Evaluation: Check Window Start Definition
T5GPBS21T - Absence Evaluation: Texts for Check Window Start Definition
T5GPBS22 - Absence Evaluation: Non-Qualifying Day Rule Definition
T5GPBS22T - Absence Evaluation: Texts for Qualifying Day Rule Definition
T5GPBS23 - Absence Evaluation: Cover Package Rule Definition
T5GPBS23T - Absence Evaluation: Cover Package Rule Definition
T5GPBS24 - Absence Evaluation: Time Unit Factors
T5GPBS24T - Absence Evaluation: Texts for Time Unit Factor Definition
T5GPBS25 - Absence Evaluation: Part Day Evaluation Classes
T5GPBS26 - Absence Evaluation: Payment Day Rule Definition
T5GPBS26T - Absence Evaluation: Texts for Qualifying Payment Days
T5GPBS27 - Absence Evaluation: Valuation Rule Grouping Definition
T5GPBS28 - Absence Evaluation: Time Unit Grouping
T5GPBS29 - Absence Evaluation: Scheme Switches
T5GPBS30 - Absence Evaluation: Limit Rule
T5GPBS30T - Absence Evaluation: Texts for Limit Rules
T5GPBS31 - Absence Evaluation Cross Reference (T554S Extension)
T5GPBS32 - Absence Evaluation: Linking Absence Grouping
T5GPBS33 - SxP Absence Processing Type
T5GPBS41 - Vehicle classes for car mileage
T5GPBS42 - Declare vehicle types for private and business miles
T5GPBS43 - Lump sum payment for car mileage
T5GPBSB_REASON - Bar pointing: Reson for overriding bar point
T5GPBSB_REASONT - Bar pointing: Text for reason for changes
T5GPBSC_BAS - Hospital
T5GPBSC_BAST - Hospital text
T5GPBSC_CGR - Honorary NHS Status
T5GPBSC_CTY - HESA: Contract types
T5GPBSC_HON - Honorary NHS Status
T5GPBSC_HONT - Honorary NHS Status text
T5GPBSC_NHS - HESA: Assignment of NHS Contract Grade to Honorary Status
T5GPBSC_RBD - HESA: Regulatory body (clinical)
T5GPBSC_REG - Registration type
T5GPBSC_REGT - Registration type text
T5GPBSC_RTB - HESA: Assignment of Regulatory body to Registration type
T5GPBSC_SPE - Clinical Specialty
T5GPBSC_SPET - Clinical Specialty text
T5GPBSC_TRU - Health Trust
T5GPBSC_TRUT - Health Trust text
T5GPBSH13 - HESA: Occupational categories for HE jobs
T5GPBSH_ACD - HESA: Codes for Academic disciplines
T5GPBSH_ACDT - HESA: Codes for Academic disciplines text table
T5GPBSH_CCT - HESA: Cost centre (HEFCE)
T5GPBSH_CCT2 - HESA: Cost centre (HEFCE)
T5GPBSH_CCT3 - HESA: Cost centre (HEFCE)
T5GPBSH_CCTT - HESA: Cost centre (HEFCE)
T5GPBSH_CHA - Mapping of Challenge group to disability
T5GPBSH_COD - not used
T5GPBSH_CODT - not used
T5GPBSH_CONTROL - HESA NISR Control table
T5GPBSH_CTY - HESA: Contract types
T5GPBSH_CTYT - HESA: Contract types (text)
T5GPBSH_CTY_NEW - HESA: Contract types
T5GPBSH_DES - HESA: Destination on leaving - obsolete
T5GPBSH_DES2 - HESA: Destination on leaving
T5GPBSH_DEST - HESA: Destination on leaving (text) - obsolete
T5GPBSH_DIS - Academic disciplines
T5GPBSH_DIS2 - Academic disciplines
T5GPBSH_DIST - Academic disciplines text table
T5GPBSH_ETC - HESA: Ethnicity codes
T5GPBSH_ETCT - HESA: Ethnicity code text
T5GPBSH_ETH - HESA: Mapping of ethnicitiy code
T5GPBSH_ETH2 - HESA: Mapping of ethnicitiy code
T5GPBSH_GRA - HESA: Grade structure
T5GPBSH_GRAT - HESA: Grade structure (text)
T5GPBSH_IC - HESA: Institution Code
T5GPBSH_IS - HESA: Institution Identifier
T5GPBSH_NA - HESA: Mapping of Nationality to HESA Code
T5GPBSH_OCC - HESA: Occupational categories
T5GPBSH_OCCT - HESA: Occupational categories (text)
T5GPBSH_PL - HESA: Parental Leave
T5GPBSH_PRV - HESA: Employment in previous year - obsolete
T5GPBSH_PRV2 - HESA: Previous Employment
T5GPBSH_PRVT - HESA: Employment in previous year (text) - obsolete
T5GPBSH_PSB - HESA: Principal source of basic salary
T5GPBSH_PSBT - HESA: Principal source of basic salary (text) - obsolete
T5GPBSH_QUD - HESA: Highest academic qualification held - obsolete
T5GPBSH_QUD2 - HESA: Highest academic qualification held
T5GPBSH_QUDT - HESA: Highest academic qualification held (text) - obsolete
T5GPBSH_RAE - HESA: Acitve in 1996 Research Assessment Exercise
T5GPBSH_RAE2 - HESA: Active in 2001 and 2008 Research Assessment Exercise
T5GPBSH_RAET - HESA: Acitve in 1996 Research Assessment Exercise
T5GPBSH_RE - HESA: Religion or Belief
T5GPBSH_SSB - HESA: Secondary source of basic salary
T5GPBSH_SSBT - HESA: Secondary source of basic salary (text) - obsolete
T5GPBSH_UOA - HESA: Unit of Assessment
T5GPBSP_ER_RATE - LGPS: Employer's Rate
T5GPBSP_PRO - LGPS Protected Contribution Rates
T5GPBSP_PSCH - Local Government Pension Schemes
T5GPBSP_SCH - GBLGP: Pension Schemes
T5GPBSP_UNP - LGPS Unprotected Contribution Rates
T5GPBSQ_ACQ - Academic qualification - obsolete
T5GPBSQ_ACQ2 - Academic qualification
T5GPBSQ_ACQT - Academic qualification text table
T5GPBSQ_PRO - Professional Body
T5GPBSQ_STA - Membership Status
T5GPBSS_ABS - SWF: Absences
T5GPBSS_ADD - SWF: Additional Payments
T5GPBSS_ADD2 - SWF: Additional Payments
T5GPBSS_DIS - SWF: Disablity
T5GPBSS_ETH - SWF: Ethnicity
T5GPBSS_ETH2 - SWF: Ethnicity with CodeSet
T5GPBSS_PSC - SWF: Pay Scale
T5GPBSS_PSC2 - SWF: Pay Scale
T5GPBST_CONTROL - TPS Control records
T5GPBST_EXC - TPS Absence evaluation rules relevant as days excluded
T5GPBST_LEA - TPS: LEA numbers and names
T5GPBST_PEN - TPS Primary and Additional pension schemes
T5GPBST_SER - TPS Recordable service
T5GPBST_SSCALE - TPS Salary Scale Codes
T5GPBST_SSCALET - TPS Salary Scale Code Description
T5GPBS_ALL - ALL Constants & Texts (as required)
T5GPBS_ALLT - ALL Text Table
T5GPBS_CARALLOW - HRGPBS: Car Allowance for essential car users
T5GPBS_CODESET - Code Sets
T5GPBS_CS_CODES - Code Set Codes
T5GPBS_CS_MAP - Hesa DDIC text structure mapping
T5GPBS_MEREPORTS - Multiple employment: Reports that are can be set for ME
T5GPBS_ME_TA - ME Tax Districts/References Trading in Association
T5GPBS_SEL - ME: Selection in reporting (Primary/all)
T5GPBS_TRANS - GB-ME: Transfer of w'types between 2ndary and 1st contract
T5GPBS_USS - Absence Evaluation: Scheme Switches
T5GPBS_USS_ABST - USS: Absences types
T5GPBS_USS_FAMS - USS: Marital statuses
T5GPBS_USS_RFL - USS: Reason for Leaving
T5GPBS_USS_SCHID - Generated Table for View
T5GPBS_USS_TITL - USS: Titles
T5GPBS_USS_VSC - USS: Voluntary Salary Cap
T5GPBS_VEHCLASS - Derive vehicle class from car manufacturer and model
T5GPBS_VEHTYPE - Derive vehicle types from car information
T5GQDP - QDP Definition
T5GQDPT - QDP Text table
T5GQDP_GPG - QDP to QDP Grouping Assignment
T5GQDP_QDP - Week to QDP Assignment
T5GQDP_WK - QDP Day to Week Assignment
T5GQDP_WKT - QDP Day to Week text
T5GT1 - Tax Rates
T5GT2 - Special Tax Code
T5GTUPE - TUPE Organisations
T5GXMLSTRUC - HR:GB Efiling - Structure to store and retrieve XML files fr
T5G_AEFORMS - HR-GB-PAE: Use of Smart Forms in Reports
T5G_AE_CYC - PAE: Cyclical Automatic Re-Enrolment Codes
T5G_AE_CYCD - PAE: Cyclical Automatic Re-Assessment Dates
T5G_AE_CYCT - PAE: Cyclical Automatic Re-Enrolment Codes Text
T5G_APP01 - Apprentice Levy Allowances - PAYE References
T5G_ASHE_CONTROL - ASHE Control Table
T5G_CONVNI - NI Conversion: Mapping customer wage types
T5G_DPIRM_DATE - GB Archiving Group Method
T5G_DTOAL - Apprenticeship Levy Data Take-On
T5G_DTOCV - PY-GB: Company Cars/Vans - Data Take On
T5G_DTONI - National Insurance Data Take-on
T5G_ERPEN - Absence Valuation
T5G_ERPENCUM - Employer's Pensionable Pay options
T5G_EYUUPLOAD - RTI: Upload Table for EYU Forms
T5G_GPG01 - Gender Pay Gap : Define Legal entity
T5G_NICLIM - NIC Limits
T5G_NICPCT - NIC Percentages
T5G_NIDTO - National Insurance data take on
T5G_P46ARV - HR-GB: Archive for P46(Car)-Forms
T5G_PRFID - Proof of Identity Type GB
T5G_RTIDC - RTI Declaration Data
Return Table index
