SAP ABAP View MGV_MCHA (Selection MCHA with material version, see: http://material)

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_MCHA
Short Description	Selection MCHA with material version, see: http://material
Root table	MCHA	Batches

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MCHA	MCHA
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MCHA	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	MCHA	MATNR	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	MCHA	*		☐		☐
2	MANDT	MCHA	MANDT		☐	MANDT	☐	Client
3	MATNR	MCHA	MATNR		☐	MATNR	☐	Material Number
4	WERKS	MCHA	WERKS		☐	WERKS_D	☐	Plant
5	CHARG	MCHA	CHARG		☐	CHARG_D	☐	Batch Number
6	LVORM	MCHA	LVORM		☐	LVOCA	☐	Deletion Flag for All Data on a Batch at a Plant
7	ERSDA	MCHA	ERSDA		☐	ERSDA	☐	Created On
8	ERNAM	MCHA	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
9	AENAM	MCHA	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
10	LAEDA	MCHA	LAEDA		☐	LAEDA	☐	Date of Last Change
11	VERAB	MCHA	VERAB		☐	VERAB	☐	Availability date
12	VFDAT	MCHA	VFDAT		☐	VFDAT	☐	Shelf Life Expiration or Best-Before Date
13	ZUSCH	MCHA	ZUSCH		☐	DZUSCH	☐	Batch status key
14	ZUSTD	MCHA	ZUSTD		☐	DZUSTD	☐	Batch in Restricted-Use Stock
15	ZAEDT	MCHA	ZAEDT		☐	DZAEDT	☐	Date of last status change
16	LIFNR	MCHA	LIFNR		☐	ELIFN	☐	Vendor's account number
17	LICHA	MCHA	LICHA		☐	LICHN	☐	Vendor Batch Number
18	VLCHA	MCHA	VLCHA		☐	VLCHN	☐	Original batch number (deactivated)
19	VLWRK	MCHA	VLWRK		☐	VLWRK	☐	Original plant (deactivated)
20	VLMAT	MCHA	VLMAT		☐	VLMAT	☐	Original material (deactivated)
21	BWTAR	MCHA	BWTAR		☐	BWTAR_D	☐	Valuation type
22	CHAME	MCHA	CHAME		☐	CHAME	☐	Unit of issue for batch (deactivated)
23	LWEDT	MCHA	LWEDT		☐	LWEDT	☐	Date of last goods receipt
24	FVDT1	MCHA	FVDT1		☐	FVDAT	☐	Date for unrestricted use
25	FVDT2	MCHA	FVDT2		☐	FVDAT	☐	Date for unrestricted use
26	FVDT3	MCHA	FVDT3		☐	FVDAT	☐	Date for unrestricted use
27	FVDT4	MCHA	FVDT4		☐	FVDAT	☐	Date for unrestricted use
28	FVDT5	MCHA	FVDT5		☐	FVDAT	☐	Date for unrestricted use
29	FVDT6	MCHA	FVDT6		☐	FVDAT	☐	Date for unrestricted use
30	HERKL	MCHA	HERKL		☐	HERKL	☐	Country of origin of the material
31	HERKR	MCHA	HERKR		☐	HERKR	☐	Region of origin of material (non-preferential origin)
32	MTVER	MCHA	MTVER		☐	MTVER	☐	Export/import material group
33	QNDAT	MCHA	QNDAT		☐	QNPDAT	☐	Next Inspection Date
34	HSDAT	MCHA	HSDAT		☐	HSDAT	☐	Date of Manufacture
35	CUOBJ_BM	MCHA	CUOBJ_BM		☐	CUOBJ_BM	☐	Internal object no.: Batch classification
36	DEACT_BM	MCHA	DEACT_BM		☐	DEACT_BM	☐	Batch is no longer active
37	BATCH_TYPE	MCHA	BATCH_TYPE		☐	BATCH_TYPE	☐	Type of Batch
38	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☐	External Long Material Number
39	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	20110901
SAP Release Created in