SLS_TMPL_ITEM SAP table for – Sales: Template Item

Here we would like to draw your attention to SLS_TMPL_ITEM table in SAP. As we know it is being mainly used with the SAP SD-SLS (Sales in SD) component which is coming under SD module (Sales & Distribution). SLS_TMPL_ITEM is a SAP standard transparent table used for storing Sales: Template Item related data in SAP. It comes under the package ERP_SLS_TEMPLATE.

SAP SLS_TMPL_ITEM table

Table SLS_TMPL_ITEM technical data

TableSLS_TMPL_ITEM
Data storingSales: Template Item
ModuleSD
ComponentSD-SLS
SAP PackageERP_SLS_TEMPLATE
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP SLS_TMPL_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 SLS_TMPL_ITEM table.

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • DLV_DATE
    Its data type is C (Character String) with field length 2
  • CREATED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 12
  • CHANGED_AT : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 11
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is TDS_SLS_TEMPLATE_ITEM
  • SEQUENCE : Alert configuration: dataelement integer
    Its data type is X (Byte string) with field length 4
  • VALID_TO : Valid To (Time Stamp)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EAN11 : International Article Number (EAN/UPC)
    Its data type is C (Character String) with field length 18