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.0CCGLC_WBC_ETD101EHS: LWB Activity
SQL:  selectupdate insert create

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

SELECT MANDT, BP_ID, TAB_ID, EXEC_TYPE_ID, SORT, ICON, UI_REACT_SUCCESS, UI_REACT_FAILED, MIN_SELECTED, MAX_SELECTED FROM CCGLC_WBC_ETD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BP_IDFunctionnvarchar120CHAR(N' ')NoCBGLE_WB_BP_ID Allow NULL? 
3TAB_IDTabnvarchar200CHAR(N' ')NoCCGLC_WBC_TABCBGLE_WB_TAB_ID Allow NULL? 
4EXEC_TYPE_IDActivitynvarchar200CHAR(N' ')NoCBGLE_WB_EXEC_TYPE_ID Allow NULL? 
5SORTSort Sequencenvarchar40NUMC(N'0000')YesESEORD Allow NULL? 
6ICONIcon for Activitynvarchar300CHAR(N' ')YesCBGLE_WB_ICONNAME_ACTIVITY Allow NULL? 
7UI_REACT_SUCCESSResponse to Successful Execution of Activitynvarchar80CHAR(N' ')YesCBGLE_WB_UI_REACTION Allow NULL? 
8UI_REACT_FAILEDResponse to Failed Execution of Activitynvarchar80CHAR(N' ')YesCBGLE_WB_UI_REACTION_FAILED Allow NULL? 
9MIN_SELECTEDMinimum Selection for Execution of Activitynvarchar40NUMC(N'0000')YesCBGLE_WB_MIN_SELECTED Allow NULL? 
10MAX_SELECTEDMaximum Selection for Execution of Activitynvarchar60NUMC(N'000000')YesCBGLE_WB_MAX_SELECTED Allow NULL? 
NamePrimaryUniqueTypeColumns
CCGLC_WBC_ETD~0YesYesCLUSTEREDEXEC_TYPE_ID, TAB_ID, BP_ID, MANDT