SAP ABAP View ENT5939 (Assortment module - profile)
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 ENT5939  
Short Description Assortment module - profile    
Root table WSOH   Assortment Modules SAP Retail 
Entity TypeDM02L 
Short text Assortment module - profile
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 1 0 0
2 WSOT MANDT JR EQ 1 AND 0 0
3 WSOH SKOPF JL EQ 1 0 0
4 WSOT SKOPF JR EQ 1 AND 0 0
5 WSOH STYPB EQ '4' 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 FILIA WSOH FILIA   W_SP_FIL Assortment assignment (profile modules)
16 WAGRP WSOH WAGRP   MATKL Material Group
17 WKWAG WSOH WKWAG   WERKF Retail plant with profile module assignment
                 
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