Tables specific to IS Oil?

[Former Member]

Dear all,

I have a problem pulling out fields which are specific to IS OIL,

Example: I capture Temperature and Density , when invoicing the oil products.

but cannot find the fields in the standard SAP Table VBRK, this is just an example.

Please advise if we can pull out data from these fields.

Thanks

[Former Member · Accepted solution]

Hello Rajiv

It is very difficult to come up with a comprehensive list of tables which are specific to IS-OIL and those tables already existing in core which are enhanced by IS-OIL.

Here is an attempt:

IS-OIL specific tables for Material Movements :

MSEGO1 - stores parameters like test temp, density etc

MSEGO1 - stores quantities in alternate UoMs.

On the delivery side, we have :

LIPSO1 and LIPSO2.

The Billing transactions fall back on the data from Delivery tables.

On the Inventory Management side, we have the following:

MARC(H)O1, MARD(H)O1, MCHB(H)O1, MKOL(H)O1, MSKA(H)O1, MSKU(H)O1, MSLB(H)O1, MSPR(H)O1

The above list of tables are used to support Logistics, Logistics Execution and Inventory Management for Oil & Gas industries.

These apart there are many tables that are specific to some Oil & Gas business processes - like Silo (Tank) Management, TD Shipment, TSW, MAP, SSR etc

We also have IS-OIL extensions to core tables. For eg,

MARA-CMETH

MARC-UOMGR, MARC-UMRSL, MARC-OITAXGRP etc.

This list too pretty huge.

Hope this benefits you.

Regards

Shruthi

[Former Member · Accepted solution]

Hi shruthi,

Thanks for the list of tables provided! Points for the same! Would it be possible to send a little exhaustive list of tables for IS Oil if possible,

Help will be deeply appreciated.

Thanks

[Former Member]

Hello,

Go to SE11 and search using "OI*" . you will get all tables specific to IS-Oil. Some of the Tables of relevant modules are listed below.

OIB* Table related to QCI

OIH* Table Releated to Excise

OIG* Table Releated to TD Bulk Shipment

OII* Table related Silo Management

OIISO* Table related Silo Master SOC

OII_DIP* Table related Silo , Tank Dip, QCI for Tank Dip

OIA* Table Releated to Exchanges

Trust it helps.

[Former Member]

LIPSO1 table is stored the temperature and density of each delivery item.

Try it...

[Former Member]

Try LIPSO2 and MSEGO2

[Former Member]

Hi,

I think the quantities and temp parameters are determined for a specific material/plant/ storgae loc combination. In my project we have custom implementation for defaulting the QCI parameters through the standard process. Standard process here is exactly what sap follow to display the qci parameters like if you look at the additional quantities tab for an invoice line item, it goes thru a series of FM and displays the additional quantities.

Thanks,

Vamshi.