J_3RFIN_RATE_CLC SAP table for – Downpayments rate calculator for foreign currency – invoices

Here we would like to draw your attention to J_3RFIN_RATE_CLC table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_3RFIN_RATE_CLC is a SAP standard transp table used for storing Downpayments rate calculator for foreign currency – invoices related data in SAP. It comes under the package J3RF.

SAP J_3RFIN_RATE_CLC table

Table J_3RFIN_RATE_CLC technical data

TableJ_3RFIN_RATE_CLC
Data storingDownpayments rate calculator for foreign currency – invoices
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LIFNR : Account Number of Vendor or Creditor
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • KUNNR : Customer Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • BELNR_INV : Number of invoice
    Its data type is CHAR (Character String) with field length 10
  • RATE_INV : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DMBTR_INV : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • WRBTR_INV : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • WAERS_INV : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AWKEY_INV : Object key
    Its data type is CHAR (Character String) with field length 20
  • RATE_CLR : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • GJAHR_INV : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUKRS_INV : Company Code
    Its data type is CHAR (Character String) with field length 4
  • CLR_AUTO : Character Field Length 1
    Its data type is CHAR (Character String) with field length 1
  • CLR_BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • CLR_RSTGR : Reason Code for Payments
    Its data type is CHAR (Character String) with field length 3
  • CLR_PART : Character Field Length 1
    Its data type is CHAR (Character String) with field length 1