SAP VISRTMSB Sales Rule Table
Overview
VISRTMSB is a standard SAP S/4HANA table that stores Sales Rule data. There are total 9 fields in the VISRTMSB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRTMSB 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 VISRTMSB to other SAP tables and standard CDS views available based on VISRTMSB table in S/4HANA 2020.
Techincal Settings of VISRTMSB
Below are technical details of the table VISRTMSB
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRTMSB Fields
The following table gives you an overview of the fields available in VISRTMSB
| 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 | |
| IS_MASTER | Is a Peak Sales Rule | RESRISMASTERSB | CHAR | 1 | |
| SALESRULE | Type of Sales Rule | RESRSALESRULE | TIVSRSR | CHAR | 4 |
| USECF4POST | Use Periodic Posting Run for Posting | RESRUSECF4POST | CHAR | 1 |
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 VISRTMSB
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRTMSB | SALESRULE | : | TIVSRSR |
| VISRTMSB | TERMNO | 1: CN | VITMTERM |
| VISRTMSB | TERMTYPE | 1: CN | TIVTMTERMTYPE |