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