Saturday, October 11, 2008

SAP BW BOOKS DOWNLOAD


Mastering the Sap Business Information Warehouse                   

afds
The long-anticipated publication of this second edition reflects the growing success of SAP NetWeaver as well as the various Business Intelligence (BI) capabilities that are embedded with SAP BW version 7.0. Written by SAP insiders, this comprehensive guide takes into account the ever-changing features, functionality, and toolsets of SAP NetWeaver to bring you the most updated information on how to use SAP BW to design, build, deploy, populate, access, analyze, present, and administer data. You'll discover the options that are available in SAP NetWeaver and uncover a new means to improve business performance.
This book reflects the process an organization goes through during an implementation of the software. The authors begin with an introduction to BI and SAP NetWeaver and quickly progress to information modeling and enterprise data warehouse concepts. You'll learn how to access and deliver meaningful analytic information to the organization, as well as perform integrated planning functions. Finally, the authors share invaluable insight on warehouse administration, performance, and security.

Download Link:
Mastering the Sap Business Information Warehouse.

 

Business Information Warehouse for SAP

33m30qg

Business Information Warehouse is the core information hub of all modules in SAP. This book shows you how to implement a data warehouse that can support reporting and analysis needs across diverse organizations and business functions. The author, Naeem Hashmi, was a member of the BW development team at SAP and covers just what you need to know to get to the core of the system and to the top of your field.

 

Download Link:
Business Information Warehouse for SAP

 

SAP Business Information Warehouse Reporting

dzfm3a

Give your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also find out how to forecast future business trends, build enterprise portals and websites, and tune performance.

  • Group data into InfoCubes and DataStore Objects and generate reports using queries and workbooks

  • Work with the BEx Analyzer, Web Analyzer, and Query Designer
  • Build queries and reports using the Business Administration Workbench
  • Add attachments and drill-through using Document Integration and RRI
  • Format and distribute results using Report Designer and Information Broadcaster
  • Extend functionality with Enterprise Portal, Data Modeling, and Visual Composer
  • Deploy charts, maps, diagrams, and unit of measure conversions
  • Predict trends and possible outcomes using SBC and Integrated Planning
  • Generate HTML pages using Enterprise Reporting and Web Application Designer
  • Create BI-based corporate Web and intranet sites using SAP Enterprise Portal

Download Link:
SAP Business Information Warehouse Reporting

 

SAP BW:A Step by Step Guide

9780201703665

SAP BW has recently come to the fore as a valuable tool for developing data warehouses that accurately and effectively support critical business decision making. It facilitates easy-to-use and high-performance extraction, transfer, transformation, and loading of data from a variety of data sources, including such comprehensive business management systems as SAP R/3.
This practitioner's guide uses step-by-step instructions complete with a plethora of screen captures to illustrate key SAP BW functionalities. It demonstrates how SAP BW implements the fundamental star schema and solves the major challenges inherent in the creation of data warehouses: performance, reliability, and error-handling. Using a real-world business scenario as a running example, SAP® BW presents a comprehensive view of the technology, from underlying concepts and basic techniques through its most sophisticated capabilities.

Download Link:
SAP BW:A Step by Step Guide


SAP BW Interview Questions

untitled

Most popular SAP book used by BW professionals for jobs and interviews.


 


 

 

Download Links:
SAP BW Interview Questions

 


SAP BW Certification

0471236349

Provides an overview to the exam's topics, including a "Need to Know" list that identifies areas that must be understood in-depth.
Includes exercises that can be performed, usually with a small test BW server.
1. Contains practice test questions that assess the readers knowledge of the current exam topics.
2.Serves as a complement to the classroom training provided by SAP.

 

Download Links:
SAP BW Certification

 

201 Interview Questions: SAP Business Warehouse Information

fymkop

Finding SAP talent has become more difficult and time consuming than ever before. Buzz words are everywhere, but don't be fooled, a persons true understanding of the subject can be unlocked by using this guide. The book contains a wide variety of carefully worded questions that are designed to help you determine the best qualified candidates available today. The questions are concise and to the point, so are the answers; this allows the candidate to answer and provide the employer an in-depth understanding of whether the candidate can cut through the "fluff" and get the job done. This is not only for employers. This will allow consultants or analysts to better prepare for the dream job and set them apart from the crowd. Self confidence and knowledge are the two most common traits employers seek in potential candidates. This book allows you to refine both. Whether you are an analyst seeking a permanent position or a consultant looking for your next project, this book allows you to impress the future employer with a clear understanding and self confidence expected from a subject matter expert.

Download Links:
201 Interview Questions: SAP Business Warehouse Information

Sunday, October 5, 2008

SAP WM & MM Resume Format

SAP Configuration – Warehouse Management, Mobile Data Entry (RF), Materials Management, Inventory Management, basic Handling Unit Management, Production Planning and WM in IS-Retail. Data clean up and migration experience. Implementing RF applications and wireless infrastructure.

Desired Positions
Implementation Consultant

Work Preferences

Desired Salary                     500 - 550 per day  

Availability                          Immediate  

Desired Job Type               Contract or Temporary  

Can Travel for Work         Moderately  

Highest Education             Bachelor Degree  

Current Location               Midlands, United Kingdom  

Willing to relocate?          No

Residency / Visa               Authorized to work in this location

Skills and Experience

Category                                                   Yrs. Exp.                  Last Used LE - Logistics Execution                            5                                   2008
Mobile Devices 

LO - Logistics General                                5                                   2007

Logistics Basic Data                                    9                                   2008

Logistics Information System                5                                   2008

MM - Materials Management                 10                                 2008

Employment History
Job Title:                                                        SAP LE Work Stream Lead and Functional          WM Consultant

Industry                                                    Food, Beverage and Tobacco

10/2007 to 03/2008   Satyam / Birds Eye - Iglo Group – (October 2007 to March 2008)WM/IM implementation and system migration project

Satyam are the SAP Partner now implementing SAP into the Birds Eye – Iglo Group (BEIG).

In my role as Logistics Execution Work Stream Lead I am responsible for the Logistics Execution design and delivery of the LE solution as well as the management of the LE Team. In addition I continue to act as a Functional WM Consultant.
Left for Paternity leave.

Job Title:               SAP Implementation and Functional WM Consultant

Industry                     Food, Beverage and Tobacco

05/2007 to 10/2007 Capgemini / Birds Eye - Iglo Group – (May 2007 October 2007)WM/IM implementation and system migration project

Capgemini were the SAP Partner implementing SAP into the Birds Eye – Iglo Group (BEIG); in their UK and European Manufacturing and Distribution facilities. BEIG have been sold off by the Unilever group of companies but have to migrate off the Unilever systems infrastructure.

In my role as Logistics Execution Applications Consultant I was responsible for business process mapping, agreeing future design, configuration of Inventory Management and Warehouse Management with particular reference to the Iglo Frozen Fish manufacturing and distribution centre.

Job Title:   SAP Implementation and Functional WM Consultant

Industry     Aerospace

05/2006 to 05/2007 WM/IM implementation and global convergence projects.

These projects covered the convergence of processes and procedures and SAP operations across RR template designs in RR UK and RR Germany repair and engine build facilities in the areas of WM and IM.

In my role I was responsible for the configuration, testing and implementation of Inventory Management, Warehouse Management and a Mobile Data Entry Interface during a 6 Plant WM / IM template rollout implemented in October 2006 and an 3 warehouse IM / WM implementation in April 2007.

Job Title:                      SAP WM IS-Retail Implementation

Industry                       Retail

1/2005 to 04/2006
EMPLOYER:    Intelligroup NZ Ltd. (Oct 2003 to April 2006)BUSINESS:         SAP Implementation Partner & Consultancy

POSITION:  Senior SAP Consultant & SMB Solution Manager

Farmers Trading Company Ltd.
Warehouse Management Consultant – [November 2005 to April 2006]

