SAP Table VISRREPORT
Sales Report
VISRREPORT (Sales Report) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VISRREPORT to other SAP tables.
Source: VISRREPORT (Sales Report)
VISRREPORT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | 0 | |||||||
| TERMNO | Term Number of Reporting Rule | RESRTMRPTERMNO | CHAR | 4 | 0 | |||||||
| RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | TIVSRRHT | CHAR | 4 | 0 | ||||||
| VALIDFROM | Reporting Interval Start for Sales-Based Lease-Out | RESRRPFROM | DATS | 8 | 0 | |||||||
| VERSION | Version of a Sales Report | RESRRPVERSION | CHAR | 3 | 0 | |||||||
| VALIDTO | End of Reporting Interval for Sales-Based Lease-Out | RESRRPTO | DATS | 8 | 0 | |||||||
| SALESTYPE | Sales Type | RESRSALESTYPE | TIVSRST | CHAR | 4 | 0 | ||||||
| SALESUNIT | Unit of measurement of sales reporting values | VVUMSEINH | UNIT | 3 | 0 | |||||||
| SALESCURR | Currency Key | WAERS | CUKY | 5 | 0 | |||||||
| RPTYPE | Sales ID | RESRRPTYPE | TIVSRRPT | CHAR | 4 | 0 | ||||||
| NO_SALES | Sales Report with Zero Sales | RESRNOSALES | CHAR | 1 | 0 |
Possible values
|
||||||
| NET_SALES | Reported Net Sales | RESRSALESNET | CURR | 15 | 2 | |||||||
| GROSS_SALES | Reported Gross Sales | RESRSALESGROSS | CURR | 15 | 2 | |||||||
| QUANTITY | Reported Sales in Units | RESRQUANTITY | QUAN | 17 | 4 | |||||||
| STAT_NETSALES | Statistical Net Sales | RESRSTATSALESNET | CURR | 15 | 2 | |||||||
| STAT_GROSSSALES | Statistical Gross Sales | RESRSTATSALESGROSS | CURR | 15 | 2 | |||||||
| STAT_QUANTITY | Statistical Quantitative Sales | RESRSTATQUANTITY | QUAN | 17 | 4 | |||||||
| RPDATE | Date Sales Report Was Received | RESRRPDATE | DATS | 8 | 0 | |||||||
| RERF | Entered by | RERF | CHAR | 12 | 0 | |||||||
| DERF | First Entered on | DERF | DATS | 8 | 0 | |||||||
| TERF | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||||||
| REHER | Source of initial entry | REHER | CHAR | 10 | 0 | |||||||
| RBEAR | Employee ID | RBEAR | CHAR | 12 | 0 | |||||||
| DBEAR | Last Edited on | DBEAR | DATS | 8 | 0 | |||||||
| TBEAR | Last Edited at | TBEAR | TIMS | 6 | 0 | |||||||
| RBHER | Editing Source | RBHER | CHAR | 10 | 0 | |||||||
VISRREPORT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VISRREPORT | RHYTHMTYPE | '1410' | TIVSRRHT | Type of Frequency | TERMTYPE | |
| VISRREPORT | RHYTHMTYPE | VISRREPORT | RHYTHMTYPE | TIVSRRHT | Type of Frequency | RHYTHMTYPE |
| VISRREPORT | RPTYPE | SYST | MANDT | TIVSRRPT | Sales ID | MANDT |
| VISRREPORT | RPTYPE | VISRREPORT | RPTYPE | TIVSRRPT | Sales ID | RPTYPE |
| VISRREPORT | SALESTYPE | SYST | MANDT | TIVSRST | Sales Type | MANDT |
| VISRREPORT | SALESTYPE | VISRREPORT | SALESTYPE | TIVSRST | Sales Type | SALESTYPE |
