SAPGYAN :how to find a perticular SFC on which operation and resource in SAP xMII?

Hi Friends, 

If you are trying to get a particular SFC's operation and resource using SAP MII then this question can help you to get your answer .  First you have to create a new SQL query that should be the type "SQLQuery" in your SAPWIP database.

In SAPWIP database you will get SFC table that holds SFC information like  SFC number (handle) and you also might get the operation and resource handle in the Same table as well as status.If you can't find those in that table you have to find the table that hold SFC data in database like SFC_ASSY.

So when you try to find the SFC on particular SFC on a particular resource and operation just write the query that says :

"select SFC from the tbl_name where resource and Operation and status is active or new ".

using this query you will get the output that contains the SFC that are on Particular Operation and Resource and those are in Active or New status.

That's it for today we will meet tomorrow with next problem and solution.

And of you have any query about the SAP MII and SAP ME feel free to comment in the comment section .

Suggestions are always welcome .

Regards,
Ankit Gupta