SMI_ITEM - SMI Item Data

SMI Item Data information is stored in SAP table SMI_ITEM.
It is part of development package VSMI in software component SD-BF-SMI. This development package consists of objects that can be grouped under "".

Fields for table SMI_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
XMLGUID	XML GUID	X	SMI_XMLGUID	CHAR	70	SMI_HEADER
MATNR	Material Number	X	MATNR	CHAR	80
VBELN	Sales Document	X	VBELN_VA	CHAR	20
POSNR	Sales Document Item	X	POSNR_VA	NUMC	12
KDMAT	Material Number Used by Customer		MATNR_KU	CHAR	70
BP_KUNNR	Customer Number		KUNNR	CHAR	20
BP_BUYID	Customer description of partner (plant, storage location)		KNREF	CHAR	60
SHIP_FROM_BUYID	Customer description of partner (plant, storage location)		KNREF	CHAR	60
WERKS	Plant (Own or External)		WERKS_EXT	CHAR	8
KNREF	Customer description of partner (plant, storage location)		KNREF	CHAR	60
WERKSTO	Plant (Own or External)		WERKS_EXT	CHAR	8
BSTKD	Customer Reference		BSTKD	CHAR	70
POSEX	Item Number of the Underlying Purchase Order		POSEX	CHAR	12
PROCTRIGGER	Processing Trigger (Automatically, Background, Manually)		SMI_PROCTRIG	CHAR	2
PROCTSTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
STATUS	Processing Status		SMI_STATUS	CHAR	2
STOPIND	Stop Indicator		SMI_STOPIND	CHAR	2
STATUSDT	DateTime		SMI_STATUSDT	DEC	8
UNRQUAN	Unrestricted-Use Quantity		SMI_UNRQUAN	QUAN	8
QUALQUAN	Quality Inspection Quantity		SMI_QUALQUAN	QUAN	8
BLOCQUAN	Blocked Quantity		SMI_BLOCQUAN	QUAN	8
PROMOQUAN	Promotion Quantity		SMI_PROMOQUAN	QUAN	8
STATUSDT_C	DateTime		SMI_STATUSDT	DEC	8
UNRQUAN_C	Unrestricted-Use Quantity Consignment		SMI_UNRQUAN_C	QUAN	8
QUALQUAN_C	Quality Inspection Quantity Consignment		SMI_QUALQUAN_C	QUAN	8
BLOCQUAN_C	Blocked Quantity Consignment		SMI_BLOCQUAN_C	QUAN	8
PROMOQUAN_C	Promotion Quantity Consignment		SMI_PROMOQUAN_C	QUAN	8
STOCKONHAND	Stock on Hand for Replenishment		SMI_STOCKONHAND	QUAN	8
MINSTOCK	Minimum Stock Level		SMI_MINSTOCK	QUAN	8
MINSTOCK_C	Minimum Stock Level Consignment		SMI_MINSTOCK_C	QUAN	8
MAXSTOCK	Maximum Stock Level		SMI_MAXSTOCK	QUAN	8
MAXSTOCK_C	Maximum Stock Level Consignment		SMI_MAXSTOCK_C	QUAN	8
ROUNDQUAN	Rounding Quantity		SMI_ROUNDQUAN	QUAN	8
ROUNDQUAN_C	Rounding Quantity Consignment		SMI_ROUNDQUAN_C	QUAN	8
PACKQUAN	Packing Quantity		SMI_PACKQUAN	QUAN	8
ABEFZ	Cumulative Quantity Received by Customer		ABKFZ	QUAN	8
VRKME	Sales unit		VRKME	UNIT	6
LABNK	Current key of delivery schedule		LABNK	CHAR	34
SCHEMAGNTID	Internal ID - Scheme Agency ID		SMI_SCAGNTID	CHAR	64
TIME_ZONE	Time Zone		TIMEZONE	CHAR	12
.INCLUDE				SMI_S_PROFILE	0
ID	Supplier-Managed Inventory Replenishment Profile		SMI_PROFILE_ID	CHAR	20
CUSTOMER_ID	Customer Number		KUNNR	CHAR	20
KDMAT_PROF	Material Number Used by Customer		MATNR_KU	CHAR	70
BSTKD_PROF	Customer Reference		BSTKD	CHAR	70
POSEX_PROF	Item Number of the Underlying Purchase Order		POSEX	CHAR	12
WERKS_EXT	Customer description of partner (plant, storage location)		KNREF	CHAR	60
HORIZON_USE	Horizon Usage Control Indicator		SMI_HORIZON_USE	NUMC	4
SMI_HORIZON	Planning Horizon in Days		SMI_HORIZON	NUMC	8
REPL_METH	SMI Replenishment Method		SMI_REPL_METH	CHAR	2
SAFETY_PERC	Safety Tolerance (%)		SMI_SAFETY_PERC	DEC	3
SAFETY_QTY	Safety Quantity		SMI_SAFETY_QTY	QUAN	7
SFTY_QTY_UOM	Safety Level Unit		SMI_SAFETY_UOM	UNIT	6
CUST_ROUND_VAL	Indicator for Usage of Customer Rounding Values		SMI_CUST_ROUNDING_VAL	CHAR	2
REPL_PROC_LOGIC	Processing Trigger Replenishment (Autom., Batch, Manually)		SMI_PROCTRIG_REPL	CHAR	2
SEND_PROC_LOGIC	Processing Trigger Send (Autom., Batch, Manually)		SMI_PROCTRIG_SEND	CHAR	2
STOP_FLAG	Stop Processing Indicator		SMI_STOP_FLAG	CHAR	2
SMI_HORIZON_S	Short-Term Period in Days		SMI_HORIZON_SHORT	NUMC	4
SMI_HORIZON_M	Mid-Term Period in Days		SMI_HORIZON_MID	NUMC	6
SMI_HORIZON_L	Long-Term Period in Days		SMI_HORIZON_HIGH	NUMC	8
HIGH_PERC_S	Upper Tolerance (%)		SMI_HIGH_PERC	DEC	3
LOW_PERC_S	Lower Tolerance (%)		SMI_LOW_PERC	DEC	3
HIGH_PERC_M	Upper Tolerance (%)		SMI_HIGH_PERC	DEC	3
LOW_PERC_M	Lower Tolerance (%)		SMI_LOW_PERC	DEC	3
HIGH_PERC_L	Upper Tolerance (%)		SMI_HIGH_PERC	DEC	3
LOW_PERC_L	Lower Tolerance (%)		SMI_LOW_PERC	DEC	3
ALERTCATEGORY	Alert Category		SALRTDCAT	CHAR	60
COMP_LOGIC	SMI Comparison Logic Type		SMI_COMP_LOGIC	CHAR	2
VKORG	Sales Organization		VKORG	CHAR	8
VTWEG	Distribution Channel		VTWEG	CHAR	4