Dynamic where clause in SAP workflow

dataservices sap-erp-bw
1

  1. I tried to create the full where clause as dynamic it didn’t work. But if i pass values from outside it is working. Please help me with this issue.

  2. Do we always have to have the SAP table extracted inside the SAP workflow? What happen if we donot include them under SAP workflow and drag it directly under dataflow with the red icon symbol visible. Is it not the good pratice?

raniaher (BOB member since 2012-01-12)

2

Help me ASAP

raniaher (BOB member since 2012-01-12)

3

  1. I have no clue what you are describing.

  2. Read the documentation on RFC Read table (or something similar) in the SAP supplement.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

4

in SAP workflow using query transform we can limit the selection of data using where clause. for that we need to drag the field in the where clause then with = sign we add the filter details. But instead of that i want the where clause to be dynamic. Today i am filtering on some column , tomorrow if i want to change my filter on another column then we can not go and change. it involve again migration so we can have global variable which will hold the where clause maintain at database level and populated using script then we will have more control on the SAP workflow where clause

raniaher (BOB member since 2012-01-12)