{"status":"success","message":"","http_code":200,"data":{"type":"message","id":"14202772","href":"/messages/14202772","view_href":"https://community.sap.com/t5/technology-blog-posts-by-sap/tree-table-support-in-cap-is-now-generally-available/ba-p/14202772","author":{"type":"user","id":"41902","href":"/users/41902","view_href":"https://community.sap.com/t5/user/viewprofilepage/user-id/41902","login":"BirgitS"},"subject":"Tree-Table Support in CAP is Now Generally Available","body":"<P><SPAN>Since July, the Tree-Table Support in the SAP Cloud Programming Model (CAP) is generally available. This exciting milestone represents the culmination of months of dedicated work. Our journey began in February with the initial release of <A href=\"https://cap.cloud.sap/docs/releases/archive/2025/feb25#hierarchy-maintenance-in-tree-table\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Hierarchy Maintenance in the Tree Table for Java</A>, followed in March by <A href=\"https://cap.cloud.sap/docs/releases/archive/2025/mar25#recursive-hierarchies-and-fiori-tree-table-support\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Recursive Hierarchies and Fiori Tree Table support for Node.js</A> in beta. Since then, we’ve consistently rolled out new features in beta, leading up to July 2025 when we officially announced that CAP's tree view support has exited beta and <A href=\"https://cap.cloud.sap/docs/releases/july25#fiori-tree-views-ga\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">is now generally available</A>.</SPAN></P><P><STRONG><SPAN>Key Features</SPAN></STRONG></P><UL><LI><STRONG><SPAN>Hierarchical Entities Definition</SPAN></STRONG><SPAN>: Use standard OData/Fiori annotations to define hierarchical entities.</SPAN></LI><LI><STRONG><SPAN>Hierarchical Queries</SPAN></STRONG><SPAN>: Hierarchical queries from the underlying <A href=\"https://www.sap.com/design-system/fiori-design-web/ui-elements/tree-table/?external\" target=\"_blank\" rel=\"noopener noreferrer\">SAPUI5 Tree Table</A> components are generically served by CAP runtimes.</SPAN></LI><LI><STRONG><SPAN>Read-Only Usage</SPAN></STRONG><SPAN>: Hierarchical entities can be used in read-only mode in List Views and Value Helps, including expanding/collapsing of an entire tree or separate nodes as well as sort, filter, and search functionalities on hierarchical data.</SPAN></LI></UL><P><span class=\"lia-inline-image-display-wrapper lia-image-align-center\" image-alt=\"TreeTables1.png\" style=\"width: 540px;\"><img src=\"https://community.sap.com/t5/image/serverpage/image-id/307285iD479D795CD0BD6BC/image-size/large?v=v2&amp;px=999\" role=\"button\" title=\"TreeTables1.png\" alt=\"TreeTables1.png\" /></span></P><UL><LI><STRONG><SPAN>Modification Capabilities for&nbsp;</SPAN></STRONG><SPAN><A href=\"https://cap.cloud.sap/docs/advanced/fiori#draft-support\" target=\"_blank\" rel=\"noopener nofollow noreferrer\"><STRONG>draft enabled</STRONG></A><STRONG>&nbsp;entities:</STRONG></SPAN><UL class=\"lia-list-style-type-circle\"><LI><STRONG><SPAN>Node Operations</SPAN></STRONG><SPAN>: Create new nodes, add them as root or child nodes, modify and delete nodes, and change a parent of a child node (node movement).</SPAN></LI></UL></LI></UL><P><SPAN><span class=\"lia-inline-image-display-wrapper lia-image-align-center\" image-alt=\"TreeTables2.png\" style=\"width: 403px;\"><img src=\"https://community.sap.com/t5/image/serverpage/image-id/307287i237D10B3F09CDA4D/image-size/large?v=v2&amp;px=999\" role=\"button\" title=\"TreeTables2.png\" alt=\"TreeTables2.png\" /></span></SPAN></P><UL><UL class=\"lia-list-style-type-circle\"><LI><STRONG><SPAN>Hierarchy Management</SPAN></STRONG><SPAN>: Deleting a node will cascade the deletion to its descendant nodes if they are in a composition relationship with the deleted node.</SPAN></LI><LI><STRONG><SPAN>Object Page Support</SPAN></STRONG><SPAN>: The same set of modifications is supported on the Object Page, with the main difference, that all nodes on the List View have their own drafts, but all nodes on the Object Page belong to the same draft.</SPAN></LI></UL><LI><STRONG><SPAN>Database Support</SPAN></STRONG><SPAN>:</SPAN></LI><UL class=\"lia-list-style-type-circle\"><LI><SPAN>For<STRONG> Java</STRONG> we already support SAP HANA and H2, with PostgreSQL to follow.</SPAN></LI><LI><SPAN>For<STRONG> Node.js</STRONG> we support SAP HANA, SQLite, and PostgreSQL.</SPAN></LI></UL></UL><P><STRONG><SPAN>Current Limitations</SPAN></STRONG></P><P><SPAN>We want to keep you informed about what’s not (yet) supported so you can plan accordingly:</SPAN></P><UL><LI><SPAN>Interception and modification of hierarchical queries in custom handlers </SPAN></LI><LI><SPAN>Arbitrary OData query options other than the ones served today for SAPUI5 Tree Table</SPAN></LI></UL><P><STRONG><SPAN>Get Started</SPAN></STRONG></P><UL><LI><STRONG><SPAN>Demo</SPAN></STRONG><SPAN>: Check out our demo session recording from <A href=\"https://recap-conf.dev/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">reCAP 2025</A>:&nbsp;<A href=\"https://www.youtube.com/watch?v=qZpWvwayIP8&amp;list=PLJDFklpD_2cTjReIS8xQ2L0HnfjoxPUxd&amp;index=11\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">TreeTables Support in CAP</A>.</SPAN></LI><LI><STRONG><SPAN>Try it out</SPAN></STRONG><SPAN>: Explore the new features in our bookshop sample apps for&nbsp;<A href=\"https://github.com/SAP-samples/cloud-cap-samples-java\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">CAP Java</A>&nbsp;and&nbsp;<A href=\"https://github.com/capire/samples\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">CAP Node.js</A>.</SPAN></LI></UL><P><SPAN>The general availability of Tree-Table Support in CAP opens up a wealth of opportunities to streamline hierarchical data management. We encourage you to dive in, explore the capabilities, and share your experiences with the community. </SPAN></P><P><SPAN>Happy coding!</SPAN></P>","teaser":"<P>Since July, the Tree-Table Support in the SAP Cloud Programming Model (CAP) is generally available.</P>","board":{"type":"board","id":"technology-blog-sap","href":"/boards/technology-blog-sap","view_href":"https://community.sap.com/t5/technology-blog-posts-by-sap/bg-p/technology-blog-sap"},"conversation":{"type":"conversation","id":"14202772","href":"/conversations/14202772","view_href":"https://community.sap.com/t5/technology-blog-posts-by-sap/tree-table-support-in-cap-is-now-generally-available/ba-p/14202772","style":"blog","thread_style":"blog","messages_count":3,"solved":false,"last_post_time":"2026-01-21T17:27:47.243+01:00","last_post_time_friendly":"2026 Jan 21"},"topic":{"type":"message","id":"14202772","href":"/messages/14202772","view_href":"https://community.sap.com/t5/technology-blog-posts-by-sap/tree-table-support-in-cap-is-now-generally-available/ba-p/14202772"},"post_time":"2025-09-01T11:31:42.912+02:00","post_time_friendly":"2025 Sep 01","depth":0,"read_only":false,"edit_frozen":false,"language":"EN","can_accept_solution":false,"placeholder":false,"is_solution":false,"solution_data":{},"metrics":{"type":"message_metrics","views":2474},"current_revision":{"type":"revision","id":"14202772_10","last_edit_author":{"type":"user","id":"41902","href":"/users/41902","view_href":"https://community.sap.com/t5/user/viewprofilepage/user-id/41902","login":"BirgitS"},"last_edit_time":"2025-09-01T11:18:54.486+02:00"},"kudos":{"query":"SELECT * FROM kudos WHERE message.id = '14202772'"},"tags":{"query":"SELECT * FROM tags WHERE messages.id = '14202772'"},"labels":{"query":"SELECT * FROM labels WHERE messages.id = '14202772'"},"images":{"query":"SELECT * FROM images WHERE messages.id = '14202772'"},"videos":{"query":"SELECT * FROM videos WHERE messages.id = '14202772'"},"attachments":{"query":"SELECT * FROM attachments WHERE message.id = '14202772'"},"replies":{"query":"SELECT * FROM messages WHERE parent.id = '14202772'"},"ratings":{"query":"SELECT * FROM ratings WHERE message.id = '14202772'"},"custom_tags":{"query":"SELECT * FROM custom_tags WHERE messages.id = '14202772'"},"moderation_status":"approved","visibility_scope":"public","user_context":{"type":"user_context","kudo":false,"read":false,"can_reply":false,"can_kudo":false,"can_delete":false},"message_type":"blog_topic_message","popularity":6.89864496423422E-6,"excluded_from_kudos_leaderboards":false,"latest_version":{"type":"friendly_version","major":"1","minor":"0"},"include_hidden_messages":true,"content_workflow":{"type":"content_workflow","state":"publish","message_draft_history":{"query":"SELECT * FROM message_draft_history WHERE message.id = '14202772'"},"user_context":{"type":"message_workflow_context","can_edit":false,"can_schedule":false},"view_href":"https://community.sap.com/t5/blogs/blogworkflowpage/blog-id/technology-blog-sap/article-id/184165"},"is_promoted":false},"metadata":{}}