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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

72 columns | Print definition?ERP 6.0  | TAXAU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RU_BALPayroll Results: Tax Retro Differences -(USA)14TAXAUTax authoritynvarchar40
2P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)10TAXAUTax authoritynvarchar40
3P2RU_DNRCTPayroll Results: Retro Differences 1042S -DNRCT- (USA)6TAXAUTax authoritynvarchar40
4P2RU_NRCTUS Tax 1042S Processing6TAXAUTax authoritynvarchar40
5P2RU_TAXPayroll Results: Tax (U.S.)7TAXAUTax authoritynvarchar40
6P2RU_TAXPRAuthorities tax prorates8TAXAUTax authoritynvarchar40
7P2RU_TAXRPayroll result: Tax authorities of resident/unemployment(US)5TAXAUTax authoritynvarchar40
8P2RU_TCRTPayroll results: Tax accumulation (USA)6TAXAUTax authoritynvarchar40
9P2RU_UNBPayroll Results: Tax Retro Differences -(USA)14TAXAUTax authoritynvarchar40
10P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)14TAXAUTax authoritynvarchar40
TOPCanada
11PA0095HR Master Record: Infotype 0095 (Tax Canada)25TAXAUTax authority keynvarchar40
12T5KINTax indicators - Canada2TAXAUTax authoritynvarchar40
13T5KITTax indicator texts - Canada3TAXAUTax authoritynvarchar40
14T5KMXTax model / Taxation authorities - Canada2TAXAUTax authoritynvarchar40
15T5KOTTaxing authorities - texts - Canada2TAXAUTax authoritynvarchar40
16T5KTOTaxation authorities - Canada1TAXAUTax authoritynvarchar40
17T5U8CTransfer external payroll results (USA)7TAXAUTax authoritynvarchar40
18T5URCHR payee for taxes derived from wage types via tax attr.5TAXAUTax authoritynvarchar40
TOPTaiwan
19T7TW2DTax Authority Code2TAXAUTax Authority Codenvarchar30
20T7TW2DTTax Authority Code3TAXAUTax Authority Codenvarchar30
TOPTax Reporter
21T51T2Definitions, how tax datas will be reported4TAXAUTax authoritynvarchar40
22T51T4Evaluated tax form reporting periods6TAXAUTax authority keynvarchar40
23T51T5Events, on which form will be issued9TAXAUTax authoritynvarchar40
24T51T6Evaluated payroll time units6TAXAUTax authority keynvarchar40
25T51T8Definitions of a tax form17TAXAUTax authoritynvarchar40
26T51TXTransfer to be Evaluated7TAXAUTax authoritynvarchar40
27T5UT1Tax Interface Table: Payroll results4TAXAUTax authoritynvarchar40
28T5UT2Deposited taxes, that have to be reported in tax forms3TAXAUTax authoritynvarchar40
29T5UT3Data to be printed in a tax form7TAXAUTax authoritynvarchar40
30T5UX1Tax Reporter Employee Index4TAXAUTax authoritynvarchar40
31T5UX5Assign attributes to tax authority3TAXAUTax authoritynvarchar40
32T5UX9Tax Reporting Additional Information5TAXAUTax authoritynvarchar40
33T5UXXEvaluated tax form reporting periods4TAXAUTax authority keynvarchar40
TOPThird Party Remittance
34T7US3PR_TXSYMKOPosting of tax wage types4TAXAUTax authoritynvarchar40
TOPUSA
35PA0096HR Master Record: Infotype 0096 (Tax - USA)25TAXAUBSI:Tax Authority Keynvarchar110
36PA0209HR Master Record: Infotype 0209 (Unemployment Insurance USA)24TAXAUTax authoritynvarchar40
37PA044633TAXAUnvarchar40
38PA0447US Federal Tax MTD33TAXAUTax authoritynvarchar40
39PA0448US Federal Tax QTD33TAXAUTax authoritynvarchar40
40PA0449HR Master Record: Infotype 044933TAXAUTax authoritynvarchar40
41PA0450HR Master Record: Infotype 045033TAXAUTax authoritynvarchar40
42PA0451HR Master Record: Infotype 045133TAXAUTax authoritynvarchar40
43PA0452HR Master Record: Infotype 045233TAXAUTax authoritynvarchar40
44PA0453HR Master Record: Infotype 045333TAXAUTax authoritynvarchar40
45PA0454HR Master Record: Infotype 045433TAXAUTax authoritynvarchar40
46PA0455HR Master Record: Infotype 045533TAXAUTax authoritynvarchar40
47PA0456HR Master Record: Infotype 045633TAXAUTax authoritynvarchar40
48PA0457HR Master Record: Infotype 045733TAXAUTax authoritynvarchar40
49T505XTax Authority Table3TAXAUTax authority keynvarchar40
50T505YTax Authority Texts4TAXAUTax authority keynvarchar40
51T5U8ATransfer ext.payroll result: Tax cumulation data (USA)7TAXAUTax authoritynvarchar40
52T5UFBSAP to ADP tax authority mapping table2TAXAUTax authoritynvarchar40
53T5UP1Minimum and cash wages for tip credit1TAXAUTax authoritynvarchar40
54T5UP2Establishment/stores for tip processing7TAXAUTax authoritynvarchar40
55T5US0Priority for tax wagetypes4TAXAUTax authoritynvarchar40
56T5US1SAP Taxability Matrix Table1TAXAUTax authoritynvarchar40
57T5UT0SAP Taxability Matrix Table2TAXAUTax authoritynvarchar40
58T5UTDDefault Tax Types2TAXAUTax authoritynvarchar40
59T5UTETax Authority / Tax Calculation Model2TAXAUTax authoritynvarchar40
60T5UTITax identification number and successor enterprise3TAXAUTax authoritynvarchar40
61T5UTKMarital Status2TAXAUTax authoritynvarchar40
62T5UTLATimedependent Attributes of Taxcompany on Taxauthority Level3TAXAUTax Authority or Tax Authority Group Matchnvarchar40
63T5UTRTax Authorities per Resident Tax Area3TAXAUTax authoritynvarchar40
64T5UTSStates without withholding tax1TAXAUTax authoritynvarchar40
65T5UTUWage Base Continuity for Tax Authorities1TAXAUTax authoritynvarchar40
66T5UTVUnemployment Insurance Work Sites/NC-9901 Locations3TAXAUTax authoritynvarchar40
67T5UTWTax Authorities per Work Tax Area3TAXAUTax authoritynvarchar40
68T5UTXTax Ceilings and rates1TAXAUTax authoritynvarchar40
69T5UTZTax Authorities2TAXAUTax authoritynvarchar40
70T5UTZCTax Authority Attributes3TAXAUTax authoritynvarchar40
71T5UU0SAP Taxability Customized Table2TAXAUTax authoritynvarchar40
72T77USPAY_COBASECost distribution base configuration4TAXAUTax authoritynvarchar40