Create Query for Plan/Actual quantites (Link MCOMP to MATNR)

[former_member319307]

Hi All

I have found the table S026 (Material Usage) to create my query

In this table i am able to enter my order number in order to get a line per material with Plan quantity and Actual quantity

The problem is now that this table S026 take my components as the field MCOMP.

I would like to add to my query plant material master data related to my components (MCOMP), but how to i link my field MCOMP to MATNR so that i can look up material master data such as MOQ, MRP Controller etc.

Alternative please recommend another table.

In other words, what i am after is to create a query like transaction KKBC_ORD where i can add fields related to material master.

[solomon_macwan · Accepted solution]

hi Thomas,

First of all S026 is table for infostructure. You can use this table in query but the point is there are lot of primery keys into this. so you need to map with all order, component, plant, date and version to this.

you can join the table with MARC with material number and check..

regards,

Solomon