J_3RFREP_ATTR SAP table for – Reporting Hierarchy Object Attributes

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

SAP J_3RFREP_ATTR table

Table J_3RFREP_ATTR technical data

TableJ_3RFREP_ATTR
Data storingReporting Hierarchy Object Attributes
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_ATTR 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_ATTR table.

  • .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 : Main Attributes of Reporting Hierarchy Object
  • ATTR_ID : Reporting Object Attribute ID
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • ATTR_TYPE : Type of Reporting Hierarchy Object Attribute
    Its data type is CHAR (Character String) with field length 2
  • ATTR_MANDATORY : Specifies, whether Reporting Hierarchy Element is mandatory
    Its data type is CHAR (Character String) with field length 1
  • TECH : Flag for Technical Attribute
    Its data type is CHAR (Character String) with field length 1
  • HAVE_EXACTVAL : Attribute have exact value
    Its data type is CHAR (Character String) with field length 1
  • EXACT_VALUE : Exact Value of Hierarchy Attribute
    Its data type is CHAR (Character String) with field length 100
  • DICT_IDX : Internal Index for Reporting Hierarchy Elements
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • ATTR_ROLE : Data Provider Role
    Its data type is CHAR (Character String) with field length 20
  • INVERT_SIGN : Invert sign for all nested attributes
    Its data type is CHAR (Character String) with field length 1
  • HAVE_GROUP : Attribute is Part of Selection Screen Group
    Its data type is CHAR (Character String) with field length 1
  • GROUP_KEY : Group Identifier
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3