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 (PY-US) module.

Top 10 tables in USA

TableDescription
T5UTTTax Types
PA0208HR Master Record: Infotype 0208 (Work Tax Area - USA)
PA0077HR Master Record: Infotype 0077 (Additional Personal Data)
PA0452HR Master Record: Infotype 0452
HRCCE_T_THRRULEDefine Threshold Rules
HRCCE_TT_W_CODEClaims threshold model text
HRCCE_T_MNWGVALMinimum Wage Amount for States
P2RU_NAMEName of Employee
PA0209HR Master Record: Infotype 0209 (Unemployment Insurance USA)
PA0506Tip Indicators

List of tables in USA

TableDescription
T5UTTTax Types
PA0208HR Master Record: Infotype 0208 (Work Tax Area - USA)
PA0077HR Master Record: Infotype 0077 (Additional Personal Data)
PA0452HR Master Record: Infotype 0452
HRCCE_T_THRRULEDefine Threshold Rules
HRCCE_TT_W_CODEClaims threshold model text
HRCCE_T_MNWGVALMinimum Wage Amount for States
P2RU_NAMEName of Employee
PA0209HR Master Record: Infotype 0209 (Unemployment Insurance USA)
PA0506Tip Indicators
P2RU_TAXRPayroll result: Tax authorities of resident/unemployment(US)
PA0941HR Master Record: Infotype 0941
HRCCE_T_WT_CODEClaims Threshold Rule Code Definition
PA0161HR Master Record: Infotype 0161 (Limits IRS)
HRCCE_T_WT_CODETClaims threshold model text
P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)
T5UF0HR-US: ADP Interface
PA0106HR Master Record: Infotype 0106 (Related Persons NA)
HRPAYUS_D_CLD_01BSI TaxFactory SaaS : User Credentials
P2RU_ADRAddress
PA0456HR Master Record: Infotype 0456
PA0210HR Master Record: Infotype 0210 (W4 USA)
PA0457HR Master Record: Infotype 0457
PA0234HR Master Record Infotype 0234 (Add. Withh. Inform. - USA)
HRPAYUS_D_CLD00BSI eFormsFactory Communication Status
PA0454HR Master Record: Infotype 0454
T5UTXTax Rates and Ceilings
PA0449HR Master Record: Infotype 0449
T77PAYUS_TCADITax Company additional information
T5UAPAddress for personnel area/subarea
PA0451HR Master Record: Infotype 0451
T5UF1HR-US: ADP Interface, ADP Fields
T5UG3Model for Calculation of the Non-Exempt Amount
T77PAYUS_SYNXCRegistry Data for Synchronization TUB Level (US)
HRCCE_T_RULECRISet the threshold rule criteria
T5UTRCPayroll USA: Tax Reciprocity Attributes
PA0103HR Master Record: Infotype 0103 (Bond Purchases NA)
T5URCHR payee for taxes derived from wage types via tax attr.
T5UTMTax Model
P2RU_UTIPSPayroll Results: Cumulated tips result
T5UP3Establishment text
T5UFBSAP to ADP tax authority mapping table
PB0077HR Master Record: Infotype 0077
T5UTDDefault Tax Types
T5UCP_STATECommon Paymaster Acknowledgement for States
T5UG6Government Service Charge
T77USPAY_COBASECost distribution base configuration
T5UTOAssignment of technical wage types to tax types
T5UF5HR-US: ADP Interface, fields per record type
P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)
T5UGDFiling Status
T5UTQTax Authority Combination for Local Reciprocity
T5UF6HR-US: ADP Interface, Mapping Information
T5UP6TDistribution Codes Text
T5US0Priority for tax wagetypes
T5UTRTax Authorities per Resident Tax Area
HRCCE_T_RULEDEFDefine Threshold Rules
T5UGHLevy Statement
T77PAYUS_SYNTXRegistry Data for Synchronization Tax (US)
PA3431HR Master Record: Infotype 3431
HRPAYUS_D_EIWO_Ee-IWO Employer Initiated Actions
T5UP2Establishment/stores for tip processing
T5UTLAVKTTexts for Variable Key
HRCCE_T_WGTPRTYWage Type Priority Table
P2RU_UNBPayroll Results: Tax Retro Differences -(USA)
T5UTZTax Authorities
P2RU_USVERSSoftware Version Information (US)
T5UTAResident Tax Areas
T5UT0SAP Taxability Matrix Table
T5UG0HR: Garnishment Order Types
T5US1SAP Taxability Matrix Table
T5UGFDetermining Additional Exempt Amount
PA0096HR Master Record: Infotype 0096 (Tax - USA)
T5UTETax Authority / Tax Calculation Model
P2RU_NRCTUS Tax 1042S Processing
T77PAYUS_CLDFEINPayroll related FEINs
T5UTBWork Tax Areas
HRCCE_T_WGTPRIOWage Type Priority Table
PA0455HR Master Record: Infotype 0455
T5UG1HR: Garnishment Document Category
T77CCE_WT_GROUPWage Type Grouping
P2RU_TCRTPayroll results: Tax accumulation (USA)
PA0104HR Master Record: Infotype 0104 (Bond Denominations NA)
T5UTZCTax Authority Attributes
T5UFDVariables for ADP company set up
T5UGKPrint Request of Answer Letters
PA0269HR Master Record: Infotype 0269 (ADP Information USA)
T5U8ATransfer ext.payroll result: Tax cumulation data (USA)
T5UTLAVKAdditional Attributes of Tax Company on Tax Authority Level
T5UGGCompany Service Charge
T5UG5Model of the Disposable Net
P2RU_GRDOCPayroll Results: Garnishment for US Document
T5UTUWage Base Continuity for Tax Authorities
P2RU_TAXPayroll Results: Tax (U.S.)
T7US3PR_TXSYMKOPosting of tax wage types
P2RU_DOC0Payroll Results: Additional C0 Data (PSG)
T5UGEDetermining Amount Exempt from Levy
T5UG4Rules for Calculation of the Non-Exempt Amount
T5UTFZIP Codes for Residence Tax Areas
PA0195HR Master Record Infotype 0195 (Garnishment Order)
T5UTWTax Authorities per Work Tax Area
T77PAYUS_TXCMPTax Company Configuration
T5UCP_COMPMCommon Paymaster Relationship
T5UCP_CPCFICommon Paymaster: Map posting wage types to CP tax company
T5UTYTax Type Combinations
T5UTLATimedependent Attributes of Taxcompany on Taxauthority Level
P2RU_GRRECPayroll Results: Garnishment for US Record
P2RU_TAXPRAuthorities tax prorates
P2RU_BALPayroll Results: Tax Retro Differences -(USA)
T5UP6Distribution Codes
T5UP1Minimum and cash wages for tip credit
T5UGIGarnishment Letters
T5UF2HR-US: ADP Interface, used fields per Interface
PA0207HR Master Record: Infotype 0207 (Residence Tax Area)
PA0235HR Master Record: Infotype 0235 (Other Taxes - USA)
T5UGLFunction Exit for Garnishment Letters
T51G2Off-Cycle Batch Table
T5UFAADP Interface: Mapping Table between SAP and ADP Wage Types
T5USLStates relevant for BSI TaxLocator
P2RU_PERMPersonal Characteristics
PA0216Garnishment Adjustment
PA0450HR Master Record: Infotype 0450
T5UP5Distribution Payments Mapping
HRCCE_T_WCODEClaims threshold model text
T5UB8Benefits Payment Model Assignment
PA3430HR Master Record: Infotype 3430
P2RU_CLM_PERSONOverpayments Processing structure
PA0453HR Master Record: Infotype 0453
P2RU_SFTVERSoftware Version Information
T5UGJPrint Request of Notification Letters
T5UGASpecial Rule for Calculation of the Non-Exempt Amount
T5UTSStates without withholding tax
PA0194HR Master Record Infotype 0194 (Garnishment Document)
P2RU_GRORDPayroll Results: Garnishment for US Order
P2RU_DNRCTPayroll Results: Retro Differences 1042S -DNRCT- (USA)
T5UGMHR: Garnishment Originator
PA0909HR Master Record: Infotype 0909
T5UF3HR-US: ADP Interface, field sort
T5UF4HR-US: ADP Interface, Record type
T5UP4Establishment level adjusted gross receipts
T5UG2Adjustment to the Disposable Net
BRCDTABSI-TAX 4.0 BRCDTA
BRCGENBSI-TAX 4.0 BRCGEN
BRCRCPBSI-TAX 4.0 BRCRCP
P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)
T5UU0SAP Taxability Customized Table
P2RU_CLMOverpayments Processing structure
T5UG7Government Remittance Rule
T77PAYUS_VTYPe-IWO Validation Action Type
T5UFEADP system variables
T5UFCADP Company Codes
T5UTITax identification number and successor enterprise
T77PAYUS_SCFGe-IWO Configuration by Jurisdiction
T5UGBCalculation Scheme for Special Rule
T5UG9Garnishment Default Values
BRCGDTABSI-TAX 4.0 BRCGDTA
T5UFFPersonnel area to ADP company code mapping (US ADP only)
HRCCE_T_THRSTATSet threshold rule for a criteria
T5UG8Company Remittance Rule
T5UGCService Charge
HRPAYUS_D_EIWO_Oe-IWO Orders
P2RU_GRCUMCumulation for garnishment results
BRCMESABSI-TAX 4.0 BRCMESA
THRCCE_OCRReasons for Off-Cycle and Claims Run
P2RU_DOWPPayroll Results: Additional WPBP Data (PSG)