SAP

SAP MATERIAL

2010-03-13T11:56:00.000-08:00

1) SAP GUI for HTML
2) SAP High Availability (BC-CCM-HAV)
3) SAP HTML Viewer
4) SAP Internet Mail Gateway (BC-SRV-COM)
5) SAP Knowledge Provider (BC-SRV-KPR)
6) SAP License (BC-CST-SL)
7) SAP List Viewer (ALV): Classic
8) SAP MAPI Service Provider (BC-SRV-GBT)
9) SAP/MS SQL Server DBA in CCMS (BC-DB-MSS-DBA)
10) SAP Open Information Warehouse
11) SAP Patch Assembly/Distribution Engine (SPADE)
12) SAP Patch Manager (SPAM)
13) SAPphone (BC-SRV-COM)
14) SAP Picture (BC-CI)
15) SAP Query (BC-SRV-QUE)
16) SAP Retail
17) SAProuter (BC-CST-NI)
18) SAP Session Manager
19) SAP Smart Forms (BC-SRV-SCR)
20) SAP Textedit
21) SAP Time Management
22) SAP Time Management in the Internet/Intranet
23) SAP Toolbar (BC-CI)
24) SAP Tree and Tree Model (BC-CI)
25) SAP ArchiveLink (BC-SRV-ARL)
26) SAP ArchiveLink - Scenarios in Applications(BC-SRV-ARL)
27) SAP Automation
28) SAP Automation GUI Code Generator (BC-FES-AIT)
29) SAP Automation GUI Interfaces (BC-FES-AIT)
30) SAP Automation RFC and BAPI Interfaces(BC-FES-AIT)
31) SAPWeb Studio
32) SAP Business Partner (SAP BP)
33) SAP Business Workflow (BC-BMT-WFM)
34) SAP Business Workflow Demo Examples
35) SAP Communication: CPI-C Programming(BC-CST-GW)
36) SAP Communication: Configuration (BC-SRV)
37) SAP Container
38) SAP Control Framework
39) SAP Data Provider
40) SAP Exchange Connector (BC-SRV-COM)
41) SAP Graphics

REAL ESTATE MATERIAL

2010-03-13T11:49:00.000-08:00

1) REAL ESTATE DATA TRANSFOR
2) REAL ESTATE MANAGEMENT
3) REAL ESTATE MANAGEMENT(RE)
4) REAL ESTATE MANAGEMENT ARCHIEVING
5) RES WORK SCENARIOS

RFC Material

2010-03-13T11:19:00.000-08:00

1) RFC API
2) RFC GENERATOR
3) RFC C++ CLASS LIBRARY(BC-FES-AIT)
4) RFC JAVA CLASS LIBRARY(BC-FES-AIT)
5) RFC PROGRAMMING IN ABAP
6) WEBRFC PROGRAMMING

2009-10-13T11:25:00.000-07:00

Work flow..
Work flow sending data from one personnel to nother or from one transaction to another.Workflow will be triggered mainly when a transaction is saved or some even occures in any transaction. When an even t occurs all the data will be bundled and sent to a Business object. From this business object we can manipulate the data, change according to our requirements and trigger a workflow.

A business object is basically object oriented repository in SAP.
Components of Business object
it contains business object type, interface type and components such as methods , attributes and events.,

when a workflow is triggered it starts from the transaction. when a user saves the transaction,the data goes to a business object send the data out as event and methods will genearte the data and send it to work flow. most of the sap transaction have business objects. but we can also do some customization to get new business objects and we can do with out business objects also by using some sap function modules..
Scenario:
For the scenario we have to first look if there is any standard workflow is available, if available we can use it and if not we have to build one.
ex: Work flow for sap hr system.
when an employee is hired or rehired, a supervisor will be informed through an email.
Here in this scenario we are using a sap smart form as a email that has to be sent to the supervisor. we can send a simple mail but why we are using a smart form is ,
the mail that goes to a supervisor should ave a standard format. for this purpose we are using a smart form.
In sap hr for hiring we use the transaction PA40.
in the transaction PA40 give the personnel number and Select the HIRE action and then execute.
The sample screen looks like this PA40 transaction

Basically this is the screen for employee hiring action in HR i.e PA40. This hiring action is a process of many screens and they are called infotypes in HR. Just because we have taken Work flow example in HR..some people may get confused like my friend Marella...who is in SD and MM module. (thanks to him for helping in building this website). so come to the point.here each screen is called as infotype. not we have to fill all the necessary fields in every screen to complete the hiring action in PA40.Fill the personnel number and select the HIring as shown in the screen left side and click execute button. By clicking you will be taken to another screen i.e infotype "0000". And you have to fill the necessary fields there. Now after saving you will be taken to infotype 0002 screen.

This is infotype 0000. give all the required fields and save. then you will be taken to next screen infotype 0002

This is infotype 0002 screen where you will have to fill the values. affter saving here you will be taken to next screen infotype 0001.

This infotype 0001 screen. Give all the required values and save. this screen is where exactly where the workflow is needed o be triggered.Here after giving the contract data and the moemnt you save, the work flow should be triggered.Now lets discuss little bit about the architecture here. The moment we save in this third screen, all the data i.e what ever we filled in the 3 screens (0000, 0002, 0001) should be bundled into a business object .I am sure you understand about this point. All the 3 screens data will be saved into a business object. Now we need to know which business object it will be stored. And have to see the data we have just filled.Now we will go from this screen and see how this business object data is sent to work flow..how we have to configure this scenario.

>>NEXT<<

SAP R/3 Architecture Qns

2008-06-17T12:30:00.000-07:00

21. What is a client in SAP terminology?

A S/W component that uses the service (offered by a s/w component) is called a Client. At the same time these clients may also be servers for other services.

22.What is a SAP system?
The union of all s/w components that are assigned to the same databases is called as a SAP system.

23. What is the means of communications between R/3 and external applications?
The means of communication between R/2,R/3 and external applications is via the CPI-C handler or SAP Gateway, using the CPI-C Protocol.

24. What is the protocol used by SAP Gateway process?
The SAP Gateway process communicates with the clients based on the TCP/IP Protocol.

25. Expand CPI-C.
Common Program Interface Communication.

26. What is a Spool request?
Spool requests are generated during dialog or background processing and placed in the spool database with information about the printer and print format. The actual data is places in the Tem Se (Temporary Sequential objects).

27. What are different types of Log records?
V1 and V2. V1 must be processed before V2. But, we can have more than one V2 logs.

28. What are the types of Update requests?
An update request can be divided into one primary (V1) and several Secondary update components (V2). Time-critical operations are placed in V1 component and those whose timing is less critical are placed in V2 components. If a V1 update fails, V2 components will not be processed.

29. Explain what is a transaction in SAP terminology.
In SAP terminology, a transaction is series of logically connected dialog steps.

30. Explain how SAP GUI handles output screen for the user.
The SAP front-end s/w can either run on the same computer or on different computers provided for that purpose. User terminal input is accepted by the SAP terminal program SAP GUI, converted to SAP proprietary format and sent to the SAP dispatcher.
The dispatcher coordinates the information exchange between the SAP GUIs and the work processes. The dispatcher first places the processing request in request queues, which it then processes.

The dispatcher dispatches the requests one after another, to the available work process. The actual processing takes place in the work process. When processing is complete, the result of a work process is returned via the dispatcher to the SAP GUI. The SAP GUI interprets the received data and generates the output screen for the user.

SAP R/3 Architecture Qns

2008-06-17T12:27:00.000-07:00

11. Define service (within R/3)?
A service is a process or group of processes that perform a specific system function and often provide an application-programming interface for other processes to call.

