MB1B table

[Former Member]

Hi Experts,

My requirement is to know the table name from where i can get  both the sales order no, line item no, batches as well as moment type (413 E) for which MB1B Transaction has done.  As I am getting this information's from MSEG table but any of this parameter is not primary key.

So, please suggest table name from where i can get this details.

Regards,

[Former Member]

Thanks all...Finally decided to touch MSKA only for checking.

[gurtej_sandhu1]

Hi Sandip,

From the MSEG Table you can use the following fields:-

Field Name    Field Description

MBLNR          Number of Material Document

ZEILE             Item in Material Document

CHARG          Batch Number

KDAUF           Sales Order Number

I hope this will help you.

Regards

Gurtej

[Former Member]

Dear All,

As I mention in my earlier post i can get this data from MSEG as well as MSKA except moment type. But my requirement is to get  both the sales order no, line item no, batches as well as moment type (413 E) for which MB1B Transaction has done. As non of this field are primary key.

@ Vemuri Santosh Kumar

Can you snuggest any Table where i can found this one.

Regards,

[former_member186385]

Hi,

In standard you dont have any table with these fields as Key fields

you may have to develop a new Query or custom table

regards,

santosh

[former_member186385]

Hi,

check Standard report MB51 , just enter required Movement type either with Material or customer

you will get list of Sales order and Sales order items using with above combination and corresponding Material documents, it may take time if you search only with Movement type

If you want this at table level, may be you have to go for Query