Saturday, January 31, 2009

Using SAP MDM 7.1 effectively and effeciently vinay swarup

Using SAP MDM 7.1 effectively and effeciently
vinay swarup



It is no more a hot news as what all is new in SAP MDM 7.1.Everyone interested in SAP MDM must have been aware of it by now. This blog mainly aims at discussing those features and their possible use .This is only my idea of representation and suggestion.

Well to begin with the most important feature ---having Multiple main tables. Wow! what important use it can be of !Many times in real life scenarios we need to share master data across different loosely or tightly coupled objects like Customer and Vendor ,Products and material as per the business needs .Now when one has actually finished modeling for Vendor and has a model for customer in pipeline ,he can reuse the vendor model by simply adding one more main table with name customer. In this case all the common tables supplying information like regions ,Countries ,Taxes etc. Also feather in the cap is these two main tables can actually talk to each other with new Lookup type Lookup[main].There are vendors who are also customers to an organization and this scenario can now be modeled better. Other complex and untraditional objects say Bank can now have relational data modeling .egs Bank might have several schemes modeled as product and it can be linked to customers in one repository only. So far so good .But some cautions should be kept in mind before actually freezing the modeling in such typical cases.

According to me following points might be worth giving a thought

a)How much reusability is there? Are objects defined as main tables in one repository well coupled and other supporting data tables can be reused effectively? Also how much efforts are saved?

b)Most importantly How bulky would repository be ?Overloading a repository with tables would result in bad performance especially while creating a record from portal, loading and unloading, searching for a record etc.So be careful while making your final call and justify your need

c) Suppose I have customer and vendor as two main tables in a single repository and I have two portal use cases for each object (customer and vendor) .But downloading a repository for any table would stop the portal working for another table .This means although my one object has no problem , it still suffers a downtime because of other object as complete repository is down .

Now coming to next feature --Introduction of Tuple. This data structure can be a dark horse as what MDM was missing was defining complex data structure by reusing the already created fields. Again only challenge is to first justify your need for tuple creation as it is a complex data structure and is proportionally connected to repository’s performance

Next comes trusted connections--Although they were launched before but MDM Standard iviews did not support trusted connection(correct me if I am wrong).I hope this is resolved as this can be helpful and we can get rid of storing passwords while transporting contents from one environment to another.

To move ahead transportation of MDM objects are better and now you can see your validations ,expressions and workflows getting transported as well .CTS+ promises to transport MDM contents .Again a welcome move from SAP.

Last but not the least SAP has promised considerable performance from repository as the downtime is reduced and online activities list has been appended.

So let's wait and watch this much awaited blue eyed product

vinay swarup is a Netweaver MDM EP Consultant with Accenture Services

Product configuration with the SAP SRM-MDM-Catalog 2.0 Daniel Busse

Product configuration with the SAP SRM-MDM-Catalog 2.0
Daniel Busse




Introduction:

The procurement of MRO goods in the company is increasingly electronically. Many companies put e-procurement systems to automate the procurement process and save costs. SAP AG offers with the SRM-MDM catalogueue a solution, based on the SAP NetWeaver MDM-based and using OCI with the SAP SRM. The proposed application is one of the possibilities which potentially could offer configuration options.

The Problems:

When searching for the products, the user can search among different (depending on the setting) choose. Then he receives a list of results to those from matching catalogue products to select and order. No additional information about the product, such as business card information’s can be added.

In the standard SRM-MDM catalogue, the user can select only the products which are store physically in the catalogue.

The proposed application provides the user the option to stored variants to configure and enrich a product with additional information about itself.


The Solution:

The order process without configuration looks like that :



image

Just add a single step to the standard process :

image



The product configuration is realized by a Java Web Dynpro application. When you click on the product, attributes in a selection screen stored in the MDM repository for this product appear. The information such as name and attribute values are defined in the Taxonomy and associated to the products. It can have information such as labelling of working clothes. This configuration and additional details will be concatenated and shown in a custom box. They will be transfer via OCI to the SRM module.

image



In the shopping basket the product configuration is shown in a separated field.



image



The application allows, presented in a user-friendly form, the configuration of products. Information not included in the MDM repository can be stored while order process is running. The total order includes the product, its configuration and any additional information which was entered.



Thanks to Nico Razlow who created this application and helped me to write this blog.





Daniel Busse Daniel Busse was born in 1981 in Mühlhausen/Germany. After high school graduation, he completed military service and studied business information at the Stuttgart Media University. Now he works for IBSolution GmbH, the innovative SAP NetWeaver consulting company. He is member of the R&D department at the IBSolution Labs in Heilbronn, Germany and finished his diploma thesis about catalog data management with SRM-MDM-CATALOG tool. His fields of activity are SRM-MDM-CATALOG, SAP Netweaver Visual Composer and Guided Procedures.

Thursday, January 29, 2009

Central MDM Business Partner Creation Scenario with Galaxy (BPM) - Part III

Central MDM Business Partner Creation Scenario with Galaxy (BPM)


The first two parts of this series dealt with overview of the process (part I) and some implementation details (part II) respectively. In this third and final part I'll talk about the rules integration as well as remote invocation of the process.

As a memory refresher - we wanted a rule such that if the new business partner record doesn't have a SSN entered the record should be manually approved. Otherwise it should be approved automatically.

Think of this rule as a function which takes two arguments - "context" which passes the entire web dynpro context to the function and "return" of type Boolean which is set to true if manual approval is needed and false otherwise. The rule engine will pick up the SSN entry from the context, evaluate it and set return accordingly.

Here's the rule at design time:

image

Since the return type is Boolean we can conveniently assign this function as a condition to the non-default gate of the exclusive choice gateway. Check the process model in part I for clarification.


For example, if you have called the ruleset as "checkApprovalMethod" and if the non-default gate for the exclusive choice is the one for auto-approval, then as a condition for this gate you can write: not(checkApprovalMethod(Context,IsAutoApproval)). So this gate will be taken by the process if the condition evaluates to true. Here Context and IsAutoApproval are two data-objects that you have created. IsAutoApproval is of type Boolean here.

So much for the rule, let's look at the way to start the process remotely. True to BPMN standards, every Galaxy process model has a Start event which can be bound to a web service interface and an operation of that interface. We can also handcraft wsdl files to suit our needs and bind it to the start event.

For example, in this scenario I had to pass the record ID to the process context when the process is started. So I added the following XML element to the default process start web service WSDL provided by Galaxy.
image
Logically if we invoke this web service operation manually it should start the process and that is exactly what happens! All you need to do is find out the URL of the wsdl of this web service from the NWA and the rest is easy. Since I was using web dynpro, I simply created an adaptive web service model out of this web service and invoked the operation on click of a button.

That brings us to the end of this series. Let me know if you have any questions regarding the implementation or about this scenario by posting your comments.





Satyajit Chakraborty is part of the BST Innovation Center team in Palo Alto.

Friday, January 23, 2009

Root Cause Analysis for SAP MDM 5.5 SP06 with SAP Solution Manager Diagnostics Detlef Thoms SAP Employee

For today's complex IT solutions, analyzing the root cause of an incident requires a systematic top down approach to finally pinpoint to the root cause of an incident. SAP MDM 5.5 SP06 Patch1 or higher can be integrated into the Root Cause Analysis scenario in SAP Solution Manager as of Solution Manager 4.0 SP15. Solution Manager Diagnostics provides two applications to perform workload analysis:

The E2E Workload Analysis application provides hourly aggregated performance and resource consumption data. It allows comparing performance data of multiple systems and has a very flexible data display. It provides solution wide performance data and allows isolating a system or software component that caused performance problems. The E2E Workload Analysis is the starting point for Root Cause Analysis of performance problems.

Wily Introscope provides non-aggregated performance and resource data for MDM and Java Systems. It can be used to perform detailed analysis of the MDM or Java System once the E2E Workload Analysis isolates a system or software component that caused performance problems. The Introscope Enterprise Manager is part of the CA Wily Introscope system management application. It is installed as part of SAP Solution Manager.



Since the new capabilities have been recently released I would like to point you to some resources that demonstrate how to perform Root Cause Analysis for SAP MDM using SAP Solution Manager.

The first one is a setup guide: "How To...setup SMD for MDM Root Cause Analysis - MDM 5.5 SP06"
http://service.sap.com/installMDM > Operations > MDM 5.5 - Monitoring Guides (ZIP File)

A second guide describes how to perform a root cause analysis:
"How to Perform Root Cause Analysis for Master Data Management with Solution Manager Diagnostics"

