SAP ABAP Table V_MMIM_CHA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_MMIM_CHA	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
4	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
5	LVORM	☐	LVOCA	XFELD	CHAR	1	0	Deletion Flag for All Data on a Batch at a Plant
6	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
10	VERAB	☐	VERAB	DATUM	DATS	8	0	Availability date
11	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
12	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
13	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
14	ZAEDT	☐	DZAEDT	DATUM	DATS	8	0	Date of last status change
15	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
16	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
17	VLCHA	☐	VLCHN	CHARG	CHAR	10	0	Original batch number (deactivated)	MCHA
18	VLWRK	☐	VLWRK	WERKS	CHAR	4	0	Original plant (deactivated)	MARC
19	VLMAT	☐	VLMAT	MATNR	CHAR	18	0	Original material (deactivated)	MARA
20	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
21	CHAME	☐	CHAME	MEINS	UNIT	3	0	Unit of issue for batch (deactivated)	T006
22	LWEDT	☐	LWEDT	DATUM	DATS	8	0	Date of last goods receipt
23	FVDT1	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
24	FVDT2	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
25	FVDT3	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
26	FVDT4	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
27	FVDT5	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
28	FVDT6	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
29	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
30	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
31	MTVER	☐	MTVER	MTVER	CHAR	4	0	Export/import material group	TVFM
32	QNDAT	☐	QNPDAT	DATUM	DATS	8	0	Next Inspection Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_MMIM_CHA	BWTAR	MBEW	BWTAR
2	V_MMIM_CHA	CHAME	T006	MSEHI	REF	C	CN
3	V_MMIM_CHA	CHARG	MCH1	CHARG	KEY	1	CN
4	V_MMIM_CHA	HERKL	T005	LAND1	REF	C	CN
5	V_MMIM_CHA	HERKR	T005S	BLAND	REF	C	CN
6	V_MMIM_CHA	LIFNR	LFA1	LIFNR
7	V_MMIM_CHA	MANDT	T000	MANDT	KEY	1	CN
8	V_MMIM_CHA	MATNR	MARA	MATNR	KEY	1	CN
9	V_MMIM_CHA	MTVER	TVFM	MTVER	REF	C	CN
10	V_MMIM_CHA	VLCHA	MCHA	CHARG	REF	C	CN
11	V_MMIM_CHA	VLMAT	MARA	MATNR	REF	C	CN
12	V_MMIM_CHA	VLWRK	MARC	WERKS	REF	C	CN
13	V_MMIM_CHA	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in