SAP ABAP Table SMI_PROFILE (SMI Profile)

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_PROFILE	Table Relationship Diagram
Short Description	SMI Profile

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	SYMANDT	MANDT	CLNT	3	0	Client ID	*
2	ID	☑	SMI_PROFILE_ID	CHAR10	CHAR	10	0	Supplier-Managed Inventory Replenishment Profile
3	ACTIVE_FLAG	☐	SMI_PROFILE_ACTIVE	SIC_PROFILE_ACTIVE	CHAR	1	0	Profile is Active
4	NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
5	CUSTOMER_ID	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	SMI_AGREEMENTS
6	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number	SMI_AGREEMENTS
7	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
8	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
9	WERKS_EXT	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)	SMI_AGREEMENTS
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
12	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
13	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
14	STOP_HORIZON	☐	SMI_STOP_HORIZON		NUMC	4	0	Stop Horizon in Days
15	REPL_METH	☐	SMI_REPL_METH	SMI_REPL_METH	CHAR	1	0	SMI Replenishment Method
16	SAFETY_PERC	☐	SMI_SAFETY_PERC	DEC3_1	DEC	4	1	Safety Tolerance (%)
17	SAFETY_QTY	☐	SMI_SAFETY_QTY	SMI_SAFETY_QTY	QUAN	13	6	Safety Quantity
18	SFTY_QTY_UOM	☐	SMI_SAFETY_UOM	MEINS	UNIT	3	0	Safety Level Unit	*
19	CUST_ROUND_VAL	☐	SMI_CUST_ROUNDING_VAL	SMI_BOOLEAN	CHAR	1	0	Indicator for Usage of Customer Rounding Values
20	REPL_PROC_LOGIC	☐	SMI_PROCTRIG_REPL	SMI_PROCTRIG	CHAR	1	0	Processing Trigger Replenishment (Autom., Batch, Manually)
21	SEND_PROC_LOGIC	☐	SMI_PROCTRIG_SEND	SMI_PROCTRIG	CHAR	1	0	Processing Trigger Send (Autom., Batch, Manually)
22	STOP_FLAG	☐	SMI_STOP_FLAG	SMI_BOOLEAN	CHAR	1	0	Stop Processing Indicator
23	COMP_LOGIC	☐	SMI_COMP_LOGIC	SMI_COMP_LOGIC	CHAR	1	0	SMI Comparison Logic Type
24	SMI_HORIZON_S	☐	SMI_HORIZON_SHORT		NUMC	2	0	Short-Term Period in Days
25	SMI_HORIZON_M	☐	SMI_HORIZON_MID		NUMC	3	0	Mid-Term Period in Days
26	SMI_HORIZON_L	☐	SMI_HORIZON_HIGH		NUMC	4	0	Long-Term Period in Days
27	HIGH_PERC_S	☐	SMI_HIGH_PERC	DEC3_1	DEC	4	1	Upper Tolerance (%)
28	LOW_PERC_S	☐	SMI_LOW_PERC	DEC3_1	DEC	4	1	Lower Tolerance (%)
29	HIGH_PERC_M	☐	SMI_HIGH_PERC	DEC3_1	DEC	4	1	Upper Tolerance (%)
30	LOW_PERC_M	☐	SMI_LOW_PERC	DEC3_1	DEC	4	1	Lower Tolerance (%)
31	HIGH_PERC_L	☐	SMI_HIGH_PERC	DEC3_1	DEC	4	1	Upper Tolerance (%)
32	LOW_PERC_L	☐	SMI_LOW_PERC	DEC3_1	DEC	4	1	Lower Tolerance (%)
33	ALERTCATEGORY	☐	SALRTDCAT	SALRTDCAT	CHAR	30	0	Alert Category	SALRTCAT
34	CREATOR	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
35	CHANGER	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
36	CREATED	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
37	CHANGED	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMI_PROFILE	ALERTCATEGORY	SALRTCAT	CATEGORY
2	SMI_PROFILE	CUSTOMER_ID	SMI_AGREEMENTS	CUSTOMER_ID
3	SMI_PROFILE	KDMAT	SMI_AGREEMENTS	KDMAT
4	SMI_PROFILE	MATNR	MARA	MATNR
5	SMI_PROFILE	WERKS_EXT	SMI_AGREEMENTS	WERKS_EXT

History

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