{"id":1273,"date":"2015-02-02T09:33:51","date_gmt":"2015-02-02T08:33:51","guid":{"rendered":"http:\/\/oprsteny.cz\/?p=1273"},"modified":"2015-02-02T09:33:51","modified_gmt":"2015-02-02T08:33:51","slug":"abap-problems-with-combo-box-in-alv","status":"publish","type":"post","link":"https:\/\/oprsteny.cz\/?p=1273","title":{"rendered":"ABAP – Problems with combo box in ALV"},"content":{"rendered":"

\"SAP\"In this article I’ll show you how to implement a “combo box” with key-value structure as one of ALV columns. It can be considered as an easy task but you would be facing an unexpected problem in ALV which will display KEYS instead of VALUES of the combo box. If you select a value from the list, it will be displayed correctly until you press enter (in case you have the Enter event handled) or you refresh the grid. After refresh keys will be displayed again instead of values.<\/p>\n

\"Keys<\/a><\/p>\n

I’m not sure if this is a bug or a “feature” in SAP,\u00a0 but in my task I needed to have KEYS hidden in the combo control and display the VALUE (understandable text) to the user. This was necessary because I had to display “Short text” description of selected DDIC domain value.<\/p>\n

\"Domain<\/a><\/p>\n

One solution of this “issue” can be described in the following steps:<\/p>\n

    \n
  1. The required ALV column is marked with dropdown handle ID in field catalog\n
    \"There might be more than one handle defined,\r\nbecause you can have more than one combo columns in your ALV\r\nSo we have to specify which one will this field use\r\n<ls_fcat>-drdn_hndl = 1.<\/pre>\n<\/li>\n
  2. The required ALV column is marked with dopdown alias in field catalog\n
    <ls_fcat>-drdn_alias = abap_true.<\/pre>\n<\/li>\n
  3. The required ALV column might be set as editable (in case you want it)\n
    <ls_fcat>-edit = abap_true.<\/pre>\n<\/li>\n
  4. Prepare an itab structure holding dropdown key-value items\n
    METHOD get_combo_items.\r\n  DATA:\r\n    lt_dd07v TYPE TABLE OF dd07v.\r\n\r\n  FIELD-SYMBOLS:\r\n    <ls_dral> TYPE lvc_s_dral,\r\n    <ls_dd07> TYPE dd07v.\r\n\r\n* Get values and their short texts for given domain \r\n  CALL FUNCTION 'DDIF_DOMA_GET'\r\n    EXPORTING\r\n      name      = 'ZDOM_TEST'\r\n      langu     = sy-langu\r\n    TABLES\r\n      dd07v_tab = lt_dd07v.\r\n\r\n  LOOP AT lt_dd07v ASSIGNING <ls_dd07>.\r\n    APPEND INITIAL LINE TO rt_dral ASSIGNING <ls_dral>.\r\n    <ls_dral>-handle    = 1.\r\n    <ls_dral>-int_value = <ls_dd07>-domvalue_l.\r\n    <ls_dral>-value     = <ls_dd07>-ddtext.\r\n  ENDLOOP.\r\nENDMETHOD.<\/pre>\n<\/li>\n
  5. Attach the itab with items to the ALV grid\n
    me->mo_grid->set_drop_down_table(\r\n  it_drop_down_alias = me->get_combo_items( )\r\n).<\/pre>\n<\/li>\n
  6. Create standard INPUT (VALUE -> KEY) conversion exit\n
    FUNCTION conversion_exit_zprio_input.\r\n*\"---------------------------------------------------------\r\n*\"*\"Local Interface:\r\n*\"  IMPORTING\r\n*\"     VALUE(INPUT)\r\n*\"  EXPORTING\r\n*\"     VALUE(OUTPUT)\r\n*\"---------------------------------------------------------\r\n  DATA:\r\n    lt_dd07v TYPE TABLE OF dd07v.\r\n  FIELD-SYMBOLS:\r\n    <ls_dd07> TYPE dd07v.\r\n\r\n  CALL FUNCTION 'DDIF_DOMA_GET'\r\n    EXPORTING\r\n      name      = 'ZDOM_TEST'\r\n      langu     = sy-langu\r\n    TABLES\r\n      dd07v_tab = lt_dd07v.\r\n\r\n  READ TABLE lt_dd07v ASSIGNING <ls_dd07>\r\n    WITH KEY ddtext = input.\r\n  CHECK sy-subrc = 0.\r\n\r\n  output = <ls_dd07>-domvalue_l.\r\nENDFUNCTION.<\/pre>\n<\/li>\n
  7. Create standard OUTPUT (KEY-> VALUE) conversion exit\n
    FUNCTION CONVERSION_EXIT_ZPRIO_OUTPUT.\r\n*\"----------------------------------------------------------\r\n*\"*\"Local Interface:\r\n*\"  IMPORTING\r\n*\"     VALUE(INPUT)\r\n*\"  EXPORTING\r\n*\"     VALUE(OUTPUT)\r\n*\"----------------------------------------------------------\r\n  DATA:\r\n    lt_dd07v TYPE TABLE OF dd07v.\r\n  FIELD-SYMBOLS:\r\n    <ls_dd07> TYPE dd07v.\r\n\r\n  CALL FUNCTION 'DDIF_DOMA_GET'\r\n    EXPORTING\r\n      name      = 'ZDOM_TEST'\r\n      langu     = sy-langu\r\n    TABLES\r\n      dd07v_tab = lt_dd07v.\r\n\r\n  READ TABLE lt_dd07v ASSIGNING <ls_dd07>\r\n    WITH KEY domvalue_l = input.\r\n  CHECK sy-subrc = 0.\r\n\r\n  output = <ls_dd07>-ddtext.\r\nENDFUNCTION.<\/pre>\n<\/li>\n
  8. Assign your conversion exit to the ALV field with dropdown in field catalog\n
    <ls_fcat>-convexit = 'ZPRIO'.<\/pre>\n<\/li>\n<\/ol>\n
    The result should now be like this:<\/p>\n
    \"ALV<\/a><\/p>\n
    You can donwload complete source code of Z_ALV_DROPDOWN right here.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    In this article I’ll show you how to implement a “combo box” with key-value structure as one of ALV columns.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"ABAP - Problems with combo box in ALV","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[16,86,9,222],"tags":[447,382,383,384,134],"class_list":["post-1273","post","type-post","status-publish","format-standard","hentry","category-abap","category-alv","category-development","category-dynpro","tag-alv","tag-combobox","tag-conversion-exit","tag-ddif_doma_get","tag-dropdown"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3nYbe-kx","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts\/1273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1273"}],"version-history":[{"count":1,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts\/1273\/revisions"}],"predecessor-version":[{"id":1279,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=\/wp\/v2\/posts\/1273\/revisions\/1279"}],"wp:attachment":[{"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oprsteny.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}