WRS1 SAP table for – Assortment

Here we would like to draw your attention to WRS1 table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). WRS1 is a SAP standard transparent table used for storing Assortment related data in SAP. It comes under the package WSOR.

SAP WRS1 table

Table WRS1 technical data

TableWRS1
Data storingAssortment
ModuleLO
ComponentLO-MD
SAP PackageWSOR
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WRS1 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 WRS1 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • DATBI : Validity end date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KOPRO
    Its data type is C (Character String) with field length 1
  • LAYPR
    Its data type is C (Character String) with field length 1
  • SOTYP
    Its data type is C (Character String) with field length 1
  • LAYVR
    Its data type is C (Character String) with field length 10
  • POSDS
    Its data type is C (Character String) with field length 1
  • EXCLU
    Its data type is C (Character String) with field length 1
  • CATEGORY : Alert configuration: dataelement for alert categories
    Its data type is C (Character String) with field length 18
  • LAY_LIST_UTIME
    Its data type is C (Character String) with field length 14
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is WRFAP_WRS1
  • ASORT
    Its a key field. Its data type is C (Character String) with field length 10
  • HIER_ID
    Its data type is C (Character String) with field length 2
  • ASSORTYP
    Its data type is C (Character String) with field length 4
  • ASSORDIMVAL1
    Its data type is C (Character String) with field length 4
  • ASSORDIMVAL2
    Its data type is C (Character String) with field length 4
  • ASSORDIMVAL3
    Its data type is C (Character String) with field length 4
  • LAYGR
    Its data type is C (Character String) with field length 10
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • STATU
    Its data type is C (Character String) with field length 1
  • KZLIK
    Its data type is C (Character String) with field length 1
  • NLMATFB
    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
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • LSTFL
    Its data type is C (Character String) with field length 2
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8