SAP Interview Questions – Part 9
1.What is the difference between updated project and end to end project.?
Some organisations select to implement SAP module by module, thus gets updated as per their convenience / schedule. This is called as updated project.
Some organisations simply plan all integrated functional modules and decide to go-live with all functional modules and take their entire operations on SAP. This is called as End to End SAP implementation project.
2.What is Ranking order in automatic payment programme ?
Its the priority assigned to each house bank which helps Automatic Payement program choose the house bank for payment in case there are more than one bank satisfying the payment program.
If a payment program ends up selecting more than one(say 4) bank for payment, the ranking of the banks helps it select one bank from the list of (say 4) selected banks.
3.What is SAP APO?
SAP APO stands for Advanced Planner and Optimizer, which is one area of SCM and application component of MySAP product. Its is designed to provide solutions for companies in Demand planning, network design, supply network planning, production planning and global available to promise, transportation and scheduling.
4.How is bank reconciliation handled in SAP?
The following are the steps for BRS:
1. Create Bank Master Data – This can be created through T.Code FI01 or you can also create the house bank through IMG/FA/Bank accounting/Bank account
2. Define House Bank
3. Set up Bank selection payment programe- IMG/FA/ARAP/BT/AUTOIP/PM/Bank selection for payment prg.
a. setup all co codes for payment transaction – Customer and vendors
b.setup paying co codes for payment transactions
c.setup payment method per country
d.setup payment method per co code for payment transaction
e.setup bank determination for payment transaction
Please go for Cheque mangement using T code FCHI (IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/CheckManagement) and for void reasons FCHV.
You can create Bank Reconcilliation statement by TC FF67 (SAP/AC/Treasury/CashManagement/Incomings/ManualBankStatement) . Don’t forget to keep the opening Balance as zero. Use FBEA for post process.
All the steps together will lead to (FF67) Bank reconciliation statement.
5.How do you configure electronic bank statement?
Following is the sequence of configuration to be done for Electronis Bank Statment(EBS):
1. create Tranaction types( which helps you group all the house baks with same External transaction code).
2. assign them to house banks.
3 create and define posting rule keys .
4 assign them to external transaction codes.external transaction codes are bank specific codes for buisness tranactions( which it issues in each EBS) each one for each type of payment. eg. transfer order, foreign transfer,bill of exchange etc.
5 define posting specification for G/L posting as well as subledger posting6. define account symbols(which determines the G/L account to be posted to) and assign them to posting keys.
6.How do you configure manual bank statement?
configuration is required during electronic bank statment not in mannual bank stament. In mannual bank statment you just have to enter the data on screen and save it.
7.What is dunning?
Dunning is actually the process by which you “bill” or “invoice” a customer for past due items. With regards bad Checks for example dunning procedure could follow these steps:
Step 1: Phone call to customer on receipt of bad check – at this stage, perform the journal posting outlined in section on Returned Checks•
Step 2: Letter to customer (+10 days)•
Step 3: Letter to CO (+7 days)•
Step 4: Legal letter to customer (? DD139) (+13 days)•
Step 5: Issue DD139 (+10 days)•
Step 6: Follow-up on DD139 (dispersing officer) (+45 days)•
Step 7: Write-off (after 6 months)Steps 2-6 above will be handled by dunning levels in SAP.
Configuration before dunning can be carried out
1. Defining Dunning Area
2. Define Dunning Keys
3. Define Dunning Block Reasons
4. Dunning Procedure• Define Dunning Procedure (T. Code – FBMP), To set up a Dunning Procedure, the following must be specified: number of Dunning Levels (1-9) Dunning Texts, Standard Text can also be included in the Dunning Texts. Dunning Procedure major parameters: Dunning Interval, Number of Dunning Levels, Grace Period
5. Assign Dunning Procedure to Customer / Vendors Accounts (T. Code – XD02)
6. Define Correspondence Types (T. Code – OB77)
7. Assign Company Codes to Correspondence company Codes
8. Assign Programs for Correspondence Types (OB78)
9. Dunning Run: Transaction Code: F150Menu Path: accounting > financial accounting > accounts receivable > periodic processing > dunning.Note: Whenever you schedule more than one dunning run a day, the “Identification” number must change. You may run several dunning runs on the same date but the “Identification” name must be different as well as certain parameters such as the “Dunning Date” and “Documents Posted up to” date.
8.What is the difference between profit center accounting and Profitability analysis ?
profit center accounting is basicaly done for internal controlling purposes. It lets you determine the profit and loss using the cost of sale approach or period accounting approach. Here you can find the profit from an “area of reponsibility or pserson” point of view.this is accound based costing
Whereas in Profitability analysis, market segments based on product , cutomer,order aor any comobination of these are studied to find wots the profit. PA provides information to the marketing,sales and planning department so that they can make decisions. PA has two forms account based and CO based.
both these are tools for profit managment, and both are alternative. They are not same.
9.What are the manufacturing cost of a producting?
Materail cost + Productions cost = Manufacturing cost
10.What is the difference between stock transfer between two plants belongs to same company code and to that of different company code?
In 1st case it is called as intracompany stock transfer and the 2nd case is inter company stock transfer
Stock Transfer between plants of same compnay code only includes inventory movement without any pricing and so called Stock Transfer Order where Stock Transfer between plants of different company code is same as a purchase order as along with the inventory there is also accounts transfer (pricing) involved.
11.In real time, How listing and exclusion is used ?
Listing and exclusion is used in chemical and pharma industries for ex:-Particular customer is not having a valid licence of selling some chemical/Medicines and he is ordering the same. in this case listing and exclusion is usefull
12.What is the schema you use in Time Management?
Schema : TC00
13.What is the work relation between SAP-MM, SD and fi/co modules?
SAP is the integration of all the modules and the topics are very relavent to each other because basically its management skillsetgroup. From manufacturing the product/goods/services to reaching the customer. All the transaction process is depending on sales area, sales doc, item proposals, shipping, delivery and billing.
14.In SAP-HR, What is the landscape of your project?
Landscape in SAP consists the following: 1. IDES = Training Server2. Development Server* Configuration (200 client)* Sandbox (210 client)* Data Change (220 client)3. Quality Server* Standby (300 client)* Testing (310 client)4. Production Server* Pre-Production (400 client)* Real Production (500 client)
15.What is the role of abapers? What is the Work Bench?
Abaper is a application programmer who retrives the data from the database and show it to the end-user with the help of report..out of three layers of SAP the abaper position is on Application Layer in which SAP programs are develop and then transported to the Production server…
Workbench… The ABAP Workbench contains several tools that allow you to edit specific repository objects. like ABAP Editor , Menu PAinter etc…
16.How to integrate MM With Fico?
By using transaction code OBYC we can get the details of MM, Fico integration.
17.What is difference between business area or cost centre?
Business area is a place where the product or the produced components are valued in group or for the total transactions carried out, Right from procurement, production and sales of goods.
Where as Cost centre is a particular area where the production or the project is taken up and expenditure is identified seperately with a seperate GL account
18.How to create Tax Calculation Procedure?
Answer1:Tax calculation procedures based on the countries depended. one country is using deferent of tax procedures. We are creating new country also and at what type calculation procedures presenrt is running on the countryand it is assighned which country used.
19.What is the difference between business area and profit center?
Business area is where the total business is valuated as a whole Whereas Profit centre is an area where the company/work place allows the outside agency to use its machinery for external profits (eq: A CNC machiine which can run 24 hrs a day is utilised in our company for 15 hrs and the balance 9 hrs is let out for addition to the company’s profit) is known as Profit Centre.
20.What is Legaccy System Migration Workbench? How it can be carried out in SAP SD?
LSMW is widely used by EDI programmers. EDI Programmers connect the SAP system to Non SAP system. During this Data migration is a necessity. When data migrates from source to destination the destination code is differrent from the source code. So what LSMW does is * Converts the data in to batch files* Then converts the batch files in to source code batch files * And then mirgates data. Standard Interfaces like BAPI or Idoc are used in this process.
21.What is the difference between the stock transfer between two plants belonging to same company code and those belonging to different company code?
The stock transfer from one plant to another belonging to same company code is same as that of belonging to different company code functionally.
In both the types of transfers, there will be a material document generated which will update the QTY in both the plants in the respective storage location.
Accounting document generation will depend on the valuation level of the material. If the materials are being valuated at company level and it is being transferred from one plant to another belonging to the same company code, no accounting entry is generated. However, if the valuation is being done at plant level, the accounting document will be generated in both the cases.
22.What are the fields in purchasing view?
RFQ/Quotation- Purchase requisition- Purchase order- Master data (Info record, Source list, Conditions, Vendors etc.)v – Outline agreements
23.How do you create movement types? What are the steps involved? When will you recommend a new movement type?
A movement type can be created using T code OMJJ. Copying an existing movement type and modifying the field contents can create a new movement type.
The SAP system is delivered with some pre-defined movement types from 100 to 899. 900 onwards can be used for customized movement types.
24.What is meant by access sequence? When it is used?
Condition type has an access sequence assigned to it which determines which tables to access for data and in what sequence. This has a sequence of table based on the most specific to most generic. It can be used for any new condition type creation.
25.How does the PO pick up the pricing schema?
The pricing procedure assigned to a vendor has a calculation schema attached to it. This schema defines the various conditions’ pre-requisite, calculation & sequence in the PO. Generally, only one type of pricing procedure is followed for all the vendors.
26.What are the types of special stocks available?
Consignment stock – vendor- Components provided to vendor- Project stock- Consignment stock – customer- Pipeline material- Orders on hand
27.What are the types of inforecords?
Standard- Pipeline- Consignment- Subcontracting
28.What is meant by consignment stock?
Consignment stock is the material which is lying in the premises but is not owned by the company. It has no value assigned to it until it is taken into own stock. Once it is used in production or to be sold, it is taken into own stock.
29.What are the steps involved in consignment cycle?
Consignment cycle is similar to a standard purchase cycle. The difference it that no accounting document is created at the time of goods receipts only QTY is updated. It is settled once the same is utilized.
30.Tell me about the subcontracting cycle.
When the material is sent for subcontracting i.e. some value addition, it is converted into a different material. It needs a BOM to define the components of the finished item being received.
31.How is scrap accounted in subcontracting?
The scrap or the process loss can be adjusted while doing a quality inspection of the material received after subcontracting.
32.How are the byproducts taken care of in subcontracting?
Byproducts can be taken care of by defining them in the BOM
33.Tell me about the various movement types and usage.
101 – GR in unrest. use103 – GR in Blocked stock105 – Release from Block to Unrest. use stock.122 – Return to vendor from unrest. use stock.124 – Return to vendor from blocked stock301 – Plant to Plant tfr.309 – Material to Material tfr.311 – Tfr. from stg loc to stg loc261 – Issue for consumption.411 – Taking consignment stock into own stock.551 – Withdrawal for scrapping.Etc.
34.What is the difference between a contract and a scheduling agreement?
A scheduling agreement can be made for Consignment, Subcontracting and stock transfer. A contract, also known as a blanket PO, can be made for standard items and can be restricted to a Value or QTY.
35.How does the system calculate taxes?
Based on the calculation schema of that condition and based on access sequence assigned to it.
36.What are the cutover activities performed infinal preparartion phase ?
This activity involves- Master data upload for objects like customer masters including partner function assignment, customer material info, pricing, outputs and credit masters.
37.How to create a Purchase Order to a vendor who got best rating in Price comparision session (me49).
I wish to create PO from this session directly, explain how can it be created?Vendor rating has to be done for new purchase order everytime. PO can be generated by using transaction ME21N. This PO has to be released after creation
The other way is to assign that item to the vendor and maintain info records and update it by using ME11. This can also be done manualy.
38.What is the complete flow of the profit center accounting,and Internal orders in controlling ?
Profit Centre Accounting:
The following data can be passed on in Profit Center Accounting
* Costs (assessment and/or distribution)* Revenue and sales deductions (assessment and/or distribution)* Balance sheet items (distribution)
For this purpose, it is necessary to define cycles containing rules for finding sender-receiver relationships.
Related Activities in Controlling
* Definition of actual assessment cycles* Definition of plan assessment cycles* Definition of actual distribution cycles* Definition of plan distribution cycles
Internal orders are normally used to plan, collect, and settle the costs of internal jobs and tasks. The SAP system enables you to monitor your internal orders throughout their entire life-cycle; from initial creation, through the planning and posting of all the actual costs, to the final settlement and archiving:Features* You can use master data to assign certain characteristics to your internal orders, which enables you to control which business transactions can be used with the internal order.
* Internal order planning enables you to roughly estimate the costs of a job before the order starts and to make an exact calculation at a later date. You can choose between various planning approaches to compare the effectiveness of different methods. * You can assign and manage budgets for internal orders.
* You apply the actual costs incurred by a job to your internal orders using actual postings. In Financial Accounting, you can assign primary cost postings (such as the procurement of external activities and external deliveries) directly to internal orders.
* In period-end closing you can use various different allocation methods (for example, overhead costing) to allocate costs between different areas of Cost Accounting. Order settlement enables you to transfer the costs incurred by an order to the appropriate receivers.
* The information system for internal orders enables you to track planned and assigned costs on your orders in each stage of the order life-cycle.
* You can archive internal orders that you no longer require.
39.What is the one full implementation of life cycle in SAP-BW.?
Full life cycle implementation means implementing the project start from requirement gathering, analysis, solution desion, mapping, implementing according to ASAP methodology.
40.How the Price determination process works in SAP-MM?
Price determination process:Create a Price schemaAdd a condition type if requiredAsssign Access sequence to the condition type.Create a condition table and specify flds required.Create a cond. rec. The price schema for the particular mat. has a cond type. This pricing will trigger the Price determination process. Basically the access sequence assigned to the cond type will search the cond table to find the particular cond. rec. and determin the price.
41.What are the activities we will do in SAP MM module implementation?
Various activities in SAP MM are : Inventory, Warehouse, Purchasing, Vendor evolution, Invoice varification, etc.
42.xplain what are the steps in the SD process at least up to the invoicing stage
SD Inquiry– Quotation—Sales Order—Delivery—Transfer Order—-Post Good Issue—-Billing—Invoicing.
Condition technique:condition technique means, the combination of- condition table- access sequence- conditon type- procedure- determination
43.What is the work you have done in the MM module and what programs did you use for creating views in MM?
In MM1.Stock overview for a period can be done by Tcode-MB5B -further giving details like storage location,Plant,Material code,Date..2.Stock as on date can be viewed by using Tcode-MMBE-further giving details like storage location,Plant,Material code.mail
44.How do you get the Sales Order (S.O) No. from the Delivery Order?
There are 2 ways through which you can see the reference of the documents.1) Through Document Flow2)Enter the delivery-> Go at the item level and select TAB PREDECESSOR DATA tab and you can see the reference order number.
45.What is an Open Item in SAP? How will you find an Open Item in SAP?
you can generate a list of open items from the information systems menu option: * General Ledger: Information system ® General ledger reports ® Line items ® General ledger line items ® G/L line items, list for printing.* Accounts Receivable: Information system* ® Reports for accounts receivable ® Customer items ® List of customer open items for printing. Accounts Payable: Information system ® Reports for accounts payable ® Vendor items ® List of vendor open items for printing.
46.What is the BSP Runtime Environment?
The class CL_BSP_RUNTIME models the BSP runtime environment. The Structure HTTP Request Handler for BSP applications (handler class CL_HTTP_EXT_BSP) calls methods from this runtime environment.
You can access attributes and methods of the runtime environment from any part of the BSP application using the Global Object runtime.
47.Is There a Server Cache for Storing Web Pages?
To ensure optimum performance when handling websites, SAP Web Application Server has a cache. This means that static objects such as MIMEs, and also dynamic pages, are retrieved from the Structure ICM Server Cache or the Internet server cache if they are frequently requested by the client. Therefore, the Structure Internet Communication Manager (ICM) does not have to send the request to the Internet Communication Framework. Instead, it can return the page located in the cache.
You use profile parameters to configure the ICM Server Cache (these profile parameters start with icm/HTTP/server_cache). These profile parameters are described in Structure Parameterizing the ICM and the ICM Server Cache and in the parameter documentation in Transaction RZ11.
48.Can I Access a Web Server via HTTP?
SAP Web Application Server can also function as a client. This means that you can create HTTP requests from an ABAP program. These requests are then sent to a Web server via the Structure Internet Communication Manager (ICM).
49. What are reusable objects in DataServices?
Job, Workflow, Dataflow.
50. What is a transform?
A transform enables you to control how datasets change in a dataflow.
51. What is a Script?
A script is a single-use object that is used to call functions and assign values in a workflow.
52. What is a real time Job?
Real-time jobs “extract” data from the body of the real time message received and from any secondary sources used in the job.
53. What is an Embedded Dataflow?
An Embedded Dataflow is a dataflow that is called from inside another dataflow.
54. What is the difference between a data store and a database?
A datastore is a connection to a database.
55. What is the difference between a Repository and a Datastore?
A Repository is a set of tables that hold system objects, source and target metadata, and transformation rules. A Datastore is an actual connection to a database that holds data.
56. What is the difference between a Parameter and a Variable?
A Parameter is an expression that passes a piece of information to a work flow, data flow or custom function when it is called in a job. A Variable is a symbolic placeholder for values.
57. When would you use a global variable instead of a local variable?
When the variable will need to be used multiple times within a job.
When you want to reduce the development time required for passing values between job components.
When you need to create a dependency between job level global variable name and job components.
58. What is Substitution Parameter?
The Value that is constant in one environment, but may change when a job is migrated to another environment.
59. List some reasons why a job might fail to execute?
Incorrect syntax, Job Server not running, port numbers for Designer and Job Server not matching.
60. List factors you consider when determining whether to run work flows or data flows serially or in parallel?
Consider the following:
Whether or not the flows are independent of each other
Whether or not the server can handle the processing requirements of flows running at the same time (in parallel)
61. What does a lookup function do? How do the different variations of the lookup function differ?
All lookup functions return one row for each row in the source. They differ in how they choose which of several matching rows to return.
62. List the three types of input formats accepted by the Address Cleanse transform.
Discrete, multiline, and hybrid.
63. Name the transform that you would use to combine incoming data sets to produce a single output data set with the same schema as the input data sets.
The Merge transform.
64. What is SAP APO?
SAP APO stands for Advanced Planner and Optimizer, which is one area of SCM and application component of MySAP product. Its is designed to provide solutions for companies in Demand planning, network design, supply network planning, production planning and global available to promise, transportation and scheduling.
65. What are the support tickets given in SAP fico module?
please give some examples.Support tickets are basically the problems that arise in day to day usage of SAP. So any sap fico consultant who is resolving the day to day production issues is actually supporting the tickets.
66. How is bank reconciliation handled in SAP?
The following are the steps for BRS:1. Create Bank Master Data – This can be created through T.Code FI01 or you can also create the house bank through IMG/FA/Bank accounting/Bank account2. Define House Bank3. Set up Bank selection payment programe- IMG/FA/ARAP/BT/AUTOIP/PM/Bank selection for payment prg.a. setup all co codes for payment transaction – Customer and vendorsb.setup paying co codes for payment transactionsc.setup payment method per countryd.setup payment method per co code for payment transactione.setup bank determination for payment transaction
Please go for Cheque mangement using T code FCHI (IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/ CheckManagement) and for void reasons FCHV. You can create Bank Reconcilliation statement by TC FF67 (SAP/AC/Treasury/CashManagement/Incomings /ManualBankStatement) . Don’t forget to keep the opening Balance as zero. Use FBEA for post process.
All the steps together will lead to (FF67) Bank reconciliation statement.
67. 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.
68. 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.
69. What is IDES?
International Demonstration and Education System. A sample application provided for faster learning and implementation.
70. 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.
71.What is the difference between release procedure with classification and without classification and when are they used?
The release procedure with classification deals with the purchase requisition it can be released both at item level and at the header level. Coming to release procedure without classification can also be used for purchase requisition which is used for item level release only. All other external documents cannot be released with classification These two procedures are mutually exclusive to say, it has to be decided in favor of one of them only.
72.In what way does the Subcontracting was cared by the byproducts?
The Byproducts take care of subcontracting in BOM for the header.
73.What is the procedure to give specifications for developments?
The procedure to give specifications are normally prepared for the business requirement document in which we specify what is required, what field and tables have to be referred for the required development.
74. How can we set the table spaces and extent sizes?
You can specify the extent sizes and the table space (physical storage area in the database) in which a transparent table is to be stored by setting the size category and data class.
75. What is the function of the correction system?
The correction system manages changes to internal system components. Such as objects of the ABAP/4 Dictionary.
76. What are local objects?
Local objects (Dev class$TMP) are independent of correction and transport system.
77. What is a Development class?
Related objects from the ABAP/4 repository are assigned to the same development class. This enables you to correct and transport related objects as a unit.
78. What is the max no of match code Id’s that can be defined for one Match code object?
A match code Id is a one character ID that can be a letter or a number.
79. Can we define our own Match Code ID’s for SAP Matchcodes?
Yes, the number 0 to 9 are reserved for us to create our own Match Code Ids for a SAP defined Matchcode object.
80. What is an Update type with reference to a Match code ID?
If the data in one of the base tables of a matchcode ID changes, the matchcode data has to be updated. The update type stipulates when the matchcode is to be updated and how it is to be done. The update type also specifies which method is to be used for Building matchcodes. You must specify the update type when you define a matchcode ID.
81.What is meant by slab? How is Indian slab and US slab? (He was talking about some %ages. I don’t know what they are. )
Grouping of employees depending on their allowances and PERKS is nothing but Slab system and it also even comes for Professonal Tax.
82.What are Dynamic Actions? Give a few examples. What are the IT’s you used in them. (I know only Birth of Child action, and the IT’s used in it are Personal Data, Additional Payments)
Dynamic actions which are triggered by the system. They are result of some personnel action. If you make a change (personnel action) to the personnel data of an info type that then has an effect on the data of a second info type, the system automatically displays the info type. One of the main purpose of the dynamic action (of the system) is to have a consistent and coherent data. These actions are started automatically by the system, unlike the Personnel actions which you start by yourself. The best example is when you carry out an action lets say hiring, you need to populate a set of info types. Your initial entry of details in infotype 0000 is personnel action. When you do this system automatically displays next infotpes- which is result of dynamic action
83.What is Recruitment Cycle?
Its is the complete process of recruitment right from identifying the vacancies displaying the same, notifying them, inviting the applicants, screening the applicants, interviewing them, selecting them, and recruiting them and appointing them(giving an organizational position in the organization— all theses processes constitute the recruitment cycles
84.What is Qualification Deficiency? How will you come to know that a Person does not have certain skills/qualificatio ns? (This was posed after I said that I worked on Training and Events also).
Generally the required qualifications are stored in Required Qualifications (Infotype 5129). So any deficient qualifications can be viewed in this infotype.
85. How many Normal and Special periods will be there in fiscal year, why do u use special periods?
12 Normal posting period and 4 special periods are in the fiscal year which can be used for posting tax and audit adjustments to a closed fiscal year.
86.Where do you open and close periods?
PPV is used to open and close the periods based on a/c types considering GL Accounts. Tr. Code. OB52.
87. What are datasets?
The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.
88.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.
89.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.
90. How can an ERP such as SAP help a business owner learn more about how business operates?
In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates. Using SAP as a tool to learn about ERP systems will require that the people understand the business processes and how they integrate.
91. 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.
92. 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.
93.How can I extend all material to a new plant?
The SAP program – RMDATIND is used to create /update material master record.
94.How can we delete materials permanently from Material master?
Use transaction MM70 – Material Master->Other->Reorganization->Material->Choose.Build variant with selection range of material master records to be selected for deletion and maintain run parameters. Execute.
Use transaction MM71 – Material Master-> other-> Reorganization->Material->Reorganization Build a second variant Maintain run parameters and execute.
It is also important to remove the records manually from info record, POs, PRs, reservation etc for successful deletion of the material.
95.We have defined all the variables for the materials. However, when I attempt to use Material Matchcode object MAT1, I get the response &Quot;No possible entries found&Quot;. Why?
Matchcode i.d. &Quot;B&Quot;, &Quot;Material by bill of material&Quot; has a selection condition for field STLNR NE ‘ ‘. STLNR is the BOM number associated with a material in table MAST. Hence the message – &Quot;no possible entries…&Quot; pops up if there are no bills of materials associated with your material numbers. You get the matchcodes as long as the material referred by you has BOM number associated with it.
96.The matchcode object selection is defaulted to matctcode ID &Quot;B&Quot;. Iwould like to change to M &Quot;Material by Description&Quot; What is the solution?
Press the pull down arrow on the material number field and matchcode &Quot;B&Quot; is displayed, press F5 double-click matchcode i.d. &Quot;M&Quot;, then press F6 . This will set matchcode &Quot;M&Quot; as the default.
97.We have one material master : X and the unit of measure is ‘pcs’ and two serial number : A,B
For this material we make two Pos
First PO calls material X , 1 pcs price 100 (will use serial number A)
Second PO calls material X , 1 pcs price 250 (will use serial number B)
Goods Receipt is done and by filling serial number for the fist PO with A and the second PO with B.
98.We want to transfer material X serial number A to another plant and want the valuation of this material as 100. How we can do it ?
Use &Quot;split valuation&Quot;. Stocks may be received into separate storage locations. Transfer stocks may be done from a storage location/plant to another storage location/plant.
99. We want to change the calculation of Moving Average Price. We know that the same is in MBEW-VERPR and two transactions to consider – MRHR, MB01. Is there a transaction to change MAV or all the places it is needed?
Any Goods receipt or issue (in case of split valuated material) changes Moving Average price depending upon the valuation type which is used when posting the goods issue. You have to go through all the transactions involving those!
Material X is using split valuation by origin:
Malaysia : MAV 60 USD – total stock 100 units
India: MAV 50 USD – total stock 200 units
Total stock 300 units MAV 53.33
Here , goods issues will also affect the global MAV, despite not changing MAV from origin country.
100.What is the use of configurable material.?
Configurable material is useful if you have a large number of combination of parts that go into a product. It means different permutations and combinations of the parts for same material. If you maintain a uniQue material code for each combination , you reQuire a large number of material numbers. KMAT may be used in such a case where you maintain just one generic product code. A super BOM is maintained for such a material consisting of all possible alternatives. A routing is also maintained consisting of all possible operations that could be used. Typically configurable material is used in Made To Order (MTO) environment. However freQuently ordered configurations may be planned with a material variant which needs to have a material master record. Thus Material variants may have stock and value. Depending upon characteristic values chosen at sales order entry Sales Order BOM is created. Routing operations are also chosen depending upon which BOM components are assigned to them.
101.Will Source List automatically appear in Material Master as default if maintained at plant level using OME5?
If you have maintained source list reQuirement in OME5 and have not maintained the source list for the material , Po can not be released. You are reQuired to maintain source list for all materials in the plant where the indicator is set if you maintain source list at plant level. Else you can make use of info record to do so automatically.
102.We have One company with a plant and another company with a sales organization. Which is better option between these – PO or Stock Transfer Order ?
Cross company Stock Transport Orders can be done.
# Configure using transaction OMGN.
# Depending upon the sending and receiving plants, maintain sales organization and customer data in customizing.
# Maintain the supplying plant as a vendor and attach the plant to the vendor in the Vendor Master.
# Material type has to be HALB or HAWA.
# Ensure that the company with sales Organization has a plant to take care of stocking.
# The PO used is NB and not Stock Transfer PO.
Configure SD for inter-company billing to enable picking up the pricing procedure for billing.
# Carry Out delivery through process delivery due list and billing through process billing due list.
103.We can make field mandatory. We want to make a default value to a Particular field in the Material Master. Say, We want that the period indicator in the MRP2 view as &Quot;P&Quot;. What is the best way?
Use transaction variant. Transaction SHD0 and then Transaction SE93.