WRSZ SAP table for – Assignment of assortment user to assortment

Here we would like to draw your attention to WRSZ 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). WRSZ is a SAP standard transparent table used for storing Assignment of assortment user to assortment related data in SAP. It comes under the package WSOR.

SAP WRSZ table

Table WRSZ technical data

TableWRSZ
Data storingAssignment of assortment user to assortment
ModuleLO
ComponentLO-MD
SAP PackageWSOR
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DATBI : Validity end date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • RANGF
    Its data type is C (Character String) with field length 1
  • LIGRD
    Its data type is C (Character String) with field length 1
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • ERZET : Entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEZET
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ASORT
    Its a key field. Its data type is C (Character String) with field length 10
  • LFDNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • LOCNR
    Its data type is C (Character String) with field length 10
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • 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
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • SONUT
    Its data type is C (Character String) with field length 1