HANA SQL Recursive Code for Material Costing Itemization (loop over CKIS table)

[sajithr]

Dear Experts,

It is possible to see material itemization (BOM exploration) through CK13N T-code but it is limited only one material at a time. To see mass level itemization, say for example, material type wise, we need to create a customized query for the same.

But how to do it using CKIS table, is a concern. We know for a fact that CKIS tables has a field named "Assembly" (BAUGR) which can be used to link/find out descendant materials. Of course, we prefer to have table like output where for each top-level material, dependent materials and their quantity and values are displayed in the same structure.

What is the best way to achieve this; using a procedure, table function? What about the possible use of "WITH RECURSIVE" or hierarchy functions? Because, as far as we can understand, through "Assembly" (BAUGR) there is a sort of "Parent-Child" relationship as well.

Highly appreciate your comments and possible sample code snippets using HANA SQL or SQLScript.

Thank you in advanced.

[sajithr]

Is it okay to use CURSOR for this kind of implementation?