on 02-19-2014 6:58 AM
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,
Thanks all...Finally decided to touch MSKA only for checking.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.