J_3RFREP_DICT SAP table for – Dictionary Values for Reporting Hierarchy Object Attribute

Here we would like to draw your attention to J_3RFREP_DICT 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_3RFREP_DICT is a SAP standard transp table used for storing Dictionary Values for Reporting Hierarchy Object Attribute related data in SAP. It comes under the package J3RFTAX.

SAP J_3RFREP_DICT table

Table J_3RFREP_DICT technical data

TableJ_3RFREP_DICT
Data storingDictionary Values for Reporting Hierarchy Object Attribute
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RFTAX
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RFREP_DICT 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_3RFREP_DICT table.

  • .INCLUDE : Whole Key of Dict. Values for Reporting Hierarchy Obj. Attr.
    Its a key field.
  • .INCLUDE : Whole Key of the Reporting Hierarchy Object Attribute
    Its a key field.
  • .INCLUDE : Whole Key of the Reporting Hierarchy Object
    Its a key field.
  • .INCLUDE : Key Fields of Reporting Hierarchy Object
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • HIER_KEY : Reporting Hierarchy Code
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : Key Fields of Reporting Hierarchy Object
    Its a key field.
  • NODE_CODE : Reporting Hierarchy Object classification code
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Key Fields of the Reporting Hierarchy Object Attribute
    Its a key field.
  • EXACT_NAME : Reporting Object Attribute
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Key fields of Dict. Values Table for Rep. Hier. Obj. Attr.
    Its a key field.
  • INTERNAL_IDX : Internal Index for Reporting Hierarchy Elements
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • .INCLUDE : Dictionary Values for Reporting Hierarchy Object Attribute
  • DICT_VALUE : Dictionary Value of Hierarchy Attribute
    Its data type is CHAR (Character String) with field length 100