Farmers Trading Company operates over 55 modern department stores, 9 Home-centres in all the major metropolitan areas in New Zealand and 1 Internet store. Farmers sells women's, men's and children's clothing, shoes, accessories, health and beauty, housewares, domestic textiles, appliances, electronics, communications equipment, furniture and employs over 3,600 team members of which over 2,800 are full time employees.

I configured, tested and trained key Distribution Centre personnel in the area of Warehouse Management as part of a 2-man configuration team. The warehouse implemented an RF solution with SAP Console and used inbound deliveries with Handling Unit Management to enable cross docking as well as interfacing to a third party packing system.

Job Title:                        SAP Project Manager

Industry                         Services

05/2005 to 11/2005
EMPLOYER:        Intelligroup NZ Ltd. (Oct 2003 to April 2006)BUSINESS:         SAP Implementation Partner & Consultancy

POSITION:  Senior SAP Consultant & SMB Solution Manager

OCS Ltd (NZ)

Project Manager – [May 2005 to November 2005]

OCS Ltd is a supplier of cleaning services throughout New Zealand and is a subsidiary of OCS Ltd (UK)

I Project managed the implementation of Project Systems, Materials Management, Sales and Distribution and Finance and Controlling modules. Additionally I was responsible for the data clean up and migration element of the project.

Job Title:       SAP Materials Management & Warehouse Management Implementation

Industry                Industrial Products

07/2004 to 12/2004
EMPLOYER:        Intelligroup NZ Ltd. (Oct 2003 to April 2006)BUSINESS:         SAP Implementation Partner & Consultancy

POSITION:  Senior SAP Consultant & SMB Solution Manager

Shoof International Limited
Materials Management Consultant – [July 2004 to December 2004]

Shoof International Ltd is a developer, manufacturer, importer, marketer and exporter of agricultural and veterinary equipment. Shoof is constantly searching world markets to find new and innovative products for the New Zealand animal breeding and veterinary industries.

I was responsible for the configuration and implementation of SAP Inventory Management, Physical Inventory and Purchasing elements of the Materials Management module and implementing full Warehouse Management and Lean Warehouse Management modules.

I managed the configuration, data conversion and training elements of the MM and WM project.

Job Title: SAP Materials Management Implementation

Industry        Electronics

01/2004 to 04/2004
EMPLOYER:        Intelligroup NZ Ltd. (Oct 2003 to April 2006)BUSINESS:         SAP Implementation Partner & Consultancy

POSITION:  Senior SAP Consultant & SMB Solution Manager

Rakon Limited
Materials Management Consultant – [January 2004 to April 2004]

Rakon Limited is a world leader in the development of high performance frequency control technology based on quartz crystals, which lie at the heart of all electronics products. Rakon pioneered the development of oscillators capable of maintaining high levels of accuracy and unique lock-on stability in extreme environments. As a result, Rakon supplies over 50% of the frequency control devices used by the GPS industry.

I was responsible for the configuration and implementation of SAP Inventory Management, Physical Inventory and Purchasing elements of the Materials Management module.

I managed the configuration, data conversion and training elements of the MM project.

Job Title                        SAP LE Functional WM Consultant

Industry                Apparel

05/2008 to 08/2008 Capgemini / Burberry – (May 2007 to August 2008)WM global template implementation roll-out gap analysis

Capgemini are the SAP Partner implementing SAP into Burberry USA.
In my role as WM Consultant I was responsible for running workshops and documenting the required localisations to the Burberry global template and costing the gaps. This was a short term contract to analyse the requirements for the US business and formed the basis of a commercial contract between Capgemini and Burberry for a US roll-out project; the build and deployment phases.

Qualifications 

Completed         Institution                     Degree / Qualification
1986                        Coventry University       Degree - BSc

Work Related Training & Certification

Completed          Institution                 Training / Certification
1996                      Goldrat Institute                      “Jonah” Programme 1994                      Derby University            Diploma in Management
1993                      Derby University   PICS - Diploma in Production 1990                      Derby University            PICS - Stage 1 Certificate

Saturday, October 4, 2008

SAP SD Resume Format


RIPON CHAKRABARTY
__________________________________________________

C/o M.S Reddy. Saptagiri Coloney, House Number-12-2-717-1-31-Hyderabad 500028
Cell +91-9985131054
ripon.sap.sd@gmail.com

___________________________________________________

SAP SD Consultant

Job Target

Looking for a place to learn and enhancing my talent and which helps me to grow and prosper along with the organization.

Technical Skills

•    ERP Package: SAP R/3 version 4.7 & ECC 5.0c
•    Operating systems: Windows 95, 98, NT, 2000, DOS,
•    Package: Microsoft Office 2003 & 2007

Capabilities

•    Sap, SD, configuration, covering the complete range of functionalities like master data, order management, pricing, shipping, billing.

•    Define the enterprise structure, common distribution channel and common division for all relevant master data, Material determination, item category, copy control.

•    Configure shipping point determination, defining reason for blocking, availability check.    

•    Partner determination, delivery item category and determination, configure new sales document type.

•    Credit management: Assign a credit control area to company code

Sap Training

•    SAP SD training, Methodox,
•    SAP SD Project, Splendid-it Services Pvt Ltd,,

Education

Cachar College Silchar, Assam Bachelor of Commerce , 2003

Experience Highlights

ICICI Prudential Life insurace Company, Silchar - Assam    2006 - 2007
Insurance Advicor (Direct Sales of Insurance Policies)

Additional Employment History

Jayasree Tea Estate, Silchar - Assam    2003 - 2004
Store House Maintainance (Record All Inflows and Outflows of Stock)

Awards (marketing Fields)

•    HeadStart, ICICI Prudential
•    Sprint, ICICI Prudential 
•    Race, Icici Prudential

Hobbies and Interests

