SAP ABAP View M_MAT1F (Generated view for matchcode ID MAT1-F)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CF (Package) R/3 Appl. development: PPS production resources/tools
Basic Data
View Type D Database View 
Database View M_MAT1F  
Short Description Generated view for matchcode ID MAT1-F    
Root table MAKT   Material Descriptions 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 MAKT MAKT
2 MARA  
3 MARC  
4 CRVM_B  
5 CRID  
6 CRFH  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 MARA MANDT JL EQ 0 0
2 MAKT MANDT JR EQ AND 0 0
3 MARA MATNR JL EQ 0 0
4 MAKT MATNR JR EQ AND 0 0
5 MARA MANDT JL EQ 0 0
6 MARC MANDT JR EQ AND 0 0
7 MARA MATNR JL EQ 0 0
8 MARC MATNR JR EQ AND 0 0
9 MARC MANDT JL EQ 0 0
10 CRVM_B MANDT JR EQ AND 0 0
11 MARC MATNR JL EQ 0 0
12 CRVM_B MATNR JR EQ AND 0 0
13 MARC WERKS JL EQ 0 0
14 CRVM_B WERKS JR EQ AND 0 0
15 CRID MANDT JL EQ 0 0
16 CRVM_B MANDT JR EQ AND 0 0
17 CRID OBJTY JL EQ 0 0
18 CRVM_B OBJTY JR EQ AND 0 0
19 CRID OBJID JL EQ 0 0
20 CRVM_B OBJID JR EQ AND 0 0
21 CRID MANDT JL EQ 0 0
22 CRFH MANDT JR EQ AND 0 0
23 CRID OBJTY JL EQ 0 0
24 CRFH OBJTY JR EQ AND 0 0
25 CRID OBJID JL EQ 0 0
26 CRFH OBJID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT MAKT MANDT   MANDT Client
2 MAKTG MAKT MAKTG   MAKTG Material description in upper case for matchcodes
3 FHM_FGRU1 CRFH FGRU1   FGRUA Grouping key 1 for production resources/tools
4 FHM_FGRU2 CRFH FGRU2   FGRUB Grouping key 2 for production resources/tools
5 SPRAS MAKT SPRAS   SPRAS Language Key
6 MATNR MARA MATNR   MATNR Material Number
7 WERKS MARC WERKS   WERKS_D Plant
                 
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  20140121 
SAP Release Created in