Skip to Content
author's profile photo
Former Member

Querry for Production receipe

I am new to this forum

From C203 : We get Receipe Details of 1 singel Material and Plant

I want to know the Operations with lead times for List of materials

For this purpose i have creaed a SAP querry using below tables

MKAL : Production Version of Materialas

MAPL :Assignment of Material to Task List -


>Linked through material number

PKLO: Task list header --->Link is Key for task list group

PLPO Task list operations---> Link is key for task list group

The problem is of Valid list of operations as on Date

C203 displays only valid list of sequence but this querry shows multiple sequence of operations as stored in PLPO

I want to restrict the querry(For multipler items) exactly to same as C203 display.

T-code C203 has 3 seleiction fields , Material , Plant and Key date(Validity)

However the Key date is not stored in any table

I have also checked the tables about Valid From, Valid to , change date etc there is no difference is sequence of operations

How can i restrict the entry to exactly the same as of c203

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo
    Former Member
    Posted on Apr 30, 2011 at 08:21 PM

    Hi there,

    technically You miss one table: PLAS (...PLKO - PLAS PLPO)

    I am not sure of what You said: do You have the same operation from PLPO multiplied (missing table could cause multiplication), or You have the one, which could be seen in C203 and some more? In this case have You checked if those ones are deleted ones? The operation deletion could be also found in PLAS-LOEKZ.

    Br

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yes you are correct i have connected PLAS and then made a joint using Internal counter & Nodes with PLPO which is now providing the dump without any multiple entries