Comparisons of SAP and Peoplesoft ERP Software

Can one software maker do it all well? There are many software development companies in the industry that are still striving to release a single, complete, successful product of outstanding quality and usability. With their modular approach to decision support software, ERP vendors are on the right track; because attempting to cover all of the separate functions of the modules would be unthinkably large and complex--not to mention costly--for one vendor.

However, Compare SAP and Peoplesoft ERP software, if each individual module has a unique function, then each module can be a different product developed by a different vendor dedicated principally to the success of a single product.

Of course, if an ERP vendor can manage to avoid the "not-invented-here" syndrome, it could integrate some of the best existing tools from the various niche software makers. For example, rather than writing a finite capacity scheduler from scratch, an ERP vendor could purchase the rights to license a scheduling tool from an existing best-in-class tool provider, and integrate it with its other offerings. Indeed, the drive to integrate best-in-class software tools from different functions may be the dominant wave of the future for the ERP industry.

Another important strategic issue facing Compare SAP and Peoplesoft ERP software ERP is whether the enterprise decision support market is essentially homogeneous or heterogeneous. While every company's specific problems are different, many problems are variations of themes. Are the similarities strong enough to support a "mass market" approach to software? Or are the differences going to keep the manufacturing software market a wide-open arena of niche specialists, systems integrators, and solutions consultants?

The point may be moot, as this issue will likely be decided by cost. Integrated packages from single vendors are going to require a major up-front investment, but buying different modules from multiple vendors will probably require a lot of effort to get them to work together, and maintenance costs will be higher in the long term if we compare SAP and Peoplesoft ERP software. If the issue comes down to pay me now or pay me later, is it possible that these technology decisions could be decided by each company's financial situation, rather than by what the best solution is? We hope not.

For some industrial managers, ERP is the nightmare that keeps them awake at nights thinking "Is the MIS department going to take over my manufacturing floor?" Much of the force pushing software makers to develop better, more useful software has been coming from practitioners: IEs and OR types who know exactly what they need from a software package. Often these experts end up actually writing the best software, as well. However, several of the ERP vendors, notably giants SAPAG and Peoplesoft come from the information systems world, and traditionally focus on the MIS piece of organizations.

For engineers who have spent months locating and purchasing software that they know and like, being forced to adopt "corporate's package" may seem like one giant step backwards. Yet, the potential strategic advantages of enterprise integration are undeniable. One thing is certain: if you want to have control over the tools you are going to be using, you're going to have to utilize your engineering training and expertise to exert positive influence on the selection process. If you sit passively on the sidelines, don't be surprised if no one hears you.

Clearly, there are more questions than answers regarding the young ERP movement. That said, we are left with one final question: will all of this change result in ever increasing consulting bills? The answer: almost certainly.

Reggie loves the ERP movement. Check out: http://www.erpsap.com ERP SAP.

Upload Excel Data to SAP: 7 Best Practices

Even with the standardized business processes and centralized data stores provided by SAP, much corporate data still resides in spreadsheets. Taking data in these spreadsheets and putting them into SAP remains one of the thorny challenges facing many corporate IT departments. Many business departments are wasting resources in manually reentering this data into SAP while introducing errors due to manual data entry. Functional and technical analysts in the IT departments are inundated with requests from business users to automate the upload of Excel data into SAP.

• Are you an SAP business user looking to reduce manual data entry for mass uploads or mass changes to SAP data, particularly when the data already exists in Excel?

• Are you an IT functional or technical analyst looking for ways to service the end-user requests for data uploadd more effectively?

• Are you looking for ways that your company can save time and resources in SAP data management?

If you answered “Yes” to any of the above questions, then this article is for you. This article describes 7 best practices in automating the upload of Excel data into SAP. Adopting these best practices will alleviate many of the pains that business users and IT analysts face in uploading Excel data to SAP.

1. Avoid Programming. With the several non-programming choices available to connect Excel and SAP, custom programming in ABAP or VB should be the absolute last resort for ad-hoc uploading Excel data to SAP. Not only programming is expensive and time consuming, a program that will be used only once or even once a year is particularly wasteful. Further, creating robust programs require a fair bit of testing and if a program has not been well-tested, it could be dangerous and cause irreparable data damage.

Use a scripting or a non-programming approach as much as possible. SAP provided tools such as BDC, CATT, LSMW, and third party tools such as Winshuttle’s TxShuttle will allow you to avoid programming to a large extent.

2. Do not Upload Directly to SAP tables. While this point is very obvious, it cannot be overemphasized. Writing directly to SAP tables avoids all the data validation and checks and balances that happen when creating data through the normal SAP transactions. So, avoid using any method that writes directly to SAP tables.

Always upload data via the pre-configured SAP transactions or BAPIs. Again, using tools such as BDC, CATT, or LSMW, or TxShuttle will allow the upload of data via SAP transactions instead of writing directly to SAP tables.

3. Choose a Record, Map, and Run strategy. A record, map, and run strategy generally involves first recording an SAP transaction where data needs to be uploaded. The recording step is followed by a mapping step where the SAP data fields captured during the recording are mapped to the Excel fields. Finally, the transaction is run over and over again with the different rows of data in the Excel file. A Record, Map, and Run strategy is similar to recording and running macros for automating routine tasks.

The advantages of choosing a record, map, and run strategy are that (a) it is very general and can work well for many different upload tasks and many different SAP transactions, even with custom transactions, (b) it is a very easy and intuitive approach and saves a lot of time making a mass data update, (c) it is something that even the business users can do themselves without requiring much IT support.

A record, map, and run strategy should be used for uploading data from Excel to SAP. Again, the SAP provided tools, such as BDC, CATT, and LSMW all support such a strategy and can work for many different upload applications. The TxShuttle tool simplifies the mapping recording and mapping tasks a lot and makes it even easier for business users. Also, for applications that require upload of transactional data containing header and line-items, such as journal vouchers, invoices, purchase orders, sales orders, etc., the TxShuttle tool has features that make it really useful.

4. Choose a Secure and SOX Compliant Method: Make sure the method you choose is secure and preserves SAP’s role-based security. In these days of Sarbanes-Oxley (SOX) audits, this point cannot be overemphasized. One key aspect of section 404 is checking that rights and duties are separately assigned to different individuals so that no individual has the power to divert business or transactions in a fraudulent manner. One of the most common open SOX audit issues is that users in the IT departments have very broad access to production data in SAP. Therefore to ease compliant with SOX, any mass changes or uploads should ideally be performed by the business users who are already authorized to make the change.

To allow business users to perform the upload via SAP-provided transaction-based tools, they would need extra authorizations to use these tools. If your company is not able to provide such authorizations, the use of Winshuttle’s TxShuttle product may be more appropriate since it lives outside the core SAP system and generally does not require extra authorizations.

5. Keep the data in native Excel format. If the data to be uploaded stays in the native Excel format, rather than being converted to comma-delimited or tab-delimited text file formats, it makes the upload process much simpler. One less step for the users to worry about.

The use of Winshuttle’s TxShuttle product allows the users to keep their data in native Excel format.

6. Select an outside-in approach: The two approaches to bringing outside data into SAP are: (a) an inside-out approach where the data import tools live inside SAP are used to bring outside data into SAP, and (b) an outside-in approach where the tools living outside SAP are used to bring outside data into SAP. An inside-out approach typically requires all the data import scripts and programs to live inside SAP and therefore need to be maintained as SAP versions are upgraded, even when the scripts are one-time-use only. Thus, these one-time use scripts clutter the SAP system when using the inside-out approach. An outside-in approach offers a cleaner alternative that can be used with the user’s existing security profiles.

The announcement of Microsoft and SAP’s joint product, Mendocinno, recently validates the importance that both companies give to an outside-in approach. Other add-on products such as TxShuttle also take an outside-in approach to connect to SAP.

7. Empower business users: On a final note, one of the best practices in uploading Excel data to SAP is to empower business users to do the upload themselves. The choice of the right tool for the business users which will enable them to easily upload data without requiring any programming will go a long way to freeing up IT resources for more mission-critical applications. Letting business users take control of their own data also makes SOX compliance easier.

An easy to use product such as Winshuttle’s TxShuttle which will let business users upload their own data from Excel to SAP allows the empowering of these business users.

In summary, the best practices in uploading Excel data to SAP proposed here involve choosing non-programmatic, easy-to-use approaches, and this will enable your company to save large amounts of time and resources in day-to-day SAP data management.

