SAP ABAP View MATERIALIDT (Material number + short texts)
Hierarchy
ECC-DIMP (Software Component) DIMP
   LO-MD-MM (Application Component) Material Master
     MGVERS (Package) Material version in material master
Basic Data
View Type D Database View 
Database View MATERIALIDT  
Short Description Material number + short texts    
Root table MATERIALID   Material Identification 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 MATERIALID MATERIALID
2 MAKT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 MATERIALID MANDT JL EQ 0 0
2 MAKT MANDT JR EQ AND 0 0
3 MATERIALID MATNR_INT JL EQ 0 0
4 MAKT MATNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT MATERIALID MANDT   MANDT Client
2 MATNR_INT MATERIALID MATNR_INT   MATNR_INT Material Number
3 MATNR_EXT MATERIALID MATNR_EXT   MATNR_EXT External Long Material Number
4 MATNR_VERS MATERIALID MATNR_VERS   MATNR_VERS Material Version Number
5 SPRAS MAKT SPRAS   SPRAS Language Key
6 MAKTX MAKT MAKTX   MAKTX Material description
                 
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