{"id":7623,"date":"2025-08-24T16:31:13","date_gmt":"2025-08-24T11:01:13","guid":{"rendered":"https:\/\/www.sapewmhelp.com\/?question=what-is-an-interactive-report"},"modified":"2025-08-24T16:31:13","modified_gmt":"2025-08-24T11:01:13","slug":"what-is-an-interactive-report","status":"publish","type":"question","link":"https:\/\/www.sapewmhelp.com\/?question=what-is-an-interactive-report","title":{"rendered":"What is an Interactive Report?"},"content":{"rendered":"

An Interactive Report in ABAP is a report that lets users interact with the list (usually by clicking on a line or hotspot).<\/p>\n

When the user clicks, the program reacts to the event and shows secondary details (like drilling down).<\/p>\n

Classic mechanism: Events AT LINE-SELECTION, AT USER-COMMAND, AT PFx.<\/p>\n

Example Scenario (using MARA<\/code> \u2192 MARC<\/code>)<\/h5>\n
    \n
  1. Basic list (Level 1): Show materials (MARA<\/code>).<\/li>\n
  2. Secondary list (Level 2): When user clicks on a material, show its plant-specific details (MARC<\/code>).<\/li>\n<\/ol>\n
    \n
    *&---------------------------------------------------------------------*<\/span>\r\n*&\u00a0Report\u00a0\u00a0ZTEST_PROGRAM_2<\/span>\r\n*&<\/span>\r\n*&---------------------------------------------------------------------*<\/span>\r\n*&<\/span>\r\n*&<\/span>\r\n*&---------------------------------------------------------------------*<\/span>\r\n\r\nREPORT\u00a0<\/span>ztest_program_2.<\/span>\r\n\r\nTABLES<\/span>:\u00a0<\/span>mara,\u00a0<\/span>marc.<\/span>\r\n\r\nDATA<\/span>:\u00a0<\/span>it_mara\u00a0TYPE\u00a0<\/span>TABLE\u00a0<\/span>OF\u00a0<\/span>mara,<\/span>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0it_marc\u00a0TYPE\u00a0<\/span>TABLE\u00a0<\/span>OF\u00a0<\/span>marc.<\/span>\r\n\r\n\"---\u00a0Fetch\u00a0data<\/span>\r\nSELECT\u00a0<\/span>matnr\u00a0mtart\u00a0FROM\u00a0<\/span>mara\u00a0UP\u00a0<\/span>TO\u00a0<\/span>20\u00a0<\/span>ROWS\u00a0<\/span>INTO\u00a0<\/span>TABLE\u00a0<\/span>it_mara.<\/span>\r\n\r\n\"---\u00a0Event:\u00a0START-OF-SELECTION\u00a0->\u00a0Display\u00a0Basic\u00a0List<\/span>\r\nSTART-OF-SELECTION<\/span>.<\/span>\r\n\u00a0\u00a0WRITE<\/span>:\u00a0<\/span>\/\u00a0'Material\u00a0No<\/span>.<\/span>',\u00a0<\/span>15\u00a0<\/span>'Material\u00a0Type'.<\/span>\r\n\u00a0\u00a0ULINE<\/span>.<\/span>\r\n\r\n\u00a0\u00a0LOOP\u00a0<\/span>AT\u00a0<\/span>it_mara\u00a0INTO\u00a0<\/span>DATA<\/span>(<\/span>wa_mara)<\/span>.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0WRITE<\/span>:\u00a0<\/span>\/\u00a0wa_mara-<\/span>matnr,\u00a0<\/span>15\u00a0<\/span>wa_mara-<\/span>mtart.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0HIDE\u00a0<\/span>wa_mara-<\/span>matnr.\u00a0<\/span>\"Hide\u00a0material\u00a0no\u00a0for\u00a0later\u00a0use<\/span>\r\n\u00a0\u00a0ENDLOOP<\/span>.<\/span>\r\n\r\n\"---\u00a0Event:\u00a0AT\u00a0LINE-SELECTION\u00a0->\u00a0Drill\u00a0down\u00a0to\u00a0details<\/span>\r\nAT\u00a0<\/span>LINE-SELECTION<\/span>.<\/span>\r\n\u00a0\u00a0CLEAR\u00a0<\/span>it_marc.<\/span>\r\n\r\n\u00a0\u00a0SELECT\u00a0<\/span>matnr\u00a0werks\u00a0dismm\r\n\u00a0\u00a0\u00a0\u00a0FROM\u00a0<\/span>marc\r\n\u00a0\u00a0\u00a0\u00a0INTO\u00a0<\/span>TABLE\u00a0<\/span>it_marc\r\n\u00a0\u00a0\u00a0\u00a0WHERE\u00a0<\/span>matnr\u00a0=\u00a0<\/span>sy-<\/span>lisel+0(<\/span>18<\/span>)<\/span>.\u00a0<\/span>\"\u00a0Material\u00a0from\u00a0selected\u00a0line<\/span>\r\n\r\n\u00a0\u00a0IF\u00a0<\/span>sy-<\/span>subrc\u00a0=\u00a0<\/span>0<\/span>.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0NEW-PAGE<\/span>.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0WRITE<\/span>:\u00a0<\/span>\/\u00a0'Material:<\/span>',\u00a0<\/span>sy-<\/span>lisel+0(<\/span>18<\/span>)<\/span>.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0ULINE<\/span>.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0WRITE<\/span>:\u00a0<\/span>\/\u00a0'Plant',\u00a0<\/span>15\u00a0<\/span>'MRP\u00a0Type'.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0ULINE<\/span>.<\/span>\r\n\r\n\u00a0\u00a0\u00a0\u00a0LOOP\u00a0<\/span>AT\u00a0<\/span>it_marc\u00a0INTO\u00a0<\/span>DATA<\/span>(<\/span>wa_marc)<\/span>.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WRITE<\/span>:\u00a0<\/span>\/\u00a0wa_marc-<\/span>werks,\u00a0<\/span>15\u00a0<\/span>wa_marc-<\/span>dismm.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0ENDLOOP<\/span>.<\/span>\r\n\u00a0\u00a0ELSE<\/span>.<\/span>\r\n\u00a0\u00a0\u00a0\u00a0MESSAGE\u00a0<\/span>'No\u00a0plant\u00a0data\u00a0<\/span>found\u00a0for\u00a0<\/span>this\u00a0material'\u00a0TYPE\u00a0<\/span>'I'.<\/span>\r\n\u00a0\u00a0ENDIF<\/span>.<\/span><\/span> <\/code><\/pre>\n
    Output :
    \n<\/p>\n
    <\/p>\n<\/div>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","question-category":[158],"question_tags":[178,368,177],"class_list":["post-7623","question","type-question","status-publish","hentry","question-category-abap","question_tags-abap","question_tags-interactive-report","question_tags-sap"],"_links":{"self":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question\/7623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question"}],"about":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7623"}],"wp:attachment":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7623"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion-category&post=7623"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion_tags&post=7623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}