VISRREPORT SAP table for – Sales Report

Here we would like to draw your attention to VISRREPORT 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). VISRREPORT is a SAP standard transp table used for storing Sales Report related data in SAP. It comes under the package RE_SR_RP.

SAP VISRREPORT table

Table VISRREPORT technical data

TableVISRREPORT
Data storingSales Report
ModuleRE
Sub ModuleRE-FX-SR
SAP PackageRE_SR_RP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VISRREPORT 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 VISRREPORT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key Fields for Sales Reports
    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
  • TERMNO : Term Number of Reporting Rule
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RHYTHMTYPE : Type of Frequency
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VALIDFROM : Reporting Interval Start for Sales-Based Lease-Out
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VERSION : Version of a Sales Report
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Non-Key Fields for Sales Reports
  • VALIDTO : End of Reporting Interval for Sales-Based Lease-Out
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SALESTYPE : Sales Type
    Its data type is CHAR (Character String) with field length 4
  • SALESUNIT : Unit of measurement of sales reporting values
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SALESCURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Input Fields for Sales Reports
  • RPTYPE : Sales ID
    Its data type is CHAR (Character String) with field length 4
  • NO_SALES : Sales Report with Zero Sales
    Its data type is CHAR (Character String) with field length 1
  • NET_SALES : Reported Net Sales
    Its data type is CURR (Currency Field) with field length 15
  • GROSS_SALES : Reported Gross Sales
    Its data type is CURR (Currency Field) with field length 15
  • QUANTITY : Reported Sales in Units
    Its data type is QUAN (Quantity field) with field length 17
  • STAT_NETSALES : Statistical Net Sales
    Its data type is CURR (Currency Field) with field length 15
  • STAT_GROSSSALES : Statistical Gross Sales
    Its data type is CURR (Currency Field) with field length 15
  • STAT_QUANTITY : Statistical Quantitative Sales
    Its data type is QUAN (Quantity field) with field length 17
  • RPDATE : Date Sales Report Was Received
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10