SAP VISRCALCCTFC Amounts in Foreign Currency Table
Overview
VISRCALCCTFC is a standard SAP S/4HANA table that stores Amounts in Foreign Currency data. There are total 34 fields in the VISRCALCCTFC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISRCALCCTFC 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 VISRCALCCTFC to other SAP tables and standard CDS views available based on VISRCALCCTFC table in S/4HANA 2020.
Techincal Settings of VISRCALCCTFC
Below are technical details of the table VISRCALCCTFC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISRCALCCTFC Fields
The following table gives you an overview of the fields available in VISRCALCCTFC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| CTFCGUID | Unique Internal Key for Amounts in Foreign Currency | RESRCTFCGUID | RAW | 16 | |
| OBJGUID | Reference Within Results Tables | RESRSBRESULTGUID | VISRCALCSUM | RAW | 16 |
| CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | * | CUKY | 5 |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| TAXTYPE | Tax Type | RERATAXTYPE | * | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | * | CHAR | 20 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| TAXDATE | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | VICAPROCESSID | RAW | 16 |
| 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 | |
| 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 | |
| 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 VISRCALCCTFC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISRCALCCTFC | OBJGUID | : | VISRCALCSUM |
| VISRCALCCTFC | PROCESSGUID | : | VICAPROCESSID |