Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 

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_CountTarget_Count
6666

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

1.

2.

3.

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

Labels in this area