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

8 COLUMNS | 1 INDEXES | ERP 6.0 | WFAC_DAYSHIFTDEF TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components :: General Application Functions :: Workforce Management Application
1	ERP EHP7	6.0	WFAC_DAYSHIFTDEF	8	1	Day Shift Definition (out of use for Retail)	Workforce Management Application

TOP ERP 6.0 | WFAC_DAYSHIFTDEF COLUMNS

	Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
	1	MANDT	Client	nvarchar	3	0				Allow NULL?
	2	LOCATION_TYPE	Location Profile	nvarchar	20	0				Allow NULL?
	3	START_DATE	Start Date	nvarchar	8	0				Allow NULL?
	4	END_DATE	End Date	nvarchar	8	0				Allow NULL?
	5	FIRSTDAYOFWEEK	Day Index	char	1	0				Allow NULL?
	6	STARTTIMEOFDAY	Start Time of Shift	nvarchar	6	0				Allow NULL?
	7	DAYLENGTH	Length of Day	nvarchar	6	0				Allow NULL?
	8	SHIFTGAP	Gap between Shifts	nvarchar	6	0				Allow NULL?

TOP ERP 6.0 | WFAC_DAYSHIFTDEF INDEXES

Name	Primary	Unique	Type	Columns
WFAC_DAYSHIFTDEF~0	Yes	Yes	CLUSTERED	MANDT, LOCATION_TYPE, START_DATE