SAP for Oil, Gas, and Energy Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and navigate the evolving energy landscape. Join the conversation today!
cancel
Showing results for 
Search instead for 
Did you mean: 

Table to look up for IS OIl material stock balance

0 Kudos
552

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

markus_seng2
Explorer
0 Kudos
295

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

0 Kudos
295

you mean MSEGO2

markus_seng2
Explorer
0 Kudos
296

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

0 Kudos
295

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