SLS_TMPL_KEY SAP table for – Sales: Template Key

Here we would like to draw your attention to SLS_TMPL_KEY 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_KEY is a SAP standard transparent table used for storing Sales: Template Key related data in SAP. It comes under the package ERP_SLS_TEMPLATE.

SAP SLS_TMPL_KEY table

Table SLS_TMPL_KEY technical data

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

SAP SLS_TMPL_KEY 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_KEY table.

  • CREATED_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
  • 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
  • GUID : 16 Byte UUID in 32 Characters (Hexadecimal Encoded)
    Its a key field. Its data type is C (Character String) with field length 32
  • KUNWE : Ship-to party
    Its data type is C (Character String) with field length 10
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is TDS_SLS_TEMPLATE_ADMIN