BRF -fetch formula value set in the expression

[Former Member]

Hi expert.

My question is how to fetch formula value set in expression of BRF.

Here is my scenario.

For SC object BUS212 is have maintained the 2 levels approval process as below .

object type u2013 BUS2121

Process schema - 3C_SC_700_002

100-approval-u2018 ' u2013 u2018 ' u2013 RR_EMPLOYEE- Specify Employee for Approval- 365-40007953- ' ' -dec entire doc.

200-approval- AMT_LIMITu2013 limit ck u2013 RR_EMPLOYEE- Specify Employee for Approval- 250- 40007953- ' '-decision for entire doc.

For second level approval system checks for SC cart total amount .

In the BRF the expression type 0FB001u2019 (CL_FORMULA_BRF) is created for event (AMT_LIMIT ) is EX_AMT_LIMIT_2

here

Expression is of type u20180FB001u2019 (CL_FORMULA_BRF ), formula editor

Has condition 0V_SC_TOTALVALUE ( Overall value) > 10000 (number)

The process levels are maintained in table u2018 /SAPSRM/C_WF_Lu2019 here I got the EVENT> AMT_LIMIT.

800 BUS2121 3C_SC_700_002 100 A RR_EMPLOYEE 365 40007953

800 BUS2121 3C_SC_700_002 200 A RR_EMPLOYEE 304 AMT_LIMIT 40007954

In table TBRF210 I got event and Expression relation

800 A SRM_WF AMT_LIMIT A EX_AMT_LIMIT_2

In table TBRF200 I got the BRF expression EX_AMT_LIMIT_2 and object OV_SC_TOTALVALUE relation

800 A SRM_WF F EX_AMT_LIMIT_2 F A 0V_SC_TOTALVALUE

Now here is my problem how to fetch condition 0V_SC_TOTALVALUE ( Overall value) > 10000 (number)

Suggest the Class-method , tables or FM to fetch this 10000 value against 0V_SC_TOTALVALUE ( Overall value).

Warm Regards.

Indranil Panzade

[Former Member]

Hi,

Can you please explain your business requirement ? i am not able to understand..

Saravanan

[Former Member]

Hi ,

first thanks for taking the interest in this thread .

I need this data matinated in BRF expression for my custome (report and pplication)purpose.

here i maintained the value 10000 for SC total amount against some EXPRession .

that i want to show in my report's column like this

Object- process levels-EVENT-EXPRESSION-valid amount(EXP.formula amt) -reposible person(AHUJA)plant-(1000).

wants more explaination ,

please reply.

Indranil