SAP VITMRH Terms: Frequency Rule Table
Overview
VITMRH is a standard SAP S/4HANA table that stores Terms: Frequency Rule data. There are total 26 fields in the VITMRH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VITMRH belongs to Rental Accounting (RE-FX-RA) module and is located in the package RE: Terms - Finance (Terms for Posting Parameters) (RE_TM_FI).
In addition, following links provide an overview of foreign key relationships, if any, that link VITMRH to other SAP tables and standard CDS views available based on VITMRH table in S/4HANA 2020.
Techincal Settings of VITMRH
Below are technical details of the table VITMRH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VITMRH Fields
The following table gives you an overview of the fields available in VITMRH
| 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 | |
| FREQUENCY | Number of Frequency Units of Period | RECDFREQUENCY | NUMC | 3 | |
| FREQUENCYUNIT | Frequency Unit | RECDFREQUENCYUNIT | NUMC | 1 | |
| WEEKFROM | Start of Week for Weekly Frequencies | RECDWEEKFROM | NUMC | 1 | |
| MONTHFROM | Start of Frequency for Daily Monthly and Yearly Frequency | RECDMONTHFROM | NUMC | 2 | |
| CONDVALUEREFER | Condition Amount Reference | RECDCONDVALUEREFER | NUMC | 1 | |
| CONDVALUEREFDIF | Condition Amount Reference Differences | RECDCONDVALUEREFDIF | NUMC | 1 | |
| PRORATE | Pro Rata Method | RECDPRORATE | NUMC | 1 | |
| CALCMETHPER | Calculation method for time-dependent periods | RECDCALCMETHPER | NUMC | 1 | |
| PAYMENTFORMRH | Payment Form (Period Start Mid-Period In Arrears Example) | RECDPAYMENTFORMRH | NUMC | 1 | |
| RHYTHMBEGIN | User-Selected Frequency Start Date | RECDRHYTHMBEGIN | DATS | 8 | |
| DUEDATECORRRULE | Due Date Correction Rule | RECDDUEDATECORRRULE | TIVCDDUEDATE | CHAR | 4 |
| DUEDATECORRDAY | Number of Days for Correcting Due Date | RECDDUEDATECORRDAY | INT2 | 5 | |
| DUEDATECORRMONTH | Number of Months for Correcting Due Date | RECDDUEDATECORRMONTH | INT2 | 5 | |
| DUEDATECORRYEAR | Number of Years for Correcting Due Date | RECDDUEDATECORRYEAR | INT2 | 5 | |
| DUEDATECORRCAL | Correction Number for Correction of Due Date by Calendar | RECDDUEDATECORRCAL | INT2 | 5 | |
| DUEDATECORRCALUN | Unit for Correcting Due Date by Calendar | RECDDUEDATECORRCALUNIT | NUMC | 2 | |
| DUEDATECALENDER | Factory Calendar | RECACALENDAR | TFACD | CHAR | 2 |
| DUEDATEMOVEBEGIN | Move Due Date to Start | RECDDUEDATEMOVEBEGIN | CHAR | 1 | |
| DUEDATEMOVEEND | Move Due Date to End | RECDDUEDATEMOVEEND | CHAR | 1 | |
| FIXPER | Fixed Periods | RECDFIXPER | TIVCDFIXPER | 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 VITMRH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VITMRH | DUEDATECALENDER | 1: CN | TFACD |
| VITMRH | DUEDATECORRRULE | 1: CN | TIVCDDUEDATE |
| VITMRH | FIXPER | 1: CN | TIVCDFIXPER |
| VITMRH | TERMNO | 1: CN | VITMTERM |
| VITMRH | TERMTYPE | 1: CN | TIVTMTERMTYPE |