Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A



I have requirement where we need to show the Production Downtime at Plant and line level.

Integration is only done with ERP and i was able to retrieve the Table and field information from ERP.

Field information is as follows:

IWERK --> Plant

TPLNR ---> Functional Location

QMART ---> Notification type

MSAUS ---> Breakdown Indicator

AUSVN ---> Malfunciton startdate

AUSBS ---> Malfunction end date

AUZTB ---> Malfunction end time

STRMN ---> Required start date

STRUR ---> Required end date

STRMN ---> Required end date

STRUR ---> Required end time

Plant level will be an aggregation of all information at Line level to give plant details

Line level will be determined by entries

M2 + ZP = Total production downtime

ZP will be downtime with a result of loss of production

M2 = Engineering Malfunction notification type

ZP = Production downtime notification type.

My Question now is how to achieve this in MII, I am aware that by using "RFC_READ_TABLE" we can retrieve the fields in MII. I need to understand here how to make use of SAP_JCO_Interface here to read the fields to aggregate all information and to show the total production downtime at line and Plant level.

My approach here with Transaction building is

1. Created a document-> added sequence of SAP_JCO_Interface>Repeater with Xpath expression

SAP_JCo_Interface_0.Response{/RFC_READ_TABLE/TABLES/FIELDS/item} ---> I am confused here how to derive different field information and calculate them.



Former Member
Not what you were looking for? View more on this topic or Ask a question