{"id":79175,"date":"2019-03-07T19:49:54","date_gmt":"2019-03-07T09:49:54","guid":{"rendered":"http:\/\/pascalrenet.com\/?p=79175"},"modified":"2023-12-15T06:39:47","modified_gmt":"2023-12-14T20:39:47","slug":"s4hcks42-sap-s-4hana-cloud-scope-generator","status":"publish","type":"post","link":"https:\/\/pascalrenet.com\/2019\/03\/s4hcks42-sap-s-4hana-cloud-scope-generator\/","title":{"rendered":"S4HCKS42 – SAP S\/4HANA Cloud Scope Map Generator"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]A key piece of information \u00a0that I use in my interactions with customers, is the SAP S\/4HANA Cloud Best Practice practices<\/a> content, for which I am sure you have already heard the term scope item<\/em>. If not then head on out to the Best Practices Explorer for SAP S\/4HANA Cloud portal<\/a> (note you need to log on with your S-User to access the rich library of accelerators). To be more specific, I like to use a graphical view of our best practices, because I find that a picture really does paint a thousand words. It is a great conversation piece that I use before, during and after a project.<\/p>\n

However, with the ever increasing number of scope items and country localisations that come with every new quarterly release of SAP S\/4HANA Cloud, trying to build a graphical view of a scope map becomes a tedious and time consuming task. What’s more when I talk to my customers, I want to provide them with content that is specific to them : Show them a scope map of those scope items that apply to them, for their chosen country localisation(s) and\/or presented in such a way that lets them take in what they are using, yet also, more subtly shows what is available to consume if and when they will have the need for additional functionality.<\/p>\n

Furthermore, a scope item may not be released in all countries – for example there are some statutory reporting capabilities that are specific to a country. There is no added value for my Japanese customer to know that the US 1099 tax reporting is not available for country Japan. Again, the idea is to offer something that is personalised to the customer.<\/p>\n

With that in mind, not wanting to become an Excel or Powerpoint jockey, I decided to come up with a tool that would help me in this task of producing customer specific Best Practices Scope maps. That said, the tool could also be used by partners during their engagements with customers to for example highlight specific services or know-how that they have in certain areas, or customers themselves to for example help them keep track of their used scope and \/ or build future state roadmaps.<\/p>\n

This tool is an Excel based tool that will produce Scope Items maps in Excel and, optionally can also generate a set of Powerpoint slides, if you needed to wrap them up nicely in a presentation. In Excel, there will be one worksheet generated for each business area selected, and in Powerpoint there will be one slide for each scope item group as well as one slide per business area. And example of both these displays is shown below.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/2″][vc_single_image media=”79186″ media_width_percent=”100″ title=”Excel Output”][\/vc_column][vc_column width=”1\/2″][vc_single_image media=”79187″ media_width_percent=”100″ title=”Powerpoint Output”][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/1″][vc_custom_heading text_font=”font-359110″ text_weight=”300″]Generating a scope map[\/vc_custom_heading][vc_custom_heading text_font=”font-359110″ text_weight=”300″]Before you start[\/vc_custom_heading][vc_row_inner][vc_column_inner width=”1\/2″][vc_column_text]Once you download the zip archive and unpack it, you should have two files. An Excel document (this is the core file), as well as a Powerpoint template file named “Template.potm”. This is a blank Powerpoint Template file that will be used when you generate your personalized scope map. You can use your own template (with your own company colours and formatting) if you wish to. TO do so place your own temaplte file in the same folder as the excel document, and name your template”Template.potm” because that is hard coded in the macro – that is the name and place it looks for it.<\/p>\n

Also, I would recommend that you do not execute the macro whist the documents are stored in a dropbox or onedrive folder location especially if you have a less than optimal bandwidth. I have found that trying to run the macro as well as update the file live in such a network folder leads to periods of – long –\u00a0 unresponsiveness.[\/vc_column_text][\/vc_column_inner][vc_column_inner width=”1\/2″][vc_single_image media=”79204″ media_width_percent=”100″][\/vc_column_inner][\/vc_row_inner][vc_custom_heading text_font=”font-359110″ text_weight=”300″]Getting Started : Selection Screen[\/vc_custom_heading][vc_row_inner][vc_column_inner width=”1\/2″][vc_column_text]The first thing that you will need to do is decide whether you want to see a generated scope map independent of a country localisation, or on the contrary you want it specific to a country. The main difference between these two selections is that the country specific map will grey out those scope item that are not available in the chosen country.<\/p>\n