12. What are the roll and page areas?
Roll and page areas are SAP R/3 buffers used to store user contexts (process requests). The SAP dispatcher assigns process requests to work processes as they are queued in the roll and page areas.
Paging area holds data from the application programs.
Roll area holds data from previous dialog steps and data that characterize the user.

13. What are the different layers in R/3 system?
Presentation Layer.
Application Layer.
Database Layer.

14. What are the phases of background processing?
Job Scheduling.
Job Processing.
Job Overview.

15. What components of the R/e system initiate the start of background jobs at the specified time?
The batch scheduler initiates the start of background job. The dispatcher then sends this request to an available background work process for processing.

16. Define Instance.
An instance is an administrative unit in which components of an R/3 systems providing one or more services are grouped together. The services offered by an instance are started and stopped at random.
All components are parameterized using a joint instance profile. A central R/3 system consists of a single instance in which all-necessary SAP services are offered. Each instance uses separate buffer areas.

17. From hardware perspective, every information system can be divided into three task areas Presentation, Application Logic and Data Storage.
The R/3 Basis software is highly suitable for use in multi-level client/server architectures.

18. What are R/3 Basis configurations?
A central system with centrally installed presentation software.
Two-level client/server system with rolled out presentation software.
Two-level client/server system. Presentation and Application run on the same computer.
Three-level client/server system. Presentation, Application and database each run on separate computers.

19. What is a Service in SAP terminology?
A service refers to something offered by a s/w component.

20. What is Server in SAP terminology?
A component can consist of one process or a group and is then called the server for the respective service.

2008-06-17T12:12:00.000-07:00

Roles and Responsibilities of End User :

Using the software at the end or after the implementation is an End User.
In sap HR , we do come across entire Org Management creation by an end user after the Personnel strucutre is created. Orgnisation Management(OM) objects like creation of Org Unit means functional area or dpt , creation Job and Position and its occupancy is with in the limits of an enduser.

Initiallly the OM is created by sap consultant . In course of time a new department has appeared in the company of the client .. this has to be created by the enduser rather than depending up on the implementor... similarly new job and position..like this small things are always done by the enduser.

The entire work of OM is purely depends upon the enduser.
After from this running periodical payroll and Ensuring of the Time schedules ( Work Schedules) of each employee is done from sap easy access by an enduser and the show run of payroll everymonth is by the enduser only. Like this lot of roles are there for an end user.

Whatever the problems come across during the enduser utilisation of sap ...that will reach as ticket to the support team.

Consultant & End users

2008-06-17T12:04:00.000-07:00

SAP consultant role is to build the system, changes & modification/updation in currently installed SAP system for the end users.

SAP End user only use the SAP system just to fetch some info, or to create new thing. So a end user is just using the final product which it is meant for and consultnat design the product/updation and modification.

The roles and responsibilities of end users is working in easy access menu they will not have authorizations of using img settings if they get doubt they will send query to the implemented company and just entering day to day transactions.

Accounting document number range for MM

2008-05-12T12:40:00.000-07:00

Accounting document number range for MM

Transaction OMW9

Document Type - Double click on desire transaction code to check the document type for number range.

(E.g. MR21 Document type - PR)

Financial accounting document type - Assign the document type to a number range and account type.
(e.g. PR - Account type allowed for posting will be MS)

Double click on the document type PR.

Assign an unique starting number range that was not used. e.g. 88

Choose the Account type for Material and G/L account (MS)

The rest of the fields are optional (you can leave it as blank)

SAP definitions for account type -

A - Assets

D - Customers

K - Vendors

M - Material

S - G/L accounts

Number ranges for financial accounting document type - Assign the number range to the running number range.

No. Year (till) From number To number Current number Ext (no tick internal or tick external)

88 9999 8800000000 8899999999 Track by SAP Blank

Accounting document will be generated if there are stocks during price change, if you don't have any stocks, no accounting document will be generated as there are no inventory to revaluate for price differences.

Valuation Class for Material Group

In 4.6x and 4.5b, you can assign valuation class to Material Group.

It is useful in the sense that user do not have to manually do an Account Assignments.

