Hello,
I have two planning areas <b>AREA1</b> and <b>AREA2</b>.
I have created a multi planning area <b>MAREA3</b> (which contains AREA1 and AREA2).
I created a planning function in MAREA3, under which is a FOX Formula.
The structures of AREA1 and AREA2 areas are mostly identical except for 1 field (call it <b>SUB</b>) which exists in AREA2.
In my FOX formula I copy the data from AREA1 to AREA2, and all values are copied OK except for <b>SUB</b>. When I view master data for SUB, I have the data I need to "build" the value from other fields in AREA1 (like a transcodification table).
My question, in the FOX formula, how do I use/read this master data table to get my value for SUB??
Thanks,
Tim