The map can only be generated for one country at a time.<\/p>\n

The next thing you will need to do is select one or more business areas for which the scope map should be generated. For each of the presented business areas, simply click the corresponding selection box to include it in the generated scope map.[\/vc_column_text][\/vc_column_inner][vc_column_inner width=”1\/2″][vc_single_image media=”79190″ media_width_percent=”100″][\/vc_column_inner][\/vc_row_inner][vc_custom_heading text_font=”font-359110″ text_weight=”300″]Choosing Display Criterias[\/vc_custom_heading][vc_row_inner][vc_column_inner width=”1\/2″][vc_column_text]For each scope item that is determined, based on the business areas you have chosen, one box will be displayed in the scope map. The box will include the scope item ID as well as the scope item description. There are then up to seven additional criteria that can be used to represent a specific feature, applicable to the scope item. For example, the content provided with the file will include information pertaining to a scope item being 2 Tier relevant, or it being an integration scenario. You may choose to use one criteria to represent a specific value driver, or a to highlight th fact that you have done some custom code extension or developed a side by side extensibility for this scope item, etc… The choice is yours. You can of course also re-purpose the delivered content. 2 Tier does not apply to you, use that criteria for something else more pertinent to you or your customer.<\/p>\n

Each one of the selected criteria will then appear in the scope item box in the form of a Glyph. If you ask to generate a powerpoint deck as well, the first slide added to the presentation will be a legend slide to let the audience know the meaning of each glyph. That said if you want to use something else to represent each of these criteria (for example you want to see 2T instead of green circle to represent that the scope item applies for a 2 Tier scenario – the code is freely accessible you can change this)[\/vc_column_text][\/vc_column_inner][vc_column_inner width=”1\/2″][vc_single_image media=”79192″ media_width_percent=”100″][vc_single_image media=”79172″ media_width_percent=”100″][\/vc_column_inner][\/vc_row_inner][vc_custom_heading text_font=”font-359110″ text_weight=”300″]Generating a Powerpoint presentation deck[\/vc_custom_heading][vc_row_inner][vc_column_inner width=”1\/2″][vc_column_text]If you also want to generate a Powerpoint slide deck of your chosen business areas, in addition to the information generated in Excel, then simply select the ‘Generate Powerpoint’ checkbox in the Other Options section. Then, in addition to this you can elect to generate the Powerpoint content as pictures or html tables. The essential difference between these two options, is that the picture will be a static element that cannot be changed, whereas the html table option will generate objects that are fully editable in Powerpoint (for example you want to color some scope items in red).[\/vc_column_text][\/vc_column_inner][vc_column_inner width=”1\/2″][vc_single_image media=”79195″ media_width_percent=”100″][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row row_height_percent=”65″ override_padding=”yes” h_padding=”2″ top_padding=”7″ bottom_padding=”7″ back_color=”color-nhtu” back_image=”79141″ parallax=”yes” overlay_color=”color-wayh” overlay_alpha=”10″ gutter_size=”3″ column_width_percent=”100″ shift_y=”0″ z_index=”2″ bottom_divider=”step_2_3″][vc_column column_width_use_pixel=”yes” position_vertical=”middle” align_horizontal=”align_center” style=”dark” overlay_alpha=”50″ gutter_size=”3″ medium_width=”0″ align_mobile=”align_center_mobile” mobile_width=”0″ shift_x=”0″ shift_y=”0″ shift_y_down=”0″ shift_y_down_fixed=”yes” z_index=”0″ width=”1\/1″ column_width_pixel=”1000″][vc_icon icon=”fa fa-play” background_style=”fa-rounded” size=”fa-3x” icon_automatic=”yes” shadow=”yes” css_animation=”zoom-out” animation_delay=”200″ media_lightbox=”79228″ title=”Video: Scope Builder”][\/vc_icon][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/1″][vc_custom_heading text_font=”font-359110″ text_weight=”300″]Downloading the required files[\/vc_custom_heading][vc_row_inner][vc_column_inner width=”1\/2″][vc_column_text]To download the needed files, simply click on the icon to the right !<\/p>\n

