SAP ABAP View M_KMATA (Generated View for Matchcode ID KMAT -A)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       CU (Package) Variant Configuration
Basic Data
View Type D Database View 
Database View M_KMATA  
Short Description Generated View for Matchcode ID KMAT -A    
Root table MARA   General Material Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 MARA MARA
2 MAKT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 MARA MANDT JL EQ 0 1 KZKFG
2 MAKT MANDT JR EQ AND 0 1 KZKFG
3 MARA MATNR JL EQ 0 1 KZKFG
4 MAKT MATNR JR EQ AND 0 1 KZKFG
5 MARA KZKFG EQ 'X' 0 1 KZKFG
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT MARA MANDT   MANDT Client
2 MATKL MARA MATKL   MATKL Material Group
3 MATNR MARA MATNR   MATNR Material Number
4 MTART MARA MTART   MTART Material type
5 MAKTG MAKT MAKTG   MAKTG Material description in upper case for matchcodes
6 SPRAS MAKT 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  20140121 
SAP Release Created in