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
Without Description :: Planning :: Business Planning and Simulation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0UPC_PROFILE61Planning ProfilesBusiness Planning and Simulation
SQL:  selectupdate insert create

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

SELECT MANDT, PROFILE, COUNTER, UNAME, AEDTM, ATIME FROM UPC_PROFILE
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PROFILEPlanning Profilenvarchar80 Allow NULL? 
3COUNTERChange counternvarchar30 Allow NULL? 
4UNAMEUser Namenvarchar120 Allow NULL? 
5AEDTMChanged onnvarchar80 Allow NULL? 
6ATIMELast changed atnvarchar60 Allow NULL? 
NamePrimaryUniqueTypeColumns
UPC_PROFILE~0YesYesCLUSTEREDMANDT, PROFILE