Skip to Content

sap information steward backend tables dependency and connections

hi experts can you please help me where can I find sap is backend tables with dependency or primary keys to connect to the other tables with in the schema.

I tried to create custom report on data quality from the rules score. I find out mmt_rule and other tables but failed in connecting them with the primary keys or matching keys between other tables.

if any one has any document please help me out.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 24, 2017 at 06:01 PM

    If you want to create an own report or dashboard, you should use the Failed Record Database concept, where for every Rule Task execution SAP Information Steward writes statistical information and failed records into a specific database schema, that you define in the database connections and set in the Rule Task definition.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2017 at 08:54 AM

    Kindly refer below link

    https://blogs.sap.com/2012/11/19/information-steward-failed-data-reporting/

    Failed Data is available in the form of tables *_FR and *_FD (Failed Record and Failed Data. You can use inner join on IS_GEN_ROWDID and RUN_ID columns to get the details of which rule has failed and on which column


    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded