SAP ABAP View MGV_01MCHB_F4HEL (RMPU Help View from MCHB & MARA for F4 Help ELORT)
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 MGV_01MCHB_F4HEL  
Short Description RMPU Help View from MCHB & MARA for F4 Help ELORT    
Root table MCHB   Batch Stocks 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 MCHB MCHB
2 MARA  
3 MARC  
4 MATERIALID  
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 MCHB MANDT JR EQ AND 0 0
3 MARA MATNR JL EQ 0 0
4 MCHB MATNR JR EQ AND 0 0
5 MARC MANDT JL EQ 0 0
6 MCHB MANDT JR EQ AND 0 0
7 MARC MATNR JL EQ 0 0
8 MCHB MATNR JR EQ AND 0 0
9 MARC WERKS JL EQ 0 0
10 MCHB WERKS JR EQ AND 0 0
11 MATERIALID MANDT JL EQ 0 0
12 MCHB MANDT JR EQ AND 0 0
13 MATERIALID MATNR_INT JL EQ 0 0
14 MCHB MATNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT MCHB MANDT   MANDT Client
2 MATNR MCHB MATNR   MATNR Material Number
3 WERKS MCHB WERKS   WERKS_D Plant
4 LGORT MCHB LGORT   LGORT_D Storage location
5 CHARG MCHB CHARG   CHARG_D Batch Number
6 CLABS MCHB CLABS   LABST Valuated Unrestricted-Use Stock
7 MEINS MARA MEINS   MEINS Base Unit of Measure
8 XCHPF MARA XCHPF   XCHPF Batch management requirement indicator
9 XCHAR MARC XCHAR   XCHAR Batch management indicator (internal)
10 MATNR_EXT MATERIALID MATNR_EXT   MATNR_EXT External Long Material Number
11 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 500