SAP VISRTMSBRP Assignment of a Reporting Rule to a Sales Rule Table
Overview
VISRTMSBRP is a standard SAP S/4HANA table that stores Assignment of a Reporting Rule to a Sales Rule data. There are total 15 fields in the VISRTMSBRP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRTMSBRP 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 VISRTMSBRP to other SAP tables and standard CDS views available based on VISRTMSBRP table in S/4HANA 2020.
Techincal Settings of VISRTMSBRP
Below are technical details of the table VISRTMSBRP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRTMSBRP Fields
The following table gives you an overview of the fields available in VISRTMSBRP
| 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 |
| SALESCURR | Currency Key | WAERS | * | CUKY | 5 |
| SALESUNIT | Unit of measurement of sales reporting values | RESRSALESUNIT | * | UNIT | 3 |
| AMOUNTTYPE | What Sales Should Be Used for Calculation | RESRCALCAMOUNTTYPE | CHAR | 2 | |
| MINSALESREP | Minimum sales in reporting interval | RESRMINSALESREP | CURR | 15 | |
| MINSALES | Minimum Monetary Sales in the Settlement Period | RESRMINSALESSEPER | CURR | 15 | |
| MAXSALES | Maximum (Monetary) Sales in the Settlement Period | RESRMAXSALESSEPER | CURR | 15 | |
| MINQUANTITYREP | Minimum Quantitative Sales in Reporting Interval | RESRMINQUANREP | QUAN | 17 | |
| MINQUANTITY | Minimum Quantitative Sales in Settlement Period | RESRMINQUANSEPER | QUAN | 17 | |
| MAXQUANTITY | Maximum Quantitative Sales in Settlement Period | RESRMAXQUANSEPER | QUAN | 17 | |
| AMOUNTTYPE_QUAN | Is Price per Unit of Measure a Net or Gross Pricee | RESRPRICEPERUNITAMOUNTTYPE | CHAR | 2 |
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 VISRTMSBRP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRTMSBRP | RPTERMNO | : | VISRTMRP |
| VISRTMSBRP | SBTERMNO | : | VISRTMSB |