SAP VISRSTATUS Status per Contract and Sales Rule (Dependent on Version) Table
Overview
VISRSTATUS is a standard SAP S/4HANA table that stores Status per Contract and Sales Rule (Dependent on Version) data. There are total 11 fields in the VISRSTATUS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRSTATUS 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 VISRSTATUS to other SAP tables and standard CDS views available based on VISRSTATUS table in S/4HANA 2020.
Techincal Settings of VISRSTATUS
Below are technical details of the table VISRSTATUS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRSTATUS Fields
The following table gives you an overview of the fields available in VISRSTATUS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| OBJGUID | Reference to Status Table | RESRSESTATUSGUID | RAW | 16 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| TERMTYPE | Term Category | RETMTERMTYPE | TIVTMTERMTYPE | CHAR | 4 |
| TERMNO | Term Number | RETMTERMNO | VITMTERM | CHAR | 4 |
| RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | CHAR | 4 | |
| PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | |
| PTO | Period End Date | RECAPERIODTO | DATS | 8 | |
| VERSION | Version of Calculation | RESRCLVERSION | CHAR | 3 | |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | VICAPROCESSID | RAW | 16 |
| LASTSUCCSTEP | Last Successful Settlement Step | RESRLASTSUCCSTEP | TIVCASTEPS | CHAR | 4 |
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 VISRSTATUS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRSTATUS | LASTSUCCSTEP | : | TIVCASTEPS |
| VISRSTATUS | PROCESSGUID | 1: CN | VICAPROCESSID |
| VISRSTATUS | TERMNO | 1: CN | VITMTERM |
| VISRSTATUS | TERMTYPE | : | TIVTMTERMTYPE |