I like posting new topic in my blog (http://bindasgayan.blogspot.com) and be an active poster in some social networking site and some forum like thinkdigit forum. Because, these are the place where i can communicate with different people and share ideas, knowledge. these forum and blogs also provide some problem solving technique and tutorials.


 

SAP Beginners Guide

sap-small So, Finally you have decided to make a career move into SAP and good to know that you have found SAPDB. Let this be your gateway to the world of SAP and allow me to walk you through everything you need to know from the SAP basics to getting a job in SAP.

Here are some posts which will give you a idea as to what SAP is all about. First, start here on What is SAP?. Once you know about SAP, I would suggest you to understand more about ERP.

Now, a big question will take over you asking where do I fit in into this vast SAP World. As you know by now that SAP has various modules and choosing the correct module will help you stir your career in the right direction. Read the post on “Best SAP Module?” which will help you to decide in choosing the correct SAP module.

Once, you have decided on the modules, look at the vast categories we have on SAP Database. We have also organized a list of all the SAP Ebooks which were collected from different blogs/forums and website and have provided the links to these books and do not forget to check out the SAP FAQs section too.

Now comes the Big question. Where should I get the training? SAP Labs has it’s own education program through out the world. Refer the SAP’s training centers and also check the SAP Course list. Well, SAP Labs is the best place if you want to get trained but sometimes we don’t have enough money, I would suggest you to check your local sources for the best alternative sap training institutes in your area and Kick off your SAP education program and once you have gained enough experience you can directly take the SAP certification without going through the training from SAP labs.

While learning SAP, go to the forums at SAP Developers Network, SAP Fans and SAP Forums to get all the queries resolved.

What is ABAP?

Well, ABAP stands for Allgemeiner Berichts-Aufbereitungs-Prozessor. I know it’s kind of difficult to understand. But that’s the german standing of it. It means “General report creation processor”, Made it a little simpler, isn’t it. Okay, The actual english version of it is Advanced Business Application Programming. It’s a high level programming language created by SAP and has a syntax similar to Cobol and is based on Fourth Generation language.

The ABAP Programming language was originally invented by SAP for developers to develop SAP R/3 and is primarily used to develop custom functionality on SAP like Creating Reports, Smart forms… etc.

Types of ABAP Programs

We have various types of ABAP Programs like Reports, BDC, Subroutine Pools, Function Modules, Includes, Type Pools, Class Pools, Interface Pools & Classes.

ABAP Workbench

This Workbench contains different tools for editing repository objects. These tools allow to develop and complete almost everything and some of the objects include ABAP Editor, ABAP Dictionary, Screen and Menu Painter, Function Builder and Class Builder.

Data Types

Refer the image below for all the Data Types.

ABAP Data Types

Where to Go from here? If you are new to ABAP and then you can find lots of ABAP Programs and ABAP Keywords and Syntax on SAP Database.

 

Which is the Best SAP Module?

For Freshers getting into SAP, They always wonder as to which is the best SAP Module?

Well… what’s your area of expertise? This will help you in getting steered correctly into SAP.

Because, SAP is a vast area. people get into doing Programming, Adminsitration, Material Management, Sales and Distribution, Finance, Warehousing…! Every business process is one big area. So, ask youself where do you fit in.

I would rather say, if you have any programming experience… go into SAP ABAP. If not, try working out in any of the functional areas and then make your move into that SAP Domain.

Here is the complete list of SAP Modules and Descriptions. You Decide where you want to go from here?

SAP Modules and Descriptions

Environmental Health & Safety
EH&S has the following sub-modules:

  • Product Safety
  • Dangerous Goods
  • Waste
  • Industrial Hygiene
  • Occupational Health.


Financial Accounting

To work on general ledger, accounts receivable, accounts payable and other sub-ledger accounts with a user defined chart of accounts. Financial Accounting has the following Sub modules.

  • FI-GL General Ledger Accounting
  • FI-LC Consolidation
  • FI-AP Accounts Payable
  • FI-AR Accounts Receivable
  • FI-BL Bank Accounting
  • FI-AA Asset Accounting
  • FI-SL Special Purpose Ledger
  • FI-FM Funds Management
  • FI-CA Contract Accounting

CO Controlling
Involved with Cost & revenue and Management
The CO module has following sub modules:

  • CO-OM Overhead Costing
  • CO-PA Profitability Analysis
  • CO-PC Product Cost Controlling

AM Asset Management
Involved in managing and supervising the fixed assets. Purchasing, Depreciation and Investment of Assets.

PS Project System
Designed to support the planning, control and monitoring of long-term, highly complex projects with defined goals.

FS Insurance
SAP for Insurance enables insurance companies to handle customer and market requirements and simultaneously control profitability and economic viability.

  • FS-CD Collections and disbursements
  • FS-CM Claims management
  • FS-CS Commissions management
  • FS-PM Policy management
  • FS-RI Reinsurance management
  • FS-PE Payment Engine (Banking Payments Solution still in development)

IS Industry Solutions
Combines the SAP application modules and additional industry-specific functionality.

  • IS-A Automotive
  • IS-ADEC Aerospace and Defense
  • IS-AFS Apparel and Footwear
  • IS-B Banking
  • IS-BEV Beverage
  • IS-CWM Catch Weight Management (Variable Weight Items such as Meats and Cheeses)
  • IS-DFS Defense and Security
  • IS-H Hospital
  • IS-HER Higher Education
  • IS-HSS Hospitality Management
  • IS-HT High tech
  • IS-M Media
  • IS-MIN Mining
  • IS-MP Milling (or IS-MILL)
  • IS-OIL Oil
  • IS-PS Public Sector
  • IS-R Retail
  • IS-REA Recycling Admin
  • IS-SP Service Provider
  • IS-T Telecommunications
  • IS-U Utilities
  • IS-U Supplier Switch Utilities
  • IS-U EDM Utilities
  • IS-U EDM Billing Utilities
  • IS-U Agregated Billing Utilities
  • IS-U /BW Utilities
  • HR Human Resources
  • Complete integrated system for supporting the planning and control of personnel activities and HR module is sometimes equivalently referred to as HCM (Human Capital Management).

HR Human Resource Management
HR has the following Modules

  • HR-OM Organizational Management
  • HR-PA Personnel Administration
  • HR-PB Recruitment
  • HR-PD Personnel Development
  • HR-PT Time Management
  • HR-PY Payroll Management
  • HR-TEM Training and Event Management

HCM Human Capital Management
Stock of productive skills and technical knowledge embodied in labor.

LE Logistics Execution
The Logistics Execution System (LES), a major component of the supply chain management (SCM) application from SAP, allows an adminstrator to manage the information and processes involved in all stages of the supply chain, from procuring raw materials to distributing finished products. LES connects SCM processes involved in procurement, order processing, production, storage, inventory management, shipping, and sales.

PLM Product Lifecycle Management
Product lifecycle management is the process of managing the entire lifecycle of a product from its conception, through design and manufacture, to service and disposal.

PM Plant Maintenance
Equipment servicing and rebuilding.

MM Materials Management
Handles Inventory and Procurement functions and handling purchasing, inventory, stocking etc.

QM Quality Management
A quality control and information system supporting quality planning, inspection, and control for manufacturing and procurement.

PP Production Planning
This module includes; bills of material, routings, work centers, sales and operations planning, master production scheduling, material requirements planning, shop floor control, production orders, product costing, etc.

SD Sales and Distribution
Helps to optimize all the tasks and activities carried out in sales, delivery and billing. Key elements are: presales support, inquiry processing, quotation processing, sales order processing, delivery processing, billing and sales information system.

SCM Supply Chain Management
Supply chain management (SCM) is the process of planning, implementing, and controlling the operations of the supply chain as efficiently as possible. Supply Chain Management spans all movement and storage of raw materials, work-in-process inventory, and finished goods from point-of-origin to point-of-consumption.

SRM Supplier Relationship Management
Supplier relationship management is a comprehensive approach to managing an enterprise’s interactions with the organizations that supply the goods and services it uses. The goal of supplier relationship management (SRM) is to streamline and make more effective the processes between an enterprise and its suppliers just as customer relationship management is intended to streamline and make more effective the processes between an enterprise and its customers.

BW Business Information Warehouse
Business Intelligence, analytical, reporting and Data Warehousing (DW) solution.

SEM Strategic Enterprise Management
Management techniques, metrics and related tools that companies can use to make strategic decisions.

WM Warehouse Management
Subdivides the “Storage Location”, which is used in the MM Module to define inventory values by location, into “Storage Types” and then into “Storage Bins”. Control of stock to a physical level down to a warehouse bin. Placement and removal rules can be configured, stock counts can be done.

HUM Handling Unit Management
Used as a unique ID for each pallet of stock held in the warehouse.

F&R Advanced Forecasting & Replenishment
Forecasting stocking levels of material, planning the purchases etc.

Big list isn’t it. So, Just think where your profile fits it and make the correct career move.

 

SAP – The Basic Series

Who and / or what is SAP? How popular is it? Wow!
SAP the company was founded in Germany in 1972 by five ex-IBM engineers. In case you’re ever asked, SAP stands for Systeme, Andwendungen, Produkte in der Datenverarbeitung which - translated to English - means Systems, Applications, Products in Data Processing. So now you know! Being incorporated in Germany, the full name of the parent company is SAP AG. It is located in Walldorf, Germany which is close to the beautiful town of Heidelberg. SAP has subsidiaries in over 50 countries around the world from Argentina to Venezuela (and pretty much everything in between). SAP America (with responsibility for North America, South America and Australia - go figure!) is located just outside Philadelphia, PA.
The original five founders have been so successful that they have multiplied many times over such that SAP AG is now the third largest software maker in the world, with over 17,500 customers (including more than half of the world’s 500 top companies). SAP employs over 27,000 people worldwide today, and had revenues of $7.34 billion and Net Income of $581 million in FY01. SAP is listed in Germany (where it is one of the 30 stocks which make up the DAX) and on the NYSE (ticker: SAP).

There are now 44,500 installations of SAP, in 120 countries, with more then 10 million users!

So what made this company so successful? Back in 1979 SAP released SAP R/2 (which runs on mainframes) into the German market. SAP R/2 was the first integrated, enterprise wide package and was an immediate success. For years SAP stayed within the German borders until it had penetrated practically every large German company. Looking for more growth, SAP expanded into the remainder of Europe during the 80’s. Towards the end of the 80’s, client-server architecture became popular and SAP responded with the release of SAP R/3 (in 1992). This turned out to be a killer app for SAP, especially in the North American region into which SAP expanded in 1988.

The success of SAP R/3 in North America has been nothing short of stunning. Within a 5 year period, the North American market went from virtually zero to 44% of total SAP worldwide sales. SAP America alone employs more than 3,000 people and has added the names of many of the Fortune 500 to it’s customer list (8 of the top 10 semiconductor companies, 7 of the top 10 pharmaceutical companies etc). SAP today is available in 46 country-specific versions, incorporating 28 languages including Kanji and other double-byte character languages. SAP also comes in 21 industry-specific versions.

SAP R/3 is delivered to a customer with selected standard process turned on, and many many other optional processes and features turned off. At the heart of SAP R/3 are about 10,000 tables which control the way the processes are executed. Configuration is the process of adjusting the settings of these tables to get SAP to run the way you want it to. Think of a radio with 10,000 dials to tune and you’ll get the picture. Functionality included is truly enterprise wide including: Financial Accounting (e.g. general ledger, accounts receivable etc), Management Accounting (e.g. cost centers, profitability analysis etc), Sales, Distribution, Manufacturing, Production Planning, Purchasing, Human Resources, Payroll etc etc etc. For a full description of the modules included in SAP, see the related articles. All of these modules are tightly integrated which – as you will find out – is a huge blessing … but brings with it special challenges.

SAP are maintaining and increasing their dominance over their competitors through a combination of
- embracing the internet with mySAP.com (a confusing name we believe) to head off i2 etc
- extending their solutions with CRM to head off Siebel
- adding functionality to their industry solutions

Who is it made for? Why might I need it?

We have all heard about the large (and very large) companies who have implemented (or are still busy implementing) SAP R/3. But SAP is gaining acceptance by smaller companies too.

There are many reasons a company selects and implements SAP – some are good and some are bad. The good ones include replacing an out-dated and inefficient IT Architecture (including the CIO’s nemesis … the burning platform), enabling business process change, and to gain competitive advantage. The bad ones are too numerous to go into here but would include the “why are we the only semiconductor company without SAP” question. More on the good reasons follows:

1. Replacing an out-dated and inefficient IT Architecture: In the beginning, computer systems were developed by individual departments to satisfy the requirements of that particular department. When someone finally realized that benefits could be had by linking these systems together, interface heaven was born. There are some companies today with literally thousands of interfaces, each of which needs to be maintained (assuming of course that there is someone around who understands how they work!). Sweeping them away and replacing them with an integrated system such as SAP can save much money in support. Of course, if you have a burning platform as well the question becomes even easier.

2. Enabling business process change – From the start, SAP was built on a foundation of process best practices. Although it sounds absurd, it is probably easier (and less expensive) to change your companies processes to adapt to SAP than the other way around. Many companies have reported good success from combining a SAP implementation with a BPR project.

3. Competitive advantage – The CFO types around have heard this old saying from the CIO types for many years now. The question still has to be asked … can you gain competitive advantage from implementing SAP? The answer, of course, depends on the company. It seems to us, however, that:

• being able to accurately provide delivery promise dates for manufactured products (and meet them) doesn’t hurt … and
• being able to consolidate purchase decisions from around the globe and use that leverage when negotiating with vendors has gotta help … and
• being able to place kiosks in stores where individual customers can enter their product specifications and then feed this data directly into it’s production planning process is pretty neat
• etc etc

How much does it cost? What will it take to implement it? Wow!
There is a defining moment in the journey of all companies on the road to SAP nirvana. This moment comes just after the company has concluded that it want’s SAP, it needs SAP, it’s gotta have SAP … then comes the question ‘so what does it take to implement it’?

Before being accused of being too negative, let me remind you that at the heart of every good business decision lies a cost benefit analysis. If this cannot be complete with a positive outcome, the initiative (whatever it is) should probably not be launched. Same goes for a SAP implementation.

Implementing SAP is expensive. No doubt about it. But the potential rewards can dwarf the costs (and have for many existing customers already). One customer reportedly made enough savings on the procurement of a single raw material to pay for the entire enterprise-wide SAP implementation! Of course these are hard to substantiate, but visit SAP’s website and take a look at the customer testimonials.

SAP sells it’s R/3 product on a ‘price per user basis’. The actual price is negotiated between SAP and the customer and therefore depends on numerous factors which include number of users and modules (and other factors which are present in any negotiation). You should check with SAP, but for a ballpark planning number you could do worse than starting with $4000 per user. There is also an annual support cost of about 10% which includes periodic upgrades. Again, check with SAP.

Then there is the implementation cost. Yowser. It is about now that you need to get the business case out again and remind yourself why you need to do this. The major drivers of the total implementation cost are the Timeframe, Resource Requirements and Hardware.

Timeframe - The absolute quickest implementation we have ever heard of is 45 days … but this was for a tiny company with very few users and no changes to the delivered SAP processes. At the other end of the scale you get the multi-nationals who are implementing SAP over 5 to 10 years. These are not necessarily failures … many of them are planned as successive global deployments (which seem to roll around the globe forever). Of course the really expensive ones are those we don’t hear about! For the most part, you should be able to get your (single instance) project completed in a 9 to 18 month period.
People – The smallest of SAP implementations can get done on a part-time basis without outside help. The largest swallow up hundreds of people (sometimes over a thousand) and include whole armies of consultants. This adds up fast. Again, get that business case out. The types of people you will need run the range from heavy duty techies to project managers.
Hardware – The smallest of SAP implementations probably use only three instances (boxes) … one for the production system, one for test, and one for development. The largest implementations have well over 100 instances, especially if they involve multiple parallel projects (otherwise known as a program).
Adding all this up, your SAP project can run anywhere from $400,000 to hundreds of millions of $’s. As you can see, SAP can be all things to all companies … so it’s best to talk to them (or your consulting firm) about your specific requirements.

Is there any help out there? What should I do next? Help From SAP AG
There is a ton of help available out there - depending on your companies budget and culture – to help you along your journey beginning with your strategy and ending up when you reach that hallowed (and sometimes distant) ground of post-implementation. This article concentrates on the help available from SAP AG. Article 5 discusses other sources of help.

SAP AG employs around 22,000 people. Although they re-organize as often as most other companies, you can think of them as being organized into the following four areas: Pre-Sales, Consulting, Training and Developers.

• Pre-Sales. These are people with heavy-duty functional knowledge of one or more SAP modules and one or more industries. They give really excellent system demonstrations on particular areas of the system which – while thick with pre-sales features – are an extremely valuable source of information about SAP. I’m sure they have many other responsibilities as well, but if you can, get a demo from them. For an even more useful demo, ask if you can provide them with business process scenarios that are pertinent to your business or industry prior to the demo.

• Consulting. While also knowledgeable in SAP (of course), these are mostly consulting types like those that can be found in the major consulting firms. Often a team will consist of consultants from SAP and a partner consulting firm and you will not know the difference. Expect them to have business process and/or industry knowledge in addition to detailed SAP knowledge. They are not readily available to non-customers as they are usually assigned to one or more customers. A good list of consulting partners is available in the links section of this website.

• Training. In 1999 SAP opened up their training programs to non-customers and non-partners. This opens up a whole world of top-rate training programs at SAP’s facilities around the globe. These can be expensive, however, and up to three weeks are usually required to gain a sufficiently deep understanding of a particular module or subject. If you have lots of time and money, you could register for one of SAP’s ‘academies’ which are five-week crash courses (emphasis on crash … as in burn) in one of the following areas: FI/CO, MM/SD, and HR/ABAP. These end with an examination and ‘certification’ in your chosen area. More information on SAP training courses can be found on SAP’s website.

• Developers. These heavy-duty techies are off limits to non-customers. Customers can sometimes get a message to them via the OSS system – which is an automated trouble ticket type system. If you ever actually see one, or have one on the phone, ask all the questions you can think of, as you may never have the chance again!

Is there any help out there? What should I do next? Help From Other Sources
Here we will cover the help that is available from other sources, including: Consulting Companies, SAPPHIRE and other SAP Events, ASUG, and this website.

1. Consulting Companies
One of SAP’s key strategies has been to develop partnerships with the Consulting Companies. This has contributed enormously to the widespread adoption of SAP due to the fact that there are literally thousands of consultants (SAP estimate 55,000) ready to help with all aspects of your SAP implementation … from strategy to completion. There are two types of consulting partners:

1. Global consulting partners (13 of these at last count) are the largest of the consulting firms who are able to provide global assistance to global companies, and

2. National consulting partners who are accredited by country

Your need of a consulting partner depends on your project scope and complexity, your project budget, company culture, and prior SAP implementation experience in your company. Suffice to say that without heavy prior SAP experience in your company, all but the simplest SAP implementations would benefit from the involvement of experienced individuals who have done it before. Rates depend on your negotiations with the consulting company, of course, but you could do worse than use an estimate of $200 per person per hour. Consulting styles differ from firm to firm, so make sure your company culture is compatible with the typical approach of your chosen consulting partner. In addition, spend some time on their websites to get an idea of their approach, experience and capabilities.

2. SAPPHIRE and other SAP events
SAPPHIRE is the name given to SAP’s annual user conference. Multiple SAPPHIRE’s can be found around the globe each year, and are usually sold out in advance. North American SAPPHIRE’s are typically held in hot cities (off season) and attract upwards of 14,000 prospects, customers and partners. Read up on SAPPHIRE’99 here. SAPPHIRE is a great place to go explore, but is quite expensive at around $2,200 for three days (food, lodging, travel etc is at your own expense). Even so, it is well worth the time and expense.

Note: SAP holds other events throughout the year (TechEd, for example, is aimed at the more technical users) see their website for additional details.

3. ASUG (America’s SAP User Group)
As the name suggests, ASUG is a forum for users of SAP. Non-users (prospects and consultants) and not usually found lurking here. ASUG actually comprises of multiple sub-ASUG’s – each focusing on a particular area of SAP, for example there is an ASUG for High Tech companies, and an ASUG for companies using ALE etc. Leadership of these sub-ASUG’s (for lack of a better description) usually rotates between members of the user community. ASUG provides opportunities for networking, learning and influencing SAP (for example joining forces with other users to convince SAP to include a particular modification in their standard software). In addition to meetings within the sub-ASUG’s, there is an annual conference (which attracted nearly 6,000 users and vendors in 1999). More details on ASUG can be found at www.asug.com.

SAP AG Corporate Overview (Updated August 2004)
3rd - SAP is the 3rd largest software company in the world

30,000 - Total number of people employed by SAP
5,400 - Number of programmers employed by SAP

$7.024 billion - FY03 Revenue
$1.077 million - FY03 Net Income

12,000 - Number of companies using SAP
79,800 - Number of SAP installations
12,000,000 - Number of people using SAP
120,000,000 - Total number of people in the 12,000 companies who are using SAP

28 - Number of languages supported by SAP
46 - Number of country-specific versions of SAP
22 - Number of industry-specific versions of SAP

1,000 - Number of pre-defined best practices contained in the SAP system
10,000 - Number of tables requiring configuration in a full SAP implementation

55,000 - Number of SAP experienced consultants worldwide

28 - Number of years ago SAP was started

5 - Number of people who started SAP

SAP Modules and Solutions Overview
SAP now are moving away from describing their system as a set of modules, and now are using the term ‘solutions’, which is much better. If you visit SAP’s website (as we urge you to do) you will find that they have structured their Solutions tab as follows:

1. Financials
2. Human Resources
3. Customer Relationship Management
4. Supplier Relationship Management
5. Product Lifecycle Management
6. Supply Chain Management
7. Business Intelligence

If you’re still looking for that list of modules, here they are:

FI Financial Accounting – essentially your regulatory ‘books of record’, including
1. General ledger
2. Book close
3. Tax
4. Accounts receivable
5. Accounts payable
6. Consolidation
7. Special ledgers

CO Controlling – basically your internal cost/management accounting, including
1. Cost elements
2. Cost centres
3. Profit centres
4. Internal orders
5. Activity based costing
6. Product costing

AM Asset Management – track, value and depreciate your assets, including
1. Purchase
2. Sale
3. Depreciation
4. Tracking

PS Project Systems – manage your projects, large and small, including

1. Make to order
2. Plant shut downs (as a project)
3. Third party billing (on the back of a project)

HR Human Resources – ah yes, people, including
1. Employment history
2. Payroll
3. Training
4. Career management
5. Succession planning

PM Plant Maintenance – maintain your equipment (e.g. a machine, an oil rig, an aircraft etc), including
1. Labour
2. Material
3. Down time and outages

MM Materials Management – underpins the supply chain, including
1. Requisitions
2. Purchase orders
3. Goods receipts
4. Accounts payable
5. Inventory management
6. BOM’s
7. Master raw materials, finished goods etc

QM Quality Management – improve the quality of your goods, including
1. Planning
2. Execution
3. Inspections
4. Certificates

PP Production Planning – manages your production process, including
1. Capacity planning
2. Master production scheduling
3. Material requirements planning
4. Shop floor

SD Sales and Distribution – from order to delivery, including
1. RFQ
2. Sales orders
3. Pricing
4. Picking (and other warehouse processes)
5. Packing
6. Shipping

CA Cross Application – these lie on top of the individual modules, and include
1. WF – workflow
2. BW – business information warehouse
3. Office – for email
4. Workplace
5. Industry solutions
6. New Dimension products such as CRM, PLM, SRM, APO etc

BW 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, mySAP.com 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, abusiness 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.

What is "SAP Business One"?

The SAP thrust to carve a niche in the medium and small corporate segment for small businesses with between five and 100 users, was defined by executing a strategy of acquiring third party developed business applications, integrating and branding the new system as “SAP Business One”. These acquisitions were targeted to allow SAP to reach out to the mid- market through its partners and to gain additional business from the smaller subsidiaries of its enterprise customers.

To this end SAP invested in the following acquisitions:
In 2002 SAP acquired TopManage Financial Systems, an Israel-based developer of business applications. TopManage was founded by Shai Agassi who was formally president of the Product and Technology Group at SAP and his father Reovan. This product is an "international product" and "easily configurable in terms of localization". The product is currently available in English, Hebrew and Spanish versions, with the German and French versions to follow.

In 2004, SAP acquired the technology and assets of iLytix Systems AS, a privately held software company based in Oslo, Norway. With this acquisition SAP introduced the new reporting and budgeting capabilities in SAP Business One called XL Reporter.

In 2006 SAP acquired Minneapolis based Praxis Software Solutions, previously a SAP Business One partner. This strategic acquisition enables SAP to integrate the company’s Web-based CRM and e-commerce capabilities into SAP Business One.
SAP Business One contains 14 core modules:

01. Administration Module, where configuration is performed
02. Financials Module, where various accounting and financial activities are conducted
03. Sales Opportunities Module, where existing customers and potential accounts are structured tracking
04. Sales Module, where orders are entered, shipped and invoiced
05. Purchasing Module, where purchase orders are issued and goods received into inventory
06. Business Partners Module, where Business Partners (customers, vendors, and leads) are contacted and maintained
07. Banking Module, where cash is received and paid out
08. Inventory Module, where Inventory is valued and managed
09. Production Module, where bill of materials is defined and manufacturing is tracked
10. MRP Module, where purchase and production planning takes place
11. Service Module, where after-service products are managed
12. Human Resources Module, where employee information is kept
13. Reports Module, where system-default and user-defined reports are generated (as on-screen tables, printouts or Excel files: Print Layout Designer, Advanced Layout Designer and XL Reporter)
14. E-commerce, allowing customers to buy and sell online to consumers or other businesses.

ABAP DICTIONARY

The ABAP Dictionary permits a central management of all the data definitions used in the R/3 System.

In the ABAP Dictionary you can create user-defined types (data elements, structures and table types) for use in ABAP programs or in interfaces of function modules. Database objects such as tables and database views can also be defined in the ABAP Dictionary and created with this definition in the database.

The ABAP Dictionary also provides a number of services that support program development. For example, setting and releasing locks, defining an input help (F4 help) and attaching a field help (F1 help) to a screen field are supported.

Tables and database views can be defined in the ABAP Dictionary.
These objects are created in the underlying database with this definition. Changes in the definition of a table or database view a re also automatically made in the database.

Indexes can be defined in the ABAP Dictionary to speed up access to data in a table. These indexes are also created in the database.
There are three different type categories in the ABAP Dictionary:
Data elements: Describe an elementary type by defining the data type, length and possibly decimal places.

Structures: Consist of components that can have any type.

Table types: Describe the structure of an internal table.
Any complex user-defined type can be built from these basic types.

Example: The data of an employee is stored in a structure EMPLOYEE with the components NAME, ADDRESS and TELEPHONE. Component NAME is also a structure with components FIRST NAME and LAST NAME. Both of these components are elementary, i.e. their type is defined by a data element. The type of component ADDRESS is also defined by a structure whose components are also structures. Component TELEPHONE is defined by a table type (since an employee can have more than one telephone number).

Types are used for example in ABAP programs or to define the types of interface parameters of function modules.
The ABAP Dictionary supports program development with a number of services:

Input helps (F4 helps) for screen fields can be defined with search helps.

Screen fields can easily be assigned a field help (F1 help) by creating documentation for the data element.

An input check that ensures that the values entered are consistent can easily be defined for screen fields using foreign keys.

The ABAP Dictionary provides support when you set and release locks. To do so, you must create lock objects in the ABAP Dictionary. Function modules for setting and releasing locks are automatically generated from these lock objects; these can then be linked into the application program.

The performance when accessing this data can be improved for database objects (tables, views) with buffering settings.
By logging, you can switch on the automatic recording of changes to the table entries.

The ABAP Dictionary is actively integrated in the development and runtime environments. Each change takes immediate effect in the relevant ABAP programs and screens.

Examples:
When a program or screen is generated, the ABAP interpreter and the screen interpreter access the type definitions stored in the ABAP Dictionary.

The ABAP tools and the Screen Painter use the information stored in the ABAP Dictionary to support you during program development. An example of this is the Get from Dictionary function in the Screen Painter, with which you can place fields of a table or structure defined in the ABAP Dictionary in a screen.
The database interface uses the information about tables or database views stored in the ABAP Dictionary to access the data of these objects.

The structure of the objects of application development are mapped in tables on the underlying relational database.
The attributes of these objects correspond to fields of the table.
A table consists of columns (fields) and rows (entries). It has a name and different attributes, such as delivery class and maintenance authorization.

A field has a unique name and attributes; for example it can be a key field.

A table has one or more key fields, called the primary key.

The values of these key fields uniquely identify a table entry.

You must specify a reference table for fields containing a currency (data type CURR) or quantity (data type QUAN). It must contain a field (reference field ) with the format for currency keys (data type CUKY) or the format for units (data type UNIT). The field is only assigned to the reference field at program runtime.

The basic objects for defining data in the ABAP Dictionary are tables, data elements and domains. The domain is used for the technical definition of a table field (for example field type and length) and the data element is used for the semantic definition (for example short description).

A domain describes the value range of a field. It is defined by its data type and length. The value range can be limited by specifying fixed values.

A data element describes the meaning of a domain in a certain business context. It contains primarily the field help (F1 documentation) and the field labels in the screen.

A field is not an independent object. It is table -dependent and can only be maintained within a table.

You can enter the data type and number of places directly for a field. No data element is required in this case. Instead the data type and number of places is defined by specifying a direct type .
The data type attributes of a data element can also be defined by specifying a built-in type , where the data type and number of places is entered directly.

A transparent table is automatically created on the database when it is activated in the ABAP Dictionary. At this time the database-independent description of the table in the ABAP Dictionary is translated into the language of the database system used.

The database table has the same name as the table in the ABAP Dictionary. The fields also have the same name in both the database and the ABAP Dictionary. The data types in the ABAP Dictionary are converted to the corresponding data types of the database system.

The order of the fields in the ABAP Dictionary can differ from the order of the fields on the database. This permits you to insert new fields without having to convert the table. When a new field is added, the adjustment is made by changing the database catalog (ALTER TABLE). The new field is added to the database table, whatever the position of the new field in the ABAP Dictionary.

ABAP programs can access a transparent table in two ways. One way is to access the data contained in the table with OPEN SQL (or EXEC SQL). With the other method, the table defines a structured type that is accessed when variables (or more complex types) are defined.

You can also create a structured type in the ABAP Dictionary for which there is no corresponding object in the database. Such types are called structures. Structures can also be used to define the types of variables.

Structures can be included in tables or other structures to avoid redundant structure definitions.

A table may only be included as an entire table.

A chain of includes may only contain one database table. The table in which you are including belongs to the include chain. This means that you may not include a transparent table in a transparent table.

Includes may contain further includes.

Foreign key definitions are generally imparted from the include to the including table. The attributes of the foreign key definition are passed from the include to the including table so that the foreign key depends on the definition in the include.

You must maintain the technical settings when you define a transparent table in the ABAP Dictionary.

The technical settings are used to individually optimize the storage requirements and accessing behavior of database tables.

The technical settings can be used to define how the table should be handled when it is created on the database, whether the table should be buffered and whether changes to entries should be logged.

The table is automatically created on the database when it is activated in the ABAP Dictionary. The storage area to be selected (tablespace) and space allocation settings are determined from the settings for the data class and size category.

The settings for buffering define whether and how the table should be buffered.

You can define whether changes to the table entries should be logged.
The data class logically defines the physical area of the database (for ORACLE the tablespace) in which your table should be stored. If you choose the data class correctly, the table will automatically be created in the appropriate area on the database when it is activated in the ABAP Dictionary.

The most important data classes are master data, transaction data, organizational data and system data.

Master data is data that is rarely modified. An example of master data is the data of an address file, for example the name, address and telephone number.

Transaction data is data that is frequently modified. An example is the material stock of a warehouse, which can change after each purchase order.

Organizational data is data that is defined during customizing when the system is installed and that is rarely modified thereafter. The country keys are an example.

System data is data that the R/3 System itself needs. The program sources are an example.

Further data classes, called customer data classes (USR, USR1), are provided for customers. These should be used for customer developments. Special storage areas must be allocated in the database.

The size category describes the expected storage requirements for the table on the database.

An initial extent is reserved when a table is created on the database. The size of the initial extent is identical for all size categories. If the table needs more space for data at a later time, extents are added. These additional extents have a fixed size that is determined by the size category specified in the ABAP Dictionary.

You can choose a size category from 0 to 4. A fixed extent size, which depends on the database system used, is assigned to each category.

Correctly assigning a size category therefore ensures that you do not create a large number of small extents. It also prevents storage space from being wasted when creating extents that are too large.

Modifications to the entries of a table can be recorded and stored using logging.

To activate logging, the corresponding field must be selected in the technical settings. Logging, however, only will take place if the R/3 System was started with a profile containing parameter 'rec/client'. Only selecting the flag in the ABAP Dictionary is not sufficient to trigger logging.

Parameter 'rec/client' can have the following settings:
rec/client = ALL All clients should be logged.
rec/client = 000[...] Only the specified clients should be logged.
rec/client = OFF Logging is not enabled on this system.

The data modifications are logged independently of the update. The logs can be displayed with the Transaction Table History (SCU3).

Logging creates a 'bottleneck' in the system:

Additional write access for each modification to tables being logged.

This can result in lock situations although the users are accessing different application tables!

SAP ABAP Interview Questions & Answers

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.

4. Describe data classes?
Master data: It is the data which is seldomly changed. Transaction data: It is the data which is often changed. Organization data: It is a customizing data which is entered in the system when the system is configured and is then rarely changed. System data:It is the data which R/3 system needs for itself.

5. What are indexes?
Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field of the tables. In order that other fields are also read, a pointer to the associated record of the actual table are included in the index. Yhe indexes are activated along with the table and are created automatically with it in the database.

6. Difference between transparent tables and pooled tables.?
Transparent tables: Transparent tables in the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data. Pooled tables. Pooled tables in the dictionary has a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.

7. What is an ABAP/4 Query?
ABAP/4 Query is a powerful tool to generate simple reports without any coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the simple reports. Statistics: Reports with statistical functions like Average, Percentages. Ranked Lists: For analytical reports. - For creating a ABAP/4 Query, programmer has to create user group and a functional group. Functional group can be created using with or without logical database table. Finally, assign user group to functional group. Finally, create a query on the functional group generated.

8. What is BDC programming?
Transferring of large/external/legacy data into SAP system using Batch Input programming. Batch input is a automatic procedure referred to as BDC(Batch Data Communications).The central component of the transfer is a queue file which receives the data vie a batch input programs and groups associated data into “sessions”.

9. What are the functional modules used in sequence in BDC?
These are the 3 functional modules which are used in a sequence to perform a data transfer successfully using BDC programming: BDC_OPEN_GROUP - Parameters like Name of the client, sessions and user name are specified in this functional modules. BDC_INSERT - It is used to insert the data for one transaction into a session. BDC_CLOSE_GROUP - This is used to close the batch input session.

10. What are internal tables?
Internal tables are a standard data type object which exists only during the runtime of the program. They are used to perform table calculations on subsets of database tables and for re-organising the contents of database tables according to users need.

11. What is ITS?
What are the merits of ITS?- ITS is a Internet Transaction Server. ITS forms an interface between HTTP server and R/3 system, which converts screen provided data by the R/3 system into HTML documents and vice-versa. Merits of ITS: A complete web transaction can be developed and tested in R/3 system. All transaction components, including those used by the ITS outside the R/3 system at runtime, can be stored in the R/3 system. The advantage of automatic language processing in the R/3 system can be utilized to language-dependent HTML documents at runtime.

12. What is DynPro?
DynPro is a Dynamic Programming which is a combination of screen and the associated flow logic Screen is also called as DynPro.

13 What are screen painter and menu painter?
Screen painter: Screen painter is a tool to design and maintain screen and its elements. It allows user to create GUI screens for the transactions. Attributes, layout, filed attributes and flow logic are the elements of Screen painter. Menu painter: Menu painter is a tool to design the interface components. Status, menu bars, menu lists, F-key settings, functions and titles are the components of Menu painters. Screen painter and menu painter both are the graphical interface of an ABAP/4 applications.

14. What are the components of SAP scripts?
SAP scripts is a word processing tool of SAP which has the following components: Standard text. It is like a standard normal documents. Layout sets. - Layout set consists of the following components: Windows and pages, Paragraph formats, Character formats. Creating forms in the R/3 system. Every layout set consists of Header, paragraph, and character string. ABAP/4 program.

15 What is ALV programming in ABAP?
When is this grid used in ABAP?- ALV is Application List viewer. Sap provides a set of ALV (ABAP LIST VIEWER) function modules which can be put into use to embellish the output of a report. This set of ALV functions is used to enhance the readability and functionality of any report output. Cases arise in sap when the output of a report contains columns extending more than 255 characters in length. In such cases, this set of ALV functions can help choose selected columns and arrange the different columns from a report output and also save different variants for report display. This is a very efficient tool for dynamically sorting and arranging the columns from a report output. The report output can contain up to 90 columns in the display with the wide array of display options.

16. What are the events in ABAP/4 language?
Initialization, At selection-screen, Start-of-selection, end-of-selection, top-of-page, end-of-page, At line-selection, At user-command, At PF, Get, At New, At LAST, AT END, AT FIRST.

17. What is CTS and what do you know about it?
The Change and Transport System (CTS) is a tool that helps you to organize development projects in the ABAP Workbench and in Customizing, and then transport the changes between the SAP Systems and clients in your system landscape. This documentation provides you with an overview of how to manage changes with the CTS and essential information on setting up your system and client landscape and deciding on a transport strategy. Read and follow this documentation when planning your development project.

18. What are logical databases?
What are the advantages/ dis-advantages of logical databases?- To read data from a database tables we use logical database. A logical database provides read-only access to a group of related tables to an ABAP/4 program. Advantages: i)check functions which check that user input is complete, correct,and plausible. ii)Meaningful data selection. iii)central authorization checks for database accesses. iv)good read access performance while retaining the hierarchical data view determined by the application logic. dis advantages: i)If you donot specify a logical database in the program attributes,the GET events never occur. ii)There is no ENDGET command,so the code block associated with an event ends with the next event statement (such as another GET or an END-OF-SELECTION).

