Skip to Content
0

sap information steward backend tables dependency and connections

Aug 11, 2017 at 10:20 PM

104

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Niels Weigel
Oct 24, 2017 at 06:01 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Oct 25, 2017 at 08:54 AM
0

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


is-metadata.png (184.3 kB)
Share
10 |10000 characters needed characters left characters exceeded