SAP ABAP View M_EQUIW (Generated view for matchcode ID EQUI-W)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       IEQM (Package) Application Develoment R/3 Equipment Management
Basic Data
View Type D Database View 
Database View M_EQUIW  
Short Description Generated view for matchcode ID EQUI-W    
Root table CRFH   CIM production resource/tool master data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRFH CRFH
2 EQKT  
3 EQUI  
4 CRVE_B  
5 CRID  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 EQUI MANDT JL EQ 0 0
2 EQKT MANDT JR EQ AND 0 0
3 EQUI EQUNR JL EQ 0 0
4 EQKT EQUNR JR EQ AND 0 0
5 EQUI MANDT JL EQ 0 0
6 CRVE_B MANDT JR EQ AND 0 0
7 EQUI EQUNR JL EQ 0 0
8 CRVE_B EQUNR JR EQ AND 0 0
9 CRID MANDT JL EQ 0 0
10 CRVE_B MANDT JR EQ AND 0 0
11 CRID OBJTY JL EQ 0 0
12 CRVE_B OBJTY JR EQ AND 0 0
13 CRID OBJID JL EQ 0 0
14 CRVE_B OBJID JR EQ AND 0 0
15 CRID MANDT JL EQ 0 0
16 CRFH MANDT JR EQ AND 0 0
17 CRID OBJTY JL EQ 0 0
18 CRFH OBJTY JR EQ AND 0 0
19 CRID OBJID JL EQ 0 0
20 CRFH OBJID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT CRFH MANDT   MANDT Client
2 FGRU1 CRFH FGRU1   FGRUA Grouping key 1 for production resources/tools
3 FGRU2 CRFH FGRU2   FGRUB Grouping key 2 for production resources/tools
4 EQKTU EQKT EQKTU   EQKTU Equipment description in capital letters
5 SPRAS EQKT SPRAS   SPRAS Language Key
6 EQUNR EQUI EQUNR   EQUNR Equipment Number
                 
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