SAP for Oil, Gas, and Energy Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table to look up for IS OIl material stock balance

0 Likes
1,037

Hi,

I'm looking for that table for IS Oil material that shows the stock balances in all UoM's (L, L15, L30, KG, etc). Pls advise.

Thanks!

1 ACCEPTED SOLUTION
Read only

markus_seng2
Explorer
0 Likes
780

Hi Zenon,

the cumulated stock values in additional UoM (where the UoM are defined in the UoM group) are kept in the following tables:

MARCHO1

MARCO1

MARDHO1

MARDO1

MCHBHO1

MCHBO1

MKOLHO1

MKOLO1

MSEGO1

MSKAHO1

MSKAO1

MSKUHO1

MSKUO1

MSLBHO1

MSLBO1

MSPRHO1

MSPRO1

The Historical Period Stock is kept in the *HO1 tabkles.

Every goods movement updates these tables with an MSEGO2 document. Higher level business processes (e.g. delivery processing or physical inventory) also keep the movement values in additional tables, from which the MSEGO2 values are derived, e.g. LIPSO2 (Delivery) or ISEGO2 (physical inventory) etc.

I hope this helps,

Kind regards,

Markus

View solution in original post

3 REPLIES 3
Read only

0 Likes
780

you mean MSEGO2

Read only

markus_seng2
Explorer
0 Likes
781

Hi Zenon,

the cumulated stock values in additional UoM (where the UoM are defined in the UoM group) are kept in the following tables:

MARCHO1

MARCO1

MARDHO1

MARDO1

MCHBHO1

MCHBO1

MKOLHO1

MKOLO1

MSEGO1

MSKAHO1

MSKAO1

MSKUHO1

MSKUO1

MSLBHO1

MSLBO1

MSPRHO1

MSPRO1

The Historical Period Stock is kept in the *HO1 tabkles.

Every goods movement updates these tables with an MSEGO2 document. Higher level business processes (e.g. delivery processing or physical inventory) also keep the movement values in additional tables, from which the MSEGO2 values are derived, e.g. LIPSO2 (Delivery) or ISEGO2 (physical inventory) etc.

I hope this helps,

Kind regards,

Markus

Read only

0 Likes
780

Thanks Markus, these are the tables that I need to see.