tables in is-oil

[Former Member]

Hi all

what are the tables and fields used in Is-oil transaction

[Former Member]

Hello,

There are lot of is-oil related tables and fields. These are dependent on the transaction you are using and also dependent on the module(MAP, ED, TDP, Exg..). best way is to use ST05 trace analysis on the transaction that you require.

You will come to know the Tables that are used.

kind regards,

Uli.

[Former Member]

Hi, claus

could you give details about transaction codes in Is-oil&gas, means are they linked with MM ,SD and PP.If so, can you give a detailed information about it.

Thanks,

Praveen

[Former Member]

Praveen,

IS-Oil is packaged with standard SAP (ie) all modules like MM,SD,FI are available along with addon of IS-Oil . Codes and tables are same as in standard R/3

PO -T.code - ME27 - Tables - EKKO,EKPO

Sales order -T.code VA01 - VBAK,VBAP

All material doucments are as in other R/3 systems saved in MSEG additionally Alternative units of posting material doucment will be enabled which willbe saved in MSEG02.

Mostly in IS-OIL Down stream - TD,TSW,HPM will be used .

Few Transaction codes are

O4F1 - Create Shipments

O4F2- Change shipments

O4F3 - Display Shipment

O4G1- Change Loading Confirmation

O4G2- Display Loading Confirmation

O4H1- Change Delivery Confirmation

O4H2- Display Delivery Confirmation

All these information will be available in Tables

OIGS TD Shipment Header

OIGSE TD Events

OIGSH TD Shipment History

OIGSI Shipment Item

OIGSM TD Material Allocated to a Shipment

OIGSMS TD Material Samples on a Shipment

OIGSMV TD Material Balance on Vehicle

OIGSS TD Shipment Stages

OIGSV TD Vehicles in Transport/Shipment

OIGSVC TD Transport Unit in Shipment

OIGSVCC TD Compartment in Shipment

OIGSVCS TD Vehicle Seals on Transport Units

OIGSVD TD Driver per Vehicle on a Shipment

OIGSVIIS TD Shipment Assignment of Document Items

OIGSVMQ TD Quantity Item for Material on Vehicle

OIGSVMQM TD On Board Movements References

OIGSVMQO1 TD Quantity Item Calculation Parameters

OIGSVMQO2 TD Quantity Item Additional Quantities

O4V1 Vehicle creation

O4V2 -Vehicle creation

O4V3 - Vehicle creation

O4C1 - Create Transport Unit

O4C2/O4C3 - Display/Change Transport Unit

O4D1/O4D2/O4D3 - Driver creation/Change/Display

Tables for the above

OIGV TD Vehicle Header

OIGVL TD Licenses Needed for Vehicle

OIGVT TD Vehicle Header Text

OIGVTU TD Vehicle - Transport Unit Assignment

VI01 - Create Shipment costing documents

VI02 - Display Shipment costing documents

O401- Create Business location

O402- Change Business location

O403 -Change Business location

O4R1/O4R2/O4R3 - Rack meter create/change/display

For Terminal automations system interface

Load ID related - O4P5,O4PR

For more details ..

Go to transaction code TSTCT - type in O4* you will get all most of OIL Related transaction.

Simialrly for table look at SE11 - OIG* it will list all ..

[Former Member]

I'd recommend to enjoy some SAP Trainings regarding IS-OIL overview or specific applications particular.

IS-OIL comes along with 8.163 specific Tables, 2320 specific Transactions , 9172 Programs and around 8000 modifications on SAP Core programs.

e.g. the Sales documents (Contracs/Orders) item table has been extended with 72 fields. Pricign/Tax handling/Quantity conversion etc ... many central areas woking odd than in SAP standard

Have Fun

Christof Schmidt

Senior Developer

Dev ERP DC DIMP / OIL

SAP AG

[Former Member]

This message was moderated.

[Former Member]

Go to transaction SE16N

Search for OI*

You will hit over 2300 tables.

For further reference, tables starting with

1.OIA* belongs to Exchanges

2.OIG* belongs to TD

3.OIJ* belongs to TSW

...........and likewise.

This way you can hit comprehensive list of Tables belonging to IS-Oil

Hope it helps.

Adarsh