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

51 columns | Print definition?ERP 6.0  | TXCMP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RK_PERMPersonal Characteristics7TXCMPTax companynvarchar40
2P2RU_DNRCTPayroll Results: Retro Differences 1042S -DNRCT- (USA)5TXCMPTax companynvarchar40
3P2RU_NRCTUS Tax 1042S Processing5TXCMPTax companynvarchar40
4P2RU_PERMPersonal Characteristics8TXCMPTax companynvarchar40
5P2RU_TCRTPayroll results: Tax accumulation (USA)5TXCMPTax companynvarchar40
6T5UMRCross month retro-calculations3TXCMPTax companynvarchar40
TOPBenefit Integration
7PA0496Payroll Infotype: US Benefits Data - Per Pay Period32TXCMPTax companynvarchar40
8PA0497Payroll Infotype: US Benefits Data - MTD32TXCMPTax companynvarchar40
9PA0498Payroll Infotype: US Benefits Data - QTD32TXCMPTax companynvarchar40
10PA0499Payroll Infotype: US Benefits Data - YTD32TXCMPTax companynvarchar40
11PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)32TXCMPTax companynvarchar40
12PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)32TXCMPTax companynvarchar40
TOPCanada
13T5K0PPersonnel Area/Sub Area (Canada)16TXCMPTax area - Canadanvarchar40
14T5KTLTax area - Canada2TXCMPTax area - Canadanvarchar40
15T5URCHR payee for taxes derived from wage types via tax attr.4TXCMPTax companynvarchar40
16T5UTLTax Company2TXCMPTax companynvarchar40
TOPTax Reporter
17T51T4Evaluated tax form reporting periods5TXCMPTax companynvarchar40
18T51T6Evaluated payroll time units5TXCMPTax companynvarchar40
19T51TXTransfer to be Evaluated6TXCMPTax companynvarchar40
20T5UQRCross quarter retro-calculations2TXCMPTax companynvarchar40
21T5UT1Tax Interface Table: Payroll results2TXCMPTax companynvarchar40
22T5UT2Deposited taxes, that have to be reported in tax forms2TXCMPTax companynvarchar40
23T5UT9User Variants2TXCMPTax companynvarchar40
24T5UX1Tax Reporter Employee Index3TXCMPTax companynvarchar40
25T5UX6W-2/W-2C Puerto Rico Control Number3TXCMPTax companynvarchar40
26T5UX9Tax Reporting Additional Information3TXCMPTax companynvarchar40
27T5UXYTax Reporter Control Record2TXCMPTax companynvarchar40
28T5UYYTR Monitor2TXCMPTax companynvarchar40
TOPThird Party Remittance
29T7US3PR_TXSYMKOPosting of tax wage types3TXCMPTax companynvarchar40
TOPUSA
30PA044632TXCMPnvarchar40
31PA0447US Federal Tax MTD32TXCMPTax companynvarchar40
32PA0448US Federal Tax QTD32TXCMPTax companynvarchar40
33PA0449HR Master Record: Infotype 044932TXCMPTax companynvarchar40
34PA0450HR Master Record: Infotype 045032TXCMPTax companynvarchar40
35PA0451HR Master Record: Infotype 045132TXCMPTax companynvarchar40
36PA0452HR Master Record: Infotype 045232TXCMPTax companynvarchar40
37PA0453HR Master Record: Infotype 045332TXCMPTax companynvarchar40
38PA0454HR Master Record: Infotype 045432TXCMPTax companynvarchar40
39PA0455HR Master Record: Infotype 045532TXCMPTax companynvarchar40
40PA0456HR Master Record: Infotype 045632TXCMPTax companynvarchar40
41PA0457HR Master Record: Infotype 045732TXCMPTax companynvarchar40
42PA0894HR Master Record: Infotype 089424TXCMPTax companynvarchar40
43PA0895HR Master Record: Infotype 089524TXCMPTax companynvarchar40
44T5U0PAdditional organizational data for personnel area/subarea16TXCMPTax companynvarchar40
45T5U8ATransfer ext.payroll result: Tax cumulation data (USA)6TXCMPTax companynvarchar40
46T5UCP_COMPMCommon Paymaster Relationship2TXCMPTax companynvarchar40
47T5UP2Establishment/stores for tip processing14TXCMPTax companynvarchar40
48T5UTITax identification number and successor enterprise2TXCMPTax companynvarchar40
49T5UTLATimedependent Attributes of Taxcompany on Taxauthority Level2TXCMPTax Company or Tax Company Group Matchnvarchar40
50T5UTRCPayroll USA: Tax Reciprocity Attributes2TXCMPTax companynvarchar40
51T5UTVUnemployment Insurance Work Sites/NC-9901 Locations2TXCMPTax companynvarchar40