SAP ABAP Table SMCHA (Lock Table MCHA)

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	SMCHA	Table Relationship Diagram
Short Description	Lock Table MCHA

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

History

Last changed by/on	SAP	20110901
SAP Release Created in