cancel
Showing results for 
Search instead for 
Did you mean: 

table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

reazuddin_md
Active Contributor
0 Kudos

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

Lakshmipathi
Active Contributor
0 Kudos

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

Former Member
0 Kudos

HI;

Just for information.

I could not find item category & schedule line category in TVAK table.

Can we find there??

Thanks in advance

Avinash

Lakshmipathi
Active Contributor
0 Kudos

Dear Puneet Patel

Check in SE16 / TVAK.

thanks

G. Lakshmipathi