SAP VISRCALCSUM Calculation Results per Sales Rule Table
Overview
VISRCALCSUM is a standard SAP S/4HANA table that stores Calculation Results per Sales Rule data. There are total 64 fields in the VISRCALCSUM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRCALCSUM 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 VISRCALCSUM to other SAP tables and standard CDS views available based on VISRCALCSUM table in S/4HANA 2020.
Techincal Settings of VISRCALCSUM
Below are technical details of the table VISRCALCSUM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRCALCSUM Fields
The following table gives you an overview of the fields available in VISRCALCSUM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| OBJGUID | Reference Within Results Tables | RESRSBRESULTGUID | VISRSTATUS | RAW | 16 |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| TERMTYPE | Term Category | RETMTERMTYPE | TIVTMTERMTYPE | CHAR | 4 |
| TERMNO | Term Number | RETMTERMNO | VITMTERM | CHAR | 4 |
| RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | CHAR | 4 | |
| PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | |
| PTO | Period End Date | RECAPERIODTO | DATS | 8 | |
| VERSION | Version of Calculation | RESRCLVERSION | CHAR | 3 | |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | VICAPROCESSID | RAW | 16 |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | * | CHAR | 22 |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| CREDITPAYBACK | Credits Withing Cumulative Settlement Are Paid | RESRCREDITPAYBACK | CHAR | 1 | |
| SALESCURR | Currency Key | WAERS | * | CUKY | 5 |
| 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 | |
| SALESRENTNET | Net Amount of Sales-Based Rent | RESRSALESRENTNET | CURR | 15 | |
| SALESRENTTAX | Tax Amount of Sales-Based Rent | RESRSALESRENTTAX | CURR | 15 | |
| ADVPAYNET | Net Amount of Advanced Payment | RERAADVPAYNET | CURR | 15 | |
| ADVPAYTAX | Tax Amount of Advance Payment | RERAADVPAYTAX | CURR | 15 | |
| PAYNET | Net Amount of Payments Already Made | RESRPAYNET | CURR | 15 | |
| PAYTAX | Tax Amount from Payments Already Made | RESRPAYTAX | CURR | 15 | |
| MINRENTNET | Net Amount of Minimum Rent for Sales-Based Rent Contracts | RESRMINRENTNET | CURR | 15 | |
| MINRENTTAX | Tax Amount of Minimum Rent for Sales-Based Rent Contracts | RESRMINRENTTAX | CURR | 15 | |
| MAXRENTNET | Net Amount of Maximum Rent for Sales-Based Rent Contracts | RESRMAXRENTNET | CURR | 15 | |
| MAXRENTTAX | Tax Amount of Maximum Rent for Sales-Based Rent Contracts | RESRMAXRENTTAX | CURR | 15 | |
| RECEIVABLENET | Net Amount of Receivable | RESRRECEIVENET | CURR | 15 | |
| RECEIVABLETAX | Tax Amount of Receivable | RESRRECEIVETAX | CURR | 15 | |
| BALANCENET | Net Amount of Balance | RESRBALANCENET | CURR | 15 | |
| BALANCETAX | Tax Amount of Balance | RESRBALANCETAX | CURR | 15 | |
| PREVBALANCENET | Net Amount of Balance from Prior Settlement | RESRPREVBALANCENET | CURR | 15 | |
| PREVBALANCETAX | Tax Amount of Balance from Prior Settlement | RESRPREVBALANCETAX | CURR | 15 | |
| PREVPAYNET | Net Amount of Payment from Previous Period | RESRPREVPAYNET | CURR | 15 | |
| PREVPAYTAX | Tax Amount of Payment from Previous Period | RESRPREVPAYTAX | CURR | 15 | |
| PREVADVPAYNET | Net Amount of Advance Payments from Previous Period | RESRPREVADVPAYNET | CURR | 15 | |
| PREVADVPAYTAX | Tax Amount of Advance Payments from Previous Period | RESRPREVADVPAYTAX | CURR | 15 | |
| PREVMINRENTNET | Net Amount of Minimum Rent from Previous Period | RESRPREVMINRENTNET | CURR | 15 | |
| PREVMINRENTTAX | Tax Amount of Minimum Rent from Previous Period | RESRPREVMINRENTTAX | CURR | 15 | |
| PREVMAXRENTNET | Net Amount of Maximum Rent from Previous Period | RESRPREVMAXRENTNET | CURR | 15 | |
| PREVMAXRENTTAX | Tax Amount of Maximum Rent from Previous Period | RESRPREVMAXRENTTAX | CURR | 15 | |
| ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | |
| INFOCOND | Statistical or Informational Condition | RECDINFOCOND | CHAR | 1 | |
| ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | 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 | |
| CTLCPOST | Post in Local Currency | RECACTLCPOST | CHAR | 1 | |
| POSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | |
| USECF4POST | Use Periodic Posting Run for Posting | RESRUSECF4POST | CHAR | 1 | |
| BASICFEENET | Net Amount of Base Fee | RESRBASICFEENET | CURR | 15 | |
| BASICFEETAX | Tax Amount of Base Fee | RESRBASICFEETAX | CURR | 15 | |
| PREVBASICFEENET | Net Amount of Base Fee from Previous Period | RESRPREVBASICFEENET | CURR | 15 | |
| PREVBASICFEETAX | Tax Amount of Base Fee from Previous Period | RESRPREVBASICFEETAX | CURR | 15 | |
| 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 VISRCALCSUM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRCALCSUM | CONDTYPE | : | TIVCDCONDTYPE |
| VISRCALCSUM | FLOWTYPE | : | TIVCDFLOWTYPE |
| VISRCALCSUM | OBJGUID | 1: C | VISRSTATUS |
| VISRCALCSUM | PROCESSGUID | 1: CN | VICAPROCESSID |
| VISRCALCSUM | TAXGROUP | : | TIVRATAXGROUP |
| VISRCALCSUM | TAXTYPE | : | TIVRATAXTYPE |
| VISRCALCSUM | TERMNO | 1: CN | VITMTERM |
| VISRCALCSUM | TERMTYPE | : | TIVTMTERMTYPE |