In addition a further SDN article and a presentation give an overview of the new capabilities:
„Root cause Analysis with Solution Manager Diagnostics for MDM"
„Monitoring Capabilities and Root Cause Analysis for SAP MDM"

A Know How Network Call (KHNC) will be given on April 30th. The presentation will be recorded and can then be found here.



SAP NetWeaver RIG is also planning a feedback project on the usage of Solution Manager Diagnostics for MDM - purpose of this is to gather customer feedback about the new functionalities for Root Cause Analysis and Monitoring. If you are right now working or will work with the new capabilities, please let me (detlef.thoms@sap.com) know. We have prepared a brief questionnaire to roll-in your feedback and requirements into the next version!



Detlef Thoms is a RIG Expert for SAP MDM and a member of the SAP NetWeaver Regional Implementation Group(RIG).

SAP MDM integration with R/3 system by Ravi Kumar

We all know what are the different It scenarios supported by MDM, namely:
Master Data Consolidation

*
– Cleansing and de-duplication
*
–Data normalization including categorization and taxonomy management
*
–New interactive consolidation capabilities

•Master Data Harmonization

*
–Automated synchronization of globally relevant master data information
*
–New interactive distribution capabilities

•Central Master Data Management

*
–One-stop data maintenance
*
–Ongoing master data quality

In this Blog I will try to cover the different steps required for integrating MDM with R/3 system which is the source of Master data.After cleansing and de-duplication of Data in MDM all changes/ updates will be reflecting back in SAP R/3. this step by step procedure should help in understanding the procedure for implementing MDM IT scenarios. :)



Different settings required for doing this are:

* Settings in R3
* Settings in XI
* Settings in MDM
* MDM console
* Import Manager
* Syndication Manager

MDM Process flow









Process Flow: Trigger Idoc containing Masters from R/3.XI converts these Idocs to XML files and places in ready folder for Inbound port. Files received by Import Manager into MDM and after changes etal via Syndicator Manager xml file placed in Ready folder of outbound Port from where it will be picked by XI and sent to R/3 using the Idocs.





Setting in R/3:

Step 1



T.Code: SALE

Define Logical System





Sender Logical System:





Receiver Logical System:



















Step 2: T.code: SALE



Assign Client to Sender Logical System:







Step 3:

Create RFC destination of type ‘3' for SAP XI system using transaction - SM59





Step 4:



Create a Distribution model through T.Code: SALE/BD64



Here we need to mention Sender Client (DEVCLNT500) and Receiver Client (XICLNT100) and Message type (MATMAS)









Step 5:

Using T.Code: WE21



Maintain Ports for IDoc Processing



















Step: 6



Maintain Partner Profile using the T.code: WE20









Step 7:

Using BD12/BD10 T.code to Send Customer IDoc or material IDoc











Using T.code WE02 we can confirm or see the message transformations.







Now we are able to generate IDoc from R/3 containing the master data.

Settings in MDM:

Select the repository for which you want to do the settings.









Go to "Admin" and select "Client Systems" and right click on it and create your client system















Then go to "Ports" for creating a Port for Client System







Here you are defining the Outbound Port for the Client system (MDC R/3) defined in previous step.

You have an option of processing the data Automatically/manually.





After Saving the "Port" and "Client System" you need to ensure the folders in respective repository has been created in server.







Because "Ready" is the folder where all the files get exchange from.



Similar steps should be repeated for Inbound Port.





MDM Import Manager: Assuming that all the settings are done in XI also we move to Import manager where we will select the file to be imported and steps to be followed for import of Data into MDM



Step 1: Login to Import Manager and connect to Source file. Select type as PORT. System automatically connects to the Inbound Port of the repository logged into.







Step 2: Do all Field mapping and value mapping in Map Field/Value tab.we can use the standard maps provided in Business content or do all mappings manually and save the map.







Step 3: Go to match records Tab select the Field used for Matching records and select the import action. PS : For each record we can manually override create/skip as import action.











Step 4: After all mappings has been done and import action is Ready to Import in Import status tab execute the import









This will import the records contained in the xml file from the Ready folder into MDM.GO to Data manager and check all records created from R3.





Syndicator Manager MDM:



Any changes made in MDM data manager based upon the validations/Assignemnts and Business rules the changed record should be syndicated back to R3 which is Data source.



Step 1: Login to Syndicator Manager giving the repository name. select File> Destination Properties and select Port as shown:



Select the remote system R3 in this case

Select the Port which we have created for Outbound port where the Syndicated file can be placed in XML format.











Step 2: Do all the mappings again. Use the standard maps provided in Business content or do it manually like in Import manager. We have the options of selecting few records based on search parameters. We also have the option of Supressing all unchanged records in map Properties. This will select only those records which has been changed in Data manager instead of all existing records.









Step 3: In Destination Preview we can actually see all records with the values for fields before syndicating. This should be always done before executing to reduce the erroneous /incomplete data flow. Once you have all the details execute the syndication.











Step 4: Check the IDoc list in SAP. In case of status 51 do the further analysis why it has failed.











RESULT: data changed in MDM Data manager will be updated in SAP R3 system provided all the mappings are correct.

Ravi Kumar is Consultant with Infosys.

Wednesday, January 21, 2009

SOA and MDM - Two Integration Solutions That Go Great Together? By Loraine Lawson

I just happened to receive notice today in my inbox of a Webinar on master data management (MDM) and SOA. Normally, I save these announcements for Friday's integration news round-up, but the event is scheduled for this Thursday, March 20, at 11 a.m. ET.

This event caught my eye for a couple of reasons.

First - though perhaps not the best reason - it's like a meeting of the products on opposite sides of the "peak of inflated expectations" on the famous Gartner hype cycle: Master data management is on its way up and SOA...well, I suspect SOA may be headed for the trough of disillusionment. I know I'm feeling pretty disillusioned since I learned people can't even agree on a definition for the "service" in SOA. But I won't go there...for now.

Second, both SOA and MDM involve, in one way or another, integration - so I can't help but wonder what happens when you marry the two, which is precisely what the event promises to discuss.

Third, MDM is all about the data and, as regular readers know, SOA has data "issues," whether you're talking data integration or data services. So, it'll be interesting to see how the two even fit together. The promo e-mail entices with this bit of marketing:

"More than just the latest three-letter acronym, SOA case studies demonstrate that in order to be successful, you must spend time on the data contents of all those messages flying around your ESB or EAI infrastructure (hint: it's not just web services!). Conversely, MDM isn't just the latest trend....Combined, MDM and SOA provide the best of best worlds and increase your chance of succeeding with an enterprise-wide future data architecture."

Marty Moseley, the CTO of Initiate Systems, is the presenter in this event, which is the latest in an ongoing vendor-sponsored MDM University Webinar Sessions. You'll need to select the presentation and fill out a basic form to preregister. After submitting the form, you'll gain access to the previous presentations, which are available for on-demand viewing.

One thing that SOA and MDM do have in common: Neither are supposed to be tied to specific technologies or vendors. While that's well-publicized with SOA, it's perhaps not so often said about MDM.

If you're just starting an MDM initiative, you might want to check out my February interview with Rob Karel, a Forrester Research principal analyst specializing in master data management (MDM) and data integration.

Karel explains what you need to know about MDM and what you should do before you talk to vendors about specific solutions, including this list of questions you should answer before you talk to vendors:

* Do I have sufficient business sponsorship and participation in the MDM effort?

* Am I solving for operational MDM, analytical MDM, or both?

* What sources and targets do I need to integrate my MDM solution with?

* What data integration solution should I leverage (ETL, SOA, EII, EAI, etc.)?

* Am I looking for a single vendor solution or best of breed to build out my MDM ecosystem?

* Have I scoped our MDM strategy appropriately?

Karel also walks through the MDM adoption steps you should take - assuming you want a solution that fits your needs, rather than just buying what a vendor offers. Given that Thursday's MDM/SOA Webinar is vendor-sponsored, the Q&A with Karel might be a useful pre-event read.

Article Source: http://EzineArticles.com/?expert=Loraine_Lawson

Loraine Lawson - EzineArticles Expert Author

Monday, January 12, 2009

Computers-and-Technology

Monday, January 5, 2009

ERP/Accounting Selection: Microsoft Dynamics, Oracle, SAP – expansion to Europe by: Andrew Karasev

This article is targeted at US-based mid-size and large companies, planning the expansion and opening branches in Europe. It is for IT director, who is nowadays responsible for ERP/MRP platform selection and following implementation. The format of the article doesn’t allow us to come up with detail specs comparison, we will be rather giving you highlights for further research and checklist of things that you should not miss at the consideration. We will begin with the specific of the market and then point out to the solutions available.

