Saturday, August 28, 2010

WWI Template - Some Tips

Dear Friends,

Recently I happened to work with WWI tool for eSDS template. I have quite a number of learning’s from this activity, some of them are

- Before working with WWI template ensure you know Microsoft Word 2007.

- Learning all the functionalities of how to align the page breaks, how to maintain page layout, provide indent, margins, spacing etc. This segment is more time consuming than any other exercise. So its always good to begin with good layout and use WWI layout settings with different color schema.

- Always create symbols yourself and don’t use previously created segments if they are spanning multiple paragraphs, at times repeating groups are given for the entire section and if they are not properly taken it creates problems.

- If its data from a single sub node of property tree, better to use SAP WWI Wizard functionality, instead of you creating each of them manually, it gives lot of flexibility interms of how to print etc., make use of this functionality.

- If you are creating tables with multiple components, again print them using Wizard functionality and then use the slave group and master group declarations.

- Advanced functionalities like blank compression / conditional output are very good features so ensuring when to use which functionality is a critical to template creation. Blank compression with alternative, or conditional output with alternative are very good features for printing the symbols in controlled conditions.

- Whenever you come across any template just examine a bit more – you might know more functionality like – how to print Risk Phrases collectively in another section, How to print DG information, how to insert templates based on conditional statements, inserting multiple templates in to a master template, how to print methods, how to use environmental parameters and ID listing data and how to create methods for suiting to your project requirements.

Thanks

Sunday, August 15, 2010

Business Process Management - SAP EH&S

Dear Friends,

For a client project at times you need to get involved in identification of as is process or identification of the current management practices of diverse business processes. The intent of such process is either to implenent the process / optimize it or stremline or to merge different systems into a common process. These models / process show a representation of the real world process model built to a certain scale and level of details for a specific purpose. Built to show viewpoint.

Examples of predominant business processes in EH&S include i) Substance and Component management ii) Supply Chain Communication for REACH iii) Generation of MSDS iv) Permit Management v) Incident Accident Management vi) SOP Management etc vii) Dangerous goods and Tremcard processing viii) Label Generation etc.

At times its tempting to use some predeveloped business maps for a new project, however be wise in choosing such material as some scenarios are developed keeping some assumption in mind, which may not hold true for other cases. The objectives of the such model may change during the life of the project, like sometimes a model developed for one purpose might not fit for a broader requirement. There are couple things which one should remember while working on such assignments – i) Why is the process performed ii) Which objects are used/modified iii) Which technology is used iv) Which processes preceed and follow v) Which rules govern the process and which organization unit performs it.

The best approach is to select a key business item (like MSDS generation) and follow it through the process, seeing for which actions are performed and who handles and where it ends up. At time client might be having a business model but following some workaround to achive the current requirement, you need to be careful in mapping such process. Always concentrate on value of each task and check and identify the flow of process correct and check for failure paths if any and see what actions are performed, who handles it and where it ends up. This is provide you a good scenario to actually develop customer scenario. There are many softwares which support this processes like ARIS, Solution Composer, Galaxy, ARIS and other graphical tools like iGrafx.

Thanks

Sunday, August 8, 2010

eSDS / MSDS management for meeting Legislative requirements

Dear Friends,

As you might know a safety data is needed for chemical products considered as dangerous to health or environment. According to REACh Article 59, the threshold of concern is typically 1% w/w (solids or liquds) or 02% v/v (gas) or 0.1% of highter for CMR, vPvP, PBT or Cat 1 sensitizers. One of the major changes in the MSDS as extended Safety Data Sheet includes envisaged exposure routes and real use patterns – coversing Exposure Scenarios. One of the obligation also is keeping records of supply of the latest SDS.
So for meeting the Compliance for REACh, Vendor MSDS needed to be managed optimally. Ensuring that new eSDS should be properly analyzed and made accessible to employees inside the organization. Whenever a new chemical is introduced its related MSDS should be properly assessed and informed to all the responsible people. I) MSDS Distribution and II) Processing of external MSDS / eSDS into EH&S are the two requirements for meeting the legislative requirements. So how to achieve these two requirements using existing SAP system ?

The first requirement – making the MSDS accessible to stakeholders – might already be in place for major companies. Like deploying into their internal websites, providing downloadable MSDS into their websites outside SAP or even providing some Document management software to access such information. In this aspect - TechniData’s EHS – WWW tool is a very useful component in meeting MSDS disribution via internet. It automatically converts the RTF documents into PDF and posts them into website, which can be accessed based on different search cabilities – simulating SAP EH&S Report Information System – though not much literature is available in public domain.

