item cat type
I want to know whether i can get specific entries for item cat type based on sales org, distribution channel and division. basically i wanna know the table which holds or where i can view the item cat type based on these conditions.
thanks in advance
You can't get all the combinations if you use VBAK and VBAP,, these two tables holds the data for the orders that were placed.
You have to refer the config tables where the data would be stored.
The basic link is Salesorg/Dis Chan/Division will be assigned to a sales document type
the table to get this data is TVAKZ.
and to get the item categories will be defined for each sales document type,you can get it from table T184 as Priyanka mentioned.
So to join the two tables TVAKZ and T184 you can use AUART Field as key.
Typically this is a weird requirement... But its up to you. May be you are trying to do something different. Good luck . Any way I hope you got your solution.
Don't forget to reward points if useful.