1. SAP Tutorial
  2. Real Estate Management

VISRCALCCTFC SAP table for – Amounts in Foreign Currency

Here we would like to draw your attention to VISRCALCCTFC 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). VISRCALCCTFC is a SAP standard transp table used for storing Amounts in Foreign Currency related data in SAP. It comes under the package RE_SR_CL.

SAP VISRCALCCTFC table

Table VISRCALCCTFC technical data

TableVISRCALCCTFC
Data storingAmounts in Foreign Currency
ModuleRE
Sub ModuleRE-FX-SR
SAP PackageRE_SR_CL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VISRCALCCTFC 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 VISRCALCCTFC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • CTFCGUID : Unique Internal Key for Amounts in Foreign Currency
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Key Fields of Table VISRCALCCTFC
  • OBJGUID : Reference Within Results Tables
    Its data type is RAW (Byte string) with field length 16
  • CTFCCURRKEY : Foreign 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
  • 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
  • .INCLUDE : Non-Key Fields of Table VISRCALCCTFC
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • 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
  • 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
  • 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

    • VISRCALCCTFC related tables

    • VISRCALCSUM : Calculation Results per Sales Rule
    • VISRCALCCTFC : Amounts in Foreign Currency
    • VISRCALCDETAIL : Results of Sales Grading Calculation
    • VISRCALCSB : Interim Result
    • VISRCRSPLIT : Split Receivable
    • VISRCALCADVPAY : Reference to Advance Payment Used
    • VISRCALCSALES : Reference to Sales Report Used

    VISRCALCCTFC related transaction codes under SAP package RE_SR_CL

    • RESRCL : Display Results of Calculation

    Related References

    Related Tutorials

    VISRCALCSUM SAP table for – Calculation Results per Sales Rule

    VISRCALCSUM table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCS_RO_CN SAP table for – Costs and Measurement Amounts for REC + RO (Lease-Out View)

    VISCS_RO_CN table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISRCALCDETAIL SAP table for – Results of Sales Grading Calculation

    VISRCALCDETAIL table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    DFKKCJK SAP table for – Data for Change Amounts at Cash Desk – Different Currency

    DFKKCJK table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    VICDCONDDIST SAP table for – Conditions – Distribution Factors and Transfer Amounts

    VICDCONDDIST table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISRCALCSB SAP table for – Interim Result

    VISRCALCSB table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VICDCONDCALC SAP table for – Conditions – Calculation Factors and Condition Amounts

    VICDCONDCALC table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »