Routing List

[Former Member]

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

[Former Member]

Check the tables:

PLKO Task list - header

PLKZ Task list: main header

PLZU Routing data for group

Regards,

Ravi

[Former Member]

Check the tables:

PLKO Task list - header

PLKZ Task list: main header

PLZU Routing data for group

Regards,

Ravi

[Former Member]

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.

[Former Member]

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.

[muthusamy_sankaran]

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

[Former Member]

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

[muthusamy_sankaran]

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

[Former Member]

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

[muthusamy_sankaran]

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

[muthusamy_sankaran]

Hi Clifton,

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

Regards,

Sankaran

[Former Member]

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