SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

231 tablesERP 6.0 

Payroll :: USA
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BRCDTA311BSI-TAX 4.0 BRCDTAUSA
2ERP EHP76.0BRCGDTA311BSI-TAX 4.0 BRCGDTAUSA
3ERP EHP76.0BRCGEN101BSI-TAX 4.0 BRCGENUSA
4ERP EHP76.0BRCMESA121BSI-TAX 4.0 BRCMESAUSA
5ERP EHP76.0BRCRCP121BSI-TAX 4.0 BRCRCPUSA
6ERP EHP76.0HRCCE_TT_W_CODE51Claims threshold model textUSA
7ERP EHP76.0HRCCE_T_MNWGVAL81Minimum Wage Amount for StatesUSA
8ERP EHP76.0HRCCE_T_OCR31Reasons for Off-Cycle and Claims RunUSA
9ERP EHP76.0HRCCE_T_OCRT41Gründe für Off-Cycle Abrechnungen - TexteUSA
10ERP EHP76.0HRCCE_T_RULECRI91Set the threshold rule criteriaUSA
11ERP EHP76.0HRCCE_T_RULEDEF91Define Threshold RulesUSA
12ERP EHP76.0HRCCE_T_THRRULE71Define Threshold RulesUSA
13ERP EHP76.0HRCCE_T_THRSTAT91Set threshold rule for a criteriaUSA
14ERP EHP76.0HRCCE_T_WCODE51Claims threshold model textUSA
15ERP EHP76.0HRCCE_T_WGTPRIO61Wage Type Priority TableUSA
16ERP EHP76.0HRCCE_T_WGTPRTY61Wage Type Priority TableUSA
17ERP EHP76.0HRCCE_T_WT_CODE61Claims Threshold Rule Code DefinitionUSA
18ERP EHP76.0HRCCE_T_WT_CODET51Claims threshold model textUSA
19ERP EHP76.0PA0077761HR Master Record: Infotype 0077 (Additional Personal Data)USA
20ERP EHP76.0PA0096831HR Master Record: Infotype 0096 (Tax - USA)USA
21ERP EHP76.0PA0103391HR Master Record: Infotype 0103 (Bond Purchases NA)USA
22ERP EHP76.0PA0104511HR Master Record: Infotype 0104 (Bond Denominations NA)USA
23ERP EHP76.0PA0106621HR Master Record: Infotype 0106 (Related Persons NA)USA
24ERP EHP76.0PA0161271HR Master Record: Infotype 0161 (Limits IRS)USA
25ERP EHP76.0PA0194521HR Master Record Infotype 0194 (Garnishment Document)USA
26ERP EHP76.0PA0195461HR Master Record Infotype 0195 (Garnishment Order)USA
27ERP EHP76.0PA0207251HR Master Record: Infotype 0207 (Residence Tax Area)USA
28ERP EHP76.0PA0208271HR Master Record: Infotype 0208 (Work Tax Area - USA)USA
29ERP EHP76.0PA0209251HR Master Record: Infotype 0209 (Unemployment Insurance USA)USA
30ERP EHP76.0PA0210431HR Master Record: Infotype 0210 (W4 USA)USA
31ERP EHP76.0PA0216301Garnishment AdjustmentUSA
32ERP EHP76.0PA0234321HR Master Record Infotype 0234 (Add. Withh. Inform. - USA)USA
33ERP EHP76.0PA0235691HR Master Record: Infotype 0235 (Other Taxes - USA)USA
34ERP EHP76.0PA0269241HR Master Record: Infotype 0269 (ADP Information USA)USA
35ERP EHP76.0PA0449511HR Master Record: Infotype 0449USA
36ERP EHP76.0PA0450811HR Master Record: Infotype 0450USA
37ERP EHP76.0PA0451451HR Master Record: Infotype 0451USA
38ERP EHP76.0PA0452451HR Master Record: Infotype 0452USA
39ERP EHP76.0PA0453451HR Master Record: Infotype 0453USA
40ERP EHP76.0PA0454331HR Master Record: Infotype 0454USA
41ERP EHP76.0PA0455331HR Master Record: Infotype 0455USA
42ERP EHP76.0PA0456331HR Master Record: Infotype 0456USA
43ERP EHP76.0PA0457331HR Master Record: Infotype 0457USA
44ERP EHP76.0PA0506251Tip IndicatorsUSA
45ERP EHP76.0PA0909451HR Master Record: Infotype 0909USA
46ERP EHP76.0PA0941441HR Master Record: Infotype 0941USA
47ERP EHP76.0PB0077761HR Master Record: Infotype 0077USA
48ERP EHP76.0PRUEXTUSERS51Link users/employees to external user namesUSA
49ERP EHP76.0T51G2101Off-Cycle Batch TableUSA
50ERP EHP76.0T5U8A111Transfer ext.payroll result: Tax cumulation data (USA)USA
51ERP EHP76.0T5UAP141Address for personnel area/subareaUSA
52ERP EHP76.0T5UB851Benefits Payment Model AssignmentUSA
53ERP EHP76.0T5UCP_COMPM51Common Paymaster RelationshipUSA
54ERP EHP76.0T5UCP_CPCFI51Common Paymaster: Map posting wage types to CP tax companyUSA
55ERP EHP76.0T5UCP_STATE51Common Paymaster Acknowledgement for StatesUSA
56ERP EHP76.0T5UF041HR-US: ADP InterfaceUSA
57ERP EHP76.0T5UF131HR-US: ADP Interface, ADP FieldsUSA
58ERP EHP76.0T5UF241HR-US: ADP Interface, used fields per InterfaceUSA
59ERP EHP76.0T5UF351HR-US: ADP Interface, field sortUSA
60ERP EHP76.0T5UF451HR-US: ADP Interface, Record typeUSA
61ERP EHP76.0T5UF551HR-US: ADP Interface, fields per record typeUSA
62ERP EHP76.0T5UF691HR-US: ADP Interface, Mapping InformationUSA
63ERP EHP76.0T5UFA81ADP Interface: Mapping Table between SAP and ADP Wage TypesUSA
64ERP EHP76.0T5UFB41SAP to ADP tax authority mapping tableUSA
65ERP EHP76.0T5UFC31ADP Company CodesUSA
66ERP EHP76.0T5UFD61Variables for ADP company set upUSA
67ERP EHP76.0T5UFE41ADP system variablesUSA
68ERP EHP76.0T5UFF51Personnel area to ADP company code mapping (US ADP only)USA
69ERP EHP76.0T5UG0151HR: Garnishment Order TypesUSA
70ERP EHP76.0T5UG141HR: Garnishment Document CategoryUSA
71ERP EHP76.0T5UG261Adjustment to the Disposable NetUSA
72ERP EHP76.0T5UG3161Model for Calculation of the Non-Exempt AmountUSA
73ERP EHP76.0T5UG4141Rules for Calculation of the Non-Exempt AmountUSA
74ERP EHP76.0T5UG531Model of the Disposable NetUSA
75ERP EHP76.0T5UG6151Government Service ChargeUSA
76ERP EHP76.0T5UG751Government Remittance RuleUSA
77ERP EHP76.0T5UG861Company Remittance RuleUSA
78ERP EHP76.0T5UG931Garnishment Default ValuesUSA
79ERP EHP76.0T5UGA111Special Rule for Calculation of the Non-Exempt AmountUSA
80ERP EHP76.0T5UGB91Calculation Scheme for Special RuleUSA
81ERP EHP76.0T5UGC61Service ChargeUSA
82ERP EHP76.0T5UGD41Filing StatusUSA
83ERP EHP76.0T5UGE81Determining Amount Exempt from LevyUSA
84ERP EHP76.0T5UGF81Determining Additional Exempt AmountUSA
85ERP EHP76.0T5UGG161Company Service ChargeUSA
86ERP EHP76.0T5UGH31Levy StatementUSA
87ERP EHP76.0T5UGI91Garnishment LettersUSA
88ERP EHP76.0T5UGJ72Print Request of Notification LettersUSA
89ERP EHP76.0T5UGK62Print Request of Answer LettersUSA
90ERP EHP76.0T5UGL51Function Exit for Garnishment LettersUSA
91ERP EHP76.0T5UGM31HR: Garnishment OriginatorUSA
92ERP EHP76.0T5UP181Minimum and cash wages for tip creditUSA
93ERP EHP76.0T5UP2151Establishment/stores for tip processingUSA
94ERP EHP76.0T5UP341Establishment textUSA
95ERP EHP76.0T5UP4121Establishment level adjusted gross receiptsUSA
96ERP EHP76.0T5UP551Distribution Payments MappingUSA
97ERP EHP76.0T5UP621Distribution CodesUSA
98ERP EHP76.0T5UP6T41Distribution Codes TextUSA
99ERP EHP76.0T5US0131Priority for tax wagetypesUSA
100ERP EHP76.0T5US161SAP Taxability Matrix TableUSA
101ERP EHP76.0T5USL41States relevant for BSI TaxLocatorUSA
102ERP EHP76.0T5UT071SAP Taxability Matrix TableUSA
103ERP EHP76.0T5UTA71Resident Tax AreasUSA
104ERP EHP76.0T5UTB61Work Tax AreasUSA
105ERP EHP76.0T5UTD71Default Tax TypesUSA
106ERP EHP76.0T5UTE51Tax Authority / Tax Calculation ModelUSA
107ERP EHP76.0T5UTF61ZIP Codes for Residence Tax AreasUSA
108ERP EHP76.0T5UTI71Tax identification number and successor enterpriseUSA
109ERP EHP76.0T5UTLA121Timedependent Attributes of Taxcompany on Taxauthority LevelUSA
110ERP EHP76.0T5UTM81Tax ModelUSA
111ERP EHP76.0T5UTO72Assignment of technical wage types to tax typesUSA
112ERP EHP76.0T5UTQ61Tax Authority Combination for Local ReciprocityUSA
113ERP EHP76.0T5UTR51Tax Authorities per Resident Tax AreaUSA
114ERP EHP76.0T5UTRC81Payroll USA: Tax Reciprocity AttributesUSA
115ERP EHP76.0T5UTS31States without withholding taxUSA
116ERP EHP76.0T5UTT21Tax TypesUSA
117ERP EHP76.0T5UTU41Wage Base Continuity for Tax AuthoritiesUSA
118ERP EHP76.0T5UTW51Tax Authorities per Work Tax AreaUSA
119ERP EHP76.0T5UTX61Tax Ceilings and ratesUSA
120ERP EHP76.0T5UTY61Tax Type CombinationsUSA
121ERP EHP76.0T5UTZ201Tax AuthoritiesUSA
122ERP EHP76.0T5UTZC71Tax Authority AttributesUSA
123ERP EHP76.0T5UU071SAP Taxability Customized TableUSA
124ERP EHP76.0T77USPAY_COBASE61Cost distribution base configurationUSA
125ERP EHP76.0THRCCE_OCR41Reasons for Off-Cycle and Claims RunUSA
Payroll :: USA :: Gross :: Benefit Integration
ProductVersionTableColumnsIndexesDescriptionModule
126ERP EHP76.0PA0496331Payroll Infotype: US Benefits Data - Per Pay PeriodBenefit Integration
127ERP EHP76.0PA0497331Payroll Infotype: US Benefits Data - MTDBenefit Integration
128ERP EHP76.0PA0498331Payroll Infotype: US Benefits Data - QTDBenefit Integration
129ERP EHP76.0PA0499331Payroll Infotype: US Benefits Data - YTDBenefit Integration
130ERP EHP76.0PA0500331Payroll Infotype: US Benefits Data in Arrears (ARRRS)Benefit Integration
131ERP EHP76.0PA0501331Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)Benefit Integration
132ERP EHP76.0T7USBEN0121Model for saving plans compensationBenefit Integration
133ERP EHP76.0T7USBEN01T41Text for saving plans compensationBenefit Integration
134ERP EHP76.0T7USBEN0251Adjustment to saving plans compensationBenefit Integration
135ERP EHP76.0T7USBEN0381Catch-up contribution for Savings planBenefit Integration
136ERP EHP76.0T7USBEN0491High Deductible Health Plan ContributionsBenefit Integration
137ERP EHP76.0T7USBENH191For saving records of issued HIPAA certificatesBenefit Integration
138ERP EHP76.0T7USBENH291For savings records of on-demand printing of HIPAA certs.Benefit Integration
139ERP EHP76.0T7USBENPE141US pension related data (e.g. Soc. Sec. wages and taxes)Benefit Integration
140ERP EHP76.0T7US_ETA_OVMTH21US Tax Override MethodBenefit Integration
141ERP EHP76.0T7US_ETA_OVMTH_T41US Tax Override Method TextBenefit Integration
142ERP EHP76.0T7US_ETA_TXOVM41Tax Override Method Per Tax TypeBenefit Integration
Payroll :: USA :: Reporting :: Tax Reporter
ProductVersionTableColumnsIndexesDescriptionModule
143ERP EHP76.0T51T091Evaluation of wage types for tax reportingTax Reporter
144ERP EHP76.0T51T151Tax Types, which has to be reported in the tax formsTax Reporter
145ERP EHP76.0T51T2101Definitions, how tax datas will be reportedTax Reporter
146ERP EHP76.0T51T3111Fields for tax information on magnetic mediaTax Reporter
147ERP EHP76.0T51T4111Evaluated tax form reporting periodsTax Reporter
148ERP EHP76.0T51T5111Events, on which form will be issuedTax Reporter
149ERP EHP76.0T51T681Evaluated payroll time unitsTax Reporter
150ERP EHP76.0T51T751Text for tax formsTax Reporter
151ERP EHP76.0T51T8201Definitions of a tax formTax Reporter
152ERP EHP76.0T51T991Tax pay datesTax Reporter
153ERP EHP76.0T51TA41Wage or tax form group for tax reporterTax Reporter
154ERP EHP76.0T51TB61Text of attributes for taxTax Reporter
155ERP EHP76.0T51TC51Tax attributesTax Reporter
156ERP EHP76.0T51TD31Tax attributesTax Reporter
157ERP EHP76.0T51TE51Text table for subjects of tax calculation and reportingTax Reporter
158ERP EHP76.0T51TX101Transfer to be EvaluatedTax Reporter
159ERP EHP76.0T51TY51Transferred EmployeesTax Reporter
160ERP EHP76.0T5UQR81Cross quarter retro-calculationsTax Reporter
161ERP EHP76.0T5UT1133Tax Interface Table: Payroll resultsTax Reporter
162ERP EHP76.0T5UT2101Deposited taxes, that have to be reported in tax formsTax Reporter
163ERP EHP76.0T5UT3192Data to be printed in a tax formTax Reporter
164ERP EHP76.0T5UT441Text form Class DescriptionTax Reporter
165ERP EHP76.0T5UT521Tax Form ClassTax Reporter
166ERP EHP76.0T5UT6121Tax form class tableTax Reporter
167ERP EHP76.0T5UT751Tax Form Class RelationsTax Reporter
168ERP EHP76.0T5UT871Tax Form Class Relations - Customer tableTax Reporter
169ERP EHP76.0T5UT951User VariantsTax Reporter
170ERP EHP76.0T5UTP111Assignment of tax amounts to tax form groupsTax Reporter
171ERP EHP76.0T5UX161Tax Reporter Employee IndexTax Reporter
172ERP EHP76.0T5UX431Assign tax form to categoryTax Reporter
173ERP EHP76.0T5UX551Assign attributes to tax authorityTax Reporter
174ERP EHP76.0T5UX691W-2/W-2C Puerto Rico Control NumberTax Reporter
175ERP EHP76.0T5UX7111Alternate forms detailsTax Reporter
176ERP EHP76.0T5UX9241Tax Reporting Additional InformationTax Reporter
177ERP EHP76.0T5UXX101Evaluated tax form reporting periodsTax Reporter
178ERP EHP76.0T5UXY71Tax Reporter Control RecordTax Reporter
179ERP EHP76.0T5UXZ21Transaction table to keep track of background jobsTax Reporter
180ERP EHP76.0T5UYY101TR MonitorTax Reporter
Payroll :: USA :: Subsequent Activities :: Third Party Remittance
ProductVersionTableColumnsIndexesDescriptionModule
181ERP EHP76.0T51R1121Remittance evaluation run dataThird Party Remittance
182ERP EHP76.0T51R241Remittance posting run dataThird Party Remittance
183ERP EHP76.0T51R361Remittance acknowledgement run dataThird Party Remittance
184ERP EHP76.0T51R441Remittance origin link data per personnel no.Third Party Remittance
185ERP EHP76.0T51R5171Remittance accumulated posting dataThird Party Remittance
186ERP EHP76.0T51R5_HIST131Remittance accumulated posting data historyThird Party Remittance
187ERP EHP76.0T51R641Remittance origin data per symbolic accountThird Party Remittance
188ERP EHP76.0T51R6_FUNDINFO241Remittance detail table for all entitiesThird Party Remittance
189ERP EHP76.0T51R841Remittance evaluation run per payroll resultThird Party Remittance
190ERP EHP76.0T51RA51HR payee derived from wage typeThird Party Remittance
191ERP EHP76.0T51RD61Remittance rule derivation per HR accumulator and amountThird Party Remittance
192ERP EHP76.0T51RH81HR payee derived link to FI vendorThird Party Remittance
193ERP EHP76.0T51RJ41Remittance rule descriptionThird Party Remittance
194ERP EHP76.0T51RK81Remittance rule definitionThird Party Remittance
195ERP EHP76.0T51RL81HR payee link derived from HR payeeThird Party Remittance
196ERP EHP76.0T51RM21HR accumulator definitionThird Party Remittance
197ERP EHP76.0T51RN41HR accumulator descriptionThird Party Remittance
198ERP EHP76.0T51RS61HR payee derived link to remittance ruleThird Party Remittance
199ERP EHP76.0T51RT51HR payee descriptionThird Party Remittance
200ERP EHP76.0T51RV41Remittance number range sub-objectsThird Party Remittance
201ERP EHP76.0T7US3PR_TXSYMKO121Posting of tax wage typesThird Party Remittance
202ERP EHP76.0T7US3PR_V0TYPE_T51Maintain wage types for other HR payees of V0 type 'T'Third Party Remittance
Payroll :: USA :: Net :: Tax :: BSI
ProductVersionTableColumnsIndexesDescriptionModule
203ERP EHP76.0BSIUDES31BSI Default DestinationBSI
204ERP EHP76.0BSIUDTA181HR-US: BSI test dataBSI
205ERP EHP76.0BSIUDTT431HR-US: BSI test data (tax record)BSI
206ERP EHP76.0BTXAUTH81BSI Tax AuthoritiesBSI
207ERP EHP76.0BTXBGRP51BSI: Group Block DataBSI
208ERP EHP76.0BTXBLOK61BSI: Tax Formula Block DataBSI
209ERP EHP76.0BTXBRAK81BSI: Tax Formula Bracket DataBSI
210ERP EHP76.0BTXCOMP51BSI: Tax Company CodeBSI
211ERP EHP76.0BTXCOMP_O41BSI: Tax Company CodeBSI
212ERP EHP76.0BTXCUTX151BSI: Customer Tax FormulaBSI
213ERP EHP76.0BTXCUTX_O141BSI: Customer Tax FormulaBSI
214ERP EHP76.0BTXEGRP51BSI: Employee GroupBSI
215ERP EHP76.0BTXEGRP_O61BSI: Employee GroupBSI
216ERP EHP76.0BTXFDOC81BSI: Tax Formula DocumentationBSI
217ERP EHP76.0BTXFORM71BSI Tax FormulasBSI
218ERP EHP76.0BTXOVER151BSI: Higher Level Tax FormulaBSI
219ERP EHP76.0BTXOVER_O141BSI: Higher Level Tax FormulaBSI
220ERP EHP76.0BTXOVFR171BSI: Higher Level Formulas for EmployeesBSI
221ERP EHP76.0BTXOVFR_O161BSI: Higher Level Formulas for EmployeesBSI
222ERP EHP76.0BTXPLAN41BSI: Benefit plan typesBSI
223ERP EHP76.0BTXPLNX101BSI: Benefit PlanBSI
224ERP EHP76.0BTXPURGE41BSI: Purge Retention PeriodsBSI
225ERP EHP76.0BTXRATE141BSI: Tax Rates per Company Based on Degree of ExperienceBSI
226ERP EHP76.0BTXRATE_O131BSI: Tax Rates per Company Based on Degree of ExperienceBSI
227ERP EHP76.0BTXRCPT81BSI: Tax Formula Reciprocal DataBSI
228ERP EHP76.0BTXTAX141BSI: Grouping Tax Authority Tax CategoryBSI
229ERP EHP76.0BTXTAXC91Tax Authority MappingBSI
230ERP EHP76.0BTXTAXT61BSI: Tax CategoryBSI
231ERP EHP76.0T5UTH_O31Tax Number <-> BSI Tax InterfaceBSI