To learn more about SAP tools, BDC, CATT and LSMW, visit  http://www.sap.com.

To learn more about Winshuttle tool, TxShuttle, visit http://www.winshuttle.com.

At this site, you can download a FREE WHITE PAPER describing this problem and how the TxShuttle tool works at uploading Excel data to SAP. 

You can also download a FREE 15-day evaluation version of the TxShuttle software for connecting SAP and Excel.

Vikram Chalana is the SAP product specialist at Winshuttle, Inc. He has helped many clients automate their SAP business processes, in particular processes dealing with the connecting spreadsheets and SAP. He has been in the IT industry as a data minining, business intelligence, business process automation expert for over 10 years.

To learn more about Winshuttle, please visit http://www.winshuttle.com

A General Idea on SAP Master Data Management

Working across Sap heterogeneous forums systems at multiple places, SAP Master Data Management leverages accessible IT assets in business-critical data, delivering greatly reduced data repairs charges and very useful for sap business jobs. Moreover, by ensuring cross-system data consistency, SAP Master Data Management speed ups the implementation of business processes for jobs. SAP MDM is a key enabler of SAP Enterprise Service-Oriented Architecture forums.

SAP is at present on its second iteration of MDM software. Facing restricted acceptance of its primary release, SAP changed path and in 2004 purchased a small vendor in the PIM space known as A2i. This code has happen to the basis for the presently shipping SAP MDM 5.5, and for itself, most analysts believe SAP MDM to be more of a PIM than a broad MDM product at this time.

The components & tools of SAP NetWeaver master data management integrates business courses across the comprehensive value chain, delivering features and functions to help: Master data consolidation, Synchronization and distribution of master data , Centralized management of master data, Administration of master data, Management of internal content, Catalog search, Print catalog customization , Multichannel syndication of product catalog content, Business process support and Business analytics and reporting.

There are five normal execution scenarios:

Content Consolidation, Central Master Data Management, Master Data Harmonization, Rich Product Content and Global Data Synchronization With the SAP (MDM), you can:

1. Control customer relationships efficiently through streamlined visibility across various systems 2. Simply allocate master data to assigned systems through automated distribute and subscribe models 3. Lessen the number of part masters maintained worldwide by removing duplicates 4. Analyze and statement on spending by part, supplier, or other master data 5. Negotiate superior sourcing contracts based on analytical insights 6. Lessen supply chain charges by ensuring exact exchange of data involving manufacturers and dispensers or dealers. SAP Master Data Management is the basis for harmonized, reliable information that can be offered to client applications across the enterprise. It offers you a great way to attain information steadiness across your business or jobs and IT landscape. It enables improved decision-making, translating chance charges into gains, and reducing the charge of IT maintenance. SAP Master Data Management allows you to go with information across myriad applications and topographies -- whether that details resides in SAP, non-SAP, or legacy applications. Therefore, you can lessen costs, develop decision-making, and attain business goals on jobs. The sap news says that SAP (MDM) increases the sap jobs search and by training this sap certified course education module, it supports and gives more vacancies for permanent sap jobs for all developers or trainers worldwide.

Ron Victor is a SEO copywriter for SAP jobs
He written many articles in various topics like SAP news,SAP Forums,SAP Articles.For more information visit sap employment
Contact him at ron.seocopywriter@gmail.com.

Brazil: ERP Selection - Oracle, SAP, Microsoft

In the beginning of 21st century we can recognize the trend in international business. Multinational corporations are moving their manufacturing facilities and sales operations to Brazil. Typical scenario – regional office is established in Sao Paulo or Rio de Janeiro and manufacturing facility in Salvador, Porto Alegre, Curitiba, Belo Horizonte, Recife, Manaus, etc. The first step in establishing controllable operations is ERP system implementation – this formalizes the chain of command, decision making and management. In this small article we will give you Brazilian ERP market review for midsize and large business. We will compare Microsoft Business Solutions, Oracle, SAP as well as local ERP vendors: Microsiga and RM. Let’s come to the topic:

• Local versus International brand. We do not pretend to be the judge, just pluses and minuses. Local brand ERP has local market experience, tax, typical chart of accounts, payroll specifics implemented. They are probably very competitive if you are Brazilian business. However if you represent multinational company or corporation – you should think about users experience for your international management team, IT centralized support and things like these.

