Is there a way to get a BOM style output (SAP CS12) from a set of parent child relationships in R?

Asked Jul 07 '20 at 21:36

Active Jan 06 '21 at 21:54

Viewed 1,105 times

I am trying to download all Bill of Materials from SAP backend tables, but can only get 1 level deep for each part. So, my data is in the form of thousands of parent-child relationships of unknown depth.

df <- data.frame(parent = c("Finished Part A", "Finished Part A", "Part 2", "Part 3"), child = c("Part 1", " Part 2",  "Part 3", "Part 4"))

Is there a way to build these parent-child relationships into a tree to see which Finished Parts each child goes in to? For example, how would I be able to see that Part 3 is a part of Finished Part A.

One desired output would be in the style of the SAP CS12 view.

Currently, as I only have parent child relationships, I can only see 1 "explosion level" deep into each part.

edited Jan 06 '21 at 19:34

Sandra Rossi

11,934
5
22
48

asked Jul 07 '20 at 21:36

MS529

So what's the desired output here? – MrFlick Jul 07 '20 at 21:37
A Multilevel Bill of Material that mirrors the output of the SAP CS12 view. – MS529 Jul 07 '20 at 21:46
Or a data.tree object where I can, for example, look up "Part 3" and see that it is used in "Finished Part A" – MS529 Jul 07 '20 at 21:47
Is that format defined somewhere? Can you give an example in your question? – MrFlick Jul 07 '20 at 21:48

Is there a way to get a BOM style output (SAP CS12) from a set of parent child relationships in R?

0 Answers0