SAP ABAP View MGV_HV_T8A60 (Search Help: Choose Representative Material Numbers)
Hierarchy
☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)
Basic Data
View Type D Database View 
Database View MGV_HV_T8A60  
Short Description Search Help: Choose Representative Material Numbers    
Root table T8A60   Representative Materials 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 T8A60 T8A60
2 MARA  
3 TKA01  
4 MAKT  
5 MATERIALID  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 T8A60 MANDT JL EQ 0 0
2 MATERIALID MANDT JR EQ AND 0 0
3 T8A60 REP_MATNR JL EQ 0 0
4 MATERIALID MATNR_INT JR EQ AND 0 0
5 MARA MANDT JL EQ 0 0
6 T8A60 MANDT JR EQ AND 0 0
7 MARA MATNR JL EQ 0 0
8 T8A60 REP_MATNR JR EQ AND 0 0
9 TKA01 MANDT JL EQ 0 0
10 T8A60 MANDT JR EQ AND 0 0
11 TKA01 KOKRS JL EQ 0 0
12 T8A60 KOKRS JR EQ AND 0 0
13 MARA MANDT JL EQ 0 0
14 MAKT MANDT JR EQ AND 0 0
15 MARA MATNR JL EQ 0 0
16 MAKT MATNR JR EQ AND 0 0
17 T8A60 REP_MATNR NE ' ' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT T8A60 MANDT   MANDT Client
2 KOKRS T8A60 KOKRS   KOKRS Controlling Area
3 REP_MATNR T8A60 REP_MATNR   REP_MATNR Representative material for Profit Center Accounting
4 MAKTX MAKT MAKTX   MAKTX Material description
5 BEZEI TKA01 BEZEI   BEZEI Name of the controlling area
6 SPRAS MAKT SPRAS   SPRAS Language Key
7 MATNR_EXT MATERIALID MATNR_EXT   MATNR_EXT External Long Material Number
8 MATNR_VERS MATERIALID MATNR_VERS   MATNR_VERS Material Version 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  20140121 
SAP Release Created in