Regarding Material and inspection type

[Former Member]

Hi,

I have developed a report which displays :

class , inspection type , usage type for the materials.

I extracted inspection type from qmat for all materials, my problem is for every material there are multiple inspection types,

how to get active inspection type for that material.

2) i am extracting task list uasge for the material by using MAPL table

Mapl Table -

---

By passing Material ,Plant and Plnty(Task list type ) iam getting

PLNNR--Key for Task List Group,

PLNAL--Group Counter.

here also i am getting Multiple entries for one Material By varying Group counter value.

By passing plnnr ,plnal and plnty to plko i am getting task list usage (verwe).

because of multiple entries in mapl , i am unable to extract exact task list usage for the Material.

can any one please clarify me.

[former_member186399]

Dear Sunil

What is your exact requirement. What is the exact content in the report

Regards

Gajesh

[Former Member]

Dear Ganesh,

In selectio screen Material ,

Material type,

plant,(Mandatory)

Base code,

Procurement type Based up on these selection has to be done.

I have to display Material,

Material desc,

Base Code,

Plant,

Class,

Inspection Type ,

usage type,

Validation Message (this is based up on Validations Not from Data base.)

[former_member186399]

Dear Sunil

please check whether my understanding is not correct

You want to get the usage and inspection type

See from QMAT table you can get which is the inspection type active for the material.

for one inspection type the usage is fixed. you need not go to MAPL to get this instead use table TQ30. you will get the usage based on the inspection type

Regards

Gajesh

[Former Member]

Dear Gajesh,

Thank u for u r reply,

How can i identify which inspection type is active for that material.

when i checked this thing in MM03 tranasaction of QM tab every thing looks similar for both inspection type of that material.

[Former Member]

Hi

check

AKTIV field for active Inspection type in QMAT on plant level.

also

In MAPL you get Number of char for a material but group & Gr counter remains same.

so when you pass it to PLKO you will only get one usage.

Regards

Sujit

[Former Member]

Dear SujitSND ,

I have checked Qmat table , for one material and plant combination there are 2 inspection types , when i check aktiv field for that both both entries this field is active , how can i get a exact inspection type for a material.

As you told

In Mapl i checked the Values,

For one material and Plant combination several entries are there , But the Group Counter value is changing for all entries, which entry i should consider for that Material.

Thank u in adavnce