SAP OEE - Production Order tables

[senthil_kumar44]

Hi,

We are using SAP OEE in MII 15.1. To download the master data for production order, instead of using S/4 HANA to send idoc, we are using production order details as excel file (like flat file) and reading thru PCo. But how to store these production order details in OEE database tables? Is there any tables we need to fill the data in OEE database? Can you please give those table names and its column names?

Thanks,

Senthil

[ankit12]

Hi Senthil,

Yes… there are tables that used to store the production data that is used at the shop floor level. In SAP OEE all manufacturing related tables starts with the MPM_* prefix. So if you want to search any SAP OEE table in the database just go with MPM_(tableName).

But this is not SAP recommended approach to fill the OEE tables as you will find it very difficult to maintain further or to find any issue if occurs in future. These table should be automatically filled by IDOC’s coming from the SAP ECC using integration used in your project.

And in addition to that why you are doing double work by maintaining all the data in Excel when SAP has already given us a way to maintain and analyze it.

Regards,
Ankit Gupta

[agentry_src]

I would first ask why you are using such an inefficient approach? IDocs are set up to be just about the least impact on network throughput and processing at the ECC level.

The tables used by OEE are essentially replicating those segments of the LOIPRO IDoc and are named accordingly.

Regards, Mike