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
1ERP EHP76.0/CIDEON/SEARCHDL151Load behavior CDESK
SQL:  selectupdate insert create

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

SELECT MANDT, BNAME, LOAD_VIEW, LOAD_MODIFY, LOAD_LATEST, LOAD_RELEASED, LOAD_ONLY, LOAD_DRAWING, LOAD_VALID, LOAD_NO_ASSI, LOAD_INSERT, LOAD_SELECTIVE, LOAD_SPEEDPAK, VIEWER_SELECT, VIEWER FROM /CIDEON/SEARCHDL
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2BNAMEUser Name in User Master Recordnvarchar120 Allow NULL? 
3LOAD_VIEWCheckboxchar10 Allow NULL? 
4LOAD_MODIFYCheckboxchar10 Allow NULL? 
5LOAD_LATESTCheckboxchar10 Allow NULL? 
6LOAD_RELEASEDCheckboxchar10 Allow NULL? 
7LOAD_ONLYCheckboxchar10 Allow NULL? 
8LOAD_DRAWINGCheckboxchar10 Allow NULL? 
9LOAD_VALIDCheckboxchar10 Allow NULL? 
10LOAD_NO_ASSICheckboxchar10 Allow NULL? 
11LOAD_INSERTCheckboxchar10 Allow NULL? 
12LOAD_SELECTIVECheckboxchar10 Allow NULL? 
13LOAD_SPEEDPAKCheckboxchar10 Allow NULL? 
14VIEWER_SELECTCheckboxchar10 Allow NULL? 
15VIEWERCideon Search Dialog Viewernvarchar1320 Allow NULL? 
NamePrimaryUniqueTypeColumns
/CIDEON/SEARCHDL~0YesYesCLUSTEREDBNAME, MANDT