Skip to Content
0

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

Jan 23, 2017 at 12:18 PM

79

avatar image

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.

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

0 Answers