VISRTMSBRP SAP table for – Assignment of a Reporting Rule to a Sales Rule

Here we would like to draw your attention to VISRTMSBRP table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VISRTMSBRP is a SAP standard transp table used for storing Assignment of a Reporting Rule to a Sales Rule related data in SAP. It comes under the package RE_SR_TM.

SAP VISRTMSBRP table

Table VISRTMSBRP technical data

TableVISRTMSBRP
Data storingAssignment of a Reporting Rule to a Sales Rule
ModuleRE
Sub ModuleRE-FX-SR
SAP PackageRE_SR_TM
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VISRTMSBRP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VISRTMSBRP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key Fields for Table VISRTMSBRP
    Its a key field.
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • SBTERMNO : Term Number of Sales Rule
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SBVALIDFROM : Valid-From Date of Term
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RPTERMNO : Term Number of Reporting Rule
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Non-Key Fields for Table VISRTMSBRP
  • SALESCURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SALESUNIT : Unit of measurement of sales reporting values
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Input Fields for Assignment of Reporting Rule to Sales Rule
  • AMOUNTTYPE : What Sales Should Be Used for Calculation
    Its data type is CHAR (Character String) with field length 2
  • MINSALESREP : Minimum sales in reporting interval
    Its data type is CURR (Currency Field) with field length 15
  • MINSALES : Minimum Monetary Sales in the Settlement Period
    Its data type is CURR (Currency Field) with field length 15
  • MAXSALES : Maximum (Monetary) Sales in the Settlement Period
    Its data type is CURR (Currency Field) with field length 15
  • MINQUANTITYREP : Minimum Quantitative Sales in Reporting Interval
    Its data type is QUAN (Quantity field) with field length 17
  • MINQUANTITY : Minimum Quantitative Sales in Settlement Period
    Its data type is QUAN (Quantity field) with field length 17
  • MAXQUANTITY : Maximum Quantitative Sales in Settlement Period
    Its data type is QUAN (Quantity field) with field length 17
  • AMOUNTTYPE_QUAN : Is Price per Unit of Measure a Net or Gross Pricee
    Its data type is CHAR (Character String) with field length 2