Capacity planning - excel download/upload

[Former Member]

Hi, we are trying to download capacity planning data from item to an excel sheet using the standard template. It always gives a message "E- specify a valid itemid". We do give a valid item id. Any inputs on this is appreciated.

[francesco_pezzoli]

Hello Anantharam,

Are you using function module /RPM/CAP_PLAN_EXCEL_DOWNLOAD to download the data?

If yes, then I would suggest that you place a breakpoint at the following coding (which should be where the error message is raised) and check why error "ESpecify a valid item ID" s being raised:

FUNCTION        / /RPM/CAP_PLAN_EXCEL_DOWNLOAD

  IF iv_isbucket IS INITIAL AND iv_isinitiative IS INITIAL.

*   Get the Item Header and Portfolio guid

    SELECT SINGLE h~guid d~guid d~portfolio_guid d~parent_guid d~item_class d~master_item_guid FROM /rpm/item_h AS h

                INNER JOIN /rpm/item_d AS d ON h~detail_guid = d~guid

                INTO (lv_item_guid, lv_detail_guid, lv_portfolio_guid, lv_bucket_guid, lv_item_class, lv_master_item_guid)

                WHERE d~external_id = is_context-item_id .

    IF sy-subrc NE 0.

      ev_rc = 4.

      ls_msg-msgtype = 'E'.

      MESSAGE e040(/rpm/planning) INTO ls_msg-msg_txt.

Best regards
Francesco