SMI_PROFILE SAP table for – SMI Profile

Here we would like to draw your attention to SMI_PROFILE 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_PROFILE is a SAP standard transparent table used for storing SMI Profile related data in SAP. It comes under the package VSMI.

SAP SMI_PROFILE table

Table SMI_PROFILE technical data

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

SAP SMI_PROFILE 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_PROFILE table.

  • VBELN : Sales and Distribution Document Number
    Its data type is C (Character String) with field length 10
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • REPL_METH
    Its data type is C (Character String) with field length 1
  • SAFETY_PERC
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • SAFETY_QTY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CUST_ROUND_VAL
    Its data type is C (Character String) with field length 1
  • ID : Demo hierarchy: Node ID
    Its a key field. Its data type is C (Character String) with field length 10
  • STOP_FLAG
    Its data type is C (Character String) with field length 1
  • SMI_HORIZON_M
    Its data type is N (Character String with Digits Only) with field length 3
  • HIGH_PERC_S
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • HIGH_PERC_M
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • HIGH_PERC_L
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • ALERTCATEGORY
    Its data type is C (Character String) with field length 30
  • CHANGER
    Its data type is C (Character String) with field length 12
  • CREATED
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CHANGED
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NAME : ABAP Program Name
    Its data type is C (Character String) with field length 50
  • KDMAT
    Its data type is C (Character String) with field length 35
  • WERKS_EXT
    Its data type is C (Character String) with field length 30