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
Basis Components :: Change Transport System :: Client Copy
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CCPROCTAB91Parallel Client Copy ProcessesClient Copy
SQL:  selectupdate insert create

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

SELECT MANDT, PROCESS, STARTTIME, STARTDATE, NBRTAB, TABNAME, HOSTNAME, CCPROCESS, CHTIME FROM CCPROCTAB
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PROCESSProcess numbernvarchar50 Allow NULL? 
3STARTTIMETimenvarchar60 Allow NULL? 
4STARTDATEDatenvarchar80 Allow NULL? 
5NBRTABNumber of Tablesint100 Allow NULL? 
6TABNAMETable Namenvarchar300 Allow NULL? 
7HOSTNAMEApplication Servernvarchar320 Allow NULL? 
8CCPROCESSProcess ID for parallel client copy processsnvarchar250 Allow NULL? 
9CHTIMETimenvarchar60 Allow NULL? 
NamePrimaryUniqueTypeColumns
CCPROCTAB~0YesYesCLUSTEREDPROCESS, MANDT