SAP VZSORT Sort values for object Table
Overview
VZSORT is a standard SAP S/4HANA table that stores Sort values for object data. There are total 20 fields in the VZSORT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZSORT belongs to Treasury and Risk Management (FIN-FSCM-TRM) module and is located in the package R/3 application development for Financial Assets Management (FVV).
In addition, following links provide an overview of foreign key relationships, if any, that link VZSORT to other SAP tables and standard CDS views available based on VZSORT table in S/4HANA 2020.
Techincal Settings of VZSORT
Below are technical details of the table VZSORT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZSORT Fields
The following table gives you an overview of the fields available in VZSORT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SNUMOBJ | Key for number range object | VVNUMOBJ | CHAR | 2 | |
| SOBJEKT | Internal key for object for business partner table | VVSOBJGPO | CHAR | 13 | |
| SLWID | Key word ID for user-defined fields | SLWID | TCN00 | CHAR | 7 |
| USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | |
| USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | |
| USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | |
| USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | |
| USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13 | |
| USE04 | User field: Unit for quantity fields | USRUNIT | T006 | UNIT | 3 |
| USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13 | |
| USE05 | User field: Unit for quantity fields | USRUNIT | T006 | UNIT | 3 |
| USR06 | User-defined field for values (length 103) | USRCURR13 | CURR | 13 | |
| USE06 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| USR07 | User-defined field for values (length 103) | USRCURR13 | CURR | 13 | |
| USE07 | User field: Unit for value fields | USRCUKY | TCURC | CUKY | 5 |
| USR08 | User field for date | USRDATE | DATS | 8 | |
| USR09 | User field for date | USRDATE | DATS | 8 | |
| USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | |
| USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VZSORT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZSORT | MANDT | 1: CN | T000 |
| VZSORT | SLWID | 1: CN | TCN00 |
| VZSORT | USE04 | C: CN | T006 |
| VZSORT | USE05 | C: CN | T006 |
| VZSORT | USE06 | C: CN | TCURC |
| VZSORT | USE07 | C: CN | TCURC |