SAP VISRTMRP Reporting Rule Table
Overview
VISRTMRP is a standard SAP S/4HANA table that stores Reporting Rule data. There are total 14 fields in the VISRTMRP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRTMRP belongs to Sales-Based Rent and Settlement (RE-FX-SR) module and is located in the package RE: Terms - Sales Agreement (RE_SR_TM).
In addition, following links provide an overview of foreign key relationships, if any, that link VISRTMRP to other SAP tables and standard CDS views available based on VISRTMRP table in S/4HANA 2020.
Techincal Settings of VISRTMRP
Below are technical details of the table VISRTMRP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRTMRP Fields
The following table gives you an overview of the fields available in VISRTMRP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| TERMTYPE | Term Category | RETMTERMTYPE | TIVTMTERMTYPE | CHAR | 4 |
| TERMNO | Term Number | RETMTERMNO | VITMTERM | CHAR | 4 |
| VALIDFROM | Valid-From Date of Term | RETMTERMVALIDFROM | DATS | 8 | |
| VALIDTO | Valid-To Date of Term | RETMTERMVALIDTO | DATS | 8 | |
| SALESTYPE | Sales Type | RESRSALESTYPE | TIVSRST | CHAR | 4 |
| IS_STATISTICAL | Statistical Sales Report | RESRREPSTATISTICAL | CHAR | 1 | |
| SALESREPORTTYPE | Gross/Net Sales | RESRSALESREPORTTYPE | CHAR | 2 | |
| USE_MEASPOINT | Sales Determined by Assigned Meter | RESRRPUSEMEASPOINT | CHAR | 1 | |
| MEAS | Measurement Type | REBDMEAS | TIVBDMEAS | CHAR | 4 |
| MEASPOINT_OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| MEASPOINT | Measuring Point | RESCPOINT | IMPTT | CHAR | 12 |
| LOC_KEY | Regional Location Key for Heating Value Days | RESCLOCKEY | TIVA2 | 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 VISRTMRP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRTMRP | LOC_KEY | : | TIVA2 |
| VISRTMRP | MEAS | : | TIVBDMEAS |
| VISRTMRP | MEASPOINT | : | IMPTT |
| VISRTMRP | SALESTYPE | : | TIVSRST |
| VISRTMRP | TERMNO | 1: CN | VITMTERM |
| VISRTMRP | TERMTYPE | 1: CN | TIVTMTERMTYPE |