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

58 columns | Print definition?ERP 6.0  | ENDUZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_ABHCM Declustering B2 - Absences17ENDUZEnd timenvarchar60
2P2B2_ABWKONTIHCM Declustering B2 - Absence Quotas (Table ABWKONTI)15ENDUZEnd timenvarchar60
3P2B2_ALPHCM Declustering B2 - Alternative Payment Table ALP11ENDUZEnd Timenvarchar60
4P2B2_ANWESHCM Declustering B2 - Attendances (Table ANWES)11ENDUZEnd timenvarchar60
5P2B2_ANWKONTIHCM Declustering B2 - Attendance Quotas (Table ANWKONTI)14ENDUZEnd timenvarchar60
6P2B2_MEHRHCM Declustering B2 - Overtime (Table MEHR)11ENDUZEnd timenvarchar60
7P2B2_RUFBHCM Declustering B2 - On-Call Duty (Table RUFB)11ENDUZEnd timenvarchar60
8P2B2_VERTHCM Declustering B2 - Table VERT11ENDUZEnd timenvarchar60
9P2B2_ZLHCM Declustering B2 - Time Wage Types (Table ZL)9ENDUZEnd timenvarchar60
10P2NZ_LVPAYPayroll Result: Leave Payment LVPAY - NZ18ENDUZEnd Timenvarchar60
11P2RB_DAYDETDaydetails for payroll outsourcing (B)9ENDUZEnd timenvarchar60
12P2RD_XITPayroll Results: Extended IT7ENDUZEnd timenvarchar60
13P2RF_ZLPTime Wage Types (Table ZL)7ENDUZEnd timenvarchar60
14P2RP_OVTime Wage Types (Table ZL)7ENDUZEnd timenvarchar60
15P2RR_RMPayroll Results: Table for Master data (SG)36ENDUZEnd Timenvarchar60
16P2RX_ABCluster RD/B2: Table AB15ENDUZEnd timenvarchar60
17P2RX_ALPAlternative Payment Table ALP9ENDUZEnd Timenvarchar60
18PA0876HR Master Record: Infotype 087626ENDUZEnd Timenvarchar60
19PA3267Személyügyi törzsrekord, 3267 infótípus27ENDUZZáró idopontnvarchar60
20PYC_D_PYPIPayroll Process Instance8ENDUZEnd timenvarchar60
21ZCATSDBRecords changed with processing status '10'93ENDUZnvarchar60
22ZCATSDB2Records changed with processing status '10'94ENDUZnvarchar60
23HRT1716Table Section for Infotype 17165ENDUZEnd Timenvarchar60
24PIQDBOFFERTMPLRSTemplates for Business Event Offerings (Resources)12ENDUZEnd Timenvarchar60
TOPAttendancesAbsences
25CATSHRCross-Application Time Sheet (CATS): Transfer to HR79ENDUZEnd timenvarchar60
TOPESS Based on WD ABAP
26HRESS_D_CATS_FAVCATS Favorites: database table100ENDUZEnd timenvarchar60
TOPNew Zealand
27PT2001HR Time Record: Infotype 2001 (Absences)25ENDUZEnd Timenvarchar60
28PT2006HR Time Record: Infotype 2006 (Absence Quotas)25ENDUZEnd Timenvarchar60
TOPPayroll
29T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP14ENDUZCas ukoncenínvarchar60
30T7SK558_ABTransfer absences (supplement to T558D) - SK14ENDUZEnd timenvarchar60
TOPPersonnel Time Management
31PA2001HR Time Record: Infotype 2001 (Absences)25ENDUZEnd Timenvarchar60
32PA2002HR Time Record: Infotype 2002 (Attendances)25ENDUZEnd Timenvarchar60
33PA2003HR Time Record: Infotype 2003 (Substitutions)25ENDUZEnd Timenvarchar60
34PA2004HR Time Record: Infotype 2004 (Availability)25ENDUZEnd Timenvarchar60
35PA2005HR Time Record: Infotype 2005 (Overtime)25ENDUZEnd Timenvarchar60
36PA2006HR Time Record: Infotype 2006 (Absence Quotas)25ENDUZEnd Timenvarchar60
37PA2007HR Time Record: Infotype 2007 (Attendance Quotas)25ENDUZEnd Timenvarchar60
38PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)25ENDUZEnd Timenvarchar60
39PA2012HR Time Record: Infotype 2012 (Time Transfer Specifications)25ENDUZEnd Timenvarchar60
40PA2013HR Time Record: Infotype 2013 (Quota Corrections)25ENDUZEnd Timenvarchar60
41PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)31ENDUZEnd Timenvarchar60
42PTEX2003SPECInterface Table for IT 2003: Interval Information7ENDUZEnd Timenvarchar60
43T552VDynamic Daily Work Schedule Assignment8ENDUZEnd Timenvarchar60
44T556AAbsence Quota Types9ENDUZEnd Timenvarchar60
45T556PAttendance Quotas9ENDUZEnd Timenvarchar60
TOPPublic Sector
46PA0573Master leave code for Public Sector Australia25ENDUZEnd Timenvarchar60
47T5QPBS2MRepeat structure for Infotype 05737ENDUZEnd Timenvarchar60
TOPShift Planning for Public Sector
48HRSPPS_AVAILShift Abbreviations for Availability Duties6ENDUZEnd Timenvarchar60
TOPTime Data Recording and Administration
49TMW_TDTYPETime Data ID17ENDUZEnd Timenvarchar60
TOPTime Sheet
50CATSDBCATS: Database Table for Time Sheet93ENDUZEnd timenvarchar60
51CATSMMCross-Application Time Sheet (CATS): Transfer to MM8ENDUZEnd timenvarchar60
52CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS19ENDUZEnd timenvarchar60
53CATSPSCross-Application Time Sheet (CATS): Transfer to PS19ENDUZEnd timenvarchar60
TOPTraining and Event Management
54HRPAD23Additional data PAD236ENDUZEnd Timenvarchar60
55HRPAD53Additional Data PAD535ENDUZEnd Timenvarchar60
56HRT1035Table Division Infotype 10356ENDUZEnd Timenvarchar60
TOPTravel Expenses
57T702HCaculation Guide Lines: Meals PD/Max.Amounts Scaled by Time13ENDUZEnd Timenvarchar60
58T706HTrip Provision:Per-diem/Maximum Amount for Meals by Time13ENDUZEnd Timenvarchar60