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

29 columns | Print definition?ERP 6.0  | STDAZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_ABHCM Declustering B2 - Absences20STDAZAbsence hoursdecimal72
2P2B2_ANWESHCM Declustering B2 - Attendances (Table ANWES)15STDAZAbsence hoursdecimal72
3P2B2_PSPHCM Declustering B2 - Personal Work Schedule (Table PSP)15STDAZNumber of hoursdecimal52
4P2CO_COAVAPC2CO_AVA15STDAZAbsence hoursdecimal72
5P2PL_EABPayroll Result PL: Split Y, absences10STDAZAbsence hoursdecimal72
6P2RD_ZTBAUPayroll Result: Construction Pay Daily Statement8STDAZNo.of hours for remuneration info.decimal72
7P2RF_PSPPPersonal Work Schedule (Table PSP)13STDAZNumber of hoursdecimal52
8P2RM_MABSHR-DK: Absence Information for PBS (Form 27)4STDAZAbsence hoursdecimal72
9P2RM_MABSCHR-DK: Cumulated Absence Information for PBS (Form 27)5STDAZAbsence hoursdecimal72
10P2RR_RMPayroll Results: Table for Master data (SG)38STDAZNo.of hours for remuneration info.decimal72
11P2RX_ABCluster RD/B2: Table AB18STDAZAbsence hoursdecimal72
12PA3267Személyügyi törzsrekord, 3267 infótípus30STDAZTávollétórákdecimal72
TOPConstruction Industry
13PA0215Construction Pay Transaction Data29STDAZNo.of hours for remuneration info.decimal72
14PDBKLOConstruction Industry Social Fund Proced: LOMEL Data Records25STDAZWeekly Working Time for Social Fund Procedurenvarchar40
15T5DBMConstruction Pay Expenses Tax Evaluation7STDAZNumber of hoursnvarchar20
TOPNew Zealand
16PT2001HR Time Record: Infotype 2001 (Absences)29STDAZAbsence hoursdecimal72
TOPPayroll
17T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP17STDAZHodiny neprítomnostidecimal72
18T7SK558_ABTransfer absences (supplement to T558D) - SK17STDAZAbsence hoursdecimal72
TOPPersonnel Administration
19PA0834HR master record for infotypes 083439STDAZAbsence hoursdecimal72
20T7COT8Payroll external results transfer: COAVA15STDAZAbsence hoursdecimal72
TOPPersonnel Time Management
21PA2001HR Time Record: Infotype 2001 (Absences)29STDAZAbsence hoursdecimal72
22PA2002HR Time Record: Infotype 2002 (Attendances)32STDAZAttendance hoursdecimal72
23PA2003HR Time Record: Infotype 2003 (Substitutions)28STDAZSubstitution hoursdecimal72
24PA2005HR Time Record: Infotype 2005 (Overtime)27STDAZOvertime hoursdecimal72
25PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)27STDAZNo.of hours for remuneration info.decimal72
26PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)32STDAZAbsence hoursdecimal72
27PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)29STDAZNo.of hours for remuneration info.decimal72
28T550PBreak Schedules10STDAZBreak after hoursdecimal52
TOPWork Center
29TC37PBreak schedule7STDAZBreak after hoursdecimal52