SFC and Workcenter relation in SAP ME tables

[former_member753989]

Hi Forum,

We have a requirement to filter SFC based on Workcenter defined in ME in a custom MII screen.

I am not able to find mapping between SFC and Workcenter table in ME database.

Also I did not see any PAPI in javdocs for SAP ME.

Can anyone provide a solution to this.

[sergiy_katerinich]

Hi!

Relations between SFC and WC are described here: https://wiki.scn.sap.com/wiki/display/ME/Work+Center+assignment

Respective tables are SFC_STEP, SFC_IN_WORK, WORKCENTER_MEMBER.

[michael_koerner3]

Hello,

The Work Center is not immediately attached to a SFC, but there are multiple relations in between.

I have linked the Database Guide below which should give you an idea how to join the tables to get to the relevant Work Centers. This is dependent on the type of order (discrete or repetitive) and how the Routing is attached (SFC, order-specific or Master).

SAP Help Portal - ME Database Guide (pdf)