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
Cross-Application Components :: General Application Functions :: Interaction Center WebClient
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CRMC_IC_ACPROFF41Activity Clipboard Filters for Profile EntriesInteraction Center WebClient
SQL:  selectupdate insert create

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

SELECT CLIENT, PROFILE, ENTRY_ID, FILTER FROM CRMC_IC_ACPROFF
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PROFILEActivity Clipboard Profilenvarchar320CHAR(N' ')NoCRMC_IC_ACPROFCRMT_IC_AC_PROFILE Allow NULL? 
3ENTRY_IDActivity Clipboard Entry IDnvarchar300CHAR(N' ')NoCRMC_IC_ACPROFECRMT_IC_AC_ENTRY_ID Allow NULL? 
4FILTERActivity Clipboard Entry Filternvarchar200CHAR(N' ')NoCRMS_IC_ACFILTERCRMT_IC_AC_FILTER Allow NULL? 
NamePrimaryUniqueTypeColumns
CRMC_IC_ACPROFF~0YesYesCLUSTEREDFILTER, ENTRY_ID, PROFILE, CLIENT