SAP ABAP View ENT5940 (Assortment module - standard)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	ENT5940
Short Description	Assortment module - standard
Root table	WSOH	Assortment Modules SAP Retail

Entity Type	DM02L
Short text	Assortment module - standard

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WSOH	WSOH
2	WSOT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WSOH	MANDT	JL	EQ				0	0
2	WSOT	MANDT	JR	EQ			AND	0	0
3	WSOH	SKOPF	JL	EQ				0	0
4	WSOT	SKOPF	JR	EQ			AND	0	0
5	WSOH	STYPB		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WSOH	MANDT		☐	MANDT	☐	Client
2	SKOPF	WSOH	SKOPF		☐	W_SORTK	☐	Assortment Module
3	SPRAS	WSOT	SPRAS		☐	SPRAS	☐	Language Key
4	DATAB	WSOH	DATAB		☐	DATAB	☐	Valid-From Date
5	DATUB	WSOH	DATUB		☐	DATBI	☐	Valid To Date
6	LVORM	WSOH	LVORM		☐	WLOEK	☐	Deletion indicator IS-R tables
7	ERSDA	WSOH	ERSDA		☐	ERSDA	☐	Created On
8	ERNAM	WSOH	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
9	PFLKN	WSOH	PFLKN		☐	W_PFLKN	☐	Assortment Priority
10	STAT1	WSOH	STAT1		☐	W_SSTAT	☐	Status (active/inactive)
11	STAT3	WSOH	STAT3		☐	W_ZSTAT	☐	Status of assignment to assortments
12	DATAE	WSOH	DATAE		☐	AEDAT	☐	Last Changed On
13	AENAM	WSOH	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
14	VTEXT	WSOT	VTEXT		☐	W_SORTX	☐	Description for assortment module
15	LOKAL	WSOH	LOKAL		☐	WLOKL	☐	Local assortment for a retail plant
16	TYPIN	WSOH	TYPIN		☐	W_TYPINT	☐	Local module for the inclusion of (automat.) relistings
17	WKLOK	WSOH	WKLOK		☐	WERKL	☐	Retail plant with a local assortment module

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in