SAP ABAP Table MSCS (Customer stock with vendor - Total)

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	MSCS	Table Relationship Diagram
Short Description	Customer stock with vendor - Total

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	T001W
4	SOBKZ	☑	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
5	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
6	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
7	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
8	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
9	CSLAB	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
10	CSINS	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
11	CSEIN	☐	EINME	MENG13V	QUAN	13	3	Total Stock of All Restricted Batches
12	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
13	XOBEW	☐	XOBEW	XFELD	CHAR	1	0	Vendor Stock Valuation Indicator
14	CSRUE	☐	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	MSCS	KUNNR	KNA1	KUNNR
2	MSCS	LIFNR	LFA1	LIFNR	KEY	1	CN
3	MSCS	MANDT	T000	MANDT	KEY	1	CN
4	MSCS	MATNR	MARA	MATNR	KEY	1	CN
5	MSCS	SOBKZ	T148	SOBKZ	KEY	1	CN
6	MSCS	WERKS	T001W	WERKS	KEY	1	CN

History

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