VISRCALCSUM SAP table for – Calculation Results per Sales Rule

Here we would like to draw your attention to VISRCALCSUM table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VISRCALCSUM is a SAP standard transp table used for storing Calculation Results per Sales Rule related data in SAP. It comes under the package RE_SR_CL.

SAP VISRCALCSUM table

Table VISRCALCSUM technical data

TableVISRCALCSUM
Data storingCalculation Results per Sales Rule
ModuleRE
Sub ModuleRE-FX-SR
SAP PackageRE_SR_CL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VISRCALCSUM Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VISRCALCSUM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OBJGUID : Reference Within Results Tables
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Key Fields of Table VISRCALCSUM
  • INTRENO : Internal Key of Real Estate Object
    Its data type is CHAR (Character String) with field length 13
  • TERMTYPE : Term Category
    Its data type is CHAR (Character String) with field length 4
  • TERMNO : Term Number
    Its data type is CHAR (Character String) with field length 4
  • RHYTHMTYPE : Type of Frequency
    Its data type is CHAR (Character String) with field length 4
  • PFROM : Period Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PTO : Period End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VERSION : Version of Calculation
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Non-Key Fields of Table VISRCALCSUM
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • PARTNEROBJNR : Object Number for Internal Use
    Its data type is CHAR (Character String) with field length 22
  • CONDTYPE : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • CREDITPAYBACK : Credits Withing Cumulative Settlement Are Paid
    Its data type is CHAR (Character String) with field length 1
  • SALESCURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TERMNOPY : Term Number of Posting Rule
    Its data type is CHAR (Character String) with field length 4
  • TAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • TAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • TAXDATE : Date for defining tax rates
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SALESRENTNET : Net Amount of Sales-Based Rent
    Its data type is CURR (Currency Field) with field length 15
  • SALESRENTTAX : Tax Amount of Sales-Based Rent
    Its data type is CURR (Currency Field) with field length 15
  • ADVPAYNET : Net Amount of Advanced Payment
    Its data type is CURR (Currency Field) with field length 15
  • ADVPAYTAX : Tax Amount of Advance Payment
    Its data type is CURR (Currency Field) with field length 15
  • PAYNET : Net Amount of Payments Already Made
    Its data type is CURR (Currency Field) with field length 15
  • PAYTAX : Tax Amount from Payments Already Made
    Its data type is CURR (Currency Field) with field length 15
  • MINRENTNET : Net Amount of Minimum Rent for Sales-Based Rent Contracts
    Its data type is CURR (Currency Field) with field length 15
  • MINRENTTAX : Tax Amount of Minimum Rent for Sales-Based Rent Contracts
    Its data type is CURR (Currency Field) with field length 15
  • MAXRENTNET : Net Amount of Maximum Rent for Sales-Based Rent Contracts
    Its data type is CURR (Currency Field) with field length 15
  • MAXRENTTAX : Tax Amount of Maximum Rent for Sales-Based Rent Contracts
    Its data type is CURR (Currency Field) with field length 15
  • RECEIVABLENET : Net Amount of Receivable
    Its data type is CURR (Currency Field) with field length 15
  • RECEIVABLETAX : Tax Amount of Receivable
    Its data type is CURR (Currency Field) with field length 15
  • BALANCENET : Net Amount of Balance
    Its data type is CURR (Currency Field) with field length 15
  • BALANCETAX : Tax Amount of Balance
    Its data type is CURR (Currency Field) with field length 15
  • PREVBALANCENET : Net Amount of Balance from Prior Settlement
    Its data type is CURR (Currency Field) with field length 15
  • PREVBALANCETAX : Tax Amount of Balance from Prior Settlement
    Its data type is CURR (Currency Field) with field length 15
  • PREVPAYNET : Net Amount of Payment from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVPAYTAX : Tax Amount of Payment from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVADVPAYNET : Net Amount of Advance Payments from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVADVPAYTAX : Tax Amount of Advance Payments from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVMINRENTNET : Net Amount of Minimum Rent from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVMINRENTTAX : Tax Amount of Minimum Rent from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVMAXRENTNET : Net Amount of Maximum Rent from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVMAXRENTTAX : Tax Amount of Maximum Rent from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • ISCDSPLIT : Condition Split
    Its data type is CHAR (Character String) with field length 1
  • INFOCOND : Statistical or Informational Condition
    Its data type is CHAR (Character String) with field length 1
  • ISGROSS : Condition Amount Is Gross Amount
    Its data type is CHAR (Character String) with field length 1
  • CTLCGROSSAMOUNT : Gross Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCNETAMOUNT : Net Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCTAXAMOUNT : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCCURRKEY : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • CTRATE : Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CTDATEACT : Actual Translation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CTLCPOST : Post in Local Currency
    Its data type is CHAR (Character String) with field length 1
  • POSTCDCURR : Post in Condition Currency
    Its data type is CHAR (Character String) with field length 1
  • CONDGUID : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • USECF4POST : Use Periodic Posting Run for Posting
    Its data type is CHAR (Character String) with field length 1
  • BASICFEENET : Net Amount of Base Fee
    Its data type is CURR (Currency Field) with field length 15
  • BASICFEETAX : Tax Amount of Base Fee
    Its data type is CURR (Currency Field) with field length 15
  • PREVBASICFEENET : Net Amount of Base Fee from Previous Period
    Its data type is CURR (Currency Field) with field length 15
  • PREVBASICFEETAX : Tax Amount of Base Fee from Previous Period
    Its data type is CURR (Currency Field) with field length 15