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

71 columns | Print definition?ERP 6.0  | MOBDE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T77TIM_AQGRPAbsence Quota Groups4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
2T77TIM_AQGRPTAbsence Quota Groups Description5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
3T7RU_T559LAutomatic Absence Quota Generation (Russian extension)4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPAustralia
4T5QIAPS Specific Characteristic for absence type4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
5T5QITCalculation rule for transfer frequency4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
6T5QLLAustralian Leave Loading - international leave4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
7T5QPRAust. Leave Provision for international leave4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPBenefits
8T5UB3Benefit area28MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPFinland
9T7FIWTWorktime equalisation /free shift matrix)2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
10T7FIWTEMWTE Model (Finland)3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPNew Zealand
11T7NZLLLeave Payment Calculation Table - NZ5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPPayroll
12T5TL5Krácení kontingentu pro dovolenou v IT20064MOBDESeskupení personálních oblastí pro evidenci casunvarchar20
13T7SKL5Quota reduction for leave in IT20064MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
14T7SKL6Quota reduction for leave in IT20064MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
15T7UAH0Time codes5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPPersonnel Administration
16T001PPersonnel Area/Subarea15MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPPersonnel Time Management
17T555ATime Types2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
18T555A_WEBTime Types to Be Displayed3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
19T555BTime Type Texts3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
20T555CPermitted PDC PIN Codes3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
21T555ETime Evaluation Messages2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
22T555FTime Evaluation Error Texts3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
23T555HSite-Restricted Access Control Groups2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
24T555IPDC Master Record Information3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
25T555JTransfer to Time Types2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
26T555KTransfer to Time Wage Types2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
27T555LTransfer to Absence Quotas2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
28T555OAccess Control Groups (time-restricted)2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
29T555PEmployee Time Transfer Type2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
30T555QTexts for Time Transfer Type3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
31T555XTexts for Access Control Groups (time-restricted)3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
32T555YProcessing Type/Time Type According to Att./Absence Class2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
33T555ZTime Type Determination2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
34T557HRelation Table: Time Types Accumulation4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
35T557MTime Types Relationships Table (from Period Totals Table)4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
36T559EBase Entitlement for Leave Accrual4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
37T559FProcessing of Absence Quota Remainders5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
38T559LAutomatic Absence Quota Generation4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
39T559PLimits for Time Balances3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
40T559QTexts for Time Balance Limits4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
41T559TTexts for Leave Accrual Rule5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
42T559UOvertime rules2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
43T559WText Table for Time Evaluation Classes3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
44T559XEvaluation Classes for Times (Internal Table TIP)2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
45T559YText Table for Conditions for Employee Times3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
46T559ZConditions for Employee Times in Time Evaluation2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
47T705BPDC Processing Statuses2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
48T705EReaction to Error Transaction2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
49T7TIM_BSB_MESSGAssignment of Business Subject to a Message2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
50T7TIM_BSB_ZTARTAssignment of Business Subject to a Time Type2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
51T7TIM_LIMIT_STEPRule Blocks Under LIMIT5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
52T7TIM_QUOTA_STEPRule Blocks Under QUOTA6MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPPortugal
53T5PV1HR-PT: Assignment of quota type selection rule group4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPPublic Sector
54T5QPBS2OImpact of Organizational change9MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
55T5QPBS2TTo determine the Seniority based on the Anniversary date4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
56T5QPBS5AHR AU PS:Australian Leave Loading4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
57T5QPBS5BHR AU PS:Australian Leave Loading for varying percentage4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPShift Planning
58T77EIContents of Info Column for Shift Planning4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPShift Planning for Public Sector
59T7PBS_SP_TSN_DAssgmt Time Type to Exam. Scheme/Training Path and Grouping4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
60T7PBS_SP_TSN_ETime Statement for Nurses: Column Customizing for UI4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
61T7PBS_SP_TSN_E_TGrouping for Practical Training: Texts5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPSwitzerland
62T5C20Time Quotas for Subapplications CH5MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPTime Data Recording and Administration
63TMW_TDTYPETime Data ID29MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPUSA
64T7US_FMLA_DETRULTable of Relationships: FMLA Rule and Feature FMLMO3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
65T7US_FMLA_DETWWKTable of Relationships: Week Converter and Feature WWKMO3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
66T7US_FMLA_RU2REAssignment of FMLA Reasons to FMLA Rules3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
67T7US_FMLA_RULERules for Administrating FMLA Events3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
68T7US_FMLA_RULTXTRule Texts for Administration of FMLA Events4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
69T7US_FMLA_WRKWKRule for Determining Week Converter2MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
70T7US_FMLA_WWKTXTRule Texts for Determining Weekly Working Time3MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20
TOPVenezuela
71T7VE10Assignment of date class to absence quota4MOBDEGrouping of Personnel Subareas for Time Recordingnvarchar20