Friday, May 2, 2008

Supporting SAP

SAP R/3 Books List (ABAP, Basis, Functional)

SAP Training CD ROMs
Computer Based Training on SAP Functional, Basis Administration and ABAP/4 Programming

Understanding SAP
Sams Teach Yourself SAP in 24 Hours (2nd Edition)
SAP R/3 for Everyone : Step-by-Step Instructions, Practical Advice, and Other Tips and Tricks for Working with SAP
Getting Started With Sap R/3 (Prima Techs Sap Book Series)
Anticipating Change: Secrets Behind the SAP Empire
Experience SAP
Flying Start SAP(R) R/3(R): A Guide to Get You Up and Running
The Whirlwind Series of SAP: In the Path of the Whirlwind: An Apprentice Guide to SAP
SAP: An Executive's Comprehensive Guide
SAP(R) Process, Analyze and Understand SAP(R) Processes with Knowledge Maps
Special Edition Using Sap R/3: The Most Complete Reference (Special Edition Using SAP R/3)
Xylem Structure and the Ascent of Sap
SAP: Inside the Secret Software Power
SAP IT Service & Application Management

Implementing SAP
Sap R/3 Implementation: Methods and Tools
Implementing SAP R/3: The Guide for Business and Technology Managers (Other Programming)
SAP Planning: Best Practices in Implementation
SAP(R) R/3 Implementation Guide
Successful SAP R/3 Implementation: Practical Management of ERP Projects
Implementing Sap R/3 : How to Introduce a Large System into a Large Organization, 2nd Edition
Enterprise Management with SAP SEM / Business Analytics
Why ERP? A Primer on SAP Implementation
Capturing the whirlwind : your field guide for a successful SAP implementation
Getting Maximum Value from SAP R/3

Dynamic, Accelerated SAP Implementation
Dynamic Implementation of SAP(R) R/3(R)
Asap Implementation at the Speed of Business: Implementation at the Speed of Business (Sap)
Implementing Sap With an Asap Methodology Focus
Preconfigured Client Made Easy 4.6C

