VISRCALCSUM SAP (Calculation Results per Sales Rule) Table details
Dictionary Type: Table
Description: Calculation Results per Sales Rule
Description: Calculation Results per Sales Rule
Table field list including key, data, relationships and ABAP select examples
VISRCALCSUM is a standard SAP Table which is used to store Calculation Results per Sales Rule data and is available within R/3 SAP systems depending on the version and release level.
The VISRCALCSUM table consists of various fields, each holding specific information or linking keys about Calculation Results per Sales Rule data available in SAP. These include OBJGUID (Reference Within Results Tables), INTRENO (Internal Key of Real Estate Object), TERMTYPE (Term Category), TERMNO (Term Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VISRCALCSUM table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
OBJGUID | Reference Within Results Tables | RESRSBRESULTGUID | RAW | 16 | VISRSTATUS | RECAGUID | |||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
TERMTYPE | Term Category | RETMTERMTYPE | CHAR | 4 | TIVTMTERMTYPE | RETMTERMTYPE | |||
TERMNO | Term Number | RETMTERMNO | CHAR | 4 | VITMTERM | ALPHA | RETMTERMNO | ||
RHYTHMTYPE | Type of Frequency | RESRRHYTHMTYPE | CHAR | 4 | ALPHA | RESRRHYTHMTYPE | |||
PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | RECADATEBEG | ||||
PTO | Period End Date | RECAPERIODTO | DATS | 8 | REDAT | RECADATEEND | |||
VERSION | Version of Calculation | RESRCLVERSION | CHAR | 3 | RESRVERSION | ||||
PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | VICAPROCESSID | RECAGUID | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | TIVCDCONDTYPE | ALPHA | RECDCONDTYPE | ||
FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | TIVCDFLOWTYPE | ALPHA | RECDFLOWTYPE | ||
CREDITPAYBACK | Credits Withing Cumulative Settlement Are Paid | RESRCREDITPAYBACK | CHAR | 1 | RECABOOL | ||||
SALESCURR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
TERMNOPY | Term Number of Posting Rule | RERATMPYTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | TIVRATAXTYPE | RERATAXTYPE | |||
TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | TIVRATAXGROUP | RERATAXGROUP | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TAXDATE | Date for defining tax rates | TXDAT | DATS | 8 | DATUM | ||||
SALESRENTNET | Net Amount of Sales-Based Rent | RESRSALESRENTNET | CURR | 15(2) | RECACURR | ||||
SALESRENTTAX | Tax Amount of Sales-Based Rent | RESRSALESRENTTAX | CURR | 15(2) | RECACURR | ||||
ADVPAYNET | Net Amount of Advanced Payment | RERAADVPAYNET | CURR | 15(2) | RECACURR | ||||
ADVPAYTAX | Tax Amount of Advance Payment | RERAADVPAYTAX | CURR | 15(2) | RECACURR | ||||
PAYNET | Net Amount of Payments Already Made | RESRPAYNET | CURR | 15(2) | RECACURR | ||||
PAYTAX | Tax Amount from Payments Already Made | RESRPAYTAX | CURR | 15(2) | RECACURR | ||||
MINRENTNET | Net Amount of Minimum Rent for Sales-Based Rent Contracts | RESRMINRENTNET | CURR | 15(2) | RECACURR | ||||
MINRENTTAX | Tax Amount of Minimum Rent for Sales-Based Rent Contracts | RESRMINRENTTAX | CURR | 15(2) | RECACURR | ||||
MAXRENTNET | Net Amount of Maximum Rent for Sales-Based Rent Contracts | RESRMAXRENTNET | CURR | 15(2) | RECACURR | ||||
MAXRENTTAX | Tax Amount of Maximum Rent for Sales-Based Rent Contracts | RESRMAXRENTTAX | CURR | 15(2) | RECACURR | ||||
RECEIVABLENET | Net Amount of Receivable | RESRRECEIVENET | CURR | 15(2) | RECACURR | ||||
RECEIVABLETAX | Tax Amount of Receivable | RESRRECEIVETAX | CURR | 15(2) | RECACURR | ||||
BALANCENET | Net Amount of Balance | RESRBALANCENET | CURR | 15(2) | RECACURR | ||||
BALANCETAX | Tax Amount of Balance | RESRBALANCETAX | CURR | 15(2) | RECACURR | ||||
PREVBALANCENET | Net Amount of Balance from Prior Settlement | RESRPREVBALANCENET | CURR | 15(2) | RECACURR | ||||
PREVBALANCETAX | Tax Amount of Balance from Prior Settlement | RESRPREVBALANCETAX | CURR | 15(2) | RECACURR | ||||
PREVPAYNET | Net Amount of Payment from Previous Period | RESRPREVPAYNET | CURR | 15(2) | RECACURR | ||||
PREVPAYTAX | Tax Amount of Payment from Previous Period | RESRPREVPAYTAX | CURR | 15(2) | RECACURR | ||||
PREVADVPAYNET | Net Amount of Advance Payments from Previous Period | RESRPREVADVPAYNET | CURR | 15(2) | RECACURR | ||||
PREVADVPAYTAX | Tax Amount of Advance Payments from Previous Period | RESRPREVADVPAYTAX | CURR | 15(2) | RECACURR | ||||
PREVMINRENTNET | Net Amount of Minimum Rent from Previous Period | RESRPREVMINRENTNET | CURR | 15(2) | RECACURR | ||||
PREVMINRENTTAX | Tax Amount of Minimum Rent from Previous Period | RESRPREVMINRENTTAX | CURR | 15(2) | RECACURR | ||||
PREVMAXRENTNET | Net Amount of Maximum Rent from Previous Period | RESRPREVMAXRENTNET | CURR | 15(2) | RECACURR | ||||
PREVMAXRENTTAX | Tax Amount of Maximum Rent from Previous Period | RESRPREVMAXRENTTAX | CURR | 15(2) | RECACURR | ||||
ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | RECABOOL | ||||
INFOCOND | Statistical or Informational Condition | RECDINFOCOND | CHAR | 1 | RECABOOL | ||||
ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | RECABOOL | ||||
CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCCURRKEY | Local Currency | RECACTLCCURRKEY | CUKY | 5 | Assigned to domain | WAERS | |||
CTRULE | Currency Translation Rule | RECACTRULE | CHAR | 20 | Assigned to domain | RECACTRULE | |||
CTRATE | Exchange Rate | RECACTRATE | DEC | 9(5) | EXCRT | KURSF | |||
CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | DATS | ||||
CTLCPOST | Post in Local Currency | RECACTLCPOST | CHAR | 1 | RECABOOL | ||||
POSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | RECABOOL | ||||
CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | RECAGUID | ||||
USECF4POST | Use Periodic Posting Run for Posting | RESRUSECF4POST | CHAR | 1 | RECABOOL | ||||
BASICFEENET | Net Amount of Base Fee | RESRBASICFEENET | CURR | 15(2) | RECACURR | ||||
BASICFEETAX | Tax Amount of Base Fee | RESRBASICFEETAX | CURR | 15(2) | RECACURR | ||||
PREVBASICFEENET | Net Amount of Base Fee from Previous Period | RESRPREVBASICFEENET | CURR | 15(2) | RECACURR | ||||
PREVBASICFEETAX | Tax Amount of Base Fee from Previous Period | RESRPREVBASICFEETAX | CURR | 15(2) | RECACURR |
Key field | Non-key field |
How do I retrieve data from SAP table VISRCALCSUM using ABAP code
The following ABAP code Example will allow you to do a basic selection on VISRCALCSUM to SELECT all data from the tableDATA: WA_VISRCALCSUM TYPE VISRCALCSUM.
SELECT SINGLE *
FROM VISRCALCSUM
INTO CORRESPONDING FIELDS OF WA_VISRCALCSUM
WHERE...
How to access SAP table VISRCALCSUM
Within an ECC or HANA version of SAP you can also view further information about VISRCALCSUM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects