SMI_ITEM is a SAP table coming under SD module and EA-APPL component.View details, Fields & related tables of SMI_ITEM in SAP.
- Table description : SMI Item Data
- Module : SD-BF-SMI
- Parent Module : SD
- Package : VSMI
- Software Component : EA-APPL
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP SMI_ITEM Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| XMLGUID | XML GUID | SMI_XMLGUID | CHAR35 |
| MATNR | Material Number | MATNR | MATNR |
| VBELN | Sales Document | VBELN_VA | VBELN |
| POSNR | Sales Document Item | POSNR_VA | POSNR |
| KDMAT | Customer Material Number | MATNR_KU | IDNEX |
| BP_KUNNR | Customer Number | KUNNR | KUNNR |
| BP_BUYID | Customer description of partner (plant, storage location) | KNREF | KNREF |
| SHIP_FROM_BUYID | Customer description of partner (plant, storage location) | KNREF | KNREF |
| WERKS | Plant (Own or External) | WERKS_EXT | WERKS |
| KNREF | Customer description of partner (plant, storage location) | KNREF | KNREF |
| WERKSTO | Plant (Own or External) | WERKS_EXT | WERKS |
| BSTKD | Customer purchase order number | BSTKD | BSTKD |
| POSEX | Item Number of the Underlying Purchase Order | POSEX | POSEX |
| PROCTRIGGER | Processing Trigger (Automatically, Background, Manually) | SMI_PROCTRIG | SMI_PROCTRIG |
| PROCTSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | TZNTSTMPS |
| STATUS | Processing Status | SMI_STATUS | SMI_STATUS |
| STOPIND | Stop Indicator | SMI_STOPIND | XFLAG |
| STATUSDT | DateTime | SMI_STATUSDT | TZNTSTMPS |
| UNRQUAN | Unrestricted-Use Quantity | SMI_UNRQUAN | MENG15 |
| QUALQUAN | Quality Inspection Quantity | SMI_QUALQUAN | MENG15 |
| BLOCQUAN | Blocked Quantity | SMI_BLOCQUAN | MENG15 |
| PROMOQUAN | Promotion Quantity | SMI_PROMOQUAN | MENG15 |
| STATUSDT_C | DateTime | SMI_STATUSDT | TZNTSTMPS |
| UNRQUAN_C | Unrestricted-Use Quantity Consignment | SMI_UNRQUAN_C | MENG15 |
| QUALQUAN_C | Quality Inspection Quantity Consignment | SMI_QUALQUAN_C | MENG15 |
| BLOCQUAN_C | Blocked Quantity Consignment | SMI_BLOCQUAN_C | MENG15 |
| PROMOQUAN_C | Promotion Quantity Consignment | SMI_PROMOQUAN_C | MENG15 |
| STOCKONHAND | Stock on Hand for Replenishment | SMI_STOCKONHAND | MENG15 |
| MINSTOCK | Minimum Stock Level | SMI_MINSTOCK | MENG15 |
| MINSTOCK_C | Minimum Stock Level Consignment | SMI_MINSTOCK_C | MENG15 |
| MAXSTOCK | Maximum Stock Level | SMI_MAXSTOCK | MENG15 |
| MAXSTOCK_C | Maximum Stock Level Consignment | SMI_MAXSTOCK_C | MENG15 |
| ROUNDQUAN | Rounding Quantity | SMI_ROUNDQUAN | MENG15 |
| ROUNDQUAN_C | Rounding Quantity Consignment | SMI_ROUNDQUAN_C | MENG15 |
| PACKQUAN | Packing Quantity | SMI_PACKQUAN | MENG15 |
| ABEFZ | Cumulative Quantity Received by Customer | ABKFZ | MENGV15 |
| VRKME | Sales unit | VRKME | MEINS |
| LABNK | Customer number for forecast / JIT dlv. sched. | LABNK | TEXT17 |
| SCHEMAGNTID | Internal ID - Scheme Agency ID | SMI_SCAGNTID | CHAR32 |
| TIME_ZONE | Time Zone | TIMEZONE | TZNZONE |
| .INCLUDE | SMI Replenishment Profile Data | ||
| ID | Supplier-Managed Inventory Replenishment Profile | SMI_PROFILE_ID | CHAR10 |
| CUSTOMER_ID | Customer Number | KUNNR | KUNNR |
| KDMAT_PROF | Customer Material Number | MATNR_KU | IDNEX |
| BSTKD_PROF | Customer purchase order number | BSTKD | BSTKD |
| POSEX_PROF | Item Number of the Underlying Purchase Order | POSEX | POSEX |
| WERKS_EXT | Customer description of partner (plant, storage location) | KNREF | KNREF |
| HORIZON_USE | Horizon Usage Control Indicator | SMI_HORIZON_USE | SMI_HORIZON_USE |
| SMI_HORIZON | Planning Horizon in Days | SMI_HORIZON | |
| REPL_METH | SMI Replenishment Method | SMI_REPL_METH | SMI_REPL_METH |
| SAFETY_PERC | Safety Tolerance (%) | SMI_SAFETY_PERC | DEC3_1 |
| SAFETY_QTY | Safety Quantity | SMI_SAFETY_QTY | SMI_SAFETY_QTY |
| SFTY_QTY_UOM | Safety Level Unit | SMI_SAFETY_UOM | MEINS |
| CUST_ROUND_VAL | Indicator for Usage of Customer Rounding Values | SMI_CUST_ROUNDING_VAL | SMI_BOOLEAN |
| REPL_PROC_LOGIC | Processing Trigger Replenishment (Autom., Batch, Manually) | SMI_PROCTRIG_REPL | SMI_PROCTRIG |
| SEND_PROC_LOGIC | Processing Trigger Send (Autom., Batch, Manually) | SMI_PROCTRIG_SEND | SMI_PROCTRIG |
| STOP_FLAG | Stop Processing Indicator | SMI_STOP_FLAG | SMI_BOOLEAN |
| SMI_HORIZON_S | Short-Term Period in Days | SMI_HORIZON_SHORT | |
| SMI_HORIZON_M | Mid-Term Period in Days | SMI_HORIZON_MID | |
| SMI_HORIZON_L | Long-Term Period in Days | SMI_HORIZON_HIGH | |
| HIGH_PERC_S | Upper Tolerance (%) | SMI_HIGH_PERC | DEC3_1 |
| LOW_PERC_S | Lower Tolerance (%) | SMI_LOW_PERC | DEC3_1 |
| HIGH_PERC_M | Upper Tolerance (%) | SMI_HIGH_PERC | DEC3_1 |
| LOW_PERC_M | Lower Tolerance (%) | SMI_LOW_PERC | DEC3_1 |
| HIGH_PERC_L | Upper Tolerance (%) | SMI_HIGH_PERC | DEC3_1 |
| LOW_PERC_L | Lower Tolerance (%) | SMI_LOW_PERC | DEC3_1 |
| ALERTCATEGORY | Alert Category | SALRTDCAT | SALRTDCAT |
| COMP_LOGIC | SMI Comparison Logic Type | SMI_COMP_LOGIC | SMI_COMP_LOGIC |
| VKORG | Sales Organization | VKORG | VKORG |
| VTWEG | Distribution Channel | VTWEG | VTWEG |
SMI_ITEM related tables
| Table | Note |
|---|---|
| SMI_ITEM | SMI Item Data |
| SMI_HEADER | SMI Header Data |
| SMI_AGREEMENTS | SMI Scheduling Agreements |
| SMI_BORDER_HIST | SMI Limit History |
| SMI_MESSAGES | SMI Customizable Messages |
| SMI_PROFILE | SMI Profile |
| SMI_TIMESERIES | SMI Time Series |
| /TMWFLOW/SMIVARC | Assignment of Task List Variant to SMI Project |
| /TMWFLOW/SMIVART | Texts for Assignment of Task List Variant to SMI Project |
| /TMWFLOW/STDTLVC | Default Variant of Task Lists for SMI Project Types |
| CDBD_SRV_I | CDB table for Item Extension - Transaction Item - Service |
| CMP_POSTYP | Item Category Customizing Complaints Proc. Credit Memo Item |
| CRMC_FICA_AR_ITM | Item Categories (Adjustment Request Item - FI-CA Document) |
| CRMC_FS_MGP_MG | Item Grouping Assignment to Item Grouping Profile |
| CRMC_IT_COPY_IF | Copy Item Categories - Item Category Determination |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP