FAGL_R_DERH SAP table for – Reorganization: Derivation Hierarchy

Here we would like to draw your attention to FAGL_R_DERH table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). FAGL_R_DERH is a SAP standard transp table used for storing Reorganization: Derivation Hierarchy related data in SAP. It comes under the package FAGL_REORGANIZATION_FW.

SAP FAGL_R_DERH table

Table FAGL_R_DERH technical data

TableFAGL_R_DERH
Data storingReorganization: Derivation Hierarchy
ModuleFI
Sub ModuleFI-GL-REO
SAP PackageFAGL_REORGANIZATION_FW
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PLAN_TYPE : Reorganization Plan Type
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • VERSION : Version of a Derivation Hierarchy
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • NODE_ID : Node in the Derivation Hierarchy
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NODE_ID_SUP : Node in the Derivation Hierarchy
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SEQNR : Sequence Number for Restriction Characteristics
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • OBJ_TYPE : Object Type
    Its data type is CHAR (Character String) with field length 4