SAP table VISRTMRP (Reporting Rule)

SAP table VISRTMRP has 5 primary key fields being MANDT,INTRENO,TERMTYPE,TERMNO,VALIDFROM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
INTRENO Internal Key of Real Estate Object CHAR 13 0 RECAINTRENO
TERMTYPE Term Category CHAR 4 0 TIVTMTERMTYPE RETMTERMTYPE
TERMNO Term Number CHAR 4 0 VITMTERM RETMTERMNO
VALIDFROM Valid-From Date of Term DATS 8 0 RETMTERMVALIDFROM
VALIDTO Valid-To Date of Term DATS 8 0 RETMTERMVALIDTO
SALESTYPE Sales Type CHAR 4 0 TIVSRST RESRSALESTYPE
IS_STATISTICAL Statistical Sales Report CHAR 1 0 RESRREPSTATISTICAL
SALESREPORTTYPE Gross/Net Sales CHAR 2 0 RESRSALESREPORTTYPE
Net Sales
G Gross Sales
NG Gross and Net Sales
USE_MEASPOINT Sales Determined by Assigned Meter CHAR 1 0 RESRRPUSEMEASPOINT
MEAS Measurement Type CHAR 4 0 TIVBDMEAS REBDMEAS
MEASPOINT_OBJNR Object Number CHAR 22 0 * RECAOBJNR
MEASPOINT Measuring Point CHAR 12 0 IMPTT RESCPOINT
LOC_KEY Regional Location Key for Heating Value Days CHAR 10 0 TIVA2 RESCLOCKEY

VISRTMRP foreign key relationships

Table Field Check Table Check Field
0 VISRTMRP LOC_KEY TIVA2 Regional Location Key for Heating Value Days MANDT
0 VISRTMRP LOC_KEY TIVA2 Regional Location Key for Heating Value Days ETHSL
1 VISRTMRP MEAS TIVBDMEAS Measurement Type MANDT
0 VISRTMRP MEASPOINT IMPTT Measuring Point (Table) POINT
1 VISRTMRP SALESTYPE TIVSRST Sales Type SALESTYPE
0 VISRTMRP TERMNO VITMTERM Term .INCLUDE
0 VISRTMRP TERMNO VITMTERM Term .INCLUDE
0 VISRTMRP TERMNO VITMTERM Term INTRENO
1 VISRTMRP TERMTYPE TIVTMTERMTYPE Term Category OBJTYPE