SAP ABAP Table ENT5940 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT5940	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SKOPF	☑	W_SORTK	WSORTK	CHAR	18	0	Assortment Module
3	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
4	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
5	DATUB	☐	DATBI	DATUM	DATS	8	0	Valid To Date
6	LVORM	☐	WLOEK	WLOEK	CHAR	1	0	Deletion indicator IS-R tables
7	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	PFLKN	☐	W_PFLKN	PFLKS	CHAR	1	0	Assortment Priority
10	STAT1	☐	W_SSTAT	XFELD	CHAR	1	0	Status (active/inactive)
11	STAT3	☐	W_ZSTAT	XFELD	CHAR	1	0	Status of assignment to assortments
12	DATAE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	VTEXT	☐	W_SORTX	TEXT40U	CHAR	40	0	Description for assortment module
15	LOKAL	☐	WLOKL	KUNNR	CHAR	10	0	Local assortment for a retail plant	KNA1
16	TYPIN	☐	W_TYPINT	FLAG	CHAR	1	0	Local module for the inclusion of (automat.) relistings
17	WKLOK	☐	WERKL	WERKS	CHAR	4	0	Retail plant with a local assortment module	T001W

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5940	LOKAL	KNA1	KUNNR	KEY	1	CN
2	ENT5940	MANDT	T000	MANDT	KEY	1	CN
3	ENT5940	SPRAS	T002	SPRAS	KEY	1	CN
4	ENT5940	WKLOK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in