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

61 columns | Print definition?ERP 6.0  | LWDG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPDangerous Goods Management
1CCDUTDGRELLKEYDG: Dummy Table for Lock Obj. on Log. Key for CCDUTDGREL3LWDGDangerous Goods Regulationnvarchar120
2DGTEXCCHKMETHExceptions to Dangerous Goods Regulations: Check Methods2LWDGDangerous Goods Regulationnvarchar120
3TDG61DG: Regulations3LWDGDangerous Goods Regulationnvarchar120
4TDG63DG: Derivation of Regulations4LWDGDangerous Goods Regulationnvarchar120
5TDG69DG: Define Checkbox Structure for Filling/Distribution2LWDGDangerous Goods Regulationnvarchar120
6TDG70DG: Checkbox Structure Description for Filling/Distribution3LWDGDangerous Goods Regulationnvarchar120
7TDG71DG: Define Checkbox Struct. for Filling/Distribution (Pack.)2LWDGDangerous Goods Regulationnvarchar120
8TDG72DG: Checkbox Structure Desc. for Filling/Distrib. (Packag.)3LWDGDangerous Goods Regulationnvarchar120
9TDG77DG: Priorities for Validity Areas per Regulation2LWDGDangerous Goods Regulationnvarchar120
10TDGD3DG: Assignment Regulation to Regulation Profile3LWDGDangerous Goods Regulationnvarchar120
11TDGD9DG: Specify Checkbox Struct. for Temp./One-Time Mat. Maint.2LWDGDangerous Goods Regulationnvarchar120
12THM083EHS: Hazard Inducer Types3LWDGDangerous Goods Regulationnvarchar120
13THM093DG: Segregation Rules for Mixed Loading Checks2LWDGDangerous Goods Regulationnvarchar120
14THM105DG: Decision Matrix for Enterpr.-Spec. Mixed Loading Groups2LWDGDangerous Goods Regulationnvarchar120
TOPEnvironment, Health and Safety
15DGMSDDG: Dangerous Goods Document Table DGMSD5LWDGDangerous Goods Regulationnvarchar120
16DGTEXCCNTRIESExceptions to Dangerous Goods Regulations: Countries2LWDGDangerous Goods Regulationnvarchar120
17DGTEXCEPTExceptions to DG Regulations - Header Table2LWDGDangerous Goods Regulationnvarchar120
18DGTEXCTEXTSExceptions to DG Regulations: Texts and Documents2LWDGDangerous Goods Regulationnvarchar120
19DGTEXCUNNOExceptions to DG Regulations: UN Numbers2LWDGDangerous Goods Regulationnvarchar120
20THM071DG: Risk Potential2LWDGDangerous Goods Regulationnvarchar120
21THM072Risk Potential Description3LWDGDangerous Goods Regulationnvarchar120
22VEDGDG: Supplement Table for DG Data (Handling Unit)4LWDGDangerous Goods Regulationnvarchar120
TOPEnvironment, Health and Safety Master Data
23CCDUTDGRELProduct Release17LWDGDangerous Goods Regulationnvarchar120
24CCUNC111Stowage Categories2LWDGDangerous Goods Regulationnvarchar120
25CCUNC112Stowage Category Descriptions3LWDGDangerous Goods Regulationnvarchar120
26CCUNC115Instructions for Enclosure2LWDGDangerous Goods Regulationnvarchar120
27CCUNC116Descriptions for Instructions for Enclosure3LWDGDangerous Goods Regulationnvarchar120
28CCUNC117Regulatory Basis for Transport Restrictions2LWDGDangerous Goods Regulationnvarchar120
29CCUNC118Descriptions for Regulatory Basis for Transport Restrictions3LWDGDangerous Goods Regulationnvarchar120
30CCUNC121Packaging Codes (Enhanced Data Model)2LWDGDangerous Goods Regulationnvarchar120
31CCUNC122Packaging Code Descriptions3LWDGDangerous Goods Regulationnvarchar120
32DGTMDDG: Dangerous Goods Master30LWDGDangerous Goods Regulationnvarchar120
33TDG105Assign Transport Indicators to Dangerous Goods Regulation3LWDGDangerous Goods Regulationnvarchar120
34THM003DG: Specify Transport Type2LWDGDangerous Goods Regulationnvarchar120
35THM004DG: Short Description for Transport Type3LWDGDangerous Goods Regulationnvarchar120
36THM009Dangerous Goods Classes2LWDGDangerous Goods Regulationnvarchar120
37THM010DG: Description of Dangerous Goods Classes3LWDGDangerous Goods Regulationnvarchar120
38THM011Classification Code2LWDGDangerous Goods Regulationnvarchar120
39THM012Description for Classification Code3LWDGDangerous Goods Regulationnvarchar120
40THM017DG Danger Label2LWDGDangerous Goods Regulationnvarchar120
41THM018DG: Short Description for Danger Label3LWDGDangerous Goods Regulationnvarchar120
42THM031DG: Hazard Identification Numbers2LWDGDangerous Goods Regulationnvarchar120
43THM032DG: Short Description for Hazard Identification Number3LWDGDangerous Goods Regulationnvarchar120
44THM063DG: Dangerous Goods Regulation2LWDGDangerous Goods Regulationnvarchar120
45THM073DG: Packaging Code Specific to Dangerous Goods Regulations2LWDGDangerous Goods Regulationnvarchar120
46THM074Descr. for packaging code specific to DG regulations3LWDGDangerous Goods Regulationnvarchar120
47THM075DG: Packaging Regulation2LWDGDangerous Goods Regulationnvarchar120
48THM076DG: Packaging Regulation Description3LWDGDangerous Goods Regulationnvarchar120
49THM091DG: Dynamic Key2LWDGDangerous Goods Regulationnvarchar120
50THM092DG: Description of Dynamic Key3LWDGDangerous Goods Regulationnvarchar120
51THM097DG: Mixed Loading Rules2LWDGDangerous Goods Regulationnvarchar120
52THM098DG: Description of Mixed Loading Rules2LWDGDangerous Goods Regulationnvarchar120
53THM099DG: Segregation2LWDGDangerous Goods Regulationnvarchar120
54THM100DG: Description of Segregation2LWDGDangerous Goods Regulationnvarchar120
55THM101DG: Regulation-Dependent Mixed Loading Groups2LWDGDangerous Goods Regulationnvarchar120
56THM102DG: Description of Regulation-Dependent Mixed Loading Groups2LWDGDangerous Goods Regulationnvarchar120
57THM157DG: Profiles for Dangerous Goods User-Defined Texts2LWDGDangerous Goods Regulationnvarchar120
58THM158DG: Description of Profiles3LWDGDangerous Goods Regulationnvarchar120
TOPMaterials Management
59/ISDFPS/VTTKDGEHS: Supplement Table for Exceptions (DG Data, Transport)3LWDGDangerous Goods Regulationnvarchar120
TOPProduct Safety
60EST0FEHS: Dangerous Goods Management - Transport Classification18LWDGDangerous Goods Regulationnvarchar120
61TCGR5EHS: Condition Schema for RGV Selection - Table 52LWDGDangerous Goods Regulationnvarchar120