Automic Workload Automation

 View Only

read data from a SAP table using uc4 function

  • 1.  read data from a SAP table using uc4 function

    Posted Aug 05, 2019 07:28 AM
    Hi,

    There is a SAP table:

    I need to read the date from this SAP table and when the date matches with the current date, to activate an SAP job.

    I have found in the documentation the FREE_SELECTION function and built the script:
    :set &date# = &$PHYS_DATE_DD_MM_YYYY_p#
    R3_SET_FREE_SELECTION TABLENAME="ZXAC_CATS_PY_DAY",FIELDNAME="ZZPY_DATE",LOW="&date#"
    R3_ACTIVATE_REPORT REPORT="XYZ"

    I have started it but something is not clear because either the date matches or not, the REPORT XYZ is triggered. Is there somebody that can make me understand better this behaviour?

    Thank you!
    Ion