19. What is a batch input session?
BATCH INPUT SESSION is an intermediate step between internal table and database table. Data along with the action is stored in session ie data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.

20. How to upload data using CATT ?
These are the steps to be followed to Upload data through CATT: Creation of the CATT test case & recording the sample data input. Download of the source file template. Modification of the source file. Upload of the data from the source file.

21. What is Smart Forms?
Smart Forms allows you to create forms using a graphical design tool with robust functionality, color, and more. Additionally, all new forms developed at SAP will be created with the new Smart Form solution.

22. How can I make a differentiation between dependent and independent data?
Client dependent or independent transfer requirements include client specific or cross client objects in the change requests. Workbench objects like SAPscripts are client specific, some entries in customizing are client independent. If you display the object list for one change request, and then for each object the object attributes, you will find the flag client specific. If one object in the task list has this flag on, then that transport will be client dependent.

23. What is the difference between macro and subroutine?
Macros can only be used in the program the are defined in and only after the definition are expanded at compilation / generation. Subroutines (FORM) can be called from both the program the are defined in and other programs . A MACRO is more or less an abbreviation for some lines of code that are used more than once or twice. A FORM is a local subroutine (which can be called external). A FUNCTION is (more or less) a subroutine that is called external. Since debugging a MACRO is not really possible, prevent the use of them (I’ve never used them, but seen them in action). If the subroutine is used only local (called internal) use a FORM. If the subroutine is called external (used by more than one program) use a FUNCTION.

