SAP VISRCALCDETAIL Results of Sales Grading Calculation Table
Overview
VISRCALCDETAIL is a standard SAP S/4HANA table that stores Results of Sales Grading Calculation data. There are total 22 fields in the VISRCALCDETAIL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRCALCDETAIL belongs to Sales-Based Rent and Settlement (RE-FX-SR) module and is located in the package RE: Calculation (RE_SR_CL).
In addition, following links provide an overview of foreign key relationships, if any, that link VISRCALCDETAIL to other SAP tables and standard CDS views available based on VISRCALCDETAIL table in S/4HANA 2020.
Techincal Settings of VISRCALCDETAIL
Below are technical details of the table VISRCALCDETAIL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRCALCDETAIL Fields
The following table gives you an overview of the fields available in VISRCALCDETAIL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| RESULTGUID | Reference Within Results Tables | RESRRESULTGUID | VISRCALCSB | RAW | 16 |
| ITEMNO | Sequence number for sales amount and percentage | RESRGRADINGITEMNO | NUMC | 3 | |
| SALESCURR | Currency Key | WAERS | * | CUKY | 5 |
| SALESUNIT | Unit of measurement of sales reporting values | RESRSALESUNIT | * | UNIT | 3 |
| MINSALES | Sales (minimum) | RESRMINSALESSALESGRADING | CURR | 15 | |
| MAXSALES | Sales (maximum) | RESRMAXSALESSALESGRADING | CURR | 15 | |
| RENTPERCENT | Percentage of sales as rent | RESRRENTPERCENT | DEC | 5 | |
| MINQUANTITY | Quantitative Sales (Minimum) | RESRMINQUANTITY | QUAN | 17 | |
| MAXQUANTITY | Quantitative Sales (Maximum) | RESRMAXQUANTITY | QUAN | 17 | |
| PRICEPERUNIT | Amount per unit of measure | RESRPRICEPERUNIT | DEC | 19 | |
| MINRENT | Minimum rent per sales grading | RESRMINRENTSALESGRADING | CURR | 15 | |
| SALES | Reported Sales | RESRSALES | CURR | 15 | |
| QUANTITY | Reported Sales in Units | RESRQUANTITY | QUAN | 17 | |
| TERMNOPY | Term Number of Posting Rule | RERATMPYTERMNO | CHAR | 4 | |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| TAXDATE | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| SALESRENT | Sales-Based Rent | RESRSALESRENT | CURR | 15 | |
| SALESRENTNET | Net Amount of Sales-Based Rent | RESRSALESRENTNET | CURR | 15 | |
| SALESRENTTAX | Tax Amount of Sales-Based Rent | RESRSALESRENTTAX | CURR | 15 |
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 VISRCALCDETAIL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRCALCDETAIL | RESULTGUID | 1: CN | VISRCALCSB |
| VISRCALCDETAIL | TAXGROUP | C: CN | TIVRATAXGROUP |
| VISRCALCDETAIL | TAXTYPE | C: CN | TIVRATAXTYPE |