SMI_ITEM SAP (SMI Item Data) Table details

Dictionary Type: Table
Description: SMI Item Data




ABAP Code to SELECT data from SMI_ITEM
Related tables to SMI_ITEM
Access table SMI_ITEM




Table field list including key, data, relationships and ABAP select examples

SMI_ITEM is a standard SAP Table which is used to store SMI Item Data data and is available within R/3 SAP systems depending on the version and release level.

The SMI_ITEM table consists of various fields, each holding specific information or linking keys about SMI Item Data data available in SAP. These include XMLGUID (XML GUID), MATNR (Material Number), VBELN (Sales Document), POSNR (Sales Document Item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SMI_ITEM table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
XMLGUIDXML GUID SMI_XMLGUIDCHAR35SMI_HEADERCHAR35
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
VBELNSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
POSNRSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
KDMATMaterial Number Used by Customer MATNR_KUCHAR35IDNEX
BP_KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
BP_BUYIDCustomer description of partner (plant, storage location) KNREFCHAR30KNREFKNREF
SHIP_FROM_BUYIDCustomer description of partner (plant, storage location) KNREFCHAR30KNREFKNREF
WERKSPlant (Own or External) WERKS_EXTCHAR4Assigned to domainWERKSWRKSH_T001W_EXTS
KNREFCustomer description of partner (plant, storage location) KNREFCHAR30KNREFKNREF
WERKSTOPlant (Own or External) WERKS_EXTCHAR4Assigned to domainWERKSWRKSH_T001W_EXTS
BSTKDCustomer purchase order number BSTKDCHAR35BSTKD
POSEXItem Number of the Underlying Purchase Order POSEXCHAR6ALPHAPOSEX
PROCTRIGGERProcessing Trigger (Automatically, Background, Manually) SMI_PROCTRIGCHAR1SMI_PROCTRIG
PROCTSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
STATUSProcessing Status SMI_STATUSCHAR1SMI_STATUS
STOPINDStop Indicator SMI_STOPINDCHAR1XFLAG
STATUSDTDateTime SMI_STATUSDTDEC15TZNTSTMPS
UNRQUANUnrestricted-Use Quantity SMI_UNRQUANQUAN15(3) MENG15
QUALQUANQuality Inspection Quantity SMI_QUALQUANQUAN15(3) MENG15
BLOCQUANBlocked Quantity SMI_BLOCQUANQUAN15(3) MENG15
PROMOQUANPromotion Quantity SMI_PROMOQUANQUAN15(3) MENG15
STATUSDT_CDateTime SMI_STATUSDTDEC15TZNTSTMPS
UNRQUAN_CUnrestricted-Use Quantity Consignment SMI_UNRQUAN_CQUAN15(3) MENG15
QUALQUAN_CQuality Inspection Quantity Consignment SMI_QUALQUAN_CQUAN15(3) MENG15
BLOCQUAN_CBlocked Quantity Consignment SMI_BLOCQUAN_CQUAN15(3) MENG15
PROMOQUAN_CPromotion Quantity Consignment SMI_PROMOQUAN_CQUAN15(3) MENG15
STOCKONHANDStock on Hand for Replenishment SMI_STOCKONHANDQUAN15(3) MENG15
MINSTOCKMinimum Stock Level SMI_MINSTOCKQUAN15(3) MENG15
MINSTOCK_CMinimum Stock Level Consignment SMI_MINSTOCK_CQUAN15(3) MENG15
MAXSTOCKMaximum Stock Level SMI_MAXSTOCKQUAN15(3) MENG15
MAXSTOCK_CMaximum Stock Level Consignment SMI_MAXSTOCK_CQUAN15(3) MENG15
ROUNDQUANRounding Quantity SMI_ROUNDQUANQUAN15(3) MENG15
ROUNDQUAN_CRounding Quantity Consignment SMI_ROUNDQUAN_CQUAN15(3) MENG15
PACKQUANPacking Quantity SMI_PACKQUANQUAN15(3) MENG15
ABEFZCumulative Quantity Received by Customer ABKFZQUAN15(3) MENGV15
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
LABNKCustomer number for forecast / JIT dlv. sched. LABNKCHAR17TEXT17
SCHEMAGNTIDInternal ID - Scheme Agency ID SMI_SCAGNTIDCHAR32CHAR32
TIME_ZONETime Zone TIMEZONECHAR6Assigned to domainTZNZONE
IDSupplier-Managed Inventory Replenishment Profile SMI_PROFILE_IDCHAR10CHAR10
CUSTOMER_IDCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
KDMAT_PROFMaterial Number Used by Customer MATNR_KUCHAR35IDNEX
BSTKD_PROFCustomer purchase order number BSTKDCHAR35BSTKD
POSEX_PROFItem Number of the Underlying Purchase Order POSEXCHAR6ALPHAPOSEX
WERKS_EXTCustomer description of partner (plant, storage location) KNREFCHAR30KNREFKNREF
HORIZON_USEHorizon Usage Control Indicator SMI_HORIZON_USENUMC2SMI_HORIZON_USE
SMI_HORIZONPlanning Horizon in Days SMI_HORIZONNUMC4
REPL_METHSMI Replenishment Method SMI_REPL_METHCHAR1SMI_REPL_METH
SAFETY_PERCSafety Tolerance (%) SMI_SAFETY_PERCDEC4(1) DEC3_1
SAFETY_QTYSafety Quantity SMI_SAFETY_QTYQUAN13(6) SMI_SAFETY_QTY
SFTY_QTY_UOMSafety Level Unit SMI_SAFETY_UOMUNIT3Assigned to domainCUNITMEINS
CUST_ROUND_VALIndicator for Usage of Customer Rounding Values SMI_CUST_ROUNDING_VALCHAR1SMI_BOOLEAN
REPL_PROC_LOGICProcessing Trigger Replenishment (Autom., Batch, Manually) SMI_PROCTRIG_REPLCHAR1SMI_PROCTRIG
SEND_PROC_LOGICProcessing Trigger Send (Autom., Batch, Manually) SMI_PROCTRIG_SENDCHAR1SMI_PROCTRIG
STOP_FLAGStop Processing Indicator SMI_STOP_FLAGCHAR1SMI_BOOLEAN
SMI_HORIZON_SShort-Term Period in Days SMI_HORIZON_SHORTNUMC2
SMI_HORIZON_MMid-Term Period in Days SMI_HORIZON_MIDNUMC3
SMI_HORIZON_LLong-Term Period in Days SMI_HORIZON_HIGHNUMC4
HIGH_PERC_SUpper Tolerance (%) SMI_HIGH_PERCDEC4(1) DEC3_1
LOW_PERC_SLower Tolerance (%) SMI_LOW_PERCDEC4(1) DEC3_1
HIGH_PERC_MUpper Tolerance (%) SMI_HIGH_PERCDEC4(1) DEC3_1
LOW_PERC_MLower Tolerance (%) SMI_LOW_PERCDEC4(1) DEC3_1
HIGH_PERC_LUpper Tolerance (%) SMI_HIGH_PERCDEC4(1) DEC3_1
LOW_PERC_LLower Tolerance (%) SMI_LOW_PERCDEC4(1) DEC3_1
ALERTCATEGORYAlert Category SALRTDCATCHAR30Assigned to domainSALRTDCAT
COMP_LOGICSMI Comparison Logic Type SMI_COMP_LOGICCHAR1SMI_COMP_LOGIC
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG

Key field Non-key field



How do I retrieve data from SAP table SMI_ITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on SMI_ITEM to SELECT all data from the table
DATA: WA_SMI_ITEM TYPE SMI_ITEM.

SELECT SINGLE *
FROM SMI_ITEM
INTO CORRESPONDING FIELDS OF WA_SMI_ITEM
WHERE...

How to access SAP table SMI_ITEM

Within an ECC or HANA version of SAP you can also view further information about SMI_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!