The Second Requirement - Making the assessment of the revised MSDS / eSDS requires manual process of actually going through each MSDS identifying the changes (majority it would be Uses, Exposure Scenarios and restrictions) it contains and creating required book marks and releasing it to the internal distribution group. However, the limitation would be it’s a manual process and companies desire some automation here. There are couple of options are there which are still in development stage which will take some more time to realise – like use of “mapping” databases from the local systems and use of some connectors / RFC to actually transfer the contents into SAP system, or using of technology similar to IMDS for processing the worklists to change the content. The other possibility would convert Vendor MSDS to XML files and load them directly into SAP to reflect the changes like some 3rd party data loading tools. SAP software has a in built supply chain communication to derive such information using Emails, Self Service Portals, XML plugins which ensure such processes as part of SAP REACh and Product Compliance 2.0.

Thanks

Monday, July 19, 2010

Converting client specific requirements into a useful tool

Dear Friends,

I am sure, many of you would have worked on the development for meeting client specific needs. At times it is very easy to hard code everything for client requirements. However, there is a wonderful furctionality called Variants – which can transform a client specific requirement into a tool for meeting broader requirements. Variants allow you to save sets of input values for programs that you often start with the same selections. Variant is like a variable inputs which can trigger varied search / program options for meeting different requirements. It is possible to store different variants for different purposes and even schedule them as required. Variants can be used either in background or via user intervention.

In EH&S such variant options are available in a sub functionality called Specification Informaiton Systems, which can provide you with different search output based on different selction requirements. Name it Set of Hits or drill down reporting or even Sepcficiation report functionality. It would be useful to explore such functionality navigating into Compliance workbench, generating different search options and save those search outputs, save the search criteria as variants and use them for drill down reporting for generating output. Create report outputs using those search outputs like Excel Output, Substance listing etc.

In future if you are into a client business blueprint or technical development sessions, look into the options of proposing the concept of variants for meeting clients current as well as future likely requirements. giving them handy tools to avoid repetitive developments again in future !.

Thanks

Wednesday, July 7, 2010

Carbon Sequestration mapping in SAP Carbon Impact !!!!

Dear Friends,

Fews days back I got a mail from a Research Scientist who is working on Micronutrient management in Lakes and Estunaries in Washington University, who is seeing for information on how to capture forest sequestration related calculations into SAP Carbon Impact - This is where the true difference between a Enterprise Software and a Academic Interest appears. At the onset it may seem very easy to map using some custom activity type and provide calculation to accomdate that request. Is it really required for enterprises to work? Enterprise carbon management mainly comprise of Carbon Accounting, Carbon Reporting and Carbon Management - It might easily fall under the scope of Carbon Accounting, however from a enterprise point of view it may not be relevant. This is where it needs to be seen - unlike other SAP modules - which are Industry specific or cross functional, Green House Gas Management is above Enterprise level, it is of Global in nature - how best it is managed depends on the level of details the information is captured - may be it needs to be seen how SAP reacts to such requirements.

SAP Carbon Impact is a On-Demand module from SAP, used for mapping Company Carbon foot print, identify reduction measures, carry out surveys, check for product carbon, validate highlevel company KPIs. It has three types of functionalities built around - Analyze, Assess and Act. You can Assess inventories, Products, use the Analyze to view the Dashboards and reduction projects and Act - for creation of reports, goal settings and offset inventory management. Tools to create master data like Facilities, equations, input and output and templates for reports. You can export SAP Carbon Impact data into SAP Business Objects Business Explorer - to view multidimentional analysis of the data.

Thanks

Monday, June 28, 2010

EH&S Workflows and Reporting

Dear Friends,

As many of you know, the easiest thing in filling the customer workflow and data management requirements – is creating a new development. it is will be very useful if they can be looked from realigning the standard functionality offered by the EH&S. For Example, one of the business requirements is triggering of emails whenever some important information is changed in a specification database or whenever new injury / illness is entered or even creation of customer specific reports for their validations. Instead of investing on the development, existing functionalities might be used.

SAP EHS already have a good functionality which can meet such requirements like EH&S Workflow and Specification Information Systems. . For EHS workflow – a demo definition is provided EHS_DEMO, with a task EHS_DEMO_TSK. This task actually carries out task of processing value assignment types. This task can be copied and adopted to client requirements. The customization settings for the workflow Specify start conditions and Specify task profile can be used to enter the required information. Once Workflow scheduler runs in the background (RC1WFSUB) – they automatically appear in the assigned agent’s inbox.

Similarly, the functionality specification information system provides a inbuilt search options and creation of reports for user analysis. There are different options available like list report, excel output, compositions etc, which can be used for client requirement. To create a report, required number of specifications can be searched using search criteria (this can be scheduled in the background) and once the hit-list is generated a required output variant can be selected to create report.

These two are very versatile functionalities to meet the customer reporting and data management requirements and I feel are very helpful though it’s always tempting to ask for development work.

Thanks