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

40 columns | Print definition?ERP 6.0  | DGSPRAS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPDangerous Goods Management
1TDG04DG: Short Description for Transport Type2DGSPRASLanguage Keynvarchar10
2TDG10DG: Label for dangerous goods classes2DGSPRASLanguage Keynvarchar10
3TDG12DG: Description for Classification Code2DGSPRASLanguage Keynvarchar10
4TDG18DG: Description for danger label number2DGSPRASLanguage Keynvarchar10
5TDG22DG: Description for user-defined texts2DGSPRASLanguage Keynvarchar10
6TDG28Descriptions for hazard notes2DGSPRASLanguage Keynvarchar10
7TDG32Text table for hazard identification numbers2DGSPRASLanguage Keynvarchar10
8TDG34DG: Description for hazard-inducing substances2DGSPRASLanguage Keynvarchar10
9TDG40DG: Description for processing status2DGSPRASLanguage Keynvarchar10
10TDG42DG: Desc. DG indicator profiles for material master2DGSPRASLanguage Keynvarchar10
11TDG48DG: Description for DG material-independent texts2DGSPRASLanguage Keynvarchar10
12TDG66DG: Text Table for Mode of Transport Categories2DGSPRASLanguage Keynvarchar10
13TDG68DG: Text table for UN number (new)2DGSPRASLanguage Keynvarchar10
14TDG70DG: Checkbox Structure Description for Filling/Distribution2DGSPRASLanguage Keynvarchar10
15TDG72DG: Checkbox Structure Desc. for Filling/Distrib. (Packag.)2DGSPRASLanguage Keynvarchar10
16TDG98GG: Text Table for Approval Code Types2DGSPRASLanguage Keynvarchar10
17TDGA6DG: Labels for dangerous goods check routines2DGSPRASLanguage Keynvarchar10
18TDGB2DG: Description for dangerous goods check schema2DGSPRASLanguage Keynvarchar10
19TDGD6DG: Description Indicator Category2DGSPRASLanguage Keynvarchar10
20THM082EHS DGM: Description for Hazard Inducer Types2DGSPRASLanguage Keynvarchar10
TOPEnvironment, Health and Safety
21TDG96DG: Text Table for Level of Dangerous Goods Packaging2DGSPRASLanguage Keynvarchar10
22TDGC6Text table for DG indicator profiles in the delivery header2DGSPRASLanguage Keynvarchar10
23TDGD2DG: Description Regulation Profile2DGSPRASLanguage Keynvarchar10
24THM072Risk Potential Description2DGSPRASLanguage Keynvarchar10
TOPEnvironment, Health and Safety Master Data
25TDG16DG: Label for water pollution class2DGSPRASLanguage Keynvarchar10
26TDG30DG: Text table for printing labels2DGSPRASLanguage Keynvarchar10
27TDG36DG: Description for VbF classes2DGSPRASLanguage Keynvarchar10
28TDG38DG: Description for Storage Hazard Classes2DGSPRASLanguage Keynvarchar10
29TDG74DG: Description of Identification Number Type2DGSPRASLanguage Keynvarchar10
30THM004DG: Short Description for Transport Type2DGSPRASLanguage Keynvarchar10
31THM010DG: Description of Dangerous Goods Classes2DGSPRASLanguage Keynvarchar10
32THM012Description for Classification Code2DGSPRASLanguage Keynvarchar10
33THM018DG: Short Description for Danger Label2DGSPRASLanguage Keynvarchar10
34THM032DG: Short Description for Hazard Identification Number2DGSPRASLanguage Keynvarchar10
35THM040DG: Short Description of Processing Status for DG Basic Data2DGSPRASLanguage Keynvarchar10
36THM074Descr. for packaging code specific to DG regulations2DGSPRASLanguage Keynvarchar10
37THM076DG: Packaging Regulation Description2DGSPRASLanguage Keynvarchar10
38THM152DG: Mode-of-Transport Category2DGSPRASLanguage Keynvarchar10
39THM158DG: Description of Profiles2DGSPRASLanguage Keynvarchar10
40THM160DG: Description Not Dangerous Goods Full/Empty Transport2DGSPRASLanguage Keynvarchar10