SAP ABAP Table SMCH1 (Lock Table MCH1)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	INTTAB	Structure
Structure	SMCH1	Table Relationship Diagram
Short Description	Lock Table MCH1

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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
3	RMCH1	☐	RMCH1	XFELD	CHAR	1	0	Return code for table MCH1
4	XDBUP	☐	XDBUP	XFELD	CHAR	1	0	Database update
5	XCHUP	☐	XDBUP	XFELD	CHAR	1	0	Database update
6	XMARE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
7	LVORM	☐	LVOC1	XFELD	CHAR	1	0	Deletion Flag for All Data in a Batch
8	.INCLUDE	☐				0	0	Data Fields for MCHA, MCH1 and MCH2: Division 1
9	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
10	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
13	VERAB	☐	VERAB	DATUM	DATS	8	0	Availability date
14	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
15	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key	*
16	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
17	ZAEDT	☐	DZAEDT	DATUM	DATS	8	0	Date of last status change
18	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
19	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
20	VLCHA	☐	VLCHN	CHARG	CHAR	10	0	Original batch number (deactivated)	*
21	VLWRK	☐	VLWRK	WERKS	CHAR	4	0	Original plant (deactivated)	MARC
22	VLMAT	☐	VLMAT	MATNR	CHAR	18	0	Original material (deactivated)	MARA
23	.INCLUDE	☐				0	0	Data Fields for MCHA, MCH1 and MCH2: Division 2
24	CHAME	☐	CHAME	MEINS	UNIT	3	0	Unit of issue for batch (deactivated)	*
25	LWEDT	☐	LWEDT	DATUM	DATS	8	0	Date of last goods receipt
26	FVDT1	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
27	FVDT2	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
28	FVDT3	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
29	FVDT4	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
30	FVDT5	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
31	FVDT6	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
32	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
33	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
34	MTVER	☐	MTVER	MTVER	CHAR	4	0	Export/import material group	TVFM
35	QNDAT	☐	QNPDAT	DATUM	DATS	8	0	Next Inspection Date
36	HSDAT	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
37	CUOBJ_BM	☐	CUOBJ_BM	CUOBJ	NUMC	18	0	Internal object no.: Batch classification
38	DEACT_BM	☐	DEACT_BM	XFELD	CHAR	1	0	Batch is no longer active
39	BATCH_TYPE	☐	BATCH_TYPE	BATCH_TYPE	CHAR	1	0	Type of Batch

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMCH1	CHARG	MCH1	CHARG
2	SMCH1	HERKL	T005	LAND1
3	SMCH1	HERKR	T005S	BLAND
4	SMCH1	LIFNR	LFA1	LIFNR
5	SMCH1	MATNR	MARA	MATNR
6	SMCH1	MTVER	TVFM	MTVER
7	SMCH1	VLMAT	MARA	MATNR
8	SMCH1	VLWRK	MARC	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in