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

37 columns | Print definition?ERP 6.0  | MNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGermany
1PD3DBANHR-DDU: Address Data Module4MNRDEUEV Notification Numbernvarchar40
2PD3DBEUHR-DDU: Data Module - European Insurance Number4MNRDEUEV Notification Numbernvarchar40
3PD3DBGBHR-DDU: Data Module - Birth Details4MNRDEUEV Notification Numbernvarchar40
4PD3DBKSHR-DDU: Data Module - Miners'/Sailors' Insurance4MNRDEUEV Notification Numbernvarchar40
5PD3DBMEHR-DDU: Reporting Facts Data Module4MNRDEUEV Notification Numbernvarchar40
6PD3DBNAHR-DDU: Name Data Module4MNRDEUEV Notification Numbernvarchar40
7PD3DBSOHR-DDU: Immediate Notification Data Module4MNRDEUEV Notification Numbernvarchar40
8PD3DBSVHR-DDU: Social Insurance Card Data Module4MNRDEUEV Notification Numbernvarchar40
9PD3DBUVDEUEV: Data Module DBUV - Accident Insurance4MNRDEUEV Notification Numbernvarchar40
10PD3DBUV_DATDEUEV AI Data for Module DBUV - Accident Insurance4MNRDEUEV Notification Numbernvarchar40
11PD3DSAPHR-DDU: Administration Record for Notifications4MNRDEUEV Notification Numbernvarchar40
12PD3DSMEHR-DDU: Data Record Notfication4MNRDEUEV Notification Numbernvarchar40
13PD3FLAGHR-DDU: Notifications Indicator4MNRDEUEV Notification Numbernvarchar40
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
14T247Month name and short text2MNRMonth numbernvarchar20
15TFARSIMONTHNames of months of Farsi calendar2MNRMonth numbernvarchar20
16TISLMONTHname of months in Islamic calendar2MNRMonth numbernvarchar20
TOPSocial Insurance
17P01BM_STATControl Records for PPO DEUEV Notifications5MNRDEUEV Notification Numbernvarchar40
18P01D3_DSAPDEUEV Confirmation: Control Record for Notifications18MNRDEUEV Notification Numbernvarchar40
19P01DS_STATControl Records for DEUEV Immediate Notifications5MNRDEUEV Notification Numbernvarchar40
20P01EE_STATAdmin. Records for Data Exchange for Compensation Benefits6MNRMessage Numbernvarchar40
21PD3DBKVDEUEV: Data Module Health Insurance4MNRDEUEV Notification Numbernvarchar40
22PD3HISTStatus History Management for DEUEV Notifications4MNRDEUEV Notification Numbernvarchar40
TOPStatements
23P01W_ADMIN_01HR: Data Module: Administration for Health Insurance Funds5MNRMessage Numbernvarchar40
24P01W_DBAEData Module: Statement of Earnings - Remuneration5MNRMessage Numbernvarchar40
25P01W_DBALData Module: Statement of Earnings - General5MNRMessage Numbernvarchar40
26P01W_DBANData Module: Address5MNRMessage Numbernvarchar40
27P01W_DBEKData Module: Statement of Earnings for Sick Child5MNRMessage Numbernvarchar40
28P01W_DBFRData Module: Stmt of Earnings - Rel. from Work f. Sick Child5MNRMessage Numbernvarchar40
29P01W_DBFZData Module: Stmt of Earnings - Absences w/o Remuneration5MNRMessage Numbernvarchar40
30P01W_DBKRData Module: Remuneration Statement for Sick Pay5MNRMessage Numbernvarchar40
31P01W_DBMUData Module: Statement of Earnings, Maternity Pay5MNRMessage Numbernvarchar40
32P01W_DBNAData Module: Name5MNRMessage Numbernvarchar40
33P01W_DBUNData Module: Statement of Earnings - Accident Data5MNRMessage Numbernvarchar40
34P01W_DBZEData Module: Statement of Earnings, Working Time, Sick Child5MNRMessage Numbernvarchar40
35P01W_DBZKData Module: Stmt of Earnings, Working Time for Sick Pay5MNRMessage Numbernvarchar40
36P01W_DSLWData Module: General Information5MNRMessage Numbernvarchar40
TOPUser and Authorization Management
37TUL_ACRESSystem Measurement: AC Results Table2MNRGUID in 'RAW' formatvarbinary160