Sap Fiori Tree Table

SAP Fiori Tree Table with Recursive Hierarchy

Purpose

Configure hierarchical tree table to display parent-child relationships in a recursive structure (organizational hierarchies, category trees, nested data).

Environment Requirements

CAP Projects:

• ✅ VS Code or SAP Business Application Studio (BAS) - Both environments supported
• ✅ Fiori MCP Server - Required for Fiori app generation and modification (VS Code only)
• ✅ CDS MCP Server - Required for CDS model queries

ABAP RAP Projects:

• ✅ VS Code only - ABAP Development Tools extension is VS Code-specific
• ✅ Fiori MCP Server - Required for Fiori app generation and modification
• ✅ ABAP Development Tools for VS Code extension - Required for backend development (includes ADT MCP server for RAP operations)

MANDATORY: Gather Required Inputs First

STOP and ASK the user for ALL of these inputs if ANY are missing from the prompt:

For ABAP RAP Projects:

1. Package name - Where to create or find backend hierarchy objects ($TMP for local, or specific package like Z_MAINT)
2. Transport Required: Depends on package type (No for local packages like $TMP, Yes for transportable packages)
3. Entity name - The entity to make hierarchical (e.g., "Equipment", "Category", "FunctionalLocation")

For CAP Projects:

1. Entity name - The entity to make hierarchical (e.g., "Travel", "Category", "ProductCategory")

DO NOT proceed with implementation until all inputs are confirmed.

---

CAP Implementation

📖 Complete CAP Implementation Guide

Quick Summary:

• 6-step process: Check entity → Add association → Add @hierarchy → Configure manifest → Create data → Test
• Supports UUID, String, and Integer keys (single key only)
• Requires @sap/cds 9.6.0+ and OData V4
• Use CDS MCP to search model before editing

---

ABAP RAP Implementation

📖 Complete RAP Implementation Guide

Quick Summary:

• 4-step process: Check existing hierarchy → Implement backend → Configure manifest → Test
• Decision required: Read-only (List Report only) vs. Editable (with Object Page)
• For detailed backend implementation:
  • Read-Only Treeviews Guide
  • Editable Treeviews Guide

---

Quick Troubleshooting

CAP Common Issues

• "@hierarchy not supported" → Use managed association (no on condition)
• "table has no column" → Use parent_ID (with underscore) in CSV
• "TreeTable not rendering" → Check type: "TreeTable" and hierarchyQualifier in manifest

ABAP RAP Common Issues

• "Element must not be search enabled" → Remove @Search annotations from hierarchy projection view
• "Primary keys do not match" → Child table needs composite key (child UUID + parent UUID)

📖 Full error reference in implementation guides

---

Key Differences

CAP:

• Managed association in entity
• @hierarchy annotation on service
• CSV data with parent_ID column
• Test with npm run watch

ABAP RAP:

• CDS view with @OData.hierarchy.recursiveHierarchy
• Qualifier in metadata
• Test data in database tables
• Test with npm start or npm run start-mock