SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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

9 COLUMNS | 1 INDEXES | ERP 6.0 | RPM_ROLE_SKILL TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Portfolio and Project Management :: Portfolio Management
1	ERP EHP7	6.0	RPM_ROLE_SKILL	9	1	Role Qualifications	Portfolio Management

TOP ERP 6.0 | RPM_ROLE_SKILL COLUMNS

	Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
	1	CLIENT	Client	nvarchar	3	0				Allow NULL?
	2	GUID	Guid for application objects	varbinary	16	0
	3	PLVAR	Plan Version	nvarchar	2	0				Allow NULL?
	4	OTYPE	Object Type	nvarchar	2	0				Allow NULL?
	5	OBJID	Object ID	nvarchar	8	0				Allow NULL?
	6	VBEGD	Start Date	nvarchar	8	0				Allow NULL?
	7	VENDD	End Date	nvarchar	8	0				Allow NULL?
	8	PROFCY	Proficiency of a Quality Scale	nvarchar	4	0				Allow NULL?
	9	ESSENTIAL	Indicator: Essential or Optional Requirement	char	1	0				Allow NULL?

TOP ERP 6.0 | RPM_ROLE_SKILL INDEXES

Name	Primary	Unique	Type	Columns
RPM_ROLE_SKILL~0	Yes	Yes	CLUSTERED	OBJID, OTYPE, PLVAR, GUID, CLIENT