About Query of Routings

[Former Member]

Hi,

I've met a serious problem,could anyone help me out?Here's the situation:

I used MAPL (PLNTY,PLNNR,PLNAL,ZAEHL)>PLKO (PLNTY,PLNNR,PLNAL,ZAEHL)>PLAS (PLNTY,PLNNR,PLNKN,ZAEHL)>PLPO (ARBID)>CRHD to set up a query,searching routings by Mats.

Now I can use this query normally when seraching the routings batchly inputted initially before the system operated,but when searching the newly mannually set-up routings(CA01),the results can only show the first operations.

Y would this happen and how could I handle this?

Edited by: Leo Zheng on Dec 21, 2007 3:07 AM

[Former Member]

Hi Leo,

Remove the data for input fields

PLAS-> ZAEHL and

PLNKN->PLPO,ZAEHL-->PLPO,

Then try and come Back

Regards

Pradeep

[Former Member]

Hi,Pradeep

I think U misunderstood waht I said.

I didn't set PLAS-> ZAEHL and PLNKN->PLPO,ZAEHL-->PLPO as input fields,the data I typed on the first floor is the connections between tables (SQ02).

What I acturally set as input fields is MAPL (WERKS,PLNTY,PLNNR,PLNAL),MAKT (MATNR,MAKTX) and CRHD (ARBPL)..

THX!

Edited by: Leo Zheng on Dec 21, 2007 11:49 AM

[Former Member]

waiting and waiting.......

[Former Member]

Hi leo Zheng,

I am sorry to say, quick viewer will not help to meet your requirement. Becasue of link between the tables.

So i would suggest to go for abap query with tables link as u mentioned and selction criteria as i mentioned in my previous reply.

i hope this will solve ur problem, please comeback for further.

Regards

Pradeep

[Former Member]

Hi,Pradeep

My ABAPER has solved this problem,he just deleted the connection between PLKO and PLAS by the field of ZAEHL.

[Former Member]

Hi Leo,

Thanks for your feedback, that is why i suggested to remove the input data for that field.

letus give the details of tables u have joined and input fields.

Anyway your problem has been solved and close the thread as answered.

Regards

Pradeep.

Edited by: Pradeep Kumar on Dec 25, 2007 12:19 PM

[Former Member]

But I'm still not quite clear why the field ZAEHL can have that influence...and can make such a difference between the data inputed manually and the data batchly inputted..

[Former Member]

Hi Leo,

The reason is if u create a routing for first time in CA01, it will be updated in PLKO and the some value is assigned to the field ZAEHL ex 1 .

If u change the routing in CA02 it will not be updated in PLKO. if u add one opeartion to the routing , the filed value (ZAEHL)should have increased to 2, this will not happen. So it remains as 1. But in PLPO the second opeartion will be updated with ZAEHL is 2.

So while data fetching, only one value is (ZAEHL=1) passed from PLKO->PLAS->PLPO.

This would result u will get always first opertion only in the output. If u remove that Field Link from PLKO->PLAS-PLPO,then u will get the all operation list same as CA02.

i hope this clear ur doub, if do plsease close the thread.

Regards

Pradeep

Edited by: Pradeep Kumar on Dec 25, 2007 3:52 PM

[Former Member]

Thanks so much...

It really helped me a lot...

[former_member196398]

Leo,

What are the inputs you are giving in the selection screen?

Regards,

Prasobh

[Former Member]

Materials...(mostly used)

plant..

work center

...

[former_member196398]

Leo,

Probably in the newly created routings the workcenter given in the selection screen has been used only in the first operation.

Regards,

Prasobh

[Former Member]

Not that exactly..

if I leave workcenter empty,or every other empty,it is expected that all the routings and operations should be out layed,but the newly manually created routings still only show the first operations.

[Former Member]

waiting online...puzzlling..