For stock items, valuation class cannot be changed whenever the stock on hand is not zero.

Valuation class are tied to a G/L account.

A change of valuation class means a change of G/L account.

In FI concept, you have to debit and credit to balance the G/L account. That is why your stock must be zero before the system allows you to changed the valuation class. If it is not zero, you have to either transfer it to another material or do a dummy issues. After changing the valuation class, do a reversal entries for the stocks which you have transfer out or you have done a dummy issues.

IMG - Material Management -> Purchasing -> Material Master -> Entry aids for items without a Material Master

G/L Accounts in MM Account Determination

The program RM07C030 check all the G/L account define in your Material Master valuation class.

Search is via Company code and Valuation area.

Compare fields status for movement types against General Ledger

Use SA38 then run RM07CUFA

2008-05-12T12:32:00.000-07:00

Maintain Storage Location

MMSC - Collective entry of Storage Location for a material.

Insert new or delete un-used Storage Location.

Maintain whether the storage location was included or excluded from MRP run.

Block Storage Location from further posting

1. You can block the storage location of a material without affecting the rest of the location using the same material.

Create a Physical Inventory document for the storage location with transaction MI01

Select the Posting Block checkbox.

This would prevent transactions from occuring until you either post or delete the physical inventory document.

(There are no impact, unless you do a post difference for the physical inventory document.)

2. Another method is to rename the storage location name.

Go to transaction OX09

Edit -> Copy as (copy the original storage location to a new name, replacing the first character e.g. ZXXX)

Edit -> Delete (delete the original storage location)

Do the reverse if you want back the original storage location.

Screens in Material Master

2008-05-12T12:26:00.000-07:00

Screens in Material Master

MM01 - Create, MM02 - Change, MM03 - Display and MM06 - Flag for deletion.

MM04 - Display the changes done to the material master.

MMAM - Change the Material Type. for e.g. from FERT to HALB

Configure the Material Master Screen MM01 / MM02 / MM03

OMSR - Assign the field to the field group
OMS9 - Maintain the data screen field

Unit of Measure

In the material master, there is a Units of measure button for users to store in the different conversion rate. This sample program (ZUNT) extract the data from the unit of measure conversion table.

In the Material Master the moving average price are affected by:-

Goods Receipt for Purchase Orders

Transfer from Plant to Plant

Invoice Receipt

Settlement

Price Change

Common configuration changes-

define new material group (OMSF)

define new valuation class (OMSK) and automatic posting (OBYC)

define new material account assignment group (transaction OVK5) and
Customer/Material/Account keys (transaction VKOA)

Block materials from inventory posting

After blocking, when the user do a inventory posting, they will get this error message :-

E: Material xxxxx has status Blocked for procmnt/whse

To activate the blocking :-

Goto transaction MM02 - Purchasing View

Type in 01 at the MM/PP status field and save it

Create Delivery Log - Material xxx is blocked

During the Create Delivery (VL01), SAP prompt you a log that Material xxx is blocked.

During the Sales Order Create/Change for that material, there might be some update termination that causes the locked of the material (Windows hanged or power failure).

You can check using transaction SM12 - type an "*" at the User name field.

Check whether the material is in the locked list.

If it is in the locked list, asked the user to log out before you delete it from the locked list.

Maintain the Material Type

2008-05-12T12:18:00.000-07:00

Maintain the Material Type

OMS2 - Material Type Maintenance - Create/Change/Display

Steps:-

Transaction OMS2
Click Change
Key in the Material Type you want to change

e.g. FERT then hit enter

The Views belows allows you to choose the Views for each Material Type.

(Press the Page up/Page Down keys to scroll the views)

If you tried to change from FERT to HAWA in 4.6x, you will receive an error message :-

The material type cannot be changed. This is not allowed if only external procurement is defined for the new material type, or if the new material type has a different account category reference than the old material type.

To overcome it, goto OMS2 and change the HAWA material type.

