SAP VISRTMSBRH Assignment of Frequency Rule to Sales Rule Table
Overview
VISRTMSBRH is a standard SAP S/4HANA table that stores Assignment of Frequency Rule to Sales Rule data. There are total 13 fields in the VISRTMSBRH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRTMSBRH 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 VISRTMSBRH to other SAP tables and standard CDS views available based on VISRTMSBRH table in S/4HANA 2020.
Techincal Settings of VISRTMSBRH
Below are technical details of the table VISRTMSBRH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRTMSBRH Fields
The following table gives you an overview of the fields available in VISRTMSBRH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| SBTERMTYPE | Term Category | RETMTERMTYPE | TIVTMTERMTYPE | CHAR | 4 |
| SBTERMNO | Term Number of Sales Rule | RESRTMSBTERMNO | VISRTMSB | CHAR | 4 |
| SBVALIDFROM | Valid-From Date of Term | RETMTERMVALIDFROM | DATS | 8 | |
| RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | TIVSRRHT | CHAR | 4 |
| RHYTMBEGIN | Start of Frequency | RESRRHBEGIN | DATS | 8 | |
| FREQUENCY | Number of Frequency Units of Period | RESRFREQUENCY | NUMC | 3 | |
| FREQUENCYUNIT | Frequency Unit | RESRFREQUENCYUNIT | NUMC | 1 | |
| FIXPER | Fixed Periods | RECDFIXPER | TIVCDFIXPER | CHAR | 10 |
| PRORATE | Pro Rata Method | RECDPRORATE | NUMC | 1 | |
| CALCMETHPER | Calculation method for time-dependent periods | RECDCALCMETHPER | NUMC | 1 | |
| CREDITPAYBACK | Credits Withing Cumulative Settlement Are Paid | RESRCREDITPAYBACK | 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 VISRTMSBRH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRTMSBRH | FIXPER | : | TIVCDFIXPER |
| VISRTMSBRH | RHYTHMTYPE | : | TIVSRRHT |
| VISRTMSBRH | SBTERMNO | : | VISRTMSB |
| VISRTMSBRH | SBTERMTYPE | : | TIVTMTERMTYPE |