SAP USA Tables

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

Top 10 tables in USA

TableDescription
T7US_FMLA_RULTXTRule Texts for Administration of FMLA Events
T5UVTVeteran Status
T5UTCStates of operation or residency
T5UTKMarital Status
T5UTVUnemployment Insurance Work Sites/NC-9901 Locations
T7US_FMLA_WRKWKRule for Determining Week Converter
T5UWTWC: Classification Code Text
T7US_FMLA_DETWWKTable of Relationships: Week Converter and Feature WWKMO
T5UWXWC: Experience modifier / Account Number assignment
T5UWLWC: Officer wage limit

List of tables in USA

TableDescription
T7US_FMLA_RULTXTRule Texts for Administration of FMLA Events
T5UVTVeteran Status
T5UTCStates of operation or residency
T5UTKMarital Status
T5UTVUnemployment Insurance Work Sites/NC-9901 Locations
T7US_FMLA_WRKWKRule for Determining Week Converter
T5UWTWC: Classification Code Text
T7US_FMLA_DETWWKTable of Relationships: Week Converter and Feature WWKMO
T5UWXWC: Experience modifier / Account Number assignment
T5UWLWC: Officer wage limit
T5UWSWC: Workers' Comp. Wage Type Assignment per WC State
T7US_FMLA_RULERules for Administrating FMLA Events
T5UPBSPA15Federal Health Plan (PS)
T5UVETTVeteran Status Texts New
T5UTLTax Company
T5UPBSPA27TValidation Rule Text
T7US_FMLA_RU2REAssignment of FMLA Reasons to FMLA Rules
T5UTGZIP Code Ranges for Work Tax Areas
T7US_FMLA_WWKTXTRule Texts for Determining Weekly Working Time
T7US_FMLA_REASONFMLA Reasons
T5UPBSPA11TAnnuitant Indicator Text
T5UWEWC: Experience rate assignment
T5UPBSPA21TValidation Field Group Field Text
T5UTHTax Number <-> BSI Tax Interface
T5UOCOccupational Classification Code Categories
T5UPBSPA04Legal Authority Attributes (PS)
BTXERESBSI: Employee/Employer tax
T5UPBSPA12Retirement Plan (PS)
BTXEMPTBSI: Employee tax results
T505NMilitary Status Texts
T7US_FMLA_PROFFMLA Workbench: Profile Settings
T5UPBSPA26Value Table Access Methods per Group
T5UPBSPA17Validation Groups
T5UACAlaska Workers Compensation Area Code
PA0459HR Master Record for Infotype 0459
T5UZCZip Code Areas
T5UVTTVeteran Status Texts
T505YTax Authority Texts
T5U0EEqual Employment Opportunity Record
T5UPBSPA16Federal Health Plan Mapping (PS)
BTXTINFBSI: Test information
T5UPBSPA14Federal Work Schedule (PS)
BTXEERRBSI: Error messages
T505LGrievance Level Texts
T505VResidence Status Texts
BTXCMTHBSI: Tax calculation method
T5UPBSPA20TValidation Field Group Text
T505KGrievance Levels (NA)
BTXMESSBSI: Error Messages Entities
T5UVETVeteran Status New
BTXTERRBSI: Employee Payroll Error Message Grouping
T5UPBSPA18Validation Field Groups per Validation Group
T5U94Document ID - Personal ID and Work Permit (USA)
T5USWLWC: State Wage limits
PA0894HR Master Record: Infotype 0894
T5UPBSPA30Validation Rules per Rule List
T5UPBSPA25TValue Table Access Group Text
T5UPBSPA21Validation Field Group Definition
T505REthnic Origin
T5U27EEO/AAP: Organizational Unit attributes
T5UPBSPA29TValidation Rule List Text
BTXPURGBSI: Purge Periods in Months
T5UPBSPA01Nature of Action Code
PA0895HR Master Record: Infotype 0895
PA0448US Federal Tax QTD
HRBEN_D_LEGDEPTable for identifying legal dependants
PA0566HR Master Record: Infotype 0566
T5UTNBSI Authority Numbers with Sequential Number per State
T505PGrievance Reason Texts
T5UPBSPA17TValidation Group Text
PA0076HR Master Record: Infotype 0076 (Workers Compensation NA)
T5UPBSPA08Assign Legal Authorities to NoA Codes
T509HType of work permit
T5UWCWC: Classification Code
T5UPBSPA07Assign Remarks to NoA Codes (PS)
T5UWWWC: WC Wage per state (Obsolete since 4.5A/4.0C)
T5UPBSPA27Validation Rules
T5USOWC: Standard Occupational Code
T7US_FMLA_RESTXTText Table for FMLA Reasons
T505MMilitary status
PA0458HR Master Record for Infotype 0458
T5U26WC: Assignment of WC to Organizational Units
T505ZBonds (NA)
T558SPayroll table type
PA0814HR Master Record: Infotype 0814
T5UPBSPA03Legal Authority Code (PS)
T5UOCGTOccupational Classification Group Texts
T5UEEOEqual Employment Opportunity Record
T5UPBSPA06Remark Code Attributes (PS)
T5U13Jobs
T5UPBSPA14TFederal Work Schedule Text (PS)
BTXSUPBBSI: Upgrade-Information
T5UOCTOccupational Classification Code Texts
T5U25WC: Job Attributes
PTFMLAABRelationship Between Absences and FMLA Events
T5UEEEEO Occupational Categories
T509GID type text
T505UResidence Status
T5UPBSPA15TFederal Health Plan Text (PS)
T7US_FMLA_PRFTXTFMLA Workbench: Description of Profile Settings
T5UPBSPA05Remark Codes (PS)
T505OGrievance Reasons (NA)
T5UPBSPA12TRetirement Plan Text (PS)
T5U29EEO/AAP: Position Attributes for US
T5UPBSPA19Value Table Access Groups per Validation Group
T5UAAAAP Occupational Categories
PA0672FMLA Event Infotype
T5UPBSPA28Validation Rule Definition
T7US_FMLA_DETRULTable of Relationships: FMLA Rule and Feature FMLMO
T5UMAHR-US: NC-9901 Major Activity Code Check Table
T505SEthnic Origin Texts
T5USCU.S. Standard Industrial Classification Codes
PA0094HR Master Record: Infotype 0094 (Residence Status - NA)
PA0102HR Master Record: Infotype 0102 (Grievances NA)
T5UPBSPA22Table and Return Information per Access Method
T5UWMWC: Manual rate assignment
T5URUUS Establishment/Work Unit for Reporting
BTXTRESBSI: Tax Results
BTXTTAXBSI: Test Taxes
PA0447US Federal Tax MTD
T5UPBSPA20Validation Field Groups
T5UPBSPA02Nature of Action Attributes
T7US_FMLA_AB_ADMPermissibility of Absences for FMLA
T5UPBSPA29Validation Rule List
T509IWork permit type text
PA0460HR Master Record for Infotype 0460
T5U28WC: Position Attributes
T505XTax Authority Table
T5UPBSPA25Value Table Access Groups
T5UOCGOccupational Classification Groups
T5U0PAdditional organizational data for personnel area/subarea
T509FID type
T5UPBSPA23Selection Rule Definition
T5UPBSPA11Annuitant Indicator
T5UPBSPA24Default CPDF Value Table
T5UADAddress for US Reporting Units
T504RTo be deleted - no longer used!