{"id":272,"date":"2025-05-20T09:33:01","date_gmt":"2025-05-20T09:33:01","guid":{"rendered":"https:\/\/sapabap.dwimansolution.com\/?p=272"},"modified":"2025-05-20T09:33:01","modified_gmt":"2025-05-20T09:33:01","slug":"sap-abap-workflow-level-with-table-function","status":"publish","type":"post","link":"https:\/\/sapabap.dwimansolution.com\/index.php\/2025\/05\/20\/sap-abap-workflow-level-with-table-function\/","title":{"rendered":"SAP ABAP &#8211; Workflow Level with Table Function"},"content":{"rendered":"\n<ol>\n<li><strong>ZI_TF_WFLevel<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>@EndUserText.label: 'Workflow Level'\r\ndefine table function ZI_TF_WFLevel\r\n  \/\/with parameters parameter_name : parameter_type\r\nreturns\r\n{\r\n  key client     : mandt;\r\n  key typeid     : sibftypeid;\r\n  key instid     : sibfboriid;\r\n  key zlevel     : int1;\r\n  key wi_id      : sww_wiid;\r\n      top_wi_id  : swfrtwiid;\r\n      wi_rh_task : sww_task;\r\n      wi_release : sysaprl;\r\n      crea_tmp   : swfrcrets;\r\n      catid      : sibfcatid;\r\n}\r\nimplemented by method\r\n  zclmm_amdp_wfrank=>get_data;<\/code><\/pre>\n\n\n\n<p><strong>2. zclmm_amdp_wfrank<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CLASS zclmm_amdp_wfrank DEFINITION\r\n  PUBLIC\r\n  FINAL\r\n  CREATE PUBLIC .\r\n\r\n  PUBLIC SECTION.\r\n    INTERFACES if_amdp_marker_hdb.\r\n\r\n    CLASS-METHODS get_data FOR TABLE FUNCTION ZI_TF_WFLevel.\r\n\r\n  PROTECTED SECTION.\r\n  PRIVATE SECTION.\r\nENDCLASS.\r\n\r\n\r\n\r\nCLASS zclmm_amdp_wfrank IMPLEMENTATION.\r\n\r\n  METHOD get_data\r\n    BY DATABASE FUNCTION FOR HDB\r\n    LANGUAGE SQLSCRIPT\r\n    OPTIONS READ-ONLY\r\n        USING sww_wi2obj.\r\n\r\n    declare lv_client \"$ABAP.type( mandt )\" ;\r\n    lv_client = session_context( 'CLIENT' );\r\n\r\n    t_query = SELECT\r\n                     client,\r\n                     typeid,\r\n                     instid,\r\n                   RANK ( ) OVER ( PARTITION BY client, typeid, instid\r\n                         ORDER BY crea_tmp ) AS zlevel,\r\n                     wi_id,\r\n                     top_wi_id,\r\n                     wi_rh_task,\r\n                     wi_release,\r\n                     crea_tmp,\r\n                     catid\r\n               FROM sww_wi2obj\r\n               WHERE client = :lv_client\r\n                 AND wi_rh_task LIKE 'TS%'\r\n                 AND typeid &lt;> 'SOFM';\r\n\r\n    RETURN\r\n      select *\r\n        from :t_query;\r\n\r\n  endmethod.\r\nENDCLASS.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>2. zclmm_amdp_wfrank<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/272"}],"collection":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/comments?post=272"}],"version-history":[{"count":1,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/272\/revisions"}],"predecessor-version":[{"id":273,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/272\/revisions\/273"}],"wp:attachment":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/media?parent=272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/categories?post=272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/tags?post=272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}