24. Is there any standard SAP report which gives a count of the number of times a program is executed ?
Try transaction STAT .

25. When we create a customer the information is updated in structure RF02D and the some tables like KNA1 are updated. How can we find the tables for master data transactions?
Go to ABAP Workbench -> Overview -> application hierarchy - SAP -> follow the customizing based tree for your application. Double click on a lowest hierarchy level to get for the correct marked development class. Here you can find all the tables, views, logical databases etc. used for a system operation.

26. How can we use CAD with SAP ?
Third party tools from Eigner + Partner provide interfaces to SAP. Another third party software - Fastlook Plus from Kamel Software enables you to view all of the Autocad formats.

27. How can I access SAP through Internet?
SAP has its own Internet transaction Server (ITS) . Other products include Haht, WebObjects, NetDynamics etc. Each product has its' own architecture.However to access the database, access paths SAP GUI or RFC Channel have to be used.

28. How to find what transactions a particular user was running for a given period in the past (Eg: from 1st of a month )?
You may use the transaction - STAT.

29. Our ABAP program is working properly in Foreground. Can I schedule it for background processing on the weekend?
SAP standard program RSBDCSUB helps you to schedule the job. Create a variant for RSBDCSUB with the BDC session name

30.What is the difference between collect and sum?
SUM.
When processing an internal table in a block starting with LOOP and concluded by ENDLOOP , SUM calculates the control totals of all fields of type I , F and P (see also ABAP/4 number types ) and places them in the LOOP output area (header line of the internal table or an explicitly specified work area).
When you use SUM in a LOOP with an explicitly specified output area, this output area must be compatible with the line type of the internal table.When using LOOP to process a sorted extract (see SORT ), the control total of f at the end of the group appears in the field SUM(f) - - if f is type I , F or P .
COLLECT.
COLLECT is used to create unique or compressed datsets. The key fields are the default key fields of the internal table itab .If you use only COLLECT to fill an internal table, COLLECT makes sure that the internal table does not contain two entries with the same default key fields.If, besides its default key fields, the internal table contains number fields,the contents of these number fields are added together if the internal table already contains an entry with the same key fields.If the default key of an internal table processed with COLLECT is blank, all the values are added up in the first table line.If you specify INTO , the entry to be processed is taken from the explicitly specified work area. If not, it comes from the header line of the internal table itab .After COLLECT , the system field SY-TABIX contains the index of the - existing or new - table entry with default key fields which match those of the entry to be processed.COLLECT can create unique or compressed datasets and should be used precisely for this purpose. If uniqueness or compression are unimportant, or two values with identical default key field values could not possibly occur in your particular task, you should use APPEND instead. However, for a unique or compressed dataset which is also efficient, COLLECT is the statement to use.If you process a table with COLLECT , you should also use COLLECT to fill it. Only by doing this can you guarantee that the internal table will actually be unique or compressed, as described above and COLLECT will run very efficiently.If you use COLLECT with an explicitly specified work area, it must be compatible with the line type of the internal table.

