SAP VISRTMSBRPI Assignment of Reporting Rule to Sales Rule (Grading) Table
Overview
VISRTMSBRPI is a standard SAP S/4HANA table that stores Assignment of Reporting Rule to Sales Rule (Grading) data. There are total 15 fields in the VISRTMSBRPI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRTMSBRPI 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 VISRTMSBRPI to other SAP tables and standard CDS views available based on VISRTMSBRPI table in S/4HANA 2020.
Techincal Settings of VISRTMSBRPI
Below are technical details of the table VISRTMSBRPI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRTMSBRPI Fields
The following table gives you an overview of the fields available in VISRTMSBRPI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| SBTERMNO | Term Number of Sales Rule | RESRTMSBTERMNO | VISRTMSB | CHAR | 4 |
| SBVALIDFROM | Valid-From Date of Term | RETMTERMVALIDFROM | DATS | 8 | |
| RPTERMNO | Term Number of Reporting Rule | RESRTMRPTERMNO | VISRTMRP | CHAR | 4 |
| ITEMNO | Sequence number for sales amount and percentage | RESRGRADINGITEMNO | NUMC | 3 | |
| SALESCURR | Currency Key | WAERS | * | CUKY | 5 |
| SALESUNIT | Unit of measurement of sales reporting values | RESRSALESUNIT | * | UNIT | 3 |
| MINSALES | Sales (minimum) | RESRMINSALESSALESGRADING | CURR | 15 | |
| MAXSALES | Sales (maximum) | RESRMAXSALESSALESGRADING | CURR | 15 | |
| RENTPERCENT | Percentage of sales as rent | RESRRENTPERCENT | DEC | 5 | |
| MINQUANTITY | Quantitative Sales (Minimum) | RESRMINQUANTITY | QUAN | 17 | |
| MAXQUANTITY | Quantitative Sales (Maximum) | RESRMAXQUANTITY | QUAN | 17 | |
| PRICEPERUNIT | Amount per unit of measure | RESRPRICEPERUNIT | DEC | 19 | |
| MINRENT | Minimum rent per sales grading | RESRMINRENTSALESGRADING | CURR | 15 |
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 VISRTMSBRPI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRTMSBRPI | RPTERMNO | : | VISRTMRP |
| VISRTMSBRPI | SBTERMNO | : | VISRTMSB |