VZSORT SAP table for – Sort values for object

Here we would like to draw your attention to VZSORT table in SAP. As we know it is being mainly used with the SAP Treasury module. VZSORT is a SAP standard transparent table used for storing Sort values for object related data in SAP. It comes under the package FVV.

SAP VZSORT table

Table VZSORT technical data

TableVZSORT
Data storingSort values for object
ModuleTR
ComponentTR
SAP PackageFVV
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • USE04 : User field: Unit for quantity fields
    Its data type is C (Character String) with field length 3
  • USR05 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE05 : User field: Unit for quantity fields
    Its data type is C (Character String) with field length 3
  • USR06 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE06 : User field: Unit for value fields
    Its data type is C (Character String) with field length 5
  • USR07 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE07 : User field: Unit for value fields
    Its data type is C (Character String) with field length 5
  • USR08 : User field for date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USR09 : User field for date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USR10 : User-defined field: Indicator for reports
    Its data type is C (Character String) with field length 1
  • SNUMOBJ
    Its a key field. Its data type is C (Character String) with field length 2
  • USR11 : User-defined field: Indicator for reports
    Its data type is C (Character String) with field length 1
  • SOBJEKT
    Its a key field. Its data type is C (Character String) with field length 13
  • SLWID : Key word ID for user-defined fields
    Its data type is C (Character String) with field length 7
  • USR00 : User field with 20 characters
    Its data type is C (Character String) with field length 20
  • USR01 : User field with 20 characters
    Its data type is C (Character String) with field length 20
  • USR02 : User field with 10 characters
    Its data type is C (Character String) with field length 10
  • USR03 : User field with 10 characters
    Its data type is C (Character String) with field length 10
  • USR04 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7