topic Re: Routing List in Application Development and Automation Discussions

Routing List

Former Member — Thu, 10 Jul 2008 19:26:05 GMT

Does anyone know which table's i Need to create a Query to display the following info from the routings.

Material Material Description Operation Sub-Oper Work Centre Setup Teardown M/C Run Pack. Operator # of Employees Units Per Minute

Thank you

<MOVED BY MODERATOR TO THE CORRECT FORUM>

Edited by: Alvaro Tejada Galindo on Jul 10, 2008 3:29 PM

Re: Routing List

Former Member — Thu, 10 Jul 2008 19:51:45 GMT

Check the tables:

PLKO Task list - header

PLKZ Task list: main header

PLZU Routing data for group

Regards,

Ravi

Re: Routing List

Former Member — Fri, 11 Jul 2008 17:44:36 GMT

These do not seem to give me what i would like , i have managed to locate most of the info under table SO22, however i cannot seem to find where i can isolate the operation and escpecially the sub operation.

Again any help at all woul dbe appreciated.

Re: Routing List

Former Member — Fri, 11 Jul 2008 20:06:52 GMT

Please Check the tables AFKO, AFPO, and RESB. This should get most of the the information you need. The link between all 3 tables is AUFNR, the Produciton Order Number.

Re: Routing List

muthusamy_sankaran — Tue, 15 Jul 2008 01:50:40 GMT

Hi Clifton,

See below relation for routing table's

Table MAPL, pass input material number, plant, alternative routing group couter

Table PLKO, filed PLNNR, PLNAL eq mapl-plnnr, mapl-plnal

Table PLAS, field PLNNR, PLNAL eq mapl-plnnr, mapl-plnal and LOEKZ ne 'X', take field PLNKN

Table PLPO, field PLNNR, PLNKN eq plas-plnnr, plas-plnkn

you will get correct result same as CA02 list

Pls take note the correct statement is LOEKZ ne 'X'

Regards,

Sankaran

Re: Routing List

Former Member — Tue, 15 Jul 2008 12:55:57 GMT

I'am fairly new to writing Queries , so i need a little help figuring out exactly what is meant by some of the your stmts.

ls see below.

See below relation for routing table's

1) Table MAPL, pass input material number, plant, alternative routing group couter

2) Table PLKO, filed PLNNR, PLNAL eq mapl-plnnr, mapl-plnal

3) Table PLAS, field PLNNR, PLNAL eq mapl-plnnr, mapl-plnal and LOEKZ ne 'X', take field PLNKN

4) Table PLPO, field PLNNR, PLNKN eq plas-plnnr, plas-plnkn

you will get correct result same as CA02 list

Pls take note the correct statement is LOEKZ ne 'X'

1) What do you mean by "pass" is this setup in the infoset or (selection / list in the query) or is this a defined condition in the query?

3) LEOKZ , pls explain how and where this is setup, is it part of my selection list and then criteria is set to "X" , also what does take fiedl PLNKN mean ?

****Would you happen to know which field will give me workcenter & operation - I have located Subop , cannot seem to get aquire Operation or workcenter field.

Thank you

Re: Routing List

muthusamy_sankaran — Wed, 16 Jul 2008 00:27:52 GMT

Hi,

1) What do you mean by "pass" is this setup in the infoset or (selection / list in the query) or is this a defined condition in the query?

Input selection list or list of query

3) LEOKZ , pls explain how and where this is setup, is it part of my selection list and then criteria is set to "X" , also what does take fiedl PLNKN mean ?

filed PLAS-LOEKZ - deletion indicator - if deleted operation line items not taken into routing selection

****Would you happen to know which field will give me workcenter & operation - I have located Subop , cannot seem to get aquire Operation or workcenter field.

you need to join one more table CRHD

PLPO-ARBID = CRHD-OBJID

Regards,

Sankaran

Re: Routing List

Former Member — Wed, 16 Jul 2008 10:56:52 GMT

Thank you very much, One more question i thought i had the sub operations, I'm using table PLPH. However i cannot seem to get the sub to show.

Thank you, again

Re: Routing List

muthusamy_sankaran — Wed, 16 Jul 2008 11:27:47 GMT

Hi Clifton,

There no seprate table for sub-operation, PLAS and PLPO only, but you need to consider filed for PLPO-SUMNR (Superior Op. node), this is for main operation node number (PLAS-PLNKN)

Hope you will understand for this

Regards,

Sankaran

Re: Routing List

muthusamy_sankaran — Fri, 18 Jul 2008 00:04:35 GMT

Hi Clifton,

pls come back if required or reward points and close this thread

Regards,

Sankaran

Re: Routing List

Former Member — Fri, 18 Jul 2008 14:10:30 GMT

Sorry, i was away for a couple of days.

I will check that out right now, i believe i understand. My question then is the following the correct fiedl for sub operations:

PLPO-VORNR.

Thank you