SAP VISRREPORT Sales Report Table
Overview
VISRREPORT is a standard SAP S/4HANA table that stores Sales Report data. There are total 27 fields in the VISRREPORT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRREPORT belongs to Sales-Based Rent and Settlement (RE-FX-SR) module and is located in the package RE: Sales Reports (RE_SR_RP).
In addition, following links provide an overview of foreign key relationships, if any, that link VISRREPORT to other SAP tables and standard CDS views available based on VISRREPORT table in S/4HANA 2020.
Techincal Settings of VISRREPORT
Below are technical details of the table VISRREPORT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRREPORT Fields
The following table gives you an overview of the fields available in VISRREPORT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| TERMNO | Term Number of Reporting Rule | RESRTMRPTERMNO | * | CHAR | 4 |
| RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | TIVSRRHT | CHAR | 4 |
| VALIDFROM | Reporting Interval Start for Sales-Based Lease-Out | RESRRPFROM | DATS | 8 | |
| VERSION | Version of a Sales Report | RESRRPVERSION | CHAR | 3 | |
| VALIDTO | End of Reporting Interval for Sales-Based Lease-Out | RESRRPTO | DATS | 8 | |
| SALESTYPE | Sales Type | RESRSALESTYPE | TIVSRST | CHAR | 4 |
| SALESUNIT | Unit of measurement of sales reporting values | VVUMSEINH | * | UNIT | 3 |
| SALESCURR | Currency Key | WAERS | * | CUKY | 5 |
| RPTYPE | Sales ID | RESRRPTYPE | TIVSRRPT | CHAR | 4 |
| NO_SALES | Sales Report with Zero Sales | RESRNOSALES | CHAR | 1 | |
| NET_SALES | Reported Net Sales | RESRSALESNET | CURR | 15 | |
| GROSS_SALES | Reported Gross Sales | RESRSALESGROSS | CURR | 15 | |
| QUANTITY | Reported Sales in Units | RESRQUANTITY | QUAN | 17 | |
| STAT_NETSALES | Statistical Net Sales | RESRSTATSALESNET | CURR | 15 | |
| STAT_GROSSSALES | Statistical Gross Sales | RESRSTATSALESGROSS | CURR | 15 | |
| STAT_QUANTITY | Statistical Quantitative Sales | RESRSTATQUANTITY | QUAN | 17 | |
| RPDATE | Date Sales Report Was Received | RESRRPDATE | DATS | 8 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | 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 VISRREPORT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRREPORT | RHYTHMTYPE | : | TIVSRRHT |
| VISRREPORT | RPTYPE | : | TIVSRRPT |
| VISRREPORT | SALESTYPE | : | TIVSRST |
| VISRREPORT | TERMNO | : | * |