In the Internal/external purchase orders sections:

Original Changes

Ext. purchase orders 2 1
Int. purchase orders 0 1

Material Master - Introduction

2008-05-12T12:13:00.001-07:00

HAWA (trading goods)

Trading goods are always procured externally and then sold. A material master record of this material type can contain purchasing and sales data.

HIBE (operating supplies)

Operating supplies are procured externally and required for the manufacture of other products. A material master record of this material type can contain purchasing data but no sales data.

NLAG (non-stock material)

Non-stock material is material that is not held in stock because it is consumed immediately. (Office supplies such as stationary. You need to create purchase order and accounting document for payment but the stock balance is always zero as it is issued out immediately to the various department.)

ROH (raw materials)

Raw materials are always procured externally and then processed. Since raw materials cannot be sold, a material master record of this material type contains no sales data.

UNBW (non-valuated materials)

Non-valuated materials are managed on a quantity basis, but not by value.

VERP (packaging materials)
Packaging materials are used to transport goods and come with the goods free of charge. A material master record of this material type is managed both on a quantity basis and by value.

WETT (competitive products)
Competitive products have their own material master records created from the Basic Data view. The competitor's number, which is stored in the material master record, assigns the material to a particular competitor.

Material Master

2008-05-12T12:02:00.000-07:00

Material Master - Introduction

The material master is the starting point for the rest of the modules.

What Material Types are there?

The material types that you use are configured in Customizing for the Material Master under

Logistics Master Data : Material Master -> Material -> Control data -> Define material type attributes.

The following list shows you the material types contained, for example, in the standard SAP R/3 System, and what their different roles are:

DIEN (services)

Services are procured externally and cannot be stored. A material master record of this material type can always contain purchasing data.

FERT (finished products)

Finished products are produced by the company itself. Since they cannot be ordered by Purchasing, a material master record of this material type does not contain purchasing data.

FHMI (production resources/tools)

Production resources/tools are procured externally and used in the manufacture of products. A material master record of this material type can contain purchasing data, but no sales data. It is managed on a quantity basis. Examples of production resources/tools are apparatus, equipment, and measuring and testing devices.

HALB (semifinished products)

Semifinished products can be procured externally (sub-contracting) as well as manufactured in-house. They are then processed by the company. A material master record of this material type can contain both purchasing and work scheduling data.

Maintain Plant

2008-05-12T11:56:00.000-07:00

The valuation level that you choose affects

The maintenance of material master records

The G/L accounts in which material stocks are managed

The G/L accounts to which transactions are posted in Materials Management

Effect on the maintenance of material master records:

Depending on the valuation level chosen,

you maintain accounting data in the material master record for each plant or for each company code

you define a valuation price for the material in each plant or in each company code

Effect on G/L accounts:

If material stocks are valuated at company code level, all plant stocks of a material are managed in a joint stock account for each company code.

If material stocks are valuated at plant level, you can manage the material stocks for each plant in different accounts. For each plant, you can define a separate determination.

If several plants are to use account determination, you can group these plants in "Valuation and Account Assignment" Customizing.

Maintain Plant

2008-05-12T11:44:00.000-07:00

The plant plays an important role in the following areas:

Material Valuation - If the valuation level is the plant, the material stocks are valuated at plant level. Each plant can have its own material prices and account determination.

Inventory Management - The material stocks are managed within a plant.

MRP - Material requirements are planned for each plant. Each plant has its own MRP data. Analyses for materials planning can be made across plants.

Production - Each plant having they own production/planning.

Costing - In costing, valuation prices are defined only within a plant.

Plant Maintenance - If a plant performs plant maintenance planning tasks, it is defined as a maintenance planning plant. A maintenance planning plant can also carry out planning tasks for other plants (maintenance plants).

If you want to use the application PP (production planning) or product costing and job-order costing, you must set valuation at plant level.

2008-05-12T11:38:00.000-07:00

Maintain Plant

Plant 0001 is the SAP default.

