SAP VISRMODIRESULT Changed Sales-Based Settlement Results Table
Overview
VISRMODIRESULT is a standard SAP S/4HANA table that stores Changed Sales-Based Settlement Results data. There are total 21 fields in the VISRMODIRESULT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRMODIRESULT belongs to Sales-Based Rent and Settlement (RE-FX-SR) module and is located in the package RE: Processing of Sales-Based Rent (RE_SR_MO).
In addition, following links provide an overview of foreign key relationships, if any, that link VISRMODIRESULT to other SAP tables and standard CDS views available based on VISRMODIRESULT table in S/4HANA 2020.
Techincal Settings of VISRMODIRESULT
Below are technical details of the table VISRMODIRESULT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRMODIRESULT Fields
The following table gives you an overview of the fields available in VISRMODIRESULT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| OBJGUID | Reference Within Results Tables | RESRSBRESULTGUID | RAW | 16 | |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | |
| SALESCURR | Currency Key | WAERS | * | CUKY | 5 |
| 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 | |
| ASGROSSAMOUNT | As Gross Amount | RESRASGROSSAMOUNT | CHAR | 1 | |
| BALANCEGROSS | Changed Balance | RESRMODIBALANCE | CURR | 15 | |
| BALANCENET | Changed Net Amount of Balance | RESRMODIBALANCENET | CURR | 15 | |
| BALANCETAX | Changed Tax Amount of Balance | RESRMODIBALANCETAX | CURR | 15 | |
| ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | |
| CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15 | |
| CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15 | |
| CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15 | |
| CTLCCURRKEY | Local Currency | RECACTLCCURRKEY | * | CUKY | 5 |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| CTRATE_BADI | Exchange Rate from BAdI | RECACTRATE_BADI | DEC | 9 |
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 VISRMODIRESULT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRMODIRESULT | TAXGROUP | : | TIVRATAXGROUP |
| VISRMODIRESULT | TAXTYPE | : | TIVRATAXTYPE |