SAP ABAP Table SMI_S_ITEM_OUT (SMI Processing: Item Output Structure for POWL Tool)
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_OUT | Table Relationship Diagram |
Short Description | SMI Processing: Item Output Structure for POWL Tool |
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 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
74 | POSTX | KDPTX | TEXT40 | CHAR | 40 | 0 | Customer description of material | ||
75 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
76 | KNREF_AG | KNREF | KNREF | CHAR | 30 | 0 | Customer description of partner (plant, storage location) | ||
77 | KNREF_WE | KNREF | KNREF | CHAR | 30 | 0 | Customer description of partner (plant, storage location) | ||
78 | CREAT_DATE | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
79 | CREAT_TIME | ERZEIT | UHRZT | TIMS | 6 | 0 | Time, at Which Record Was Added | ||
80 | REC_DATE | SIN_DAT_IN | SIN_DATUM | DATS | 8 | 0 | Date received | ||
81 | REC_TIME | SIN_TIM_IN | SIN_UZEIT | TIMS | 6 | 0 | Time received | ||
82 | UNIT_TEXT | MSEHL | TEXT30 | CHAR | 30 | 0 | Unit of Measurement Text (Maximum 30 Characters) | ||
83 | IC_STATUS | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
84 | IC_STOP | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
85 | KUNNR | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
86 | BUYER_BUYID | KNREF | KNREF | CHAR | 30 | 0 | Customer description of partner (plant, storage location) | ||
87 | VENDOR_BUYID | KNREF | KNREF | CHAR | 30 | 0 | Customer description of partner (plant, storage location) | ||
88 | KUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
89 | PRODREC_BUYID | KNREF | KNREF | CHAR | 30 | 0 | Customer description of partner (plant, storage location) | ||
90 | TOOLTIP_REF_STAT | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
91 | TOOLTIP_REF_STOP | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
92 | .INCLUDE | 0 | 0 | Inventory Status of periods | |||||
93 | P01 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
94 | P01_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
95 | P01_TOOLTIP | STRG | 0 | 0 | |||||
96 | P01_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
97 | P02 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
98 | P02_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
99 | P02_TOOLTIP | STRG | 0 | 0 | |||||
100 | P02_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
101 | P03 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
102 | P03_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
103 | P03_TOOLTIP | STRG | 0 | 0 | |||||
104 | P03_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
105 | P04 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
106 | P04_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
107 | P04_TOOLTIP | STRG | 0 | 0 | |||||
108 | P04_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
109 | P05 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
110 | P05_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
111 | P05_TOOLTIP | STRG | 0 | 0 | |||||
112 | P05_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
113 | P06 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
114 | P06_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
115 | P06_TOOLTIP | STRG | 0 | 0 | |||||
116 | P06_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
117 | P07 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
118 | P07_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
119 | P07_TOOLTIP | STRG | 0 | 0 | |||||
120 | P07_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
121 | P08 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
122 | P08_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
123 | P08_TOOLTIP | STRG | 0 | 0 | |||||
124 | P08_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
125 | P09 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
126 | P09_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
127 | P09_TOOLTIP | STRG | 0 | 0 | |||||
128 | P09_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
129 | P10 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
130 | P10_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
131 | P10_TOOLTIP | STRG | 0 | 0 | |||||
132 | P10_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
133 | P11 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
134 | P11_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
135 | P11_TOOLTIP | STRG | 0 | 0 | |||||
136 | P11_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
137 | P12 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
138 | P12_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
139 | P12_TOOLTIP | STRG | 0 | 0 | |||||
140 | P12_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
141 | P13 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
142 | P13_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
143 | P13_TOOLTIP | STRG | 0 | 0 | |||||
144 | P13_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
145 | P14 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
146 | P14_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
147 | P14_TOOLTIP | STRG | 0 | 0 | |||||
148 | P14_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
149 | P15 | SMI_PERIOD | CHAR | 2 | 0 | Period String | |||
150 | P15_COLOUR | NUMC2 | NUMC2 | NUMC | 2 | 0 | Two digit number | ||
151 | P15_TOOLTIP | STRG | 0 | 0 | |||||
152 | P15_ICON | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
153 | STOCKOUT | SMI_STOCKOUT | DATS | 8 | 0 | Date of First Out-of-Stock Situation | |||
154 | DATEMIN | SMI_DATEMIN | DATS | 8 | 0 | Date of First Violation of Minimum Stock Level | |||
155 | DATEMAX | SMI_DATEMAX | DATS | 8 | 0 | Date of First Violation of Maximum Stock Level |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SMI_S_ITEM_OUT | XMLGUID | SMI_HEADER | XMLGUID | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 604 |