Hi,
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.
Thanks,
Mukul