HANA 层级遍历
1. 创建表并插入数据
PARENT_SON_TREE
CREATE
COLUMN TABLE "PARENT_SON_TREE" (
"MATNR" NVARCHAR(10),
"P_ID" NVARCHAR(255),
"ID" NVARCHAR(10)
)
![](https://img-blog.csdn.net/20181024150520202?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2pvYW5fbmFu/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70)
PARENT_SON_TREE_TEMP
CREATE
COLUMN TABLE "PARENT_SON_TREE_TEMP" (
"STR" NVARCHAR(10),
"P_ID" NVARCHAR(25),
"ID" NVARCHAR(10)
)