<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>
Jake:<BR>
<BR>
Just create a virtual atribute (multi-lines, as you can have more than one material for each routing) and do the select on the mapl table.<BR>
<BR>
Something like this:<BR>
<BR>
select * <BR> into table t_mapl <BR> from mapl <BR> where plnnr eq object-key-group <BR> and plnal eq object-key-groupcounter. <BR> <BR>Regards,<BR>
Flávio.<BR><BR><BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #008080 2px solid; MARGIN-RIGHT: 0px">
<HR>
Subject: Routing/Material Master Issue<BR>Date: Mon, 26 Mar 2007 13:29:51 -0500<BR>From: jake.schmidt@spiritaero.com<BR>To: sap-wug@mit.edu<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<DIV><SPAN class=EC_500522218-26032007><FONT face=Arial size=2>WUGites,</FONT></SPAN></DIV>
<DIV><SPAN class=EC_500522218-26032007><FONT face=Arial size=2>I'm currently trying to "get" the material master # for a routing. Most routing information is in table PLKO. When a user launches Tcode CA02 they can display a routing by using the Material number or the group number. PLKO only cares about the group number and group counter, but somewhere there has to be the material number. I believe I found in in table MAPL. However the material number is a key field in this table. I can't add a keyfield to an attribute of my business object.</FONT></SPAN></DIV>
<DIV><SPAN class=EC_500522218-26032007><FONT face=Arial size=2>Does anyone have any advice on how to get the material number into my workflow container so I can use it? I've tried just creating an element in my WF container to include MAPL-MATNR but that doesn't work. A group # and a group counter # should equal a material master number. I need that Material number. </FONT></SPAN></DIV>
<DIV><SPAN class=EC_500522218-26032007><FONT face=Arial size=2>Thanks!</FONT></SPAN></DIV>
<DIV><SPAN class=EC_500522218-26032007><FONT face=Arial size=2>Jake Schmidt</FONT></SPAN></DIV>
<DIV><SPAN class=EC_500522218-26032007><FONT face=Arial size=2>Spirit AeroSystems</FONT></SPAN></DIV></BLOCKQUOTE><br /><hr />Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! <a href='http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us' target='_new'>Try it!</a></body>
</html>