topic Re: which table stores selection criteria values given in SUBMIT statement in Application Development and Automation Discussions

which table stores selection criteria values given in SUBMIT statement

Former Member — Fri, 22 Jun 2012 06:38:48 GMT

Hi Experts,

I am passing selection criteria using submit statement like

SUBMIT report_name WITH f1 = val1.

I want to know which data base table stores the value val1.

Please reply .

Re: which table stores selection criteria values given in SUBMIT statement

RaymondGiuseppi — Fri, 22 Jun 2012 07:45:36 GMT

- Outside scheduling of a background job, I would say NONE.

- During scheduling of a job those are stiored in a variant (table VARI, with keys REPORT is submitted report and VARIANT like &0000000741833 counter)

Regards,

Raymond

Re: which table stores selection criteria values given in SUBMIT statement

Former Member — Fri, 22 Jun 2012 10:38:21 GMT

Hi Raymond ,

Thanks for the reply.

What i understood from your post is

outside scheduling : Job is finished/terminated

During scheduling : Job is running and this particular entry is available in the table.

Here Report----- is Submitted report name

Variant ----- Job counter ( output of Job_open function module )

Please correct me if i am wrong

Re: which table stores selection criteria values given in SUBMIT statement

RaymondGiuseppi — Fri, 22 Jun 2012 11:00:53 GMT

without background scheduling - report is executed immediately, so system does not require to save the parameters.

inside background scheduling- parameters are saved in a temporary variant, at execution the parameters are recovered from this variant, purge jobs that clear job logs should remove those variants.

Regards,

Raymond

Re: which table stores selection criteria values given in SUBMIT statement

Former Member — Fri, 22 Jun 2012 12:19:02 GMT

Hi raymond,

Here Report----- is Submitted report name

Variant ----- Job counter ( output of Job_open function module )

Is this correct ? Thanks in advance