Show TOC

Background documentationODS Data Summarization

 

Note Note

This topic is relevant only if you are using SAP ME with Oracle or Microsoft SQL Server database. If you are using SAP ME with SAP HANA database, see System Landscape Recommendations Guide for SAP ME on SAP HANA.

End of the note.

You can control how (for which business objects) the data is summarized using ODS Rule Maintenance (see ODS Rule Maintenance). Each summary data type is summarized for some business objects by default.

The summary data types and the business objects for which they are summarized are the following:

  • Defect transfer table summary (DPMO)

    • Always summarized by

      • DPMO category

      • Material

      • Root Cause Operation

      • Site

    • Option to summarize by

      • Customer

      • Customer order

      • NC code

      • Operation

      • Order type

      • Resource

      • Shop order

      • Times processed

  • Nonconformance summary

    • Always summarized by

      • Failure ID

      • Material

      • NC category

      • NC code

      • Operation

      • Parent NC code

      • Site

    • Option to summarize by

      • Component

      • Component SFC material

        Can be set only for global site

      • Custom NC data fields

        Can be set only for global site

      • Customer

      • Customer order

      • Disposition routing

      • External lot number

      • External serial number

      • Grand parent NC code

      • Identifier

      • Incident NC code

      • Inventory ID

      • Location

      • Operation type

      • Order type

      • Ref Des

      • Reporting center

      • Resource

      • Responsible operation

      • Routing

      • Routing type

      • Shop order

      • Step ID

      • Times processed

      • User ID

      • Vendor

      • Vendor date code

      • Vendor lot

      • Work center

  • Order cycle time

    • Always summarized by

      • Material

      • Operation

      • Shop order

      • Site

    • Option to summarize by

      • Customer

      • Customer order

      • Cost center

      • Labor charge code

      • Order type

      • Reporting center

      • Resource

      • Rollup cost center

      • Routing

      • Step ID

      • User ID

  • Production cycle time

    • Always summarized by

      • Material

      • Operation

      • Site

    • Option to summarize by

      • Customer

      • Customer order

      • Cost center

      • Labor charge code

      • Reporting center

      • Resource

      • Rollup cost center

      • Routing

      • Routing step

      • Shop order

      • User ID

  • Production operation summary

    • Always summarized by

      • Material

      • Operation

      • Site

    • Option to summarize by

      • Customer

      • Customer order

      • Cost center

      • Labor charge code

      • Reporting center

      • Order type

      • Resource

      • Rollup cost center

      • Routing

      • Shop order

      • Step ID

      • User ID

  • Resource utilization summary

    • Always summarized by

      • Resource

      • Site

    • Option to summarize by

      • Resource type

      • Work center

  • Work center production

    • Always summarized by

      • Site

      • Work center

      • Work center category

    • Option to summarize by

      • Customer

      • Customer order

      • Material

      • Order type

      • Shop order