Finding Special Stock Number by Sales Order & item Number

[Former Member]

Hi Gurus,

I am trying to find specal stock number from ABAP table by using sales order number and sales order item number. I need to know which field for special stock number in which table I should look into by using Sales Order number and item number?????

Please help it is very urgent.

Jess

[bsivasankarreddy_reddy]

hi

check the MSEG table

and also check the MB5B, MB51, MIDO ,

please check this

[Shiva_Ram]

Did you check with t.code MB52 or MBBS. If you want to develop your own report, check the programs associated with these t.code and you can find the relevant tables.

Regards,

[Former Member]

I am trying to find field relavance in ABAP coding for developing logic. Once I find special stock number form table using sales order and line item then I will use this special stock number in table LTAP to check it TO status.

[Shiva_Ram]

Can you check with table EBEW or MSSA?

Regards,

[bsivasankarreddy_reddy]

hi

check below tables

MKOLH - Special Stocks from Vendor: History

MSCAH - Sales Order Stock at Vendor: History

MSKAH - Sales Order Stock: History

MSKUH - Special Stocks at Customer: History

MSLBH - Special Stocks at Vendor: History

MSPRH - Project Stock: History

MSSAH - Total Sales Order Stocks: History

[Former Member]

I think we are miscommunicating here. I am looking for Special Stock Number..if you go to table VEPO field SONUM.

[Shiva_Ram]

OK, then try with table VBFA-SONUM. Enter the sales order number in the preceding document filed and maintain subsequent document category as Q-WMS Transfer order.

Regards,