31.How we format the data before before write statement in report ?
We can format the reports output by using the loop events like:
1.at first
2.at new
3.at last
etc check docu

32.What is the difference between Table and Template?
Table is a dynamic and template is a staticWhen do we use End-of-selection?End-of-selection event are mostly used when we are writing HR-ABAP code. In the HR-ABAP code, data is retrived in the Start-of-selection event and Printing on the list and all will be done in End-of-selection event.

33.In events start-of-selection is default event. When we have to use this event explicitly? Why?The default event in the ABAP is Start-of-selection.We have to call explicitely this event when you are writing other than ths event , that is when you write AT SELECTION-SCREEN EVENTS OR INITIALIZATION EVENT etc,you have to explicitely mention the Start-of-selection event while you are writing the logic.Before these events called ,all the code you have written come into this default Start-of-selection screen event.

34.What is the differences between ABAP and OOABAP. In which situation we use OOABAP?OOABAP is used to develop BSP/PCUI applications and also anthing involved object oriented like BADIs, SmartForms.etc.where as ABAP is used to develop traditional programs in R/3.

35.What is table buffer?Which type of tables used this buffer?
Buffer is nothing but a memory area. table is buffered means that table information is available on application server. when you call data from database table it will come from application server.transperent and pooled tables are buffered. cluster tables can not buffered.

