Skip to Content

BODS Audit on SAP Source Tables

  • Audit Feature on SAP Sources works in the same manner as in Database Source and Target tables.
  • Source SAP Table Count and Target Table Count are Computed in Audit window.
  • Source Table count should be applied on ABAP Data Flow and Not on SAP Table.
  • Source Count and Target Count are checked as described below in the screenshots.
  • If the Audit condition set is violated, an Exception is raised.
  • We can give Custom Conditions apart from

  $Count_ABAP_DF = $Count_Target_DB_Table.

  • We can Insert the Source Count and Target Count values from Audit Labels, into any Table using below Script.

This Script is used in Custom Audit Condition.

$Count_Source_Count=$Count_Target_Count

and

sql(‘Target_SQL‘, ‘insert into dbo.Source_table_Count values ([$Count_Source_Count],[$Count_Target_Count])’) is NULL     ##  THIS CONDITION IS ALWAYS TRUE as Output of Insert query is NULL

After successful completion of the Job, You will find the Source and Target Counts inserted into the Control Table.

select * from Source_table_Count

Source_Count Target_Count
66 66

Note: This Script can be used in Any Audit Condition regardless of the type of Source/Target table, to Capture Audit Label Value.

1.

/wp-content/uploads/2012/12/1_164722.jpg

2.

/wp-content/uploads/2012/12/2_164792.jpg

3.

/wp-content/uploads/2012/12/3_164793.jpg

4.Apply the above mentioned script in Custom Audit Condition.

/wp-content/uploads/2012/12/4_164794.jpg

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply