on 04-09-2008 2:03 PM
Hi,
Can anyone please give me a table which will have details like for which Sales Doc Type what Item category group, item category and schedule line category will be reflected..
thanks
Hi Puneet,
going in hand with RMD's view, you need to check in multiple tables for the info requested. You are asking sales order header data for order type which is in VBAK table, item data which is in VBAP and schedule line data which is in VBEP. Item cat group can be seen in Sales org 2 view and the sales view infomration is stored in MVKE table.
regards
sadhu kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Puneet,
goto SE16-
no such single table exist to get the all the fields which your luking for .
these fields stores in different tables.
if your luking for the order type in sales order-
table :VBAK
only for doctype:TVAK ( as laxmipathi said)
item category in sales order: VBAP
only item cat: TVAP
schedule lines in sales order: VBEP
only schedule lines: TVEP
item cat group will be in material master: MARA/MVKE
hope it adds info
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear RMD
With regard to your comments
"only for doctype:TVAK ( as laxmipathi said)",
I would request you check at your end so that you will come to know that in the said table TVAK, without giving any sale document type, if you execute, it will NOT only display the sale order types, but also its subsequent document types like delivery and billing.
thanks
G. Lakshmipathi
Dear Puneet Patel
Check in SE16 / TVAK.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.