SMI_ITEM SAP table for – SMI Item Data

Here we would like to draw your attention to SMI_ITEM table in SAP. As we know it is being mainly used with the SAP SD-BF (Basic Functions in SD) component which is coming under SD module (Sales & Distribution). SMI_ITEM is a SAP standard transparent table used for storing SMI Item Data related data in SAP. It comes under the package VSMI.

SAP SMI_ITEM table

Table SMI_ITEM technical data

TableSMI_ITEM
Data storingSMI Item Data
ModuleSD
ComponentSD-BF
SAP PackageVSMI
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP SMI_ITEM Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in SMI_ITEM table.

  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • WERKSTO
    Its data type is C (Character String) with field length 4
  • POSEX
    Its data type is C (Character String) with field length 6
  • PROCTRIGGER
    Its data type is C (Character String) with field length 1
  • STATUS : AC: Context Status
    Its data type is C (Character String) with field length 1
  • STATUSDT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • XMLGUID
    Its a key field. Its data type is C (Character String) with field length 35
  • BLOCQUAN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • STATUSDT_C
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • QUALQUAN_C
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PROMOQUAN_C
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MINSTOCK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MAXSTOCK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ROUNDQUAN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ROUNDQUAN_C
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ABEFZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • SCHEMAGNTID
    Its data type is C (Character String) with field length 32
  • TIME_ZONE : Address time zone
    Its data type is C (Character String) with field length 6
  • ID : Demo hierarchy: Node ID
    Its data type is C (Character String) with field length 10
  • CUSTOMER_ID
    Its data type is C (Character String) with field length 10
  • BSTKD_PROF
    Its data type is C (Character String) with field length 35
  • WERKS_EXT
    Its data type is C (Character String) with field length 30
  • SMI_HORIZON
    Its data type is N (Character String with Digits Only) with field length 4
  • SFTY_QTY_UOM
    Its data type is C (Character String) with field length 3
  • REPL_PROC_LOGIC
    Its data type is C (Character String) with field length 1
  • SEND_PROC_LOGIC
    Its data type is C (Character String) with field length 1
  • STOP_FLAG
    Its data type is C (Character String) with field length 1
  • KDMAT
    Its data type is C (Character String) with field length 35
  • SMI_HORIZON_L
    Its data type is N (Character String with Digits Only) with field length 4
  • LOW_PERC_S
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • LOW_PERC_M
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • LOW_PERC_L
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • COMP_LOGIC
    Its data type is C (Character String) with field length 1
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • BP_BUYID
    Its data type is C (Character String) with field length 30