HANA 层级遍历
1. 创建表并插入数据
PARENT_SON_TREE
CREATE
COLUMN TABLE "PARENT_SON_TREE" (
"MATNR" NVARCHAR(10),
"P_ID" NVARCHAR(255),
"ID" NVARCHAR(10)
)
PARENT_SON_TREE_TEMP
CREATE
COLUMN TABLE "PARENT_SON_TREE_TEMP" (
"STR" NVARCHAR(10),
"P_ID" NVARCHAR(25),
"ID" NVARCHAR(10)
)
PARENT_SON_TREE_TEMP2
CREATE
COLUMN TABLE "PARENT_SON_TREE_TEMP2" (
"STR" NVARCHA