J_3RFREP_VALFMT SAP table for – Predefined Attributes for the Reporting Hierarchy Elements

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

SAP J_3RFREP_VALFMT table

Table J_3RFREP_VALFMT technical data

TableJ_3RFREP_VALFMT
Data storingPredefined Attributes for the Reporting Hierarchy Elements
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_VALFMT 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_VALFMT 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 : Attribute Value Format Options
  • VAL_TYPE : Value Type of Reporting Hierarchy Object Attribute
    Its data type is CHAR (Character String) with field length 2
  • VAL_MIN_LENGTH : Minimum Length of Reporting Hierarchy Element
  • VAL_MAX_LENGTH : Maximum Length of Reporting Hierarchy Element
  • VAL_MIN_INCLUSIV : Minimal Element Value (inclusive)
    Its data type is D16D (Decimal Floating Point, 16 Digits, decimal on Database) with field length 15
  • VAL_MAX_INCLUSIV : Maximal Element Value (inclusive)
    Its data type is D16D (Decimal Floating Point, 16 Digits, decimal on Database) with field length 15
  • VAL_MIN_EXCLUSIV : Minimal Element Value (exclusive)
    Its data type is D16D (Decimal Floating Point, 16 Digits, decimal on Database) with field length 15
  • VAL_MAX_EXCLUSIV : Maximal Element Value (exclusive)
    Its data type is D16D (Decimal Floating Point, 16 Digits, decimal on Database) with field length 15
  • VAL_FRAC_DIGTS : Decimal Places Number in Reporting Hierarchy Element Value
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • VAL_OUT_FMT : Formatting pattern for internal vars:date,time etc
    Its data type is CHAR (Character String) with field length 50
  • PRESET_ID : Reporting Hierarchy Element Preset
    Its data type is CHAR (Character String) with field length 8