SAP ABAP Table MCSD (Customer Stock)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-AD-SSP (Application Component) Spare Part Sharing and Stock Providede by Customer
     ⤷ DIPCS (Package) DI-A&D Enhancements for Pooled & Customer Stock

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MCSD	Table Relationship Diagram
Short Description	Customer Stock

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	MARD
5	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
6	SOBKZ	☑	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
7	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
8	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
9	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
10	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
11	SDSPR	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
12	SDLAB	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
13	SDINS	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
14	SDSPE	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock
15	SDEIN	☐	EINME	MENG13V	QUAN	13	3	Total Stock of All Restricted Batches
16	SDVLA	☐	VMLAB	MENG13V	QUAN	13	3	Valuated unrestricted-use stock in previous period
17	SDVIN	☐	VMINS	MENG13V	QUAN	13	3	Stock in quality inspection from previous period
18	SDVSP	☐	VMSPE	MENG13V	QUAN	13	3	Blocked stock of previous period
19	SDVEI	☐	VMEIN	MENG13V	QUAN	13	3	Restricted-use stock in previous period
20	SDILL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
21	SDILQ	☐	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
22	SDILS	☐	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
23	SDVLL	☐	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
24	SDVLQ	☐	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
25	SDVLS	☐	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
26	SDFLL	☐	KZFLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in following year
27	SDFLQ	☐	KZFLQ	INVKZ	CHAR	3	0	Physical inventory indicator, quality insp.stck, follow.yr.
28	SDFLS	☐	KZFLS	INVKZ	CHAR	3	0	Phys. inventory ind. for blocked stock in following period
29	SDDLL	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
30	SDJIN	☐	GJINV	GJAHR	NUMC	4	0	Fiscal year of current physical inventory indicator
31	SDRUE	☐	SBRUE	XFELD	CHAR	1	0	MxxxH rec. already exists for per. before last of Mxxx per.

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCSD	CHARG	MCHA	CHARG	KEY	1	CN
2	MCSD	KUNNR	KNA1	KUNNR
3	MCSD	LGORT	MARD	LGORT	KEY	1	CN
4	MCSD	MANDT	T000	MANDT	KEY	1	CN
5	MCSD	MATNR	MARA	MATNR	KEY	1	CN
6	MCSD	SOBKZ	T148	SOBKZ	KEY	1	CN
7	MCSD	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C2