SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema: Module: Table: Column: Search^beta

SAP TABLESv1

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

	Table	Columns	Description

B1 9.2: Top 10 requests

	Table	Columns	Description

B1 8.8: Top 10 requests

	Table	Columns	Description

6 COLUMNS | 1 INDEXES | ERP 6.0 | /POA/D_CLM_HIST TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Collaborative Cross Applications
1	ERP EHP7	6.0	/POA/D_CLM_HIST	6	1	History of Activities	Collaborative Cross Applications

TOP ERP 6.0 | /POA/D_CLM_HIST COLUMNS

	Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
	1	CLIENT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
	2	CLM_OBJECT_TYPE	Version Number Component	nvarchar	2	0	CHAR	(N' ')	No		CHAR2	Allow NULL?
	3	CLM_OBJECT_ID	ID in Content Lifecycle Management	int	10	0	INT4	((0))	No		/POA/CLM_ID	Allow NULL?
	4	ACTIVITY	CLM Activities	nvarchar	4	0	NUMC	(N'0000')	No	*	/POA/CLM_ACTIVITY	Allow NULL?
	5	LAST_CHANGED_AT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0	DEC	((0))	No		TIMESTAMP
	6	ACTION	CLM Activities	nvarchar	4	0	NUMC	(N'0000')	Yes	*	/POA/CLM_ACTIVITY	Allow NULL?

TOP ERP 6.0 | /POA/D_CLM_HIST INDEXES

Name	Primary	Unique	Type	Columns
/POA/D_CLM_HIST~0	Yes	Yes	CLUSTERED	LAST_CHANGED_AT, ACTIVITY, CLM_OBJECT_ID, CLM_OBJECT_TYPE, CLIENT