Updated with 1905 content – 20 June 2019[\/vc_column_text][\/vc_column_inner][vc_column_inner width=”1\/2″][vc_single_image media=”79217″ media_width_use_pixel=”yes” alignment=”center” media_link=”url:https%3A%2F%2Fwp.me%2Fa53usN-kHp||target:%20_blank|” media_width_pixel=”125″][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row][vc_column width=”1\/1″][vc_accordion title=”FAQ”][vc_accordion_tab title=”How much does it cost to use this tool?” tab_id=”1551940789416-3-3″][vc_column_text]There is no fee associated with the use of this tool.<\/p>\n

If you do use it, I would appreciate that you subscribe to the SAP S\/4HANA CLoud Knowledge Youtube Channel<\/a> and spread the word on social media.<\/p>\n

If you would like to make a monetary donation, then I would ask that you make a charitable donation to an organisation that helps with raising dyslexia awareness such as\u00a0 MSL Club in Australia<\/a> or The Reading League in the USA<\/a>.<\/p>\n

Before you ask, no you cannot charge for this tool.[\/vc_column_text][\/vc_accordion_tab][vc_accordion_tab title=”How can I change the criteria used?” tab_id=”1551873067-1-1″][vc_column_text]To change the criterias that appear for each scope item:<\/p>\n

    \n
  1. Go to the tab named “SETUP”.<\/li>\n
  2. In the section “Output Criteria – Explanation”, in the column named “Significance” change the name of one of the free criterias (named Criteria 4, 5, etc…) to the name you want to give to it<\/li>\n
  3. Go to the tab named “DATA”<\/li>\n
  4. Columns L to O map to the free criterias (Criteria 4 –> Column L, Criteria 5 –> Column M, etc…). At the intersection of your criteria and scope item ID, put an ‘X’ in the cell if your criteria applies. NOTE : It has to be an X – anything else will not be taken into account.<\/li>\n<\/ol>\n

    [\/vc_column_text][\/vc_accordion_tab][vc_accordion_tab title=”How can I change the look and feel of the generated Powerpoint?” tab_id=”1551873067-2-80″][vc_column_text]If you want to use your own template, then create your own .potm file in Powerpoint, with the look and feel you want to give it (colours, fonts, logo…). Then save that file in the same folder where you have saved the Excel file, and name it “Template.potm”. The macro looks for a file with that exact name, in the same folder as the excel document.[\/vc_column_text][\/vc_accordion_tab][vc_accordion_tab title=”Can I use the generated outputs?” tab_id=”1551940574056-2-7″][vc_column_text]Yes, you can use the generated output for your S\/4HANA Cloud Projects. But note that this tool is not created, provided, endorsed or supported by SAP. If you use it, then you are responsible for checking the accuracy and veracity of the data that you will generate and use.[\/vc_column_text][\/vc_accordion_tab][vc_accordion_tab title=”I have found a bug. Can I change the code?” tab_id=”1551941517487-4-8″][vc_column_text]Yes, you sure can ! The code is available and open. You will also note that my code is fairly “dirty”. If you do find a way to optimise the code or correct a bug or add a new features to it, then please send me an updated version of the excel document, so that I can update the source file and the entire community can benefit from this ![\/vc_column_text][\/vc_accordion_tab][vc_accordion_tab title=”There are things I like, some I don’t. Can I provide you with feedback?” tab_id=”1551941836449-6-8″][vc_column_text]Yes – absolutely.<\/p>\n

    A well thought out critique is worth Gold (E.Musk). Any feedback as long as it is not offensive is welcome, good or bad. You can leave a comment here or on the video on YouTube.[\/vc_column_text][\/vc_accordion_tab][\/vc_accordion][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

    This #S4HCKS introduces you to an Excel based tool that you can use to generate scope maps. You can generate them per business area and generate an Powerpoint Presentation out of it as well. These scope maps are customizable and localized to a country too.<\/p>\n","protected":false},"author":2,"featured_media":79174,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67],"tags":[],"class_list":["post-79175","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-s4hc"],"_links":{"self":[{"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/posts\/79175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/comments?post=79175"}],"version-history":[{"count":10,"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/posts\/79175\/revisions"}],"predecessor-version":[{"id":79573,"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/posts\/79175\/revisions\/79573"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/media\/79174"}],"wp:attachment":[{"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/media?parent=79175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/categories?post=79175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pascalrenet.com\/wp-json\/wp\/v2\/tags?post=79175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}