Report Required

[Former Member]

Friends,

1)

I have an item category determination as follows:

XOR + XORM + +XAN

2)

I have created a Material MX01 with Item category group XORM

another material M01 with item category group NORM.

So when I create a sales order with XOR, I am able to process my material MX01 successfully, but when I try to process the material M01 Obviously I cant because M01 has item category group as NORM.

Now I need a report in which I want to segregate the materials, for the type of order type , under which it can be processed.

I know that while trying to create info sets and assigning it to user group, I wanted to join MARA, and TVAK, but there is no common field. How can I do it, ANY IDEA PLEASE >>>>

Regards,

Venkat

[ajitkumar]

pl try whether the following work

take material type from MARA

pass it on to t134 to find the item category

use this in t 184 to find the order type

an SQVI may not work; you may have to code it

[jpfriends079]

I don't think with only using Table MARA and TVAK you can achieve your result.

Instead, you will require T184 - Sales Documents: Item Category Determination.

Try and share your feedback.

Regards

JP

[Former Member]

Hello JP & Ajit

When I am trying to generate infosets with TVAK, T184, MARA, I get error message:

"For pooled tables, cluster tables and projection views, JOIN is not allowed"

I have also tried with T134, and the common field between the MARA and T134 is Material type.

I know obviously the T184 is a pooled table so we are getting this error message, but then how to generate a report which should clearly say, what material belongs to which order type ??

Regards,

Venkat