OX14 - Define Valuation Area (Tick one only- Once your system go live, no more changes)
Most company take the SAP recommended choice - Value Material Stock at Plant level
Value Material Stock at Plant or Company Level

If you valuate material stocks at plant level, the plant is the valuation area.

If you valuate material stocks at company code level, the company code is the valuation area.

The decision you make applies to the whole client.

OX10 - Create / Change / View Plants

OVXB - Create / Change / View Division

OX18 - Assign Plant to company code
e.g. 0001 - 0001 - All Plants
Px1 - Plant Px1
Px2 - Plant Px2

OX19 - Assignment of company code to the Controlling Area

OB38 - Assign company code to Credit Control Area

OMJ7 - Assign business area to Plant/Valuation area and division

e.g. Plant Px1 - Business Area Bx1

Bx2

Assign Valuation area to the Business Area.

e.g. Valuation area Vx1 - Business Area Bx1

Business Area Bx2

OMS0 - Assign Factory Calendar to the Plant and Business Area

SAP Questions

2008-05-05T00:11:00.000-07:00

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.

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.

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.

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.

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.

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.

What is IDES?

- International Demonstration and Education System. A sample application provided for faster learning and implementation.

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.

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.

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.

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).

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.

What are datasets?

- The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.

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.

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.

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 thepeople understand the business processes and how they integrate.

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.

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.

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.

Name some drawbacks of SAP - Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.

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.

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.

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.

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.

What are the different types of source system?

- SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.

What is Extractor?

- Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.

SAP CERTIFICATION EXAM

2008-04-22T00:22:00.000-07:00

Requirements for R/3 Consultants in Production and Production Planning

In the examination for production and production planning, the participant must provide that he/she has grasped the basic functionality of the R/3 system in this area and can apply this knowledge to the project for which he/she is responsible.

The examination consists of 80 multiple choice questions from the areas specified below:

1. General Questions

2. Material Master

3. PP Master Data

4. Sales And Operations Planning

5. Demand Management & MRP

6. Production Orders

7. Capacity Planning

8. Product Costing9. Repetitive Manufacturing

10. Logistics Information System

11. Integration

Sample Question in Production and Production Planning

The following control parameters can be set in a long-term planning scenario:

A Planning period

B Opening stock

C Strategy group

D MRP type

E Version of available capacity

>>Next>>

SAP CERTIFICATION EXAM

2008-04-22T00:19:00.000-07:00

Requirements for R/3 Consultants in Materials Management

To fulfil the requirements of the examination for R/3 consultants in Materials Management, participants have to demonstrate fundamental knowledge of the R/3 system in the area of Materials Management and be able to apply this knowledge to customer projects.

The examination consists of 80 multiple choice questions from the subject areas specified below: Subject Areas

1. General Questions

2. Master Data

3. Material Planning & Forecasting

4. Purchasing

5. Inventory Management

6. Invoice Verification

7. VALUATION AND ACCOUNT DETERMINATION

Sample Question in Materials Management

You wish to procure a material using a purchase order. You wish to take delivery of the material at different times. A graduated discount scale exists for the material.

How do you proceed if you wish to take advantage of the discount arrangement?

A Enter several order items with the same material number and different delivery dates

B Enter one order item with the material number and assign the material to different accounts

C Enter an order item with the material number and create a number of schedule lines

D Enter a number of purchase orders for the material and specify different delivery dates

>>Next>>

SAP CERTIFICATION EXAM

2008-04-22T00:14:00.000-07:00

Requirements for R/3 Consultants in Human Resources

To fulfil the requirements of the examination for R/3 consultants in Human Resources, participants have to demonstrate fundamental knowledge of the R/3 system in the area of Human Resources and be able to apply this knowledge to customer projects.

The examination consists of 80 multiple choice questions from the subject areas specified below:

1. General Questions

2. Basic HR Principles

3. Master Data

4. Time Recording

5. Recruitment

6. Gross Payroll

