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

Here we would like to draw your attention to J_3RFREP_PRESETS 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_PRESETS 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_PRESETS table

Table J_3RFREP_PRESETS technical data

TableJ_3RFREP_PRESETS
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_PRESETS 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_PRESETS table.

  • .INCLUDE : Whole key of the Reporting Hierarchy Predefined Attribute
    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 the Reporting Hierarchy Predefined Attribute
    Its a key field.
  • PRESET_ID : Reporting Hierarchy Element Preset
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Predefined Attributes for the Reporting Hierarchy Elements
  • 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_PATTERN : Value Pattern for Reporting Hierarchy Element
    Its data type is CHAR (Character String) with field length 100