SAP ABAP Table S200 (Inventory Controlling Stores)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S200	Table Relationship Diagram
Short Description	Inventory Controlling Stores

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	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	INVNU	☑	INVNU1	XBLNR1	CHAR	16	0	Physical inventory number
9	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	*
11	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
12	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
13	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
14	SOBKZ	☑	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
15	BSTAR	☑	BSTAR	BSTAR	CHAR	1	0	Stock type	T064A
16	IVSTAT	☑	IVSTATUS	IVSTATUS	NUMC	2	0	Statistical status of physical inventory
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
20	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
21	IBUMNG	☐	MCW_IBUMNG	MENGV15_3	QUAN	15	3	Book inventory balance, quantity in base unit of measure
22	IBUGEO	☐	MCW_IBUGEO	WERTV9	CURR	17	2	Book inventory balance at cost
23	IBUGVO	☐	MCW_IBUGVO	WERTV9	CURR	17	2	Book inventory balance at retail
24	IBUGVP	☐	MCW_IBUGVP	WERTV9	CURR	17	2	Book inventory balance at retail with tax
25	IZLMNG	☐	MCW_IZLMNG	MENGV15_3	QUAN	15	3	Quantity of stock, counted in base unit of measure
26	IZLGEO	☐	MCW_IZLGEO	WERTV9	CURR	17	2	Quantity of stock counted at cost
27	IZLGVO	☐	MCW_IZLGVO	WERTV9	CURR	17	2	Quantity of stock counted at retail
28	IZLGVP	☐	MCW_IZLGVP	WERTV9	CURR	17	2	Quantity of stock counted at retail with tax
29	IDMMNG	☐	MCW_IDMMNG	MENGV15_3	QUAN	15	3	Minus inventory difference quantity in BUn
30	IDMGEO	☐	MCW_IDMGEO	WERTV9	CURR	17	2	Minus inventory difference at cost
31	IDMGVO	☐	MCW_IDMGVO	WERTV9	CURR	17	2	Minus inventory difference at retail
32	IDMGVP	☐	MCW_IDMGVP	WERTV9	CURR	17	2	Minus inventory difference at retail
33	IDPMNG	☐	MCW_IDPMNG	MENGV15_3	QUAN	15	3	Plus inventory difference quantity in BUn
34	IDPGEO	☐	MCW_IDPGEO	WERTV9	CURR	17	2	Plus inventory difference at cost
35	IDPGVO	☐	MCW_IDPGVO	WERTV9	CURR	17	2	Plus inventory difference at retail
36	IDPGVP	☐	MCW_IDPGVP	WERTV9	CURR	17	2	Plus inventory difference at retail with tax
37	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
38	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
39	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
40	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
41	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
42	KWART	☐	XWART	XFELD	CHAR	1	0	Indicates that the value-only material is to be inventoried

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S200	ABTNR	TSAB	ABTNR
2	S200	BASME	T006	MSEHI
3	S200	BSTAR	T064A	BSTAR
4	S200	CHARG	MCH1	CHARG	KEY
5	S200	HWAER	TCURC	WAERS
6	S200	MANDT	T000	MANDT
7	S200	MATKL	T023	MATKL
8	S200	MATNR	MARA	MATNR	KEY	C	CN
9	S200	SATNR	MARA	MATNR
10	S200	SOBKZ	T148	SOBKZ	KEY	C	CN
11	S200	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in