36.What is the use of pretty printer ?
Exactly where can we link the functional module to abap coding.Pretty Printer is used to format the ABAP Code we write in ABAP Editor ,like KEY WORDS in Capitals and remaining are in small letters which is also depend on system settings.We can call the function module in the ABAP Code .Press the Pattern button on Appl. tool bar then u will get box where u write the function module NAME which u want to call in the code by selecting the radio button CALL FUNCTION. In this way we link function module to ABAP Code.

37.What is the difference between SAP memory and ABAP memory?
Answer1:
Data sending between main sessions using get parameter and set parameter is sap memorydata sending between internal sessions using import or export parameters is abap memory
Answer2:
SAP memory is a global memory whereas abap memory is local memory.For example, we have four programs in abap memory and assigned some varibles to a particular program in abap memory then those varibles can't be used by anyother program in abap memory i.e., the variables are only for that program and also local to that memory,whereas sap memory can access all the abap memory or else it can perform any kind of modifications.
Answer3:
SAP memory is available to the user during the entire terminal session.ABAP memory is available to the user during life time of external session.

38.What is the difference between Type and Like?
Answer1:
TYPE, you assign datatype directly to the data object while declaring.LIKE,you assign the datatype of another object to the declaring data object. The datatype is referenced indirectly.
Answer2:
Type is a keyword used to refer to a data type whereas Like is a keyword used to copy the existing properties of already existing data object.
Answer3:
Type refers the existing data typelike refers the existing data object.