• SAP. If you are committed to SAP solution - SAP Business One is probably the system of choice – it has transactions integration to SAP, CRM, MRP/Production, POP, SOP, HR, Multilanguage, multicurrency. SAP Business One is just localized for Brazilian ERP market, especially we should mention localized tax engine. SAP tested its localization with 7 pilot implementation in 2005. You should be looking for SAP Business One customization partner (who is licensed to develop customizations and integration in SAP Business One SDK). SAP Business One sits in Microsoft SQL Server and is written in C++ - it also has integration with MS Office on the level of COM objects

• Oracle. Oracle E-Business Suite, also known as Oracle Financials (as part of Oracle E-Business Suite) and Oracle Applications is natural choice if your Headquarters in Europe, USA, Australia or elsewhere is committed to Oracle platform. Oracle has long time presence in Brazil and is very good choice.

• Microsoft Business Solutions Navision & Axapta. Microsoft is currently on the way of merging/integrating its applications – this is known as Project Green, in September 2005 new marketing name was introduced- Microsoft Dynamics. Respectively Microsoft Navision and Axapta became Microsoft Dynamics NAV and Microsoft Dynamics AX. More traditional solution for Brazilian market is Navision. It has very strong position in both Europe (where it is recommended by Microsoft in all the countries, except UK – where both Navision and Great Plains are in use) and USA- especially in manufacturing sector. Axapta, however is newer and respectively its design should be more geared toward new technological trends. Axapta should be released for Brazilian market in 2006

You can always appeal to our help and expertise – in our Sao Paulo office we have all these systems expertise, plus Microsoft CRM, MS Great Plains, Lotus Notes Domino. Please give as a call São Paulo 55-11-3826-3449, USA 1-866-528-0577, 1-630-961-5918! help@albaspectrum.com

Andrew is Great Plains specialist in Alba Spectrum Technologies (http://www.albaspectrum.com) – Oracle, SAP, Microsoft Great Plains, Navision, Axapta, Microsoft CRM Partner, serving clients in São Paulo, Rio de Janeiro, Salvador, Porto Alegre, Curitiba, Belo Horizonte, Recife, Manaus, Lisboa, Coimbra, Porto, Cascais and having locations in multiple states and internationally.

Remove Tree Sap From Your Paint

Removing tree sap (Gummosis as defined by Wikipedia) from your car's paint is generally a very difficult and time consuming task. Here are some tips and tools that are very effective and safe ways to remove tree sap.

1) You need to remove the bulk of the sap from the paint without damage to your paint. The most effective and safe method is to use a wood paint stirring stick. These are the flat wood sticks given to you free every time you buy house paint. These work well because they are soft enough to not seriously scratch the paint yet they have nice edges that can grab the sap and scrape it off. Be careful not to get too aggressive with your scraping if you care about the paint.With enough force, you could do some damage to your paint.

2) Remove the remaining residue with full strength Simple Green or Goo Gone. I have purchased a number of Tar and Sap removers that are made for this but so far, I have found full strength Simple Green or Goo Gone to do a better job and seems to be safe for your paint. Now, this does take a fair amount of rubbing with pressure to completely remove the remains of the sticky sap. Use a soft clean rag or cloth and apply the Simple Green to the cloth, then rub like crazy! An old sock works well.

3) Finally, apply a cleaner wax to the entire area that you worked on. In many cases, this is a number of areas on your roof trunk and hood because you parked under a nasty tree that was raining sap onto your car. With that, you should probably go ahead and wax the entire car... What else are you going to do on a Sunday afternoon? You may need to use a mild rubbing compound or a cleaner wax with a mild abrasive to eliminate any minor scratches created from step 1.

Gummosis on your windows - The easy part.

Any tree sap on your windows is easily removed with a razor blade. This is the easy part because you can scrape it all off in one pass without a worry of damaging the glass. Make sure to use a razor blade holder so that you do not cut your finger off and really make it a bad day!

Dean Chafee, owner and creator of http://www.HowToFixYourStuff.com A community of People Helping People Fix Stuff.
Dean is also a contributing expert at Experts-Exchange: http://www.experts-exchange.com/M_3706695.html