7. Organizational Management

8. Personnel Development

9. Training And Events Management

10. Reporting

Sample Question in Human Resources

Choose the variable which can be used to determine the screen modifications for master data.

A User Group

B Personnel Administrator

C Organisational Key

D Cost CentreE Payroll Area

>>Next>>

SAP CERTIFICATION EXAM

2008-04-22T00:04:00.000-07:00

Certification Exam dates for Australia & New Zealand:

Sydney - 26 November 1998
Melbourne - 6 Nov 1998
Auckland -27 November, 7 December 1998

Curent ist can be viewed at http://www.sap.com/australia/sapient/certific/cerdates.htm
The center in the US is at Walthom( Boston) in US, Toronto, Montreal and Calgary in Canada.

Requirements for R/3 Consultants in Accounting and Controlling The examination for becoming an R/3 consultant for the Accounting and Controlling area is intended to provide candidates with the opportunity of proving that they have a fundamental knowledge of this particular area of the R/3 System as well as that they are able to apply this knowledge within a project environment.

The examination consists of 80 multiple choice questions from the areas specified below:
1.General Questions
2. Master Data
3. General Ledger
4. Accounts Receivable
5. Accounts Payable
6. Fixed Assets
7. Cost Element Accounting And Cost Center Accounting
8. Internal Orders
9. Profitability Analysis
10. Integration

Sample Question in Accounting and Controlling

Which of the following statements are correct?

Caution: more than one answer may be correct. Please mark ALL correct answers.

A More than one chart of accounts can be created for each client
B The chart of accounts contains all the G/L accounts, vendor accounts and customer accounts
C More than one company code can be allocated to the same chart of accounts
D The chart of accounts controls all the customising settings in the R/3 system
E All accounts within a chart of accounts must have the same tax code

2008-04-21T23:49:00.000-07:00

SAP CERTIFICATION EXAM

SAP offers Certification Tests for Application consultants in the areas of:

Accounting and Controlling

Human Resources

Materials Management

Production and Production Scheduling

Sales Order Processing

Application development in the ABAP/4 Development Workbench

The Exam

Multiple choice examination lasting 3 hours allows the candidate to refer to the R/3 on-line documentation.

Each question may contain 3 to 5 propositions to answer. Sometimes more than one proposition may be correct.

Application Consultants 3.x - 80 questions - 3 hours - 600 AUD ( with effect from 1 Oct 1998) Application Consultant Delta 3.x , 4.x - 30 questions - 1 hour - 350 AUD ( with effect from 1 Oct 1998)

Application Consultant 4.x - 80 questions - FI, CO, MM - 3 hrs each, PP, SD, HR, ABAP - 1 hr each - 600 AUD

Technical Consultants 3.x- 160 questions - 4 hours for all Databases ( 3 hours for Basis/AS/400) - 600 AUD

>>Next>>

2008-03-20T03:02:00.000-07:00

What is ERP?

ERP stands for Enterprise Resource Planning.

Enterprise Resource Planning systems integrate all data and processes of an organization into unified system.

The key feature of an ERP system is it uses a single or unified database to store data for the various system modules.

Various Modules which comes under ERP are listed below:

Manufacturing
Supply Chain
Financials
CRM
Human Resources
Warehouse management

What is SAP?

SAP stands for Systems Applications and Products in data processing.
SAP is the fourth largest software company in the world. It ranks after Microsoft, IBM and Oracle.
SAP Head quarters are in Walldorf, Germany. SAP was founded in 1972 by five former IBM engineers.
SAP released SAP R/2 version initially. The architecture of R/2 system is Mainframe architecture.
Later SAP R/3 is released which is different from R/2 architecture. R stands for Real time. 3 stands for 3 tier architecture. There are over 100,800 installations at more than 28,000 companies. SAP products are used by 12 million people in more than 120 countries.

TABLES

2008-03-19T23:25:00.000-07:00

Materials Management Tables

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing
Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types