SAP ABAP View M_WSOHA (Generated view for matchcode ID WSOH -A)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       WSOR (Package) IS-R: Assortments
Basic Data
View Type D Database View 
Database View M_WSOHA  
Short Description Generated view for matchcode ID WSOH -A    
Root table WSOH   Assortment Modules SAP Retail 
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 1 LVORM
2 WSOT MANDT JR EQ AND 0 1 LVORM
3 WSOH SKOPF JL EQ 0 1 LVORM
4 WSOT SKOPF JR EQ AND 0 1 LVORM
5 WSOH LVORM NE 'X' 0 1 LVORM
                     
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 DATAB WSOH DATAB   DATUV Valid-From Date
4 DATUB WSOH DATUB   DATUB Valid-to date
5 STAT1 WSOH STAT1   W_SSTAT Status (active/inactive)
6 STYPB WSOH STYPB   BAUSTYP Module type
7 PFLKN WSOH PFLKN   W_PFLKN Assortment Priority
8 VTEXT WSOT VTEXT   W_SORTX Description for assortment module
9 SPRAS WSOT SPRAS   SPRAS Language Key
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in