• Multiple Languages. Continental Europe doesn’t speak on English language natively – documentation is in German, French, Italian or whichever country you consider. It is not just a question of finding English speaking and writing accounting personnel – as you will see, reading further

• Taxation. Now it is becoming more standardized, however you should now that in Europe you have to deal with VAT (Value Added Tax), in comparison to Sales Tax in the US. VAT should be paid not only by end consumer, but also by resellers, distributors, etc. Also it is common practice when Services are taxable in European countries.

• Government Reporting. In the USA you report on the federal and state levels and usually IRS and the states don’t care about the accounting system you use. In Europe, again depending on the country and probably this tendency is more applicable when you move Eastward, the government might have more involvement in the ERP brands selection, recommending several systems as approved, certified, localized, etc.

• Accounting Procedures. In some countries (France, Russia) you may encounter with the situation, when government wants you to use recommended chart of accounts, usually generalized and geared toward manufacturing accounting, which might be a nightmare in the case if you are service-oriented business. Considering innovative nature of US businesses in expansion mode – this issue should be addressed

Now we will give you solutions highlights

• Local ERP. The specific legislation and conditions of the country you chose for your European penetration probably produced several locally originated ERPs. As a tendency – these systems typically deal with government reporting and available in local language only. If you decide to implement such a solution, please understand the trade-ins – you can not find US/international managers who could efficiently take the control over when needed.

• Microsoft Dynamics. Microsoft Business Solutions these systems for continental Europe: Navision, Axapta – Microsoft Dynamics NAV and Microsoft Dynamics AX (Microsoft Great Plains/Microsoft Dynamics GP will be pulled out from France, Germany and Holland, where it currently has some market presence). Navision & Axapta are both localized and “approved”

• SAP Business One. Assuming that you represent mid-size business – this system has all-in-one and the named user license includes all the modules (you can have CRM-only client for your sales people at ½ of the price). SAP Business One was designed with the ideas of the Multilanguage, flexible reporting and object-oriented tax engine. Plus SAP Business One has transaction integration to mySAP.

• Oracle Financials/E-Business Suite. This solution, coming from Oracle, also referred as Oracle Applications should be considered as very efficient and reliable. It is also localized and has very long market presence history in Europe. Oracle comes with J2EE/EJB/Java customization & development

• IBM Lotus Notes/Domino. It is not an ERP – it is rather the platform, Lotus is very popular in Europe and you should consider and respect it if you purchase existing company, using Lotus for document workflow

• Integration, Customization & Reporting. You should consider European branch ERP integration ability to your corporate ERP in the USA and management reporting compliance.

Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com

About The Author

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.enterlogix.com.br http://greatplains.com.mx ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN, Europe: Germany, France, Belgium, Poland, Russia, Middle East (Egypt, Saudi Arabia, OAE, Bahrain), Asia: China, Australia, New Zealand, Oceania, South & Central America: Mexico, Peru, Brazil, Venezuela, Columbia, Ecuador, Chili, Paraguay, Uruguay, Argentina, Dominican Republic, Puerto Rico

SAP Business One – MRP Implementation in São Paulo by: Arthur Ferretti

SAP just introduced localized version of its mid-size and small ERP solution – SAP Business One. As you probably know SAP Business One has Multilanguage in one company feature, and it is adaptable to unique tax rules, which is the case in Brazil. Among the other localized solutions: Microsoft Navision, Oracle Financials (or the whole set of Oracle Business Suite – Oracle Applications), Microsoft Axapta (localized version should be release in 2006), SAP Business One should be considered to be implemented for either Brazilian company with the connections to European and American market and business partners or for Brazilian branch of multinational corporation. Let’s consider market specifics and how SAP Business One could potentially fit for the ERP market in Sao Paulo, Rio de Janeiro or the whole Brazil.

• Multilanguage & Brazilian Portuguese Support. This is really strong point of SAP Business One - you can switch from say Portuguese to American English by pressing cntrl keys combination. System will close all your existing screens and this is probably the only inconvenience you may notice. Please, be aware that SAP Business One has also version with Portuguese interface for continental Portugal.

• Manufacturing/Production module. For the multinational company Brazil is often considered as the place for quality and cost efficient manufacturing operations. And we see diversified needs for manufacturing automation – from machinery to food processing. SAP Business One Production module targets the whole spectrum of manufacturing needs.

• CRM. CRM module is integrated within the system. We should mention modern design of CRM module and really intuitive interface for business professionals, dealing with sales analysis.

• HR. SAP Business One doesn’t have Payroll module for Brazil.

• Drag & Relate. This feature allows you intuitively drag and compare/relate the data in the system.

• Customization, Reporting & Integration. SAP BO integrates with Microsoft Office on the level of COM objects, it sits in MS SQL Server database (the only platform available for Brazil at this time). It has SAP Business One SDK and we expect large number of ISV with custom products show up on the Brazilian market within a few years. Besides internal SAP BO reporting – you can do reporting from SQL Server directly.

• Competitors. If you are looking from the number of installations in Brazil, then you should consider Microsiga, where you will see similar slightly higher license and system implementation prices. If you are looking for international ERP brand, localized for Brazil – then consider Microsoft Navision/Dynamics NAV, Microsoft Axapta/Dynamics AX and Oracle E-Business Suite, which includes Oracle Financials, also known as Oracle Applications. Microsiga should be recognized as very efficient Brazilian tax & government reporting solution, at the same time SAP, Microsoft and Oracle are catching up with the compliance of their localized MRPs.

• Releasing Dates. SAP Business One, having over 8,000 installations Worldwide is scheduled to be released in Brazil in November/December 2005. Microsoft Navision and Oracle E-Business Suite are available and availability of localized Microsoft Axapta (Microsoft Dynamics AX) version is 2006.

• Licensing Price Structure. SAP Business One has all-in-one named user licenses. This means that you do not pay for adding new modules – all the modules are available for the user and included in the license price. CRM-only user license is available at 50% or the all-in-one user license. SAP Business One requires also annual maintenance fee, which will give you now standard for the ERP industry software upgrade and discounted technical support.

Please give as a call São Paulo 55-11-3444-4949, USA 1-866-528-0577, 1-630-961-5918! help@albaspectrum.com

About The Author

Arthur Ferretti is SAP Business One specialist at Alba Spectrum Technologies ( http://www.albaspectrum.com ) – Oracle, SAP, Microsoft Great Plains, Navision, Axapta, Microsoft CRM and IBM Lotus Notes Domino 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.

Basics of Database in SAP by: Ron Victor

SAP like enterprise applications are specifically made up of programs with the data which are used by and created by those programs. In a meaningful way the data are organized within in a database, For the benefit of programmers, which are made easy so that they can access and find the necessary data to do something useful, for instance run a financial report or to create a sales order. The programs and the data will be in same database for SAP component or product like ECC, Normally each component will posses its own database (Even some exceptions exists) - a production system landscape composed of SAP Business Warehouse (BW), SAP ECC, plus SAP Customer Relationship Management (CRM) consists of three production databases. Given its basic station in the life of an SAP system, since it is important we have to understand the over all role of database.

Highlights of this hour comprise

Exploring the concepts as well as structures of an RDBMS

Determine which databases are supported by SAP

Learning the disparity between a primary and foreign key

Find out why indexes speed up data retrieval

Structure of Database

A database can be said as electronic warehouse where we can store information’s in an organized manner so that the system can find the desired information quickly.

The database is composed of tables, columns (called fields), and rows (called records or data). A simple example of a database is telephone book which are organized alphabetically so that it make the user to get their information very easily likewise the database is formed with the same concept. Instead of man the system will do the work so the work can be done easily and efficiently.

The basic structure of a database is somewhat comparable to a Microsoft Excel spreadsheet in which columns (fields) store row after row of records (data). The major difference between a database as well as a spreadsheet is simply that databases be able to contain multiple tables that are connected to one another through relationships. Thus, a database can be thought of as a much more complex, plus ultimately much more useful, spreadsheet.

The database plays an important role in each SAP system, as it houses all the data that are used by that particular SAP component or else product. Several brands of databases exist, making it easy intended for an IT shop to choose a database vendor with which they are probably already well-known. Currently, SAP can use a range of different brand name database releases ranging from very expensive as well as imminently flexible to very inexpensive as well as yet quite capable.

It is significant to note that not all database vendors as well as versions are supported by SAP. SAP is likely to stick with the market leaders, over the years adding as well as removing support intended for certain vendors. In this way they not just limit the amount of database-specific customization they have to perform, but they endow with IT shops with flexibility plus choices, keys to success both for SAP as well as the IT organizations tasked with organize and supporting SAP solutions.

About The Author
Ron Victor is a SEO copywriter for http://www.simplysap.com He written many articles in various topics.For more information visit http://www.simplysap.comContact him at ron.seocopywriter@gmail.com

Software Consulting for Todays Business by Fernando Vargaz

With so many businesses now making the switch to business management software, the need for software consulting services has also expanded in kind. You see, each business will have its own unique requirements that will necessitate that any business related software that they implement be custom fit to their exacting needs.

Payroll Software

Take payroll software for instance. While the fundamental principles of the payroll system are basically the same from one business to another, the intricacies involved in how each company compiles the data that they use to calculate and process payroll information can differ dramatically from one business to another.

Manufacturing Software

The same thing applies to manufacturing and inventory based software. Needless to say, no two manufacturing companies will be the same and neither will the systems that they have in place for storing and keeping inventory of the materials that they base their manufacturing operations from.

Determining Differing Needs

So, while two manufacturing businesses may need the same basic software tools, each company will need it customized to fit their own unique applications. Determining what theses needs are and how they will be integrated into the software that they use will be the job of a software consultant.

Make it Easy on Yourself and Your Company

Trying to make software work that is not customized to a companies exacting needs can be far more trouble then it is worth and in the end will inevitably lead to unnecessary expenses and losses. This is why it is imperative for a company to seek out and confer with a software consultant prior to implementing any type of business based software.

software consultant, sap developer

About the Author

Written by Fernando Vargaz. Get all the best details on software consultant and sap developer

Offshore Development as it Pertains to Websites by Fernando Vargaz

Today you have more choices then ever before with regards to the people and place your website is going to be developed. Of course, this means that offshore development is definitely one of your options. However; what exactly are the benefits, if any, to taking this route for having your website created?

Lower Overall Cost

Actually there are many and some of these benefits may in fact surprise you. Of course, for the time being overall labor costs will be much lower offshore but there is far more to consider then just cheap labor when launching a website. After all, the last thing that you need is a website that looks like it was done cheaply.

To Sell in Rome talk to Romans

With offshore markets expanding as they have been in the past decade, who better to go to to understand and capitalize on overseas markets then the people who live there. It is these people who can best provide you with expertise and insight that you need to best cater to this growing market region.

A Collaborative Team Working Together

One thing that you will also find in offshore website development enterprises is that their entire labor pool works together under one roof. With this arrangement they are far better able to collaborate more effectively, particularly on the more complex projects that require an actual team effort.

You Won't be Dealing With Kids

Another positive aspect of offshore development as it pertains to websites is the level of professionalism that you are more likely o encounter. The truth is that when you deal with an offshore developer who is designing your website chances are that he or she is a university graduate, around 35 years of age, who has an extended family to support. This of course means a far more responsive and diligent designer you will be dealing with.

oracle consulting, sap consulting

About the Author

Written by Fernando Vargaz. Come on over to my website and find all you wanted to know about oracle consulting as well as sap consulting

A Few Tips to Help You Become a Successful SAP Developer by Fernando Vargaz

Who wouldn't like to become a successful SAP developer? It's a fantastic job to have that is not only intellectually rewarding but financially rewarding as well. However; bear in mind that you must have a certain level of intelligence and education before you even consider taking the necessary steps to becoming a SAP developer.

Know SAP Products

SAP employs a huge number of consultants that work in conjunction with SAP developers. This is because SAP is a consulting firm that in turn developers and sells the products that the consultants recommend. Of course this would also means that your knowledge of SAP products must be complete.

More Stuff to Know

Also, because SAP consultants serve a wide range of business genres, ranging from all areas of the chemical and petrochemical industries, as well as other industries including all types of manufacturing and wholesaling industries, it does help if you possess some level of expertise in some type of business or industry.

No Place for Wimps

However; you have to bear in mind that SAP developers and consultants work in world filled with ambitious type A personalities, so the stress level can be very high at times. What this means is that if you are not entirely up to the challenge then you may want to reconsider other career options.

Willing to Think Out of the Box

However; the pay and benefits for a good qualified SAP developer are among the best that you will find anywhere, so if you like good money then you will like being a SAP developer. So, if the bad economy has gotten you down, don't fret because there are still plenty of god job opportunities out there for people who are willing to think out of the box such as SAP developers do.

sap developer, sap consultant

About the Author

Written by Fernando Vargaz. Find the top information on sap developer as well as sap consultant



SiteProNews - Expert Articles
A FREE webmaster resource site, focusing on web site promotion, submission, positioning, and design.
SEO-News.com
A free newsletter & forum for web business owners about Search Engine Optimization.

Give Your Website
Top 10 Exposure

Click Here!

Bookmark this article:

DropJack! DropJack! | Delicious del.icio.us | Furl Furl | Technorati Technorati | Blinklist Blinklist | Reddit Reddit | Mister Wong Mister Wong | Socializer Everywhere Else

Small Business ERP: Dynamics GP or SAP Business One by Andrew Karasev

Corporate ERP and MRP application selection process is not an easy fun. ERP application may ruin your business, if it is too expensive in the sense of users licenses and ERP implementation consulting cost. At the same time, corporate ERP is capable to boost your small or mid-size business to new sales and profit goals achievements. If you are very small business we recommend you to review such packages as Peachtree, Quickbooks, MYOB, Microsoft Small Business Accounting. However if you feel that you have already outgrew these small business accounting packages, we recommend you to consider Dynamics GP Great Plains, coming from Microsoft, and SAP Business One MRP and ERP, coming from SAP. Both are recognized ERP brands, and both have strong vendor commitment and solid customer support

1. Alba Spectrum recommendation. If your small business has the need in solid discrete manufacturing, we would recommend SAP B1 over Dynamics GP. In the case of Dynamics GP Business Ready, you have access to Bill of Materials extension to GP inventory control. SB1 has Production module plus MRP wizard. Great Plains has similar functionality in POP replenishment wizard, however implementation is more expensive and not so intuitive as you could expect from SAP BO

2. HR and Payroll. If you are Payroll services outsourcing small or mid-size business, Great Plains with its US or Canadian Payroll modules and HR are the ways to go. SB1 has HR module, which fits to employee selection and recruiting process as well as to certification tracking, but if you are looking for SBO Payroll module, you will be redirected to third party ISV add-ons

3. Latest Versions. Great Plains 10.0 (January 2009) and Sap Business One 2007A (also January 2009 for US and Canadian ERP markets)

4. Data Mining and Data Warehousing. Both SAP B1 and Dynamics GP are MS SQL Server based, and you can deploy SQL Server Analytical processes with Excel Pivot tables to implement Datawarehosing and OLAP reporting. In Great Plains you can also deploy Analytical Accounting and FRx forecaster


About the Author

About Alba Spectrum. Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com. Serving ERP and MRP: Great Plains and now SAP Business One community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com



SiteProNews - Expert Articles
A FREE webmaster resource site, focusing on web site promotion, submission, positioning, and design.
SEO-News.com
A free newsletter & forum for web business owners about Search Engine Optimization.

Give Your Website
Top 10 Exposure

Click Here!

Bookmark this article:

DropJack! DropJack! | Delicious del.icio.us | Furl Furl | Technorati Technorati | Blinklist Blinklist | Reddit Reddit | Mister Wong Mister Wong | Socializer Everywhere Else

SAP Business One Consultant Newsflash: Nationwide Support by Andrew Karasev

SAP B1 ERP and MRP is rising star in American and Canadian accounting software market, especially since the release of SAP BO 2007A for US in May of 2008. SAP Business One has complete set of modules to serve small to mid-size firm: Financials, Manufacturing, MRP, CRM, Services, Purchasing, Picking and Packing, Sales, and others. Plus consider modern interface with intuitive export to Excel, drag-and-relate, users self study and self discovery possibilities. In this small publication we would like to give you SB1 case studies and typical implementation scenarios paragraphs:

1. Discrete manufacturing or light assembly. If your company is small and doesn't need full-scale production software, typically expensive in both software licensing and implementation services, SBO is excellent candidate to consider. If you are making to order, then SB1 has disassembly Production Order, where you can disassemble cancelled order and place all the parts back on the shelves or their bins

2. Service Warranty Contracts. Warranties are typical business scenario for small manufacturing, dealership and distribution companies and it is probably true statement, that this reasonable market niche is underserved. In SAP Business One you can associate serialized item (with serial number) with Service Contract, and then you can repair the item on as needed base under warranty with free technician support, spare parts, or decide to bill for portion of warranty services. You can also associate technical support knowledge base with your items and contracts

3. Warehouse Management. Picking and Packing functionality allows you to automate paperwork associated with assembly, finished goods and parts storage and release to be shipped to your customers or returned back to your suppliers. There are also barcode add-ons to automate barcoding scanners in real time or batch mode with barcode servers

4. SAP Business One Reporting. Please, consider such industry standard reports design tool as Crystal Reports to be deployed.


About the Author

Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com . We specialize in SAP Business One nationwide implementation and support. Serving ERP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com

ERP for Small Business: SAP Business One vs. Great Plains Dynamics GP by Andrew Karasev

If you are small of mid-size business, and you are in the corporate ERP and MRP selection process, please read this small publication. We would like you to concentrate on your Business Processes automation requirements in trying to understand which small business accounting package will fit the best for your enterprise

1. Database Platform. There are several reliable and relatively inexpensive SQL oriented DB platforms on the ERP market: MySQL (good option if you are making custom programming in PHP platform), Microsoft SQL Server 2005 Select (also consider Microsoft SQL Server 2008 for Small Business Server 2008) - also you can get scaled down version from Oracle, which is outside of the scope for this paper. SQL compliance is in our opinion critical, and it is not recommended to choose proprietary DB, typically coming together with such accounting applications as MYOB, Peach Tree, Quick Books

2. Words of respect to Linux and other free Operating Systems. We recommend you to review such Linux platforms as Suse, for example, where you can get software free of charge, and where you pay per customer support case only as you go. We would like to keep reservations at this time to recommend ERP selection on Linux, however we encourage you to make your own ERP market discovery

3. SAP Business One. This ERP and MRP application for Small Business comes from SAP and we trust this ERP brand. SB1 is available on Microsoft SQL Server 2005 and with version SAP Business One 2007A it is now pretty reliable and localized for United States: 1099, Sales Tax, Barcode, Warehouse management, Credit Cards Processing, eCommerce module, CRM. SAP Business One SDK allows you to customize user interface as well as Database transactions: EDI, Integrations with legacy systems: Microsoft CRM, Lotus Notes Domino, Oracle

4. Great Plains Dynamics GP. This solution is coming directly from Microsoft Dynamics subdivision. If you are one-person-operations, we would like you to review Microsoft Small Business Accounting - both SAP BO and Dynamics GP would be probably too expensive for you. Current Dynamics GP, belonging and supported by Microsoft Business Solutions had long small business accounting trace: Great Plains Accounting for DOS: 9.2 and 9.5 were the most popular versions, Great Plains Small Business Financials 7.5, 8.0 and 9.0 were dedicated to small business scaled down versions of Microsoft Great Plains. Current trend in SBF is upgrade and migration to Dynamics GP Business Ready

5. MRP. Both SAP Business One and Great Plains Dynamics GP offer discrete Manufacturing and MRP modules. SAP Business One is closer to small business in our opinion, where you can do intuitive Production Module self discovery. Great Plains, however has Bill of Materials module, which could cover small business manufacturing and assembly

6. Great Plains eConnect versus SAP Business One SDK programming. Both SDK packages are targeted to custom ecommerce applications and software developers. We would like to treat them with the same respect and recommend for deployment

7. Corporate ERP reporting. In both cases we recommend you to consider Crystal Reports. In the case when you are tight with the budget, try to consider Microsoft SQL Server Reporting Services or SSRS, as this extension is coming free with Microsoft SQL Server 2005 or 2000 Standard or Enterprise

8. Legacy accounting data conversion and migration. If you company deployed such proprietary accounting packages as PeachTree, MYOB, QuickBooks, we recommend you to consider printing modules reports and saving them in Text tab or comma delimited files, Excel also is good option

9. ERP for International Business. Even Small Business could be involved in international operations, such as purchasing your merchandise from China, India, Philippines, Brazil, Mexico, Russia. If this is your scenario, please try to make the research of Microsoft Business Solutions ERP products support internationally. At this time Dynamics GP is supported in English Speaking countries, and SAP Business One is localized for major nations: Latin America, France, Germany, Italy, Portugal and Brazil, Israel to name a few


About the Author

Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com. Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP call center



Your Ad on 100's of Engines
$4 per Month or less
Silver Dragon Electronics
Superior HDTV's and Laptops Wholesale Pricing
Discount Electronics
Find the best deals on Computers, HDTV's, MP3, Video Games systems, Monitors and more
Get up to 40% CASH BACK
Shop MAJOR DEPT. STORES BUY and SAVE. Get up to 40% CASH BACK on name brand products
Bargain Computers
Shop for Computers, Monitors, Printers and Accessories. Buy Online and Save!
Donald Roby's Gift Store
Visit Donald Roby's Online SuperStore for the best buys on the web
one stop online shopping mall
Buy your laptop computers, digital cameras, cell phones, Flat screened tvs, dewalt tools.
Ultimate shopping Store
The ultimate online mall. Stores such as target, Ebay, Office depot, and Travelocity
Discounted Computers
Huge discounts on computers, software, peripherals, and much more!
Computers & Electronics
Huge selection of computer products and electronics for businesses and consumers near wholesale cost
Computers
Online retailer of computer hardware, software, accessories,

Bookmark this article:

DropJack! DropJack! | Delicious del.icio.us | Furl Furl | Technorati Technorati | Blinklist Blinklist | Reddit Reddit | Mister Wong Mister Wong | Socializer Everywhere Else

Saturday, January 3, 2009

Advantages of BAPI in SAP


1. SAP BAPIs provide developers with stable, reliable interfaces for accessing the functionality offered bySAP business objects.


2. BAPIs can reduce development cost by providing built in functionality through predefined methods of the SAP business objects. These methods can reduce programming time in development projects.


3. Maintenance costs can be reduced because the BAPIs are stable and documented structures representing SAP’s investment in the R/3 business object architecture.


Naming Standards:


1. Instance-independent BAPIs can be used without explicitly creating an instance n of the business object.


2. Instance-dependent BAPIs require explicit creation of the business object instance.


BAPI Life Cycle: Change Management


1.On the basis of SAP Release strategy and the strict rules for enhancing existing BAPIs, application developers can rely on the stability of BAPI interfaces.


2. Each enhancement to a released BAPI is carried out ensuring that the syntax and contents are downwardly compatible. This means that applications programmed with BAPIs in a particular R/3 Release are not affected by changes to this BAPI in later releases.


3. If changes that are not downwards compatible need to be made to an existing BAPI, a new interface, that is, a new additional BAPI is created. This BAPI has the same name of the existing BAPI to be replaced but with a number added at the end, for example, CustomerCode.GetDetail1.


4. The BAPI to be replaced is marked as expiring (obsolete) in the Release in which the successor BAPI is implemented, but will continue to be supported in the next two functional Releases.


5.The BOR organizes SAP objects in a hierarchical scheme within applications.


6. The object-oriented principle of inheritance is supported enabling hierarchies and subclassing.


43 Things Tags: , , , , , , , ,

Integration of SAP Netweaver


In the present era, where SAP companies are struggling to fuse the various heterogeneous environment in their organization and maintain a lower Total Cost of Ownership (TCO) Netweaver comes as a solution to all their problems. SAP Netweaver is the latest advancement in the SAP Technologies, which was developed as an Artificial Intelligence (AI) shell that accepts standard comments literally as domain experts speak them.


Modularity is the unique feature of Netweaver that makes it stand out amongst other software technologies. The knowledge engineer can more easily create "digestible chunks" of modules or sub-dependency networks, which help to keep the overarching dependency network from becoming potentially incomprehensible because of obvious complexity. The following plain text is aimed at expanding SAP Netweaver architecture and its interoperability with Microsoft.NET and IBM WebSpere.


In simple words, Netweaver is an application and Integration platform in which Web Services plays a major role and which is open for Non-SAP applications and platform.
Using Netweaver to improve the organizations productivity and enhance efficiency by making all the resources that are available in an enterprise to work collectively. To bring heterogeneous environment at one platform SAP Netweaver can be used. In addition, by using this technology we can use the existing systems without putting in much investment. Further in the near future, the various SAP Companies and Organizations have to take a decision for some common platform; could be Microsoft .NET, IBM Websphere or SAP Netweaver. Irrespective of selecting, SAP Netweaver is the one that integrates with all the three technologies.


SAP Netweaver attains the process of integration by integrating all the available heterogeneous resources of the existing system and combining them into a homogeneous form. This integrated information forms the basis of total, comprehendible, focused solution as preferred in an enterprise.


Advantages of SAP Netweaver


Enhanced Adaptability: Enhanced adaptability actually refers to the adaptability of SAP Netweaver towards the existing Business System in any organization without investment. It provides a heterogeneous environment, by integrating the various applications; databases and making available open technologies like web services readily available to the user. It saves money and time on unnecessary customization of the existing business System.


Lower TCO: SAP Netweaver instead of replacing the existing system interweaves the various resources like databases, legacy systems; Internet based Information and provides a heterogeneous Environment for the user to get the maximum from the new unified system. It will also prevent the unnecessary customization of the entire system. Moreover, it reduces complexity and makes the system more comprehendible and flexible to the frequently changing business processes. All of these lead to reduce the total cost of ownership.


Better ROI: SAP Netweaver increases the return on investment in a shorter period. As mentioned earlier, by using this SAP Netweaver technology IT strategies can be synchronized with SAP solutions. This synchronization makes the system more reliable and it leads to better assessment services, which in turn lead to financial benefits.


Netweaver uses a very transparent process to provide the ability to trace the logic structure right from the raw data to information, which can be used for analysis. Developing portal content on your preferred platform is possible. Interoperability of SAP Netweaver with Microsoft .NET and IBM Hemisphere takes at People, Information and process level. For Microsoft .NET, Saps .NET connector provides a vastly scalable and reliable communication infrastructure, as well as a Microsoft Visual Studio .NET Add-In to simplify development. SAP customers and SAP partners will easily build SAP enabled components using Java Using Saps Java middleware and the SAP Java Connector. Thus, helping decision makers to interpret and manipulate the output of the decision model that provides precisely robust knowledge about complex problems. Hence, making SAP Netweaver is a Complete Solution and Integration with various applications and platforms that are used in various organizations.








Ron Victor is a SEO copywriter for SAP Training. He written many articles in various topics in SAP Articles and SAP Jobs. For more information about sap information visit SAP Forums. Contact him at ron.seocopywriter@gmail.com


43 Things Tags: , , , , , , , ,

Microsoft Axapta, SAP Business One, Oracle E-Business Suite - Brazilian MRP Market Overview


At this moment, as we write this article in the beginning of 2006, two international ERP vendors are aggressively launching their campaigns on the Brazilian ground: Microsoft Business Solutions with Microsoft Dynamics AX / Axapta (first quarter 2006) and SAP with SAP Business One (end of January/February 2006). Both companies have presence on the market in Sao Paulo and Rio de Janeiro: SAP has mySAP-SAP R/3, sold, implemented and supported directly by SAP consultants (Sao Paulo SAP office) and Microsoft has Navision, supported by MBS partner channel. Plus SAP has SAP all-in-one, implemented through the partners. Here we are presenting our opinion on these campaigns and targeted clientele.


• Local ERPs: Microsiga has over 10% of the market and both Microsoft Business Solutions and SAP plan to appeal to Microsiga clientele. We could understand the plans, and obviously Microsiga has its own defense strategy – it fits to Brazilian taxation, payroll, government reporting. At the same time Microsoft, SAP and Oracle could play the card of international business requirements, especially from the management reporting standpoint.


• SAP Business One. If you look at SAP Business One market niche in the USA or Europe, all-in-one named user licensing program usually has minimum requirement of 2 users. In Brazil, SAP recently reconsidered it to be 5 users, that means that SAP BO doesn’t go down to the small businesses, but rather targets mid-size and even upper mid-size clients.


• Microsoft Axapta / Dynamics AX. As you know Microsoft has new name for its Project Green – now it is in the conception of Microsoft Dynamics. With Axapta and really ‘starting from the ground’ – Microsoft is probably staking on Axapta as its future technology, and again it is probably would go down to the mid-market and even low mid-market with Axapta licensing. Currently Axapta is in localization beta testing mode – Brazilian taxes, Portuguese language (language is not a concern – taxes are a way more challenging).


• Oracle Financials / Applications. Oracle has long-time presence on the market here. If you are Oracle professional – you should be familiar with Oracle customization and localization technology. Oracle has LATAM localized code and portion of this is applicable to Brazil specifics.


• Multinational Companies. Both Microsoft Axapta and SAP Business One have very good positions to be chosen by Multinational corporation for it Brazilian subsidiary ERP. Both of them are localized, support Multilanguage (English and Portuguese are required in Brazil)


• Implementation Partner. In the case of multinational corporation – you need the ERP partner who is very familiar and experienced in international business, has presence in USA, Europe and Brazil


• CRM. Navision, Axapta, SAP Business One, Oracle Financials have CRM module / granule. Microsoft and Oracle have advanced CRM solutions: Microsoft CRM and Siebel respectively. Microsoft CRM has connectors to Microsoft Great Plains / Dynamics GP, Navision (through third party integration module) and Axapta integration is on the way. Also Microsoft CRM has connector to IBM Lotus Notes Domino, developed by Alba Spectrum Group, allowing you to protect the investment into Lotus Domino licenses.


• POS Connection (Point of Sale). Navision and Axapta have POS modules, for the small stores connection could be achieved via Microsoft Retail Management (Microsoft RMS)


Feel free to call us in US & Canada: 1-866-528-0577, 1-630-961-5918, Latin America: São Paulo 55-11-3444-4949, Europe: Deutschland (0177) 8349 806, help@albaspectrum.com








Andrew Karasev is Chief Technology Office, Alba Spectrum Group serves corporate clients in the following industries: Oil & Gas, Healthcare, Manufacturing, Tools & Machinery, Pharmaceutical, Mining, Services, Non-Profit, Advertising & Publishing, Distribution & Logistics, Transportation, Consignment, Food & Beverages, Restaurants Supply Chain, Textile, Building & Construction, Real Estate, Engineering & Project Management.


43 Things Tags: , , , , , , , ,

Using SAP to Automate The Accounting Function


While ERP software is generally thought of as an enterprise wide application, one overlooked use of this type of software is to provide a specific solution for a specific business function. In this article I will explain how SAP software (which is usually implemented enterprise wide) can be used to automate your company’s accounting function.


Over the years Accounting has become more sophisticated. It’s no longer a question of ’debit the receiver and credit giver’. This increase in complexity is reflected in the difficulty many companies have in automating their Accounting function. Fortunately, software packages such as SAP can assist.


For starters, SAP’s intelligent user interface (UI) provides for rapid and error-free data entry. Unlike many other accounting programs where even a simple task of data entry requires multiple key and mouse movements, the SAP User Interface relies on special shortcuts to help you keep your hands on the keyboard at all times. This assists in easier and therefore quicker data entry.


SAP also offers comprehensive inventory controls. This module helps the users manage the location and quantity of goods stored. The capabilities are not just simple record-keeping, but can be used at a component level to assist manufacturers. For example, inventory parts can be grouped into categories which can then be nested. Purchase Orders can then be applied at any level within the category nest. Similarly, setting prices for items can be set at such levels and can also be discounted in many different ways. These items of them reported using SAP’s Accounting modules.


Finally, SAP can effectively manage the sales and purchasing function. It is a simple matter to convert quotes into invoices which require payment. Profit margins can be reported at multiple levels by specific customer, specific store, or even specific salesman. In a similar manner, Purchase Orders are automatically converted to vendor invoices which are then forwarded to the Accounts Payable module. SAP provides for payment in many different ways including Electronic Funds Transfer (EFT) all the standard check.


So, as you can see the enterprise-wide nature of SAP, provides a useful solution to automating a company’s accounting function.


43 Things Tags: , , , , , , , ,

Your Complete Guide to SAP Training Courses & Certification Tests


We sometimes here the technical term SAP and we become curious when we hear it for number of times. SAP is an English acronym for Systems, Applications, Products in Data Processing. Originally, SAP means Systeme, Andwendungen, Produkte in der Datenverarbeitung, a company established in Germany in the year 1972 by five people who previously worked as IBM engineers.


But what is SAP and how does it really work? All SAP trainings are self - study and online courses that are continuous and available 24/7 to everyone. Anyone can study and learn in the comfort of his working place and anywhere he has an internet access.


All SAP lessons include replicated SAP sessions that will make you feel like you are logged into a real SAP system. The online lessons explain each transaction and all you have to do is interact with what you are viewing in the screen and do whatever you are told to do so. This includes tasks such as clicking the buttons, filling out fields like logins and the like.


The courses are valid for at least four months or 120 days while some courses will take longer than that. You can take the lessons as many times as you want while your subscription is active. If you still have questions on your mind regarding the course, you can always go back to the part of the session where you had a hard time understanding.


There are also SAP demonstrations for one to be able to see how the SAP courses really work. The demo provides online quiz afterwards so as to assess your learning acquired and once you fail to answer the quiz correctly, there is no harm done but the site will even tell you the correct answer so there is no way not to understand the lesson, unless you don’t take it seriously.


There is no technical requirement for you to be able to apply in online SAP training courses. All you need to have is a computer and internet access. You may use any computer and use them anywhere you want. High speed internet is not a requirement but is recommended for more continuous and hassle - free sessions.


The SAP training courses are available twenty - four hours in a day and you may inquire anytime you desire. The courses do not include an audio and explanations are all in written form. This is due to the huge files of audio which will cause certain delay on the part of the trainee to response. Not only that, adding audio will increase the course prices and that is mainly reason why the training is in written form only. Most courses include study guidelines and you may print the lesson if you like so that you can take notes as you go on learning. A completion certificate will be given to those who will finish the course and this can be printed directly from the website after the course is completed. You do not need formal exam anymore to obtain your certificate of completion.








Eli Griffin is the founder of UltimateSAP - http://www.UltimateSAP.com.


He is a former Siemens SAP consultant with over 5 years of experience in 4 different companies. UltimateSAP was founded to provide a one-stop cost effective training and certification course amist all the overpriced courses on the market.


UltimateSAP contains hundreds of high quality SAP interactive CBTs which covers all major SAP modules including R/3, ERP, ABAP, DB, MM, Basis and more


Discover the easiest way to attain SAP certification with certification resources, industry handbooks, workbooks and examination software applications


Visit the official site now to download free handbooks and interview Q&As


=> Start your SAP training Now!


P.S: Bonus: It comes with a limited supply of exercises and study exam guides so check it out while stocks last.


43 Things Tags: , , , , , , , ,

ABAP - Advanced Business Application Programming


ABAP stands for Allgemeiner Berichts-Aufbereitungs-Prozessor. I know it’s kind of difficult to understand. In Actual English term it’s called Advance Business Application Programming. So what is this SAP ABAP all about?


The ABAP is a programming langauge which has been invented by SAP and is primarily used to develop custom functionality in SAP.


The ABAP programs run at the application server level, that is, both the applications provided by SAP and the ones you develop yourself. The ABAP programs read data from the database, process the data, and possibly store data.


ABAP programs are processed on the application server. The design of user dialogs and database accesses is of particular importance when writing application programs. The user is only interested in how his or her business transaction flows and how data can be entered and output within the transaction. The technical aspects of programming are less interesting for the user.


The user does not need to know the precise flow of the ABAP program on the application server. To the average user, the SAP System is like a "Black Box".


Technically speaking, however, there are three different types of screens: standard screens, selection screens, and lists. Each type of screen provides different services to the user. Here the task of the developer is to select for each user dialog exactly those types that are most suitable for the accomplishment of the tasks concerned.


Once the user performs a user action, for example by choosing Enter, a function key, a menu function, or a pushbutton, control is passed from the presentation server to the application server. Only certain parts of the ABAP program will then be processed. If a further user dialog is triggered from within the ABAP program, the system transmits the screen, and control is once again passed to the presentation server.








To Learn more about ABAP visit ABAP Tutorials.


The Author is a SAP Consultant and has a SAP Blog and provides free information on SAP Learning.


43 Things Tags: , , , , , , , ,

How to Use SAP R3 and Its Implementation - SAP Modules


Brief Introduction to SAP43 Things Tags: , , , , , , , ,


SAP stands for systems, applications, products in data processing. Having put it this way it is easier to understand for the novice. The Company was incorporated in Germany, and for many years as they grew in leaps and bounds they carried on all of their business within Germany. It is no surprise that they soon had tapped the entire market, and as time progressed they needed to progress and keep up with the IT as it was evolving.


This lead to the birth of SAP R/2 in 1979.Now with something advanced to offer, the Company remained servicing the business industry within Germany. In a matter of years the SAP/R2 had saturated the German market with the majority of business taking full advantage of what it had to offer. It was time to branch out. In 1992 SAP R/3 hit the market with a boom.


What makes Sap R/3 so special and who can use it


The very quick answer to this would be because of how easy it is to implement and how well it functions. Just these two points alone can be critical to the lifeline of any business. Having fully integrated modules such as Sap R/3 has means a continuous flow of data for the end user. Just to name a few of the modules one would find in Sap R/3 is financial accounting, sales, and distribution. This is just to name a few, and is only the tip of the iceberg of what Saps R/3 capabilities are. The benefits alone just for the manufacturing industry, is staggering. Which if these companies would not want to be able to ensure delivery, consolidate purchase decisions, and production and planning as well. Talk about giving a competitive edge.


Decision making time


Once you are convinced that you truly need Sap R/3 then you need to determine the cost factors and what will be the monetary value of having the competitive edge you will have with Sap R/3. Once you have determined that the income potential outweighs the cost , the next decision to be made is the time frame, just how long before you are up and running. Finally how may people are going to have to be involved. You will require a lot of answers before you will be anywhere near to making your final decisions and knowing your final investment costs.


SUPPORT


It is very unlikely you are going to make such a huge decision and financial decision that integrating Sap R/3 will demand. Sap is prepared to support you every step along the way. However .there are 3 major areas that their support will be critical, which is pres sales, consulting, training and developers. In addition to the direct support you will have the opportunity to take advantage of the extra curricular support. which is consulting companies, annual conferences and forums. All that is left at this point is for you to reach your final decisions. Its important that any area you don’t feel that you are knowledgeable in should be addressed by SAP.








Eli Griffin is the founder of UltimateSAP - http://www.UltimateSAP.com.


He is a former Siemens SAP consultant with over 5 years of experience in 4 different companies. UltimateSAP was founded to provide a one-stop cost effective training and certification course amist all the overpriced courses on the market.


UltimateSAP contains hundreds of high quality SAP interactive CBTs which covers all major SAP modules including R/3, ERP, ABAP, DB, MM, Basis and more


Discover the easiest way to attain SAP certification with certification resources, industry handbooks, workbooks and examination software applications


Visit the official site now to download free handbooks and interview Q&As.


Click on the link below:


=> Start your SAP training Now!


P.S: Bonus: It comes with a limited supply of exercises and study exam guides so check it out while stocks last.


Looking For an SAP Job? What SAP Training & Courses Will Do to Your Career

SAP (which stands for Systems, Applications, and Products), is a comprehensive database system that was created more than 30 years ago by a group of IBM employees in Germany. The system has gained notoriety not only for its usefulness, but because it is so comprehensive that not a single person alone can seem to describe or use the system effectively. In short, the system allows companies to use one database to run all of the programs and software applications they use within their businesses on a daily basis.

The SAP applications themselves are easy to use and understand. SAP has introduced a variety of products, including the SAP Knowledge Warehouse, the Human Resource Management System, and the Advanced Planner and Optimizer, amongst many other programs. The real trick is to find someone who can train employees on how to use the system or who has enough knowledge to service these programs from a technical standpoint if there is ever an error or glitch.

SAP systems are commonly referred to as ERPs (Enterprise Resource Planning systems). These unique systems make it easy for large corporations to integrate all of their operations onto one place, but it is incredibly important to understand and recognize just how challenging it is for an information or computer specialist to manage and maintain this type of technology.

Taking a SAP training or certification course it almost guaranteed to launch your career to the next level. Very few people are able or willing to learn about the SAP system, which makes it difficult for companies using SAP to address their daily concerns. A number of courses are available for anyone wishing to advance their knowledge regarding SAP systems.

If you choose to study in a formal setting, there are a number of colleges, universities, and trade schools with SAP training courses. This type of formal training will give you the opportunity to learn about all of the different SAP systems while gaining hands on experience with simulated businesses processes. The University of Southern Carolina, for example, offers an entire 10-part course program that you can take over a series of semesters, either alone or along side other classes.

Those who prefer to self study may appreciate the myriad of online courses available. Some formal courses, such as that provided by the University of Texas, also post some of their SAP training tutorials on the internet free of charge. Netwind Learning Center is another great source of SAP Training information. Their program involves a series of training 50 training DVDs that will give you individualized lessons, practice exercises, and tutorials designed to prepare you for SAP Certification.

Regardless of whether or not you train in a formal setting or online, a firm understanding of SAP and ERM systems will instantly rank you amongst the most valuable employees any company or organization will hire. The training may not be the easiest you'll ever encounter, but we have a feeling it may end up being amongst the most profitable and rewarding.

Eli Griffin is a former Siemens SAP consultant with over 5 years of experience in 4 different companies.

He is the founder of UltimateSAP.com - http://www.UltimateSAP.com

UltimateSAP was founded to provide a one-stop cost effective training and certification course amist all the overpriced courses on the market.

UltimateSAP contains hundreds of high quality SAP interactive CBTs which covers all major SAP modules including R/3, ERP, ABAP, DB, MM, Basis and more

Discover the easiest way to attain SAP certification with certification resources, industry handbooks, workbooks and examination software applications

Visit the official site now to download free handbooks and interview Q&As.

Click on the link below:

=> Download your free SAP manual right now!

P.S: Bonus: It comes with a limited supply of exercises and study exam guides so check it out while stocks last.

Article Source: http://EzineArticles.com/?expert=Eli_Griffin

SAP Upgrade

There are many people around nowadays that will advise businesses to upgrade their SAP services to SAP ERP or something else that can be considered a modern upgrade. There are many ways to interpret this type of advice but in most cases you can be sure it is given in good conscience by someone that has done the same upgrade and found much to their surprise that it really did live up to the promises that were billed for it.

One of the main things that the SAP upgrade will do is furnish you with a software package and technology solutions that are far more efficient than the previous generation. One only has to be a very minor student of the history of technology to understand that successive generations are all about increased efficiency. In fact, there are certain generations of basic computers where the upgrades to the hardware did not actually add any new features but rather made the old ones work at far more efficiency with the end result being improved performance that had nothing to do with the addition of anything new in principle.

With all rich history, no wonder SAP upgrade technology tends to work and increased efficiency in the business world means fewer costs which of course automatically translate by definition into increased profits. Many people will argue that an SAP upgrade will pay for itself over time and as far as all of the data available on the topic is concerned this argument is one that generally rings true to form.

Another reason that the SAP upgrade is a good idea is that it allows your business to become more competitive with the rest of the world. Globalization has resulted in businesses getting competition from parts of the world they never would have dreamed of having to deal with and for that reason the modern business world forces you to improve performance and efficiency or end up on the scrap heap of businesses that did not have the ability to change with the times. The SAP upgrade that you do today will provide you with enhanced technology and better consultation services, both of which can mean the difference between life and death in the modern business world.

Article Source: http://EzineArticles.com/?expert=Motchka_Curtis

Importance of SAP R-3 Solutions


SAP Company was founded by five former IBM employees- Dietmar Hopp, Hans Werner Hector, Hasso Plattner, Klaus Tschira and Claus Wellenreuther. It was founded in Germany in the year 1972. SAP stands for systems, applications, products in data processing. In a year’s time the first financial accounting software was completed which was known as R/1 System. R stands for real-time data processing. The full name of the parent company is SAP AG. It has subsidiaries in nearly 50 countries. SAP AG is the third largest software maker in the whole world and it has nearly 27,000 employers all over the world and over 17,500 customers. It is listed in Frankfurt stock exchange and NYSE. Sap delivers software to small and mid sized companies also. SAP solutions that are used in small and mid sized business are SAP business one, SAP business all-in-one etc. These solutions are affordable, easy to use.


SAP business one is specially designed for small concerns mostly for 10 to 100 employees. It covers the core operations to run a successful business like customer relationship management, accounting, e-commerce, reporting and warehousing and partner management. Sap products and services integrate an organization from financials to human resources to manufacturing and sales and distribution. Because of this integration the companies can optimize supply chains, strengthen customer relationships and make correct management decisions. More than 100 midsize companies implemented SAP R/3 solutions.


SAP R/3 is a software solution for client/server computing. This software can be used by a small grocer to a billion dollar companies. This software is generally designed to meet the needs of the customer. SAP R/3 can be used on several databases like oracle, Adabas D, Informix, DB2 for UNIX, DB2/400 and Microsoft SQL SERVER 6.0. SAP R/3 software is used in many industries like insurance, banking, automobiles, oil and gas, public sector, manufacturing and material, services, transportation, aerospace, defense, construction, pharmaceuticals and chemicals.


Most of the distinctive functional modules are financials and controlling (FICO), Human Resources (HR), Materials Management (MM), sales & Distribution (SD), and Production planning (PP).The most difficult part in SAP R/3 is its implementation. Atlas copco has a different implementation of SAP R/3 from Proctor & Gamble. For example if a company is running SAP and then acquires a new business where SAP is already being used. They may elect to keep both systems separate, migrate one into the other, or migrate both onto a completely new instance. SAP has many layers. The Basis system (BC) includes the ABAP programming language, and is the base of operations and should not be visible to higher or managerial users. The heart of the system is the application modules. SAP R/3 provides an implementation roadmap that is broken into five phases. The five phases and their tasks include project preparation, business blueprint, realization, final preparation, and roll-out. SAP R/3 is a leader in ERP installations and ERP sales. SAP R/3 is based on many hardware and software architectures which is being runner in most types of UNIX, Windows NT, and OS/400.








brayan peter 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 bryan.peter@gmail.com


43 Things Tags: , , , , , , , ,

Is Oracle Sapping SAP?

I got training in SAP Enterprise Resource Planning (ERP) system years ago when it was on a mainframe platform – version R/2. At that time the Germans who came to the US to teach, emphasized that the name was S-A-P. They were aware of the negative connotations of the word sap in the United States.

The Players

The letters S, A, P stand for some German words. At this point, knowing what those letters mean, is as irrelevant as knowing what IBM stands for. (By the way, I just learned that SAP was started by former IBMers). SAP was founded in Germany in 1972. It had become greatly successful and respected in the European market before it made any serious inroads in North America.

Oracle Corporation, a US company, leads the way in the home grown variety of enterprise-wide software. At its start in 1977, the focus was on database solutions. It took close to 20 years before a reasonable facsimile of an ERP system was produced.

Both companies started with ERP systems, which handled basic business functions such as order entry, accounts receivable, production, inventory, purchasing and accounts payable – all integrated with a financial backbone. Now their offerings have expanded to include ERP off-springs like Customer Relationship Management (CRM), Business Intelligence, and Supply Chain Management (SCM) to name a few.

The Definitions

At dictionary.com, I looked up definitions for sap. The two definitions I would have given:

1) to undermine;weaken or destroy insidiously - with Synonyms: impair, enfeeble, deplete, exhaust, enervate

2) Slang. a fool; dupe.

But two other definitions surprised me:

1) Fortification. a deep, narrow trench constructed so as to form an approach to a besieged place or an enemy's position

2) Fortification.

a. to approach (a besieged place or an enemy position) by means of deep, narrow trenches protected by gabions or parapets.

b. to dig such trenches in (ground).

Which sap is SAP?

The Challenges:

• SAP corporation is still the leader in the ERP space, but Oracle is gaining ground.

• Turnover at the top is worth noting and watching

• SAP is sticking to old ways of doing things - ways that have been successful in the past.

• They have evolved from mainframe R/2 to client server SAP R/3 and then to enterprise version mySAP. Now, SAP is giving more attention to "software as a service" to try to capture more of the midsize market. Are they committed to operating in that space?

The Approach

Oracle is building approach / attack trenches by acquiring companies that make Oracle a more comprehensive solution provider. Is SAP impaired by this? An April 2007 InformationWeek article talks about SAP's CEO Kagermann and his strategies for the future. SAP did not capture the lead position by being a fool. They cannot and should not be discounted. SAP is still a force to be reckoned with.

Sandra Noble, MBA, CPIM, DCFS, CDP, Six Sigma, is president of Noble & Associates Consulting which specializes in IT Needs Assessments, RFP creation, unbiased software selection assistance and we're the cure for Post Implementation Distress™. We also have full life cycle implementation expertise in SAP, Oracle and other enterprise-wide software solutions. Reducing the STRESS of Software Implementations Worldwide!

Get the *FREE* report,
“8 Tips for Selecting Software” by visiting
http://www.SoftwareSelectionHelp.com

Noble Finances, a division of Noble & Associates Consulting, provides accounts receivable financing, equipment & software leasing, and lawsuit funding. Turn your accounts receivable into immediate CA$H. If your bank says No, then Yes, you need to explore other alternatives. Get a FREE report on Business Financing Options, by clicking http://GetCashFromReceivables.com

Article Source: http://EzineArticles.com/?expert=Sandra_Noble

Latest updates from sdn.sap.com

SAP Developer Network Latest Updates