SAP AFX_TREEDEF Hierarchy Tree Definition Table
Overview
AFX_TREEDEF is a standard SAP S/4HANA table that stores Hierarchy Tree Definition data. There are total 12 fields in the AFX_TREEDEF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFX_TREEDEF belongs to Generating, Monitoring for Mass Data Archiving Solutions (CA-GTF-TS-GMA) module and is located in the package Archiving Framework: Generator (AFX_GENERATOR).
In addition, following links provide an overview of foreign key relationships, if any, that link AFX_TREEDEF to other SAP tables and standard CDS views available based on AFX_TREEDEF table in S/4HANA 2020.
Techincal Settings of AFX_TREEDEF
Below are technical details of the table AFX_TREEDEF
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFX_TREEDEF Fields
The following table gives you an overview of the fields available in AFX_TREEDEF
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| NODE | Node in Hierarchy Tree | AFX_DTE_NODE | NUMC | 5 | |
| PARENT | Reference to Preceding Node in Hierarchy Tree | AFX_DTE_PARENTNODE | NUMC | 5 | |
| DOCUMENTATION | Documentation Object | DOKU_OBJ | CHAR | 60 | |
| TCODE | Transaction Code | TCODE | TSTC | CHAR | 20 |
| REPID | ABAP Program Name | PROGNAME | TRDIR | CHAR | 40 |
| FUNCNAME | Name of Function Module | RS38L_FNAM | TFDIR | CHAR | 30 |
| FUNCNAME_UNDO | Name of Function Module | RS38L_FNAM | * | CHAR | 30 |
| IS_OBLIGATORY | Node must have an executable function | AFX_DTE_EXEC_IS_OBLIGATORY | CHAR | 1 | |
| NO_PRED_CHECK | Deactivate Check for Processing of Predecessor Node | AFX_DTE_NO_PRED_CHECK | CHAR | 1 | |
| STATUS_MANUAL | Node Status Set Manually Online | AFX_DTE_STATUS_MANUAL | CHAR | 1 | |
| POST_EDIT_TASK | This task is a postprocessing step | AFX_DTE_POST_EDIT_TASK | CHAR | 1 | |
| NAV_POINT | Navigation Point in ABAP Source | AFX_DTE_NAV_POINT | CHAR | 72 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFX_TREEDEF
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFX_TREEDEF | FUNCNAME | 1: CN | TFDIR |
| AFX_TREEDEF | REPID | 1: CN | TRDIR |
| AFX_TREEDEF | TCODE | 1: CN | TSTC |