SAP VISRSETTL Settlement Identification with Log Reference Table
Overview
VISRSETTL is a standard SAP S/4HANA table that stores Settlement Identification with Log Reference data. There are total 13 fields in the VISRSETTL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRSETTL belongs to Sales-Based Rent and Settlement (RE-FX-SR) module and is located in the package RE: Invoicing (RE_SR_SE).
In addition, following links provide an overview of foreign key relationships, if any, that link VISRSETTL to other SAP tables and standard CDS views available based on VISRSETTL table in S/4HANA 2020.
Techincal Settings of VISRSETTL
Below are technical details of the table VISRSETTL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRSETTL Fields
The following table gives you an overview of the fields available in VISRSETTL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | VICAPROCESSID | RAW | 16 |
| FLG_REVERSAL | Reversal indicator | VSSTORNO | CHAR | 1 | |
| PARAMKEY | Settlement Schema | RESRPARAMKEY | TIVSRSETTLPARAM | CHAR | 4 |
| DOCCOUNTER | Document Counter | RERADOCCOUNTER | INT4 | 10 | |
| IS_FINAL | Should Final Settlement Be Performed | RESRFINALSETTLEMENT | CHAR | 1 | |
| IS_CORRECTION | Settlement Correction | RESRISCORRECTION | CHAR | 1 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| TERMNO | Term Number of Reporting Rule | RESRTMRPTERMNO | CHAR | 4 | |
| RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | TIVSRRHT | CHAR | 4 |
| VALIDFROM | Reporting Interval Start for Sales-Based Lease-Out | RESRRPFROM | DATS | 8 | |
| VERSION | Version of a Sales Report | RESRRPVERSION | VISRREPORT | CHAR | 3 |
| PSTNGDATE | Posting Date | RERAPSTNGDATE | DATS | 8 |
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 VISRSETTL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRSETTL | PARAMKEY | : | TIVSRSETTLPARAM |
| VISRSETTL | PROCESSGUID | : | VICAPROCESSID |
| VISRSETTL | RHYTHMTYPE | : | TIVSRRHT |
| VISRSETTL | VERSION | : | VISRREPORT |