1. E9.2 F0150 Address Organization Structure Master - Find Top Parent with SQL

    In order to do some reporting outside of E1, I need to find the top parent for any given child in F0150. The hierarchies vary in the number of levels and the child entered may not be the bottom child. How can I accomplish this in a SQL query? I'm hoping someone has done this before and I...
  2. Matrix Items

    Hi, does anyone has already set up Matrix Items? I am trying to use that for a company with an specific problem: They have an Item and this item may have "multiple" sub-items, they have a "PANT" item but this pant have Size and Color (size = S=01, M=02, L=03, XL=04) and (color = Beige=01...