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

B1 9.2: Top 10 requests

TableColumnsDescription

B1 8.8: Top 10 requests

TableColumnsDescription
Financials :: Strategic Enterprise Management :: Business Consolidation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0UCML031121Monitor Layouts: Column Chars in SID PresentationBusiness Consolidation
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, AREA, UNAME, MLAYOUT, HRYNAME_SID, P_FIELDNAME_SID, P_VALUE_SID, FIELDNAME_SID, VALUE_SID, COL_HIDDEN, COL_WIDTH, GWC_HIDDEN FROM UCML031
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AREAConsolidation Areanvarchar20CHAR(N' ')NoUCM003CUC_AREA Allow NULL? 
3UNAMEUser Namenvarchar120CHAR(N' ')NoSYUNAME Allow NULL? 
4MLAYOUTMonitor Layoutnvarchar100CHAR(N' ')NoUCML00CUC_MLAYOUT Allow NULL? 
5HRYNAME_SIDSurrogate IDint100INT4((0))No*UC_SID Allow NULL? 
6P_FIELDNAME_SIDSurrogate IDint100INT4((0))No*UC_SID Allow NULL? 
7P_VALUE_SIDSurrogate IDint100INT4((0))No*UC_SID Allow NULL? 
8FIELDNAME_SIDSurrogate IDint100INT4((0))No*UC_SID Allow NULL? 
9VALUE_SIDSurrogate IDint100INT4((0))No*UC_SID Allow NULL? 
10COL_HIDDENGeneral indicator, SAP Consolidationchar10CHAR(N' ')YesUC_FLG Allow NULL? 
11COL_WIDTHNatural Numberint100INT4((0))YesINT4 Allow NULL? 
12GWC_HIDDENGeneral indicator, SAP Consolidationchar10CHAR(N' ')YesUC_FLG Allow NULL? 
NamePrimaryUniqueTypeColumns
UCML031~0YesYesCLUSTEREDMANDT, AREA, UNAME, MLAYOUT, HRYNAME_SID, P_FIELDNAME_SID, P_VALUE_SID, FIELDNAME_SID, VALUE_SID