SFC Data

[houssem_temimi1]

Hello

I need to use collected data in table SFC DATA from BO

but DATA are not loaded into ODS .

it's not recommanded to use WIP tables

Can you recommand me ?

thanks

[sergiy_katerinich]

Hi!

You are right that it is not recommended.

Of cause, you can extend the default universe and add links to whatever table. But it might affect performance of live production. So, you have to consider this and test somehow closely to the real conditions.

Another issue about SFC Data is that it is split between WIP and ARC tables. So, if you need a universal solution, you will have to join both resources that might be quite expensive.

You might want to replicate in any way the data from WIP table to some other location, for example, in ODS, and then point the report to that place.

Regards,

Sergiy