SAP ABAP View MGV_M_KREDM (Generated view for matchcode ID KRED -M)
Hierarchy
ECC-DIMP (Software Component) DIMP
   LO-MD-MM (Application Component) Material Master
     MGV_MATNR_LAMA (Package) LAMA: Material number conversion (long mat. no.)
Basic Data
View Type D Database View 
Database View MGV_M_KREDM  
Short Description Generated view for matchcode ID KRED -M    
Root table EINA   Purchasing Info Record: General Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 EINA EINA
2 LFA1  
3 EINE  
4 MATERIALID  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 LFA1 MANDT JL EQ 0 0
2 EINA MANDT JR EQ AND 0 0
3 LFA1 LIFNR JL EQ 0 0
4 EINA LIFNR JR EQ AND 0 0
5 EINA MANDT JL EQ 0 0
6 EINE MANDT JR EQ AND 0 0
7 EINA INFNR JL EQ 0 0
8 EINE INFNR JR EQ AND 0 0
9 EINA MANDT JL EQ 0 0
10 MATERIALID MANDT JR EQ AND 0 0
11 EINA MATNR JL EQ 0 0
12 MATERIALID MATNR_INT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT EINA MANDT   MANDT Client
2 MATNR EINA MATNR   MATNR Material Number
3 IDNLF EINA IDNLF   IDNLF Material Number Used by Vendor
4 EIORG EINE EKORG   EKORG Purchasing organization
5 LIFNR LFA1 LIFNR   LIFNR Account Number of Vendor or Creditor
6 INFNR EINA INFNR   INFNR Number of purchasing info record
7 ESOKZ EINE ESOKZ   ESOKZ Purchasing info record category
8 EWERK EINE WERKS   WERKS_D Plant
9 MATNR_EXT MATERIALID MATNR_EXT   MGV_MATNR_EXTERNAL Material Number
10 MATNR_VERS MATERIALID MATNR_VERS   MGV_MATNR_VERSION Version Number for MATNR Field
                 
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  20131127 
SAP Release Created in 600