SAP VIRN02 RE: Date Scheduling of Renewals by Contract Table
Overview
VIRN02 is a standard SAP S/4HANA table that stores RE: Date Scheduling of Renewals by Contract data. There are total 27 fields in the VIRN02 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRN02 belongs to Real Estate Management (RE) module and is located in the package R/3 Real Estate Application Development - General Contract (FVVICN).
In addition, following links provide an overview of foreign key relationships, if any, that link VIRN02 to other SAP tables and standard CDS views available based on VIRN02 table in S/4HANA 2020.
Techincal Settings of VIRN02
Below are technical details of the table VIRN02
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRN02 Fields
The following table gives you an overview of the fields available in VIRN02
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | VIRN01 | CHAR | 13 |
| SRNWOPTION | Renewal Rule | RECNSRNWOPTION | TIVCN09 | CHAR | 4 |
| NRNWJHR | Contract Renewed for Number of Years | RECNRNWYEARS | NUMC | 3 | |
| NRNWMON | Contract Renewed for Number of Months | RECNRNWMONTHS | NUMC | 3 | |
| NRNWTAG | Contract Renewed for Number of Days | RECNRNWDAYS | NUMC | 3 | |
| SRNWDAYRND | Rounding Rule for Determined Renewal Date | RECNRNWDAYRND | CHAR | 1 | |
| NAMTJHR | Notification Must Be This No. of Years before Renewal Date | RECNAMTYEARS | NUMC | 3 | |
| NAMTMON | Notification Must Be This No. of Months before Renewal Date | RECNAMTMONTHS | NUMC | 3 | |
| NAMTTAG | Notification Must Be This No. of Days before Renewal Date | RECNAMTDAYS | NUMC | 3 | |
| SAMTDAYRND | Rounding Rule for Determined Notification Date | RECNAMTDAYRND | CHAR | 1 | |
| DRNWDATE | Renewal date (new contract end date) | RECNDRNWDATE | DATS | 8 | |
| DAMTDATE | Notification Date (Latest Date for Declaring Option) | RECNDAMTDATE | DATS | 8 | |
| DRNWACCOWN | Approval date for renewal (own) | RECNDRNWACCOWN | DATS | 8 | |
| DRNWACCPAR | Approval date for renewal (partner) | RECNDRNWACCPAR | DATS | 8 | |
| DRNWOPTACT | Date of activation of renewal | RECNDRNWOPTACT | DATS | 8 | |
| JRNWDCTINP | Renewal date added (no rule evaluation) | RECNJRNWDCTINP | CHAR | 1 | |
| XRNWINFTXT | Short text for renewal date | RECNXRNWINFTXT | CHAR | 50 | |
| SRNWSOURCE | Source of Renewal Date (Option or Automatic) | RECNSRNWSOURCE | NUMC | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 |
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 VIRN02
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRN02 | INTRENO | 1: CN | VIRN01 |
| VIRN02 | MANDT | 1: CN | T000 |
| VIRN02 | SRNWOPTION | 1: CN | TIVCN09 |