Page History

...

Second Layer

Projection_3 : Table RSDCUBEMULTI to get dependent objects for a Multiprovider.

Left Join_3 with the list of Main providers from Join_1 to get dependent objects.

Projection_4 : Table RSOOBJXREF to get dependent objects for a Composite Provider or ADSO.

Left Join_2 with the list of Main providers from Join_1 to get dependent objects.

...

Projection_8 : Master Data C_GLBFILT to force fix dependent objects for a Composite Provider built on CV (No selectable information in XML format).

Left Join_6 with the list of Main providers from Join_1 to get dependent objects.

Third Layer

Union_1 : Merge information from Main providers and dependent objects.

Projection_4 2 : Table RSOOBJXREF RSDINFOPROVDATA to get last request loaded date and time of a Provider.

Left Join_4 with the union_1 of Main providers and dependent objects.

Fourth Layer

Projection_7 : To exclude redundant lines without part provider.

Rank_1 : To select the last updated Part Provider Type of a Main Provider (sorted descending on Timestamp).

Rank_2 : To select the first Part Provider Type of a Main Provider (1RST, ADSO, CUBE).

Master Data Global Filter C_GLBFILT

In order to force fix dependent objects for a Composite Provider or ADSO.Left JoinComposite Provider built on CV (No selectable information in XML format), the Master Data C_GLBFILT is used with below inputs.

Here the Composite Provider CPCOPA03 will be completed with part providers DBCOPA34, DBCOPA41, DBCOPA36...etc

This list will be merged with all others part providers found in the CV for the Main Provider, and the last refreshed part provider will be displayed in the query result.