Skip to Content
avatar image
Former Member

Can we capture AUDIT variables in SAP BODS into Global variables?

Can we capture AUDIT variables in BODS into Global variables?(Without querying on Repository tables as i dont have acccess to that) or somehow capture them and write in into a Table? I am using BODS 4.2 Version.

I tried sql function in the Rule section to insert into a table as shown below

sql('TGT_AUDIT', 'INSERT INTO Table_Name VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,[$Count_FF_MFG_STG_CDD52_CONSTRUCT_MAIN],[$Count_MFG_STG_CDD52_CONSTRUCT_MAIN])') IS NULL

Got the below error when validated:

Invalid audit rule: <
>. Additional information: <Syntax error at line <2>: <>: found <[end of text]> expecting <CREATE>.
1 error(s), 0 warning(s).

Check and fix the syntax and retry the operation. (BODI-1112394)>. (BODI-1112508)

Please help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers