Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I need to extract Spares Parts from Ellipse
- Thread starter wilobi
- Start date
Archimedez
Instructor
The APl Items are found in MSF131. If the item has a Stock Code, it's description will in MSF100. That is actually a natural join.
In Ellipse, a Stock code can have multiple mfg/part#, which you'll find in MSF110. They can also have muliple vendors, which are in MSF210.
The Component Description is hald in MSF010, Table Type = 'CO'.
Lastly, the equipment assigned is held partially in MSF130 and partially in MSF600; use only the first 2 segments of the 5-part key (13 characters).
In Ellipse, a Stock code can have multiple mfg/part#, which you'll find in MSF110. They can also have muliple vendors, which are in MSF210.
The Component Description is hald in MSF010, Table Type = 'CO'.
Lastly, the equipment assigned is held partially in MSF130 and partially in MSF600; use only the first 2 segments of the 5-part key (13 characters).
- Status