SAP ABAP Table SMI_ITEM (SMI Item Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-BF-SMI (Application Component) Supplier Managed Inventory
     ⤷ VSMI (Package) Supplier-Managed Inventory (SNC-ERP)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMI_ITEM	Table Relationship Diagram
Short Description	SMI Item Data

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	*
2	XMLGUID	☑	SMI_XMLGUID	CHAR35	CHAR	35	0	XML GUID	SMI_HEADER
3	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
4	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
5	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
6	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
7	BP_KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
8	BP_BUYID	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
9	SHIP_FROM_BUYID	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
10	WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
11	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
12	WERKSTO	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
13	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
14	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
15	PROCTRIGGER	☐	SMI_PROCTRIG	SMI_PROCTRIG	CHAR	1	0	Processing Trigger (Automatically, Background, Manually)
16	PROCTSTMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
17	STATUS	☐	SMI_STATUS	SMI_STATUS	CHAR	1	0	Processing Status
18	STOPIND	☐	SMI_STOPIND	XFLAG	CHAR	1	0	Stop Indicator
19	STATUSDT	☐	SMI_STATUSDT	TZNTSTMPS	DEC	15	0	DateTime
20	UNRQUAN	☐	SMI_UNRQUAN	MENG15	QUAN	15	3	Unrestricted-Use Quantity
21	QUALQUAN	☐	SMI_QUALQUAN	MENG15	QUAN	15	3	Quality Inspection Quantity
22	BLOCQUAN	☐	SMI_BLOCQUAN	MENG15	QUAN	15	3	Blocked Quantity
23	PROMOQUAN	☐	SMI_PROMOQUAN	MENG15	QUAN	15	3	Promotion Quantity
24	STATUSDT_C	☐	SMI_STATUSDT	TZNTSTMPS	DEC	15	0	DateTime
25	UNRQUAN_C	☐	SMI_UNRQUAN_C	MENG15	QUAN	15	3	Unrestricted-Use Quantity Consignment
26	QUALQUAN_C	☐	SMI_QUALQUAN_C	MENG15	QUAN	15	3	Quality Inspection Quantity Consignment
27	BLOCQUAN_C	☐	SMI_BLOCQUAN_C	MENG15	QUAN	15	3	Blocked Quantity Consignment
28	PROMOQUAN_C	☐	SMI_PROMOQUAN_C	MENG15	QUAN	15	3	Promotion Quantity Consignment
29	STOCKONHAND	☐	SMI_STOCKONHAND	MENG15	QUAN	15	3	Stock on Hand for Replenishment
30	MINSTOCK	☐	SMI_MINSTOCK	MENG15	QUAN	15	3	Minimum Stock Level
31	MINSTOCK_C	☐	SMI_MINSTOCK_C	MENG15	QUAN	15	3	Minimum Stock Level Consignment
32	MAXSTOCK	☐	SMI_MAXSTOCK	MENG15	QUAN	15	3	Maximum Stock Level
33	MAXSTOCK_C	☐	SMI_MAXSTOCK_C	MENG15	QUAN	15	3	Maximum Stock Level Consignment
34	ROUNDQUAN	☐	SMI_ROUNDQUAN	MENG15	QUAN	15	3	Rounding Quantity
35	ROUNDQUAN_C	☐	SMI_ROUNDQUAN_C	MENG15	QUAN	15	3	Rounding Quantity Consignment
36	PACKQUAN	☐	SMI_PACKQUAN	MENG15	QUAN	15	3	Packing Quantity
37	ABEFZ	☐	ABKFZ	MENGV15	QUAN	15	3	Cumulative Quantity Received by Customer
38	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
39	LABNK	☐	LABNK	TEXT17	CHAR	17	0	Customer number for forecast / JIT dlv. sched.
40	SCHEMAGNTID	☐	SMI_SCAGNTID	CHAR32	CHAR	32	0	Internal ID - Scheme Agency ID
41	TIME_ZONE	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
42	.INCLUDE	☐				0	0	SMI Replenishment Profile Data
43	ID	☐	SMI_PROFILE_ID	CHAR10	CHAR	10	0	Supplier-Managed Inventory Replenishment Profile
44	CUSTOMER_ID	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
45	KDMAT_PROF	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
46	BSTKD_PROF	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
47	POSEX_PROF	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
48	WERKS_EXT	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
49	HORIZON_USE	☐	SMI_HORIZON_USE	SMI_HORIZON_USE	NUMC	2	0	Horizon Usage Control Indicator
50	SMI_HORIZON	☐	SMI_HORIZON		NUMC	4	0	Planning Horizon in Days
51	REPL_METH	☐	SMI_REPL_METH	SMI_REPL_METH	CHAR	1	0	SMI Replenishment Method
52	SAFETY_PERC	☐	SMI_SAFETY_PERC	DEC3_1	DEC	4	1	Safety Tolerance (%)
53	SAFETY_QTY	☐	SMI_SAFETY_QTY	SMI_SAFETY_QTY	QUAN	13	6	Safety Quantity
54	SFTY_QTY_UOM	☐	SMI_SAFETY_UOM	MEINS	UNIT	3	0	Safety Level Unit	*
55	CUST_ROUND_VAL	☐	SMI_CUST_ROUNDING_VAL	SMI_BOOLEAN	CHAR	1	0	Indicator for Usage of Customer Rounding Values
56	REPL_PROC_LOGIC	☐	SMI_PROCTRIG_REPL	SMI_PROCTRIG	CHAR	1	0	Processing Trigger Replenishment (Autom., Batch, Manually)
57	SEND_PROC_LOGIC	☐	SMI_PROCTRIG_SEND	SMI_PROCTRIG	CHAR	1	0	Processing Trigger Send (Autom., Batch, Manually)
58	STOP_FLAG	☐	SMI_STOP_FLAG	SMI_BOOLEAN	CHAR	1	0	Stop Processing Indicator
59	SMI_HORIZON_S	☐	SMI_HORIZON_SHORT		NUMC	2	0	Short-Term Period in Days
60	SMI_HORIZON_M	☐	SMI_HORIZON_MID		NUMC	3	0	Mid-Term Period in Days
61	SMI_HORIZON_L	☐	SMI_HORIZON_HIGH		NUMC	4	0	Long-Term Period in Days
62	HIGH_PERC_S	☐	SMI_HIGH_PERC	DEC3_1	DEC	4	1	Upper Tolerance (%)
63	LOW_PERC_S	☐	SMI_LOW_PERC	DEC3_1	DEC	4	1	Lower Tolerance (%)
64	HIGH_PERC_M	☐	SMI_HIGH_PERC	DEC3_1	DEC	4	1	Upper Tolerance (%)
65	LOW_PERC_M	☐	SMI_LOW_PERC	DEC3_1	DEC	4	1	Lower Tolerance (%)
66	HIGH_PERC_L	☐	SMI_HIGH_PERC	DEC3_1	DEC	4	1	Upper Tolerance (%)
67	LOW_PERC_L	☐	SMI_LOW_PERC	DEC3_1	DEC	4	1	Lower Tolerance (%)
68	ALERTCATEGORY	☐	SALRTDCAT	SALRTDCAT	CHAR	30	0	Alert Category	*
69	COMP_LOGIC	☐	SMI_COMP_LOGIC	SMI_COMP_LOGIC	CHAR	1	0	SMI Comparison Logic Type
70	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
71	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMI_ITEM	XMLGUID	SMI_HEADER	XMLGUID	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	604