39.What is Tcode SE16. For what is it used. Explain briefly?
Answer1:
SE16 is a T-code for object browser.Generally used to search the fields of SAP Tables . and respective data.
Answer2:
SE16 is a data browse and it is used to view the contents of the table and we cannot change or append new fields to the existing structure of the table as we cannot view the structure level display using the se16.

40.What are different ABAP/4 editors? What are the differences?
The 2 editors are se38 and se80 both have the abap editor in place. In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor. In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications .

41.What is difference between dialog program and a report?
Report is a excecutable programDialog is a module pool program.It has to be executed via a transaction only.Dialog programming is used for customization ofscreens.

42.How do you connect to the remote server if you are working from the office for the client in remote place?
WAS web application server or ITS are generally used for this purpose. If you are sitting at your office with a server which is in the system and the other server is at the clients place you can generate IDOC, intermidiate documents which carry the data you want to transfer or the documents you want to transfer, these IDOC are interpretted by the system at the recieving end with the message class with which it is bound with. If you want to logon a system which is very distant..then remote login can be used this depends on the internet speed.

43.Explain about roll area , Dispatcher, ABAP-Processor.
Answer1:
Roll area is nothing but memory allocated by work process. It holds the information needed by R/3 about programs execution such as value of the variables.Dispatcher :All the requests that come from presentation server will be directed first to dispatcher. Further dispatcher sends this requests to work process on FIFO(First In and First Out) basis.
Answer2:
Dispatcher recieves the request from client and assigns the request to one of the work process.Roll area: Each workprocess works in a particular memory that memory is known as Role Area, which consists of User context and session data.ABAP- Processor :is an interpretor which can execute logic.
44.Which one is not an exit comand ?(Exit, cencle, stop, back)
STOP.
Effect :The statement STOP is only to be used in executable programs.
EXIT.
Effect :If the EXIT statement is executed outside of a loop, it will immediately terminate the current processing block.
BACK.
Effect : This statement positions the list cursor on the first position of the first line in a logical unit.So "Cancle" is not an exit command.

45.What is Field symbol ?
Answer1:
You can use field symbols to make the program more dynamic. In this example the name of a table control is substituted by a field symbol. Thus you cal call the form with any internal table, using the name of the table control as a parameter.
Example:
form insert_rowusing p_tc_name.field-symbols type cxtab_control. "Table controlassign (p_tc_name) to .* insert 100 lines in table control-lines = 100.
Answer2:
fieldsymbol has the same concept as pointer in c,
fieldsymbol don't point to a data type like char, num instead of that it points to the memory block. the syntax for fieldsymbol is
FIELD-SYMBOL
.EG. FOR FIELD SYMBOL.
DATA: DAT LIKE SY-DATUM,
TIM LIKE SY-UZEIT,
CHAR(3) TYPE C VALUE 'ADF'.
FIELD-SYMBOL :
MOVE DAT TO .
WRITE:/ .
MOVE TIM TO .
WRITE:/ .
MOVE CHAR TO .
WRITE:/ .
The output will be
Today's date
current time

46.What is lock object ?
LockObjects used to synchornize access of several users using same data.

47.Why BAPI need then BDC ?
BAPI"S provide the standard interface to other applications apart from SAP and within differnt vesions of SAP too. Also it is OOD bases so dosen"t depends on screen flow. BDC gets failed if we make changes for screen changes through IMG customization