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

59 columns | Print definition?ERP 6.0  | BEGUZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_ABHCM Declustering B2 - Absences16BEGUZStart timenvarchar60
2P2B2_ABWKONTIHCM Declustering B2 - Absence Quotas (Table ABWKONTI)14BEGUZStart timenvarchar60
3P2B2_ALPHCM Declustering B2 - Alternative Payment Table ALP10BEGUZStart Timenvarchar60
4P2B2_ANWESHCM Declustering B2 - Attendances (Table ANWES)10BEGUZStart timenvarchar60
5P2B2_ANWKONTIHCM Declustering B2 - Attendance Quotas (Table ANWKONTI)13BEGUZStart timenvarchar60
6P2B2_MEHRHCM Declustering B2 - Overtime (Table MEHR)10BEGUZStart timenvarchar60
7P2B2_RUFBHCM Declustering B2 - On-Call Duty (Table RUFB)10BEGUZStart timenvarchar60
8P2B2_VERTHCM Declustering B2 - Table VERT10BEGUZStart timenvarchar60
9P2B2_ZLHCM Declustering B2 - Time Wage Types (Table ZL)8BEGUZStart timenvarchar60
10P2NZ_LVPAYPayroll Result: Leave Payment LVPAY - NZ17BEGUZStart Timenvarchar60
11P2RB_DAYDETDaydetails for payroll outsourcing (B)8BEGUZStart timenvarchar60
12P2RD_XITPayroll Results: Extended IT6BEGUZStart timenvarchar60
13P2RF_ZLPTime Wage Types (Table ZL)6BEGUZStart timenvarchar60
14P2RP_OVTime Wage Types (Table ZL)6BEGUZStart timenvarchar60
15P2RR_RMPayroll Results: Table for Master data (SG)35BEGUZStart Timenvarchar60
16P2RX_ABCluster RD/B2: Table AB14BEGUZStart timenvarchar60
17P2RX_ALPAlternative Payment Table ALP8BEGUZStart Timenvarchar60
18PA0876HR Master Record: Infotype 087625BEGUZStart Timenvarchar60
19PA3267Személyügyi törzsrekord, 3267 infótípus26BEGUZKezdo idopontnvarchar60
20PYC_D_PYPIPayroll Process Instance5BEGUZStart timenvarchar60
21ZCATSDBRecords changed with processing status '10'92BEGUZnvarchar60
22ZCATSDB2Records changed with processing status '10'93BEGUZnvarchar60
23HRT1716Table Section for Infotype 17164BEGUZStart Timenvarchar60
24PIQDBOFFERTMPLRSTemplates for Business Event Offerings (Resources)11BEGUZStart Timenvarchar60
TOPAttendancesAbsences
25CATSHRCross-Application Time Sheet (CATS): Transfer to HR78BEGUZStart timenvarchar60
TOPESS Based on WD ABAP
26HRESS_D_CATS_FAVCATS Favorites: database table99BEGUZStart timenvarchar60
TOPNew Zealand
27HNZLVPAYTable for modified LVPAY cluster table records19BEGUZStart Timenvarchar60
28PT2001HR Time Record: Infotype 2001 (Absences)24BEGUZStart Timenvarchar60
29PT2006HR Time Record: Infotype 2006 (Absence Quotas)24BEGUZStart Timenvarchar60
TOPPayroll
30T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP13BEGUZPocátecní casnvarchar60
31T7SK558_ABTransfer absences (supplement to T558D) - SK13BEGUZStart timenvarchar60
TOPPersonnel Time Management
32PA2001HR Time Record: Infotype 2001 (Absences)24BEGUZStart Timenvarchar60
33PA2002HR Time Record: Infotype 2002 (Attendances)24BEGUZStart Timenvarchar60
34PA2003HR Time Record: Infotype 2003 (Substitutions)24BEGUZStart Timenvarchar60
35PA2004HR Time Record: Infotype 2004 (Availability)24BEGUZStart Timenvarchar60
36PA2005HR Time Record: Infotype 2005 (Overtime)24BEGUZStart Timenvarchar60
37PA2006HR Time Record: Infotype 2006 (Absence Quotas)24BEGUZStart Timenvarchar60
38PA2007HR Time Record: Infotype 2007 (Attendance Quotas)24BEGUZStart Timenvarchar60
39PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)24BEGUZStart Timenvarchar60
40PA2012HR Time Record: Infotype 2012 (Time Transfer Specifications)24BEGUZStart Timenvarchar60
41PA2013HR Time Record: Infotype 2013 (Quota Corrections)24BEGUZStart Timenvarchar60
42PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)30BEGUZStart Timenvarchar60
43PTEX2003SPECInterface Table for IT 2003: Interval Information6BEGUZStart Timenvarchar60
44T552VDynamic Daily Work Schedule Assignment6BEGUZStart Timenvarchar60
45T556AAbsence Quota Types8BEGUZStart Timenvarchar60
46T556PAttendance Quotas8BEGUZStart Timenvarchar60
TOPPublic Sector
47PA0573Master leave code for Public Sector Australia24BEGUZStart Timenvarchar60
48T5QPBS2MRepeat structure for Infotype 05736BEGUZStart Timenvarchar60
TOPShift Planning for Public Sector
49HRSPPS_AVAILShift Abbreviations for Availability Duties5BEGUZStart Timenvarchar60
TOPTime Data Recording and Administration
50TMW_TDTYPETime Data ID16BEGUZStart Timenvarchar60
TOPTime Sheet
51CATSDBCATS: Database Table for Time Sheet92BEGUZStart timenvarchar60
52CATSMMCross-Application Time Sheet (CATS): Transfer to MM7BEGUZStart timenvarchar60
53CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS18BEGUZStart timenvarchar60
54CATSPSCross-Application Time Sheet (CATS): Transfer to PS18BEGUZStart timenvarchar60
TOPTraining and Event Management
55HRPAD23Additional data PAD235BEGUZStart Timenvarchar60
56HRPAD53Additional Data PAD534BEGUZStart Timenvarchar60
57HRT1035Table Division Infotype 10355BEGUZStart Timenvarchar60
TOPTravel Expenses
58T702HCaculation Guide Lines: Meals PD/Max.Amounts Scaled by Time12BEGUZStart Timenvarchar60
59T706HTrip Provision:Per-diem/Maximum Amount for Meals by Time12BEGUZStart Timenvarchar60