SAP Business
SAP Blue Book, A Concise Business Guide to the World of SAP
Sap R/3 Business Blueprint: Understanding the Business Process Reference Model
What Every Business Needs to Know About SAP (Prima Tech's SAP Book Series)
SAP R/3 Business Blueprint - The Complete Video Course

Supporting SAP
SAP Service and Support
Supporting Sap R/3

SAP Quick Reference
Common Sap R/3 Functions Manual (Springer Professional Computing)
Instant Access: SAP, Reference Card of R/3

SAP Career
Five Steps to an Sap Career: Your Guide to Getting into Sap

SAP Consultant
SAP Consultant Handbook
Becoming an SAP Consultant
The Sap Consultant Handbook: Your Sourcebook to Lasting Success in an Sap Consulting Career

SAP Data Migration Tools
Migrating Your SAP Data
Data Transfer Made Easy 4.0B/4.5x
Testing SAP(R) R/3(R) Systems: Using the Computer Aided Test Tool

SAP Reporting Tools
SAP Query Reporting
SAP R/3 Reporting Made Easy, 4.6C:Fundamentals and Development Tools
Reporting Made Easy Guidebook series, Release 4.0B
SAP R/3 Reporting Made Easy: 4.6C SET
SAP R/3 Reporting & eBusiness Intelligence
Afp Printing for Sap Using R/3 and R/2

Internet Technology of SAP
The E-Business Workplace: Discovering the Power of Enterprise Portals
Roadmap to Industry Solutions: New Strategies for Success with SAP's Industry Business Units
SAP R/3 Reporting & eBusiness Intelligence
The SAP R/3 on the Internet
Online Store Made Easy 4.6B ¿ Accelerated Internet Selling
E-Business and ERP: Transforming the Enterprise

SAP Workflow
SAP Workflow Interview Questions, Answers, and Explanations
Practical Workflow for SAP - Effective Business Processes using SAP's WebFlow Engine
Workflow Management With Sap Webflow: A Practical Manual
Optimising Business Performance With Standard Software Systems: How to Reorganise Workflows by Chance of Implementing New Erp-Systems (Sap, Baan, Peoplesoft, Navision ...) or New Releases

ABAP Certification
SAP ABAP Certification Review: SAP ABAP Interview Questions, Answers, and Explanations
ABAP Programming: A Guide to the Certification Course

Introduction to ABAP/4 Programming for SAP, Revised and Expanded Edition
Developing Sap's R/3 Applications With Abap/4
ABAP/4, Second Edition: Programming the SAP(R) R/3(R) System
The Official ABAP Reference

Advanced ABAP Programming
Advanced ABAP Programming for SAP
Enhancing the Quality of ABAP Development
SAP Interface Programming

ABAP Data Dictionary and Quick Reference
Software Development for Sap R/3: Data Dictionary, Abap/4, Interfaces
Sap Abap Command Reference
ABAP Language Quick-Reference

SAP ABAP Objects
ABAP Objects: Introduction to Programming SAP Applications with CDROM
ABAP Objects Reference Book

SAPscript Made Easy 4.6

SAP Smart Forms

SAP R/3 Interfacing Using BAPIs; A Practical Guide to Working within the SAP Business Framework with CDROM

The ABAP Developer's Guide to Java (SAP Press)
Foundations of Java for ABAP Programmers (Foundations)
Enterprise Java for SAP
JAVA Programming With the SAP Web Application Server (Hardcover)

SAP Visual Basic
Professional Visual Basic SAP R/3 Programming
SAP R/3 Data Integration Techniques using ABAP/4 and Visual Basic

SAP Web Programming
Web Programming with the SAP Web Application Server

SAP NetWeaver
SAP NetWeaver Interview Questions, Answers, and Explanations: SAP NetWeaver Certification Review
SAP Netweaver MDM: Master Data Management Certification: SAP MDM FAQ
SAP NetWeaver For Dummies
SAP NetWeaver Roadmap

SAP Tcodes
SAP R/3 Transaction Codes: SAP R3 FICO, HR, MM, SD, Basis Transaction Code Reference

SAP Financial Accounting
SAP FI/CO Questions & Answers (with CD-ROM)
SAP R/3 FI Transactions
SAP FICO Interview Questions, Answers, and Explanations: SAP FICO Certification Review
Configuring SAP R/3 FI/CO: The Essential Resource for Configuring the Financial and Controlling Modules
SAP Account Determination
New General Ledger in SAP ERP Financials
SAP Foreign Currency Revaluation: FAS 52 and GAAP Requirements
SAP(R) R/3(R) Financial Accounting: Making It Work For Your Business
Using Sap R/3 Fi: Beyond Business Process Reengineering

SAP Controlling
The 123s of ABC in SAP: Using SAP R/3 to Support Activity-Based Costing

SAP BW Certification
SAP BW Certification: A Business Information Warehouse Study Guide
SAP BW Ultimate Interview Questions, Answers, and Explanations: Saw BW Certification Review

SAP Business Information Warehouse
201 Interview Questions: SAP Business Warehouse Information
SAP BW Ultimate Cookbook: SAP BW Basic Settings and Configuration Guide
SAP BW: A Step by Step Guide
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
SAP and BW Data Warehousing: How to Plan and Implement
SAP BW Professional
Business Information Warehouse for SAP
Mastering the SAP Business Information Warehouse
SAP BW Data Modeling
SAP BW Data Retrieval: Mastering the ETL Process
SAP BW Reporting And Analysis

SAP Supply Chain Management
SAP SCM Interview Questions Answers and Explanations: SAP Supply Chain Management Certification Review
SAP R/3 Business Blueprint: Understanding Enterprise Supply Chain Management (2nd Edition)
Supply Chain Management Based on SAP Systems

SAP Materials Management
SAP MM-Functionality and Technical Configuration
SAP MM Certification and Interview Questions: SAP MM Interview Questions, Answers, and Explanations
Instant Access: Sap Reference for Materials Management
Administering Sap R/3 : Mm-Materials Managment Modules

SAP Sales and Distribution
Implementing SAP ERP Sales & Distribution
SAP SD Interview Questions, Answers, and Explanations
Sales and Distribution With Sap: Making Sap Sd Work for Your Business
Instant Access: SAP, Reference for Sales and Distribution
Sales and Inventory Planning with SAP APO

SAP Customer Relationship Management
SAP CRM Interview Questions, Answers, and Explanations: SAP Customer Relationship Management Certification Review
mySAP CRM: The Offcial Guide to SAP CRM Release 4.0

SAP Production Planning
Production Plannning and Control with SAP
SAP MM / PP Interview Questions, Answers, and Explanations: SAP Production Planning Certification
Production Planning with SAP APO-PP/DS
Administering SAP R/3: The Production and Planning Modules

SAP APO Interview Questions, Answers, and Explanations: SAP APO Certification Review
Supply Chain Management with APO
Real Optimization with SAP APO
The SAP APO Knowledge Book - Supply and Demand Planning

SAP Plant Maintenance
SAP PM Interview Questions, Answers, And Explanations: Sap Plant Maintenance Certification Review
SAP(R) R/3(R) Plant Maintenance: Making It Work for Your Business
Enterprise Asset Management : Configuring and Administering SAP R/3 Plant Maintenance

SAP Service Management
Inter-Organizational Cooperation With Sap Systems: Perspectives on Logistics and Service Management (Sap Excellence)

SAP Quality Management
Quality Management with SAP
SAP(R) R/3(R) Quality Management: Making It Work for Your Business
SAP QM Interview Questions, Answers, Explanations: SAP Quality Management Certification Review

SAP Project Management
SAP PS FAQ: SAP Project Systems Interview Questions, Answers, and Explanations
Project Management with SAP(R) R/3(R)
SAP Consulting and Project Management (Book/CD-ROM package)

SAP Human Resource
Mysap HR Interview Questions, Answers, and Explanations: SAP HR Certification Review
Mastering HR Management with SAP
mySAP HR: Technical Principles and Programming
HR Personnel Planning and Development Using SAP
Practical SAP US Payroll

SAP Certification for MM, SD, PP, FI, CO
Sap R/3 Certification Exam Guide

SAP Travel Management
Business Process Redesign in Travel Management in an SAP R/3 Upgrade Project [DOWNLOAD: PDF]

SAP Retail Industry
SAP IS-Retail Interview Questions: SAP IS-Retail Certification Review
Retail Information Systems Based on SAP Products

SAP Basis Administration
SAP Basis Certification Questions: Basis Interview Questions, Answers, and Explanations
SAP Basis Administration for Windows
SAP R/3 System Administration : The Official SAP Guide
System Administration Made Easy, 4.6C/D
Basis Administration for SAP
SAP(R) R/3(R) Administration
SAP R/3 Administrator's Handbook
SAP R/3 Administration For Dummies

SAP Electronic Data Interchange
ALE, EDI, and IDoc Technologies for SAP
SAP Exchange Infrastructure for Developers
SAP XI Interview Questions, Answers, and Explanations: SAP Exchange Infrastructure Certification Review
SAP Exchange Infrastructure: The official guide to integrating business processes using SAP XI technology
SAP XI Transaction Codes, Tables, and Frequently Asked Questions

SAP Transport
Sap R/3 Change and Transport Management: The Official Sap Guide (Official Sap Guide)

SAP Archiving
Archiving your SAP Data
Efficient SAP R/3-Data Archiving : How to Handle Large Data Volumes

SAP Authorizations
R/3 Authorization Made Easy 4.6A/B
SAP Authorization System: Design and Implementation of Authorization concepts for SAP R/3 and SAP Enterprise Portals

SAP Security
Security and Data Protection for SAP Systems

SAP Operating System and Performance Fine Tuning
SAP Performance Optimization Guide , Third Edition
SAP System Landscape Optimization
SAP Hardware Solutions : Servers, Storage and Networks for
Network Resource Planning For SAP R/3, BAAN IV, and PeopleSoft: A Guide to Planning Enterprise Applications

SAP Oracle
Oracle SAP Administration (O'Reilly Oracle)
SAP R/3 and Oracle: Backup & Recovery

SAP Microsoft
Implementing Sap R/3 Using Microsoft Cluster Server
SAP Database Administration with Microsoft SQL Server 2000
SAP(R) R/3(R) and Windows NT

A Holistic Approach to a Reliable Infrastructure for Sap R/3 on Aix

SAP Linux
Sap on DB2 Udb for Os/390 and Z/OS: Implementing Application Servers on Linux for Zseries

About SAP

About SAP
SAP AG (ISIN: DE0007164600, FWB:SAP, NYSE: SAP) is the largest European software enterprise and the third largest in the world, with headquarters in Walldorf, Germany.

SAP was founded in 1972 as Systemanalyse und Programmentwicklung by five former IBM engineers in Mannheim, Baden-Württemberg (Dietmar Hopp, Hans-Werner Hector, Hasso Plattner, Klaus Tschira, and Claus Wellenreuther). The acronym was later changed to stand for Systeme, Anwendungen und Produkte in der Datenverarbeitung ("Systems, Applications and Products in Data Processing").
In 1976 "SAP GmbH" was founded and the following year it moved headquarters to Walldorf. SAP AG became the company's official name after the 2005 annual general meeting (AG is short for Aktiengesellschaft).
In August 1988, SAP GmbH transferred into SAP AG (a corporation by German law), and public trading started November 4. Shares are listed on the Frankfurt and Stuttgart stock exchange. The founding members Dietmar Hopp, Hasso Plattner, Klaus E. Tschira and Hans-Werner Hector form the executive board. In 1995, SAP was included in the German stock index DAX. On September 22, 2003, SAP was included in the Dow Jones STOXX 50. In 1991, Prof. Dr. Henning Kagermann joined the board; Dr. Peter Zencke became a board member in 1993. Claus Heinrich, and Gerhard Oswald have been members of the SAP Executive Board since 1996. Two years later, in 1998 the first change at the helm takes place. Dietmar Hopp and Klaus Tschira move to the supervisory board, Dietmar Hopp is appointed Chairman of the supervisory board. Henning Kagermann is appointed as Co-Chairman and CEO of SAP next to Hasso Plattner. Werner Brandt joined SAP in 2001 as member of the SAP Executive Board and Chief Financial Officer since 2001. Léo Apotheker has
been a member of the SAP Executive Board and president of Global Customer Solutions & Operations since 2002, was appointed Deputy CEO in 2007, then became co-CEO alongside Kagermann in 2008.
Henning Kagermann became the sole CEO of SAP in 2003. In February 2007 his contract was extended until 2009. After continuous disputes over the responsibility of the development organization, Shai Agassi, a member of the executive board who had been named as a potential successor to Kagermann, left the organization.

Business and markets
SAP is the world's largest business software company and the third-largest independent software provider in terms of revenues. It operates in three geographic regions – EMEA, which represents Europe, Middle East and Africa; the Americas (SAP America, headquartered in Newtown Square, Pennsylvania), which represents both North America and Latin America; and Asia Pacific Japan (APJ), which represents Japan, Australia and parts of Asia. In addition, SAP operates a network of 115 subsidiaries, and has R&D facilities around the globe in Germany, North America, Canada, China, Hungary, India, Israel and Bulgaria.
SAP focuses on six industry sectors: process industries, discrete industries, consumer industries, service industries, financial services, and public services. It offers more than 25 industry solution portfolios for large enterprises and more than 550 micro-vertical solutions for midsize companies and small businesses.

SAP's products focus on Enterprise Resource Planning (ERP), which it helped to pioneer. The company's main product is SAP ERP. The name of its predecessor SAP R/3 hints at its functionality: the "R" stands for realtime (even though it is not a realtime solution), the number 3 relates to a 3-tier architecture: database, application server and client (SAPgui). R/2, which ran on a Mainframe architecture, was the first SAP version.
SAP ERP is one of five major enterprise applications in SAP's Business Suite. The other four applications are:
* customer relationship management (CRM) - helps companies acquire and retain customers, gain deep marketing and customer insight, and align organization on customer-focused strategies
* product lifecycle management (PLM) - helps manufacturers with a single source of all product-related information necessary for collaborating with business partners and supporting product lines
* supply chain management (SCM) - helps companies enhance operational flexibility across global enterprises and provide real-time visibility for customers and suppliers
* supplier relationship management (SRM) - customers can collaborate closely with suppliers and integrate sourcing processes with applications throughout the enterprise to enhance transparency and lower costs
Other major product offerings include: the NetWeaver platform, Governance, Risk and Compliance (GRC) solutions, Duet (joint offering with Microsoft), Performance Management solutions and RFID. SAP offers a systematic approach to enterprise SOA, which is the technical standard that enables various enterprise software applications to exchange data effectively. Through enterprise SOA, SAP is focusing on enabling more flexible business processes as well as creating technical connections between IT systems and building a common language for business.
While its original products were typically used by Fortune 500 companies, SAP is now also actively targeting small and medium sized enterprises (SME) with its SAP Business One and SAP Business All-in-One. On September 19th, 2007 SAP announced a new product named SAP Business ByDesign complementing its portfolio for SME. SAP Business ByDesign was known under the code name "A1S" before.
SAP officials say there are over 100,600 SAP installations serving more than 41,200 companies in more than 25 industries in more than 120 countries.

List of SAP Products
Enterprise Applications
o Customer Relationship Management (CRM)
o Enterprise Resource Planning (ERP)
o Product Lifecycle Management (PLM)
o Supply Chain Management (SCM)
o Supplier Relationship Management (SRM)

Business Solutions
* SAP Advanced Planner and Optimizer (APO)
* SAP Analytics
* SAP Apparel and Footwear Solution (AFS)
* SAP Business Information Warehouse (BW)
* SAP Business Intelligence (BI)
* SAP Catalog Content Management (CCM)
* SAP Enterprise Buyer Professional (EBP)
* SAP Enterprise Learning
* SAP Portal (EP)
* SAP Exchange Infrastructure (XI)
* SAP Financial and Controlling (FICO)
* Governance, Risk and Compliance (GRC)
* SAP Human Resource Management Systems (HRMS)
* SAP Internet Transaction Server (ITS)
* SAP Knowledge Warehouse (KW)
* SAP Manufacturing
* SAP Master Data Management (MDM)
* SAP Materials Management (MM)
* SAP Plant Maintenance (PM)
* SAP Production Planning (PP)
* SAP Sales and Distribution (SD)
* SAP Service and Asset Management
* SAP Solutions for mobile business
* SAP Solution Composer
* SAP Solution Manager
* SAP Strategic Enterprise Management (SEM)
* SAP Test Data Migration Server (TDMS)
* SAP Training and Event Management (TEM)
* SAP NetWeaver Application Server (Web AS)
* SAP xApps
* SAP Quality Maintenance (QM)

Solutions for Small and Midsize Enterprises
* SAP Business One (6.2, 6.5, 2004, 2005, 7.x)
* SAP Business ByDesign[1]]
* SAP Business All-in-One

Platforms and frameworks
* SAP Enterprise Services Architecture
* SAP NetWeaver Platform
o SAP NetWeaver Portal (formerly SAP Enterprise Portal)
o SAP NetWeaver Business Intelligence
o SAP NetWeaver Visual Composer
o SAP Auto-ID Infrastructure
o SAP Composite Application Framework
o SAP Netweaver Development Infrastructure
* SAP Business Connector (deprecated/removed from product range)

Legacy Platforms
* SAP R/3
* SAP R/2

* SAP CCMS, monitoring program
* SAPgui
* SAP Central Process Scheduling, process automation and job scheduler

New Product Development and Introduction:
Innovating for Profitable Growth
Driven by consumer demand and fueled by technology advances, many companies must bring more products to market faster – if they hope to remain competitive and sustain profitable growth. That's why new product development and introduction (NPDI) may be your most important business process.
SAP delivers a comprehensive set of solutions for managing your end-to-end NPDI processes – from identification of market opportunity to successful product launch. With SAP solutions, you can address these key process areas:
* NPDI process visibility – An NPDI dashboard lets you easily monitor and control your overall product portfolio and pipeline, as well as NPDI-related key performance indicators.
* Portfolio strategy – Portfolio management capabilities help you make the right go/kill decisions and prioritize your use of resources.
* Product management – Project, cost, and resource management capabilities improve the management of the entire product development and introduction process.
* Functional execution – A broad range of capabilities support functional-level tasks such as initial ideas capture, product development, strategic sourcing, supply chain planning, prototyping, production ramp-up, and market launch. Plus, you get capabilities for managing product-related data, including quality engineering and change and configuration management.

Cross-Industry and Industry-Specific Functionality
SAP enables NPDI through a broad range of proven solutions, including:
* SAP Customer Relationship Management
* SAP Product Lifecycle Management
* SAP Supplier Relationship Management
* SAP Supply Chain Management
* SAP Product Definition
* SAP Resource and Portfolio Management

SAP solutions address the NPDI needs of key industry segments, including:
* Apparel and Footwear
* Automotive OEMs
* Automotive Suppliers
* Beverage
* Chemicals
* Consumer Durables
* Food
* High-Tech OEMs
* Home and Personal Care
* Industrial Machinery & Components
* Semiconductor Manufacturers


Strategic Portfolio Management
The primary challenge of strategic portfolio management is to provide a comprehensive up-to-date view of a company’s entire project portfolio and answer several important questions. Is the portfolio aligned with corporate goals? What is the future demand for resources and what is the capacity? Are the most skilled employees working on the most appropriate projects? Will the portfolio meet its business performance targets? What are the risks and impact of a delay? Timely answers to these questions are critical in determining which projects to pursue and which ones to fix or cancel. Project registration and enforcing an enterprise-wide decision making process for approving projects is an additional critical area in strategic portfolio management. Strategic portfolio management combines and gives visibility into the financial, strategic and operative aspects across your entire project portfolio to enforce governance, to make fact-based decisions and to maximize return on existing assets.

Idea and Concept Management
SAP xPD addresses the hurdles and inefficiencies at the critical front-end of product development processes: idea management and concept development. This solution enables organizations to capitalize on every possible good idea for new products or services, study their market potential and technical constraints, evaluate if and how to efficiently produce them and then come up with a short list of promising product concepts that match a company’s strategy.

Source of Supply Management
You can use this business process to process all your requirements and optimize your source of supply for each individual item. You can identify saving opportunities and evaluate suppliers in their ability to provide materials and services at low cost, high quality, and according to schedule.
Once you have determined the best source of supply for your requirements, you can collaborate in project teams both internally and with your suppliers, and establish on-going relationships based, for example, on contracts and global outline agreements.

SAP Interview Questions

SAP Interview Questions

1. What is ERP? - ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.
2. Different types of ERP? - SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.
3. What is SAP? - SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.

4. Explain the concept of “Business Content” in SAP Business Information Warehouse? - Business Content is a pre-configured set of role and task-relevant information models based on consistent Metadata in the SAP Business Information Warehouse. Business Content provides selected roles within a company with the information they need to carry out their tasks. These information models essentially contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update rules and extractors for SAP R/3, Business Applications and other selected applications.
5. Why do you usually choose to implement SAP? - There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
6. Can BW run without a SAP R/3 implementation? - Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.
7. What is IDES? - International Demonstration and Education System. A sample application provided for faster learning and implementation.
8. What is WF and its importance? - Business Work Flow: Tool for automatic control and execution of cross-application processes. This involves coordinating the persons involved, the work steps required, the data, which needs to be processed (business objects). The main advantage is reduction in throughput times and the costs involved in managing business processes. Transparency and quality are enhanced by its use.
9. What is SAP R/3? - A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.
10. What are presentation, application and database servers in SAP R/3? - The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.
11. What should be the approach for writing a BDC program? - Convert the legacy system data to a flat file and convert flat file into internal table. Transfer the flat file into sap system called “sap data transfer”. Call transaction(Write the program explicitly) or create sessions (sessions are created and processed ,if success data will transfer).
12. Explain open SQL vs native SQL? - ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.
13. What are datasets? - The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.
14. What are internal tables check table, value table, and transparent table? - Internal table: It is a standard data type object, which exists only during the runtime of the program. Check table: Check table will be at field level checking. Value table: Value table will be at domain level checking ex: scarr table is check table for carrid. Transparent table: - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.
15. What are the major benefits of reporting with BW over R/3? Would it be sufficient just to Web-enable R/3 Reports? - Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end — now imagine that occurring even more frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.
16. How can an ERP such as SAP help a business owner learn more about how business operates? - In order to use an ERP system, a
business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates. Using SAP as a tool to learn about ERP systems will require that the
people understand the business processes and how they integrate.
17. What is the difference between OLAP and Data Mining? - OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting.
18. What is “Extended Star Schema” and how did it emerge? - The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.
19. Define Meta data, Master data and Transaction data - Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data. Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies. Transaction data: Data relating to the day-to-day transactions is the Transaction data.
20. Name some drawbacks of SAP - Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.
21. What is Bex? - Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.
22. What are variables? - Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.
23. What is AWB?. What is its purpose? - AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.
24. What is the significance of ODS in BIW? - An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.
25. What are the different types of source system? - SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.
26. What is Extractor? - Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.

SAP PP Questions and Answers

SAP PP Questions and Answers

What are the cutover activities followed for PP module?
I am listing some cut over activities to be followed (for PP - Discrete Manufacturing).
Production Planning / Master data:
For Production planning, only master data shall be migrated to SAP. In the 1st Stage, there is no master data. Following is the master data elements relevant for PP:
- Bill of materials
- Routing.
- Work Centres.
Transaction data:
As of the cut off date, ideally there should not be any work in process. All the open production orders should be closed and semi finished goods should be dismantled and should be added to Raw materials. This strategy should be followed for all production orders where lead time to complete the production order is not large.
Since, the production orders are for longer duration and it is not possible to dismantle the product and add it to inventory, following can be the strategy for migrating the data to SAP:
- Create a material master for the work in process and set the standard price as the cost incurred for that product (ie. Work in process)
- Create a bill of material (which will be used only for this production order) including this material and other materials still to be consumed.
- Create Routing for rest of the production process.
- Bring the work in process material into inventory as of the cut off date.
- Create the production orders in SAP for the Work in process and issue materials to production order.
Complete the production process after the cut off date of the project.

What happens to planned after it has been converted into production order?
When you convert Planned order to Production order. the planned order are offset by production order. Reference of planned order can be seen in the production order.

How to attach a drawing for a material to BOM? Is it possible?
Yes, you can attach a drawing.
First create a document using Transaction Code "CV01N - Create Document".
Attach your drawing in that document.
The system will generate a document number. Assign this document in the BOM with item category D.

Report in Long Term Planning - You use long term planning for your customers, what they need are very simple, just to calculate future requirements for 1 or 2 years.
Are there any reports in SAP to list of material requirement from LTP?
You need a list of material requirement from long term planning result for each item.
Use MS70 then use MCEC.

Scheduling planned order - How can you get planned orders scheduled so that you can do capacity leveling?
MD11 and then Schedule works fine but ideally you would want the the planned order scheduled automatically on creation? You have tried setting up an action to schedule the orders but cannot get that to work either.
When running MRP, try selecting "2" in the scheduling box this will bring planned orders into CM01 and CM21

Capacity planning CM01 - When you run capacity planning T-code: CM01, you found the plan orders are not included in the pegged requirement, you checked the profile, the check box for order and plan order are all actived.
Guess that planned orders have been created without capacity requirement indicator in MRP ("2" - Lead Time scheduling), if this is the case, then when converted to process orders they will have impact on the Resource. If you want to see them as planned orders, re-run the MRP or change in every planned order, going to the Menu: Edit --> Scheduling
Another couple of possibilities are to do with the routing/work centres used and whether it isactually calculates consumption of capacity of the category at the work centre being displayed in CM01 (it might consume a capacity pool or it might not consume the category).

MPS in Backgound/Online - You want to run MPS for a plant either online or in the background, but you do not get any results. If you run MPS for a single material/plant, then everything is 100% OK.
You need to run a planning file and a consistency check first, transaction OMDO and MDRE respectively you'll need to set up two jobs to do it but it is straight forward, once you've done this set up the background job for MPS to run and do it in NEUPL first time round and then change to NETCH after that.

What is the output of MPS run?
From MPS run you plan the materials which are of 'A' type in the abc analysis (80% dollar value) that have to be planned before hand.
MPS is also a type of MRP only in which components just below the materials on which MPS run is taken place, are planned.

Table for production order status - What is the table for finding status (for Ex TECO ed prodn orders). We are not able to find from AFKO and AFRU tables the status of production orders or at least the link tables if known can be mentionned. You are unable to link the structure caufvd and IOHEADER WITH AFKO and AFRU.
JEST is the table.

Data dictonary table for SOP planning data - You are using Standard SOP (Info structure S076), in which table can you see the planning values that you maintained in MC93 transaction?
You looked under table "S076" and did not see any values there.
Use T.Code MC95 to display your entries under the version which maintained the the table S076.

Production order operation's component allocation - How does SAP know that an operation has components as indicated by the component allocation indicator? Tcode CO08.
Component allocation is done via routing maintenance or BOM maintenance for the assembly. This is master data maintenance. As soon as a PO is created, the master data is read into the PO.

How to delete groups of products?
How to delete a group of products that was created in screen MC84?
Delete the members in the product group and then archive the product group in transaction SARA, object=MM_MATNR.
(The product group is created as a material master record with material type PROD and this record is deleted in SARA.)

SAP ABAP interview questions

SAP ABAP interview questions with no answers
1. What are the various compoents of SAP XI?
2. Define Integaration Builder.
3. What is Software Component Version.
4. Explain IR and ID.
5. What is data type, message type, Message Interface, etc.
6. What is context handling?

SAP ABAP frequent questions cheatsheet
1. How do you call SAP script in reports & reports in SAP script?
2. What is different between SAP script & reports?
3. What is stack?
4. What is the defination of ALE RFC?
5. Why is BAPI required? How about BDC?
6. What happens if I use control break statement in between select & endselect?
7. What is lock Object

SAP/ABAP interview questions
1. Type of table?
2. Events of module pool?
3. Events of interactive report?

Simple SAP ABAP questions
1. What is the diffrence between watchpoint and breakpoint?
2. How many watchpoints and breakpoints can be used in each program?
3. Types of watchpoints and breakpoints?

SAP ABAP interview questions
1. What is an ABAP data dictionary?- ABAP 4 data dictionary describes the logical structures of the objects used in application development and shows how they are mapped to the underlying relational database in tables/views.
2. What are domains and data element?- Domains:Domain is the central object for describing the technical characteristics of an attribute of an business objects. It describes the value range of the field. Data Element: It is used to describe the semantic definition of the table fields like description the field. Data element describes how a field can be displayed to end-user.
3. What is foreign key relationship?- A relationship which can be defined between tables and must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data entered should be checked against existing data to ensure that there are now contradiction. While defining foreign key relationship cardinality has to be specified. Cardinality mentions how many dependent records or how referenced records are possible.

SAP Interview Questions
1. What is ERP? - ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.
2. Different types of ERP? - SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.
3. What is SAP? - SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.