Top 100+ Sap Bw Interview Questions And Answers
Question 1. What Is Table Partition?
Answer :
SAP is using fact table partitioning to improve the performance. You can partition handiest on 0CALMONTH or 0FISCPER.
Question 2. What Are The Options Available In Transfer Rule And When Abap Code Is Recquired During The Transfer Rule What Important Variables You Can Use?
Answer :
Assign information object, Assign a Constant , ABAP habitual or a Formula.
SAP BI Interview Questions
Question three. How Would You Optimize The Dimensions?
Answer :
Use as many as possible for performance improvement; Ex: Assume that u have one hundred products and 2 hundred customers; in case you make one dimension for each ,the scale of the size can be 20000; in case you make individual dimensions then the whole number of rows may be 300. Even if you positioned multiple characterstic according to size, do the maths thinking about worst case senerio and determine which characterstics can be combined in a size.
Question four. What Are The Conversion Routines For Units And Currencies In The Update Rule?
Answer :
Time dimensions are robotically transformed; Ex: if the dice incorporates calender month and your transfer shape includes date, the date to calender month is transformed automatically.
SAP BI Tutorial
Question five. Can You Make An Info Object As Info Provider And Why?
Answer :
Yes, When you need to document on characterstics or master statistics, you can cause them to as data provider. Ex: you can make 0CUSTMER as data provider and do Bex reporting on zero CUSTOMER;proper click on at the data place and pick out Insert characterstic as facts goal.
SAP WM Interview Questions
Question 6. What Are The Steps To Unload Non Cumulative Cubes?
Answer :
1. Initialize openig balance in R/three(S278)
2. Activate extract shape MC03BF0 for information supply 2LIS_03_BF
3. Setup historical fabric docus in R/3.
Four. Load establishing balance using information source 2LIS_40_s278
five. Load historic actions and compress with out marker update.
6. Setup V3 Update
7. Load deltas the usage of 2LIS_03_BF
Question 7. Give Step To Step Approach To Archiving Cubex?
Answer :
1. Double click on on the dice (or right click on and pick alternate)
2. Extras -> Select archival
three. Choose fields for choice(like 0CALDAY, 0CUSTOMER..Etc)
four. Define the record structure(max report size and max no of records items)
five. Select the folder(logical record call)
6. Select the delete alternatives (not scheduled, begin routinely or after occasion)
7. Spark off the dice.
8. Cube is ready for archival.
SAP WM Tutorial SAP BO Interview Questions
Question eight. What Are The Load Process And Post Processing?
Answer :
Info packake, Read PSA and replace records goal, Save Hierarchy, Update ODS information item, Data export(open hub), delete overlapping requests.
Question nine. What Are The Data Target Administration Task?
Answer :
delete index, generate index, construct database records, initial fill of recent aggregates, roll up of crammed aggregates, compression of the infocube,set off ODS, entire deletion of data target.
SAP Netweaver Interview Questions
Question 10. What Are The Parallel Process That Could Have Locking Problems ?
Answer :
1. Heirachy characteristic alternate run
2. Loading grasp information from equal infoobject; for ex: avoid master records from distinctive source systems on the same time.
Three. Rolling up for the same information dice.
Four. Selecting deletion of information dice/ ODS and parallel loading.
5. Activation or delection of ODS object while loading parallel.
SAP BO Tutorial
Question eleven. How Would You Convert A Info Package Group Into A Process Chain?
Answer :
Double Click at the data package deal grp, click on on the 'Process Chain Maint' button and sort inside the name and descrition ; the man or woman info applications are inserted automatically.
SAP BODS Interview Questions
Question 12. How Do You Transform Open Hub Data?
Answer :
Using BADI.
SAP BI Interview Questions
Question 13. What Are The Data Loading Tuning One Can Do?
Answer :
1. Watch the ABAP code in transfer and replace guidelines;
2. Load stability on exceptional servers
3. Indexes on source tables
4. Use fixed duration documents if u load records from flat files and placed the report at the utility server.
5. Use content extractor
6. Use PSA and facts goal inparallel alternative within the info bundle
7. Begin numerous data packagers parallel with different choice alternatives
8. Buffer the SID quantity stages if u load lot of information at once
nine. Load master data before loading transaction data.
SAP Netweaver Tutorial
Question 14. What Is Ods?
Answer :
Operations information Source you can overwrite the present facts in ODS.
Question 15. What Is The Use Of Bw Statistics?
Answer :
The sets of cubes introduced by way of SAP is used to degree overall performance for question, loading information and so on., It additionally shoes the usage of aggregates and the cost associated with then.
SAP Webi Interview Questions
Question 16. What Are The Options When Defining Aggregates?
Answer :
* - corporations according to characterstics.
H - Hierarchy.
F - constant price.
Blank --- none.
SAP BODS Tutorial
Question 17. How Will You Debug Errors With Sap Gui (like Active X Error Etc)?
Answer :
Run Bex analyzer -> Business Explorer menu object -> Installation take a look at; this suggests an excel sheet with a begin button; click on on it; this verifies the GUI installation ;if u locate any errors either reinstall or fix it.
SAP Web Dynpro Interview Questions
Question 18. When You Write User Exit For Variables What Does I_step Do?
Answer :
I_Step is utilized in ABAP code as a conditional test.
SAP WM Interview Questions
Question 19. How Do You Replace A Query Result From A Master Query To A Child Query?
Answer :
If you pick out characterstic fee with alternative route then it used the consequences from previuos question; for ex: allow us to anticipate that u have question Q1 which displays the top 10 customers, we've query Q2 which gets the pinnacle 10 customers for information object zero customer with as a vairable with alternative direction and display distinct report at the customers listing handed from Q1.
SAP Webi Tutorial
Question 20. How Do You Define Exception Reporting In The Background?
Answer :
Use the reporting agent for this from the AWB. Click on the exception icon at the left;give a call and outline. Select the exception from query for reporting(drag and drop).
SAP BDC Interview Questions
Question 21. How You'll Write Date In Bw?
Answer :
YYYYMMDD.
Question 22. What Are The Data Types For The Characteristic Info Object?
Answer :
There are 4types:
1. CHAR
2. NUMC
three. DATS
4. TIMS
SAP Web Dynpro Tutorial
Question 23. What Is The Model Of The Info Cube?
Answer :
Info cube model is prolonged star schema.
SAP BW on HANA Interview Questions
Question 24. What Is The Maximum No. Of Characteristics?
Answer :
248.
SAP BO Interview Questions
Question 25. What Is The Maximum No. Of Key Figures?
Answer :
233.
SAP BW on HANA Tutorial
Question 26. What Are The 3sap Defined Dimensions?
Answer :
The three SAP defined dimensions are…..
1. Data packet measurement (P)…..It carries 3characteristics.A) request Id (b) Record type (c) Change run id
2. Time size (T)….It consists of time characteristics which includes 0calmonth, 0calday and many others
three. Unit Dimension (U)…it contains basically amount and amount related units.
Question 27. What Are The Minimum No Of Dimensions In Info Cube?
Answer :
four(3 Sap defined and 1 purchaser defined).
SAP Netweaver Interview Questions
Question 28. What Is The Maximum No. Of Dimensions In Info Cube?
Answer :
sixteen(3 are sap defines and 13 are customer defined).
Question 29. How Many Tables Does Info Cube Contain?
Answer :
Actually info dice consists of two table's E desk and F (fact) desk.
Question 30. What Is Dimension Table?
Answer :
Dimension table is a set of logically associated descriptive attributes which means traits.
Question 31. What Is Fact Table?
Answer :
Fact desk is the gathering if information and members of the family that means overseas keys with the size. Actually reality desk holds transactional information.
Question 32. What Is Slowly Changing Dimension?
Answer :
Dimensions those adjustments with time are called slowly changing measurement.
Question 33. What Is Star Schema?
Answer :
In Star Schema model, Fact table is surrounded by using dimensional tables. Fact table is normally very massive, that means it includes tens of millions to billions of statistics. On the other hand dimensional tables are very small. Hence they comprise a few heaps to few million statistics. In exercise, Fact table holds transactional records and dimensional table holdsmaster statistics.
The dimensional tables are unique to a reality desk. This means that dimensional tables are not shared to across different truth tables. When different truth table which include a product desires the equal product measurement facts any other size desk that is particular to a brand new fact desk is wanted.
This scenario creates data control troubles inclusive of master records redundancy because the very equal product is duplicated in several dimensional tables as opposed to sharing from one single master records desk. This hassle may be solved in prolonged celebrity schema.
SAP BODS Interview Questions
Question 34. What Is The Difference Between Start Routine And Update Routine, When, How And Why Are They Called?
Answer :
• Start ordinary may be used to get right of entry to InfoPackage even as update workouts are used while updating the Data Targets.
Question 35. How To Create A Connection With Lis Infostructures?
Answer :
• LBW0 Connecting LIS InfoStructures to BW.
Question 36. What Is The Difference Between Ods And Infocube And Multiprovider?
Answer :
• ODS: Provides granular data, lets in overwrite and records is in transparent tables, perfect for drilldown and RRI.
• CUBE: Follows the superstar schema, we are able to handiest append records, perfect for primary reporting.
• MultiProvider: Does not have physical records. It lets in to get entry to facts from specific InfoProviders (Cube, ODS, InfoObject). It is also favored for reporting.
SAP Webi Interview Questions
Question 37. What Are Start Routines, Transfer Routines And Update Routines?
Answer :
• Start Routines: The start habitual is run for each DataPackage after the statistics has been written to the PSA and earlier than the switch rules have been finished. It allows complex computations for a key discern or a feature. It has no return value. Its motive is to execute preliminary calculations and to shop them in worldwide DataStructures. This shape or desk can be accessed within the different workouts. The whole DataPackage in the switch shape layout is used as a parameter for the ordinary.
• Transfer / Update Routines: They are defined at the InfoObject level. It is just like the Start Routine. It is impartial of the DataSource. We can use this to outline Global Data and Global Checks.
Question 38. What Are The Steps Involved In Lo Extraction?
Answer :
• The steps are:
o RSA5 Select the DataSources
o LBWE Maintain DataSources and Activate Extract Structures
o LBWG Delete Setup Tables
o 0LI*BW Setup tables
o RSA3 Check extraction and the facts in Setup tables
o LBWQ Check the extraction queue
o LBWF Log for LO Extract Structures
o RSA7 BW Delta Queue Monitor
Question 39. What Are The Extractor Types?
Answer :
• Application Specific
o BW Content FI, HR, CO, SAP CRM, LO Cockpit
o Customer-Generated Extractors
LIS, FI-SL, CO-PA
• Cross Application (Generic Extractors)
o DB View, InfoSet, Function Module
Question 40. What Are The Delta Options Available When You Load From Flat File?
Answer :
• The three options for Delta Management with Flat Files:
- Full Upload
- New Status for Changed statistics (ODS Object most effective)
- Additive Delta (ODS Object & InfoCube)
SAP Web Dynpro Interview Questions
Question forty one. What Are The Steps To Extract Data From R/three?
Answer :
• Replicate DataSources
• Assign InfoSources
• Maintain Communication Structure and Transfer guidelines
• Create and InfoPackage
• Load Data
Question forty two. What Are Bw Statistics And What Is Its Use?
Answer :
• They are organization of Business Content InfoCubes which are used to degree overall performance for Query and Load Monitoring. It also suggests the usage of aggregates, OLAP and Warehouse management.
SAP BDC Interview Questions
Question forty three. How Do You Transform Open Hub Data?
Answer :
• Using BADI we are able to transform Open Hub Data in keeping with the vacation spot requirement.
Question forty four. What Is Open Hub Service?
Answer :
• The Open Hub Service permits us to distribute statistics from an SAP BW device into external Data Marts, analytical packages, and different programs. We can ensure managed distribution the use of numerous systems. The important object for exporting statistics is the InfoSpoke. We can outline the supply and the target object for the facts. BW becomes a hub of an business enterprise information warehouse. The distribution of information will become clean through vital monitoring from the distribution popularity in the BW system.
Question 45. Can An Infoobject Be An Infoprovider, How And Why?
Answer :
• Yes, whilst we need to record on Characteristics or Master Data. We have to proper click on on the InfoArea and choose “Insert function as statistics target”. For example, we can make 0CUSTOMER as an InfoProvider and report on it.
Question 46. What Are Conversion Routines For Units And Currencies In The Update Rule?
Answer :
• Using this option we will write ABAP code for Units / Currencies conversion. If we permit this flag then unit of Key Figure seems inside the ABAP code as a further parameter. For example, we are able to convert gadgets in Pounds to Kilos.
Question forty seven. What Is Compression?
Answer :
• It is a system used to delete the Request IDs and this saves area.
Question 48. How To Create Condition And Exceptions In Bi.7.0? But I Know In Bw3.Five Version.?
Answer :
From a question name or description, you'll now not be able to choose whether or not the question is having any exception.There are methods of locating exception against a query:1. Execute queries one at a time, the one that is having historical past coloration as exception reporting are with exceptions.2. Open queries within the BEX Query Designer. If you're finding exception tab on the proper aspect of clear out and rows/column tab, the question is having exception.
Question 49. What Is 0recordmode?
Answer :
It is an data object , 0Record mode is used to perceive the delta pix in BW that's used in DSO .It is mechanically activated whilst u set off DSO in BW. Like that in R/three additionally have area 0cancel. It holds delta pix in R/three. When ever u extracting information from R/three the usage of LO or Generic.. Etc. This area 0Cancel is mapping with 0Record mode in BW. Like this BW become aware of the Delta photographs.
Question 50. Development Tasks For Rms Release Work?
Answer :
The main project is Complete life cycle improvement of SAP Authorization Roles. This includes collaborating inside the high degree, low level, RMS's and technical improvement of the jobs.
Question 51. What Is The Rms Application?
Answer :
SAP Records Management is a component of the SAP Web Application Server for the electronic control of facts and even paper-based information may be part of the digital file within the SAP RMS. Other advantages of the use of SAP Records Management compared to other companies of record-based solutions: Records Management is a solution for the electronic control of statistics. The RMS divides various commercial enterprise units logically thereby making it viable to provide precise corporations of customers with get right of entry to to unique information, as wanted inside their enterprise approaches.
Quick access to statistics is a key aspect for acting enterprise efficiently. Records Management ensures this short access. In one document, all information items of a enterprise transaction are grouped together in a transparent hierarchical structure. By converting paper statistics to electronic records, an corporation can experience all of the blessings of a paper-loose office: No garage fees for statistics, no cost-intensive copying methods, and ultimate retrieval of statistics.
However, SAP Records Management not most effective presents an electronic representation of the conventional paper document.
Question 52. What Is The Use Of Define Cell In Bex & Where It Is Useful?
Answer :
Cell in BEX:::Use * When you outline choice criteria and formulation for structural additives and there are structural components of a question, frequent cell definitions are created on the intersection of the structural additives that determine the values to be offered inside the cell. Cell-unique definitions permit you to outline explicit formulas, at the side of implicit cell definition, and choice conditions for cells and on this manner, to override implicitly created cell values. This characteristic permits you to layout plenty more detailed queries. In addition, you may define cells that have no direct dating to the structural additives. These cells are not displayed and function containers for assist picks or assist formulation. You want two systems to enable mobile editor in bex. In every question you have got one shape for key figures, then you need to do every other structure with picks or formulation inside. Then having structures, the move amongst them effects in a fix reporting region of n rows * m columns. The go of any row with any column may be described as formula in mobile editor. This is beneficial when you need to any cell had a special behaviour that the overall one described for your question definition. For example imagine you have got the subsequent in which % is a formula kfB/KfA *one hundred.KfA kfB %chA 6 four sixty six%chB 10 2 20%chC 8 four 50percentThen you want that % for row chC was the sum of % for chA and % chB. Then in cellular editor you are allow to put in writing a formulation especially for that cellular as sum of the 2 cell before. ChC/% = chA/% + chB/% then:kfA kfB %chA 6 4 66p.CchB 10 2 20p.CchC eight 4 86% Manager Round Review Questions.
Question fifty three. How To Convert A Bex Query Global Structure To Local Structure (steps Involved)?
Answer :
BeX query Global structure to local shape Steps a neighborhood structure while you want to feature shape elements which might be specific to the unique question. Changing the worldwide structure changes the structure for all the queries that use the global shape. That is purpose you go for a local structure. Coming to the navigation part--In the BEx Analyzer, from the SAP Business Explorer toolbar, select the open query icon (icon tht looks as if a folder) On the SAP BEx Open conversation field:Choose Queries. Select the desired InfoCubeChoose New.On the Define the query screen:In the left frame, make bigger the Structure node. Drag and drop the favored shape into both the Rows or Columnsframe. Select the global shape. Right-click and pick Remove reference. A nearby shape is created. Remember that you can't revert returned the changes made to worldwide shape in this regard. You will should delete the neighborhood shape and then drag ndrop global shape into question definition. When you try to store a worldwide shape, a speak field activates you to verify modifications to all queries. That is how you become aware of a global structure.
Question fifty four. An Sap Bw Functional Consultant Is Responsible For The Following: Key Responsibilities Include?
Answer :
Maintain project plans Manage all undertaking activities, a lot of which can be finished by means of assets no longer immediately managed via the task chief (critical BW improvement team, source gadget developer, enterprise key customers) Lease with key users to agree reporting necessities, record designs Translate requirements into layout specifications( file specs, records mapping / translation, practical specs) Write and execute check plans and scripts . Coordinate and control commercial enterprise / user testing Deliver training to key users Coordinate and control product ionization and rollout sports Track CIP (non-stop development) requests, work with customers to prioritize, plan and control CIP An SAP BW technical consultant is answerable for:SAP BW extraction using trendy information extractor and to be had development equipment for SAP and non-SAP statistics assets. -SAP ABAP programming with BWData modeling, megastar schema, master facts, ODS and cube layout in BWData loading manner and strategies (performance tuning)Query and record improvement using Bex Analyzer and Query Designer Web file improvement the usage of Web Application.
Question 55. When We Use Maintain Data Source, What We Do? What We Will Maintain?
Answer :
Go to BW machine and create a brand new data package for delta hundreds. Double click on new data package. Under update tab you may see the delta update radio button.
Question fifty six. Who Used To Make The Technical And Functional Specifications?
Answer :
Technical Specification:Here we are able to point out all the BW gadgets (data items, records sources, info resources and information providers). Then we are going to mention the records go with the flow and behavior of the data load (both delta or full) additionally we can inform the length of the dice activation or introduction. Pure BW technical matters are to be had in this document. This isn't for End customers report. Functional Specification:Here we can describe the enterprise necessities. That approach here we are going to mention which might be all enterprise we're imposing like SD, MM and FI and many others., then we're going to inform the KPI and deliverable reviews element to the customers. This record is going to mingle with both Function Consultants and Business Users. This document is relevant for stop users additionally.
Question 57. How Do We Decide What Cubes Has To Be Created?
Answer :
It relies upon to your task requirement. Customized cubes are not obligatory for all the tasks. If your business requirement is differs from given scenario ( BI content cubes ) then only we are able to choose customized cubes. Normally your BW customization or creation of recent info providers all are relying in your source system. If your supply system different that R3 then you definately ought to go together with customization of your all objects. If your supply machine is R3 and your users are the usage of only R3 popular business situations like SD, MM or FI... And many others., then you definitely dont want to create any info vendors otherwise you dont want to enhance any factor inside the present BW Business Content. But ninety nine% this is not feasible. Because truly they must have covered their new business state of affairs or new improvements. For instance, In my first challenge we applied for Solution Manager BW implementation. There we've got activated all of the business content material in CRM. But the supply gadget have new scenarios for message escalation, getting older calculation and many others., According their enterprise situation we couldn't use fashionable commercial enterprise content material. For that we've taken simplest present info objects and created new information items which aren't there within the business content. After that we've created custom statistics supply to data carriers in addition to reports.
Question 58. How Do We Gather The Requirements For An Implementation Project?
Answer :
One of the largest and most vital demanding situations in any implementation is amassing and information the give up user and process group functional requirements. These purposeful necessities represent the scope of analysis desires and expectancies (both now and within the future) of the quit consumer. These generally involve all the following:- Business motives for the task and enterprise questions answered via the implementation- Critical success elements for the implementation- Source systems which are involved and the scope of records wished from every- Intended audience and stakeholders and their evaluation needs- Any important transformation that is wanted in order to offer the records- Security requirements to save you unauthorized use This process entails one apparently simple challenge: Find out precisely what the give up users' evaluation necessities are, each now and inside the future, and construct the BW device to these necessities. Although simple in idea, in practice collecting and reaching a clear expertise and settlement on a complete set of BW practical requirements isn't constantly so simple.
Question fifty nine. How Can You Solve The Data Mismatch Tickets Between R/3 And Bw?
Answer :
Check the mapping at BW aspect for 0STREET in transfer regulations. Check the records in PSA for the identical subject. If the PSA is likewise doesn't have complete information then take a look at the field in RSA3 in supply device.
Question 60. Difference Between V1, V2, V3 Jobs In Extraction?
Answer :
V1 Update: whilst ever we create a transaction in R/3(e.G.,Sales Order) then the entries get into the R/three Tables(VBAK, VBAP..) and this takes area in V1 Update.
V2 Update: V2 Update starts offevolved some seconds after V1 Update and in this update the values get into Statistical Tables, from in which we do the extraction into BW.
V3 Update: Its merely for BW extraction.
Question 61. What Is A Star Schema?
Answer :
A reality table on the middle and surrounded (linked) with the aid of size tables.
Question 62. What Is A Slowly Changing Dimension?
Answer :
A measurement containing a traits which modifications over a time; for instance take employee process identify; this adjustments over a time period with different activity titles.
Question 63. What Is Business Content?
Answer :
The pre configured objects brought via SAP is enterprise content; it is roles, queries, info vendors, info supply, information source, info items, information package deal, and so forth; as an instance OMATERIAL is a enterprise content added by way of sap.
Question 64. What Is The 90 Day Rule?
Answer :
Finish inside ninety days and show the usage of added business content.
Question 65. What Is A Typical Set Up Of Bw Team?
Answer :
Usually the group has a undertaking supervisor, one or extra Functional experts, one or greater developers and one or more QA testers and the usual foundation group.
Question 66. What Are The Project Phases Within Asap?
Answer :
a. Project coaching - preliminary stuff; do a conceptual review after this segment
b. Business blue print - Functional spec; do a design overview after this section
c. Realization - increase; do a configuration overview after this section
d. Final coaching - QA and different final stuff earlier than moving to manufacturing; do a overall performance overview after this section
e. Go stay and assist - to manufacturing and aid
Question sixty seven. What Is Asap?
Answer :
Accelerated SAP.
Question 68. How Do You Do Euro Conversion At The Database Level?
Answer :
Use this system RSEURO.
Question sixty nine. What Is The Function Module To Convert Currency?
Answer :
RSW_CURRENCYTRANSLATION.
Question 70. Which Table Contains The Exchange Rate?
Answer :
TCURV.
Question seventy one. What Is Translation Key?
Answer :
Defines how the change charge is calculated; the target forex can be constant or can be determined on the time of translation.
Question seventy two. What Are The Options To Convert Currency?
Answer :
In the update rule or in Bex; in case you do it in the replace rule then you definitely lose the data on the unique foreign money.
Question 73. What Are The Steps To Create Db Connect?
Answer :
a. First affirm that the DB connection works from the server
b. AWB -> Source structures -> create
c. Select Database supply device
d. Enter the database user call, password and connect string; for instance Oracle enter the TNS call
e. Generate the statistics supply using transaction RSDBC
f. Assign facts source to information source
g. Maintain and activate communication structure and switch guidelines
h. Create data package deal and cargo facts
Question seventy four. What Are The Pre-requisites For Db Connect?
Answer :
a. DBSL have to be established on SAP server
b. Database particular DB Client should be installed
c. Table and subject names must be in capital letters
Question 75. What Is Db Connect?
Answer :
SAP has given a software to load statistics from outside databases at once like Oracle; that is called DB connect.
Question 76. What Are The Sap Enhancements To Enhance Fir Data?
Answer :
HRPTDWO1 - for HR time associated facts.
Question 77. What Are The Parameters Available In User Exit For Enhancing Master Data?
Answer :
a. I_T_FIELDS - list of switch structure fields
b. I_T_DATA - internal table containing facts for the grasp attributes; recollect this carries all facts
c. LUPDMODE - update mode
d. I_CHABASNM - simple characteristics
e. I_SOURCE - name of the data supply
Question 78. Can You Add Data Records In The User Exit?
Answer :
No; user go out is most effective to append information to the document.
Question 79. How Do You Debug User Exit?
Answer :
a. Create an endless loop on a price instance x = three. Do at the same time as x> 1.
B. Start the extraction on BW
c. Now the procedure on R/three goes on countless loop
d. Look for procedure in SM5O
e. Debug the procedure
f. With in debugger change value of x to 1.
G. Now you may see and debug your code.
Question eighty. Is The User Exit Common For All Data Sources?
Answer :
Yes; this is why you ought to use case assertion to check the facts source call to code.
Question eighty one. What Are The User Exits With In The Enhancement?
Answer :
EX1T_SAPLRSAP_001 transaction information
EXIT_SAPLRSAPJ)02- master facts
EXIT_SAPLRSAP_003- text
EXIT_SAPLRSAPJ)04- hierarchy
Question eighty two. What Is The Sap Enhancement Of Data Sources?
Answer :
RSAP00001.
Question 83. What Is The Name Restriction On Field When You Append Structure?
Answer :
All new fields in the appended shape need to start with ZZ.
Question eighty four. What Are The Steps In General To Enhance Data?
Answer :
a. Append the standard information shape
b. Upload the custom fields
c. Edit the right person exit and populate the greater fields
d. Don’t forget to prompt the consumer exit
e. Create info items similar to the brand new fields
f. Mirror the datasources
g. Map the new fields to the information items
h. Activate verbal exchange structure and switch policies
i. Create data package and cargo facts
Question 85. What Are The Query Restrictions?
Answer :
a. Enable the query for OLE DB
b. Only one shape allowed for question and have to include corporation code and a time size
c. User for RFC connection must have conversation or provider kind.
D. The query is administered one time and despatched to R13 in a single packet; due to this queries with big amount of facts have to be divided and run as several queries (with exceptional selection criteria the usage of variables)
Question 86. What Are The General Restrictions?
Answer :
a. Allowed best for price based CO-PA
b. No delta capability; however runs may be cancelled
c. Retractor makes use of RSCRM_BAPI to run question
d. Actual statistics is continually updated the use of file type H and planning facts, document kind and model may be designated.
E. Use the valuation choice in case you need CO-PA valuation.
Question 87. How The Query From Bw Is Used?
Answer :
The query on BW is the source for the retraction; records is retracted after drill down the usage of all free characteristics (drill down is accomplished internally).
Question 88. Define The Steps Necessary To Set Up Co-pa For Bw?
Answer :
a. CO-PA datasource must be described at Operating Concern I Client Level
b. Define statistics supply for complete updates (summarization degree, phase degree and line item)
c. Select SBIW transaction to get into CO-PA setup
d. Select the traits
e. Select the cost fields
f. Generate the statistics source.
Question 89. Give Me An Example Of Co-pa Fields At The Operating Concern That Are Not Replicated?
Answer :
Not all of the fields are replicated; some fields are converted into BW fields; the week ALTPERIO is converted into OCALWEEK.
Question 90. What Is The Standard Naming Convention Of The Co-pa Data Source?
Answer :
CO_PA_<SYS>_<CLIENT>_<OPC0N> - in which sys — gadget ID, client - customer quantity and opcon — operating concern call.
Question 91. What Is The Safety Delta For Co-pa?
Answer :
BW updates statistics most effective at the least half-hour antique.
Question 92. What Are Value Fields?
Answer :
Key figures like amount offered, prices, etc are known as price fields.
Question 93. What Is The Maximum Number Of Customer Defined Characteristics Allowed?
Answer :
50.
Question ninety four. What Is "predefined Characteristics"?
Answer :
Some characteristics like organisation code, fabric and customer are predefined.
Question 95. What Is A Profitability Segment?
Answer :
This is described as a combination of characteristics values and it's far constant example Over the counter drugs, National chains.
Question ninety six. What Are Characteristics Values?
Answer :
These are the values within the traits; as an instance if you take purchaser businesses it can be country wide chains, stores, and many others.
Question 97. What Is A Characteristic In Co-pa?
Answer :
These are defined as tiers wherein statistics is maintained; example patron businesses, divisions, and so on.
Question ninety eight. What Is A Operating Concern?
Answer :
This is a organizational shape which agencies controlling regions.
Question ninety nine. What Is A Controlling Area?
Answer :
This is to group groups.
Question a hundred. Why Co-pa Is A Generic Extraction And Not A Business Content Extraction?
Answer :
CO-PA is exceedingly customizable and cost fields and characteristics are defined otherwise between clients, SAP has given CO-PA as a familiar extraction which can be customized.
Question 101. Give Some Examples Of Old Us And New Equivalent Lo?
Answer :
a. S260 Sales order and S264 Request => VA header, Item and Unit
b. S261 Delivery => VC Header, Item and Unit
c. S262 Billing => VD Header and VD object.
Question 102. How Do You Improve The Performance When Creating Setup Table?
Answer :
You create a couple of batch jobs with different choice criteria; as an example whilst you do setup desk for SD, use unique record number degrees and do the setup in parallel.
Question 103. What Are The New Update Methods Since P12002?
Answer :
a. Direct delta — records is transferred to BW delta queue for every report posting; useful for low quantity customers.
B. Queued delta — extraction data is accrued for the affected application instead of being accumulated in an extraction queue; serialization is ensured; for large extent clients .
C. Non serialized V3 update — the facts inside the updating run are read with out regard to the sequence from update tables.
Question 104. What Is The Issues With V3 Updates Prior To P12002?
Answer :
a. Issues with posting more than one updates within a 2d.
B. Issues with a couple of language in serialized V3 replace.
Question a hundred and five. Give Examples Of Old And New (lis To Lo)?
Answer :
a. S263 order shipping LIS is transformed to object and scheduling strains LO records assets (MCi 1V_O1TM and MC1 1V_OSCL).
B. S262 billing is converted to VD header and VD object (MC13VDOHDR and MC 1 3VDOITM).
Question 106. What Is The Use Of Setup Table?
Answer :
Set up desk is used in particular to do Full update or mit of Delta.
Question 107. What Is Extraction Setup?
Answer :
This is for mit of delta much like refreshing the LIS statistical facts; whilst you do that the statistics tables like VBAK are crammed into applicable verbal exchange shape; this data is saved in cluster tables <extraction Structure>_Setup from in which they're examine while mit of delta is performed on BW.
Question 108. What Are The Lo Extraction Transaction?
Answer :
a. LBWE — Customizing cockpit,
b. LBWF - BW log
c. LBWG — Delete setup tables
d. OLI*BW — Initialization/Setup
Question 109. What Is The Format Of Lo Data Sources?
Answer :
2LIS_nn_xxxxx in which nn is the number and xxxx is the supply of data; example
2LIS_12_VAHDR for income record header.
Question one hundred ten. Which Transaction On R13 Shows The Transactions With Pending Processes For Update?
Answer :
SM 13.
Question 111. What Are The Advantages Of New Lo Extraction?
Answer :
a. Improved performance and reduced quantity
b. No US capability meaning you don’t need to setup US on R/three
c. Single answer for all logistics packages
d. No 2 desk use like in LIS
e. Particular extraction
f. Simplest information which might be changed from BW attitude are delivered inside the delta queue
g. Up to date with batch manner (V3 update)
Question 112. Where The Data Is Extracted During Mit Of Delta And During Delta Updates?
Answer :
During ut of delta, the statistics is extracted from the S tables at once; the delta update packages whilst activated, begin collecting delta data and populates into one of the SB1W tables (1 or 2); for the duration of delta update on BW both such a tables is examine and information is extracted.
Question 113. Give The Step By Step Approach To Set Up Lis?
Answer :
a. Run transaction RMCSB1WC
b. Set up the US surroundings
c. Generate the records supply; on this pick the fields for selections and mark fields as hidden and cancellation fields.
D. Generate the replace application for Delta
e. Replicate the statistics supply, assign info supply, maintain communication structure and transfer regulations, create data bundle.
F. Do the mit of delta on BW facet
g. Activate the Delta
h. Start loading the delta information programs on BW.
Question 114. How Does It Do Delta?
Answer :
Delta is extracted from one of the BIW tables described earlier than.
Question one hundred fifteen. What Happens When You Do A Mit Of Delta For Lis Data Source?
Answer :
The whole information from the S desk example S301 is written to the data company;
Question 116. What Is The Naming Convention Of Lis Data Source?
Answer :
2_US_01_Sxxx wherein xxx is america table name.
Question 117. What Is Lis?
Answer :
Logistics Information System; used in R13 for reporting in order that reporting packages will now not gradual down online transactions.
Question 118. What Is The Transaction For Lis?
Answer :
RMCSBIWC.
Question 119. What Are The Steps To Enable Delta Load For Generic Data Sources?
Answer :
a. In the create data source display, click on on the well-known delta button
b. Type the delta specific discipline; pick whether this is time stamp, calendar day or numeric pointer.
C. Specify protection c language
d. Select delta kind — New reputation for changed statistics -> this is after image which may be used with ODS; Additive Delta — aggregated records
e. Generate the data supply
f. Now you will see the delta flag being enabled
Question a hundred and twenty. What Are The Steps To Create A Generic Data Source?
Answer :
a. Execute transaction RSO2
b. Pick the statistics source name and description
c. Pick out a desk, view or a sap question/information set for the supply for records
d. Flag the fields for selection
e. Flag the fields to be hidden
f. Spark off the information source
g. Mirror, assign info supply, define conversation structure and switch guidelines; create data package and cargo records.
Question 121. What Are The Steps Within Sbiw To Create Classes For Bw?
Answer :
a. Select the facts supply for assigning instructions; example choose OMATERIAL_A1TR .
B. Choose the class.
C. Generate the records source; a prefix 1CL is introduced to the statistics sources generated.
Question 122. Which Transaction Do You Use To Do Classification On Rj3 For Bw?
Answer :
SBIW and select hold facts supply for category data.
Question 123. What Is A Class?
Answer :
To organization gadgets together; improves in searching, and so on.
Question 124. What Are The Steps To Create Classes?
Answer :
a. Outline the homes
b. Create class types; this controls the instructions assigned to them; for example class kind may be material
c. Create training and assign to a category kind; as an instance magnificence might be digital cameras
d. Assign items
e. Now searches may be achieved on lessons; as an instance get all of the cameras with three.Zero mega pixels.
F. These values are transferred to BW as Omaterial attributes
Question one hundred twenty five. What Is Early Delta Initialization?
Answer :
This is the system in that you run the mit of delta and load the delta queue in parallel; the LO extraction supports this; you operate this selection within the data package deal screen.
Question 126. How Will You Configure Bw To Load Data From Data Stage?
Answer :
a. Create the RFC connection (SM59) and take a look at it with datastage machine
b. Define the activity in statistics level
c. Create a supply device (type third celebration)
d. Load switch structure from BW
e. Map columns to BW shape
f. Define and load data package.
Question 127. Where Will You Get More Information On The Delta Methods?
Answer :
From table RODELTAM.
Question 128. How Will You Get More Details On Data Source And Delta Modes?
Answer :
Use desk ROOSOURCE; the delta column indicates the delta method (A — ALE, E- Extractor, and so on); the value AIM describes type of delta like Fl for characteristic module, V — view, Q — infoset query.
Question 129. What Are The Delta Modes Available?
Answer :
a. “F’ — Flat file gives delta.
B. “A” — uses ALE.
C. “D” — Application determines the delta queue; instance LO.
D. “E” — Extractor determines delta; example CO-PA, LIS.
Question one hundred thirty. How Do You Send Xml Data To Bw?
Answer :
a. Install XML 3.Zero parser
b. Create an information supply
c. Assign PC file as data source
d. Create switch and communique structure and prompt
e. From transfer shape display screen choose Extras -> Create BW datasource with SOAP application
f. After successful technology, the facts supply is attached to myself datamart; the name of the information source is 6A*
g. Create an info package
h. Load data from xml file
Question 131. When You Fill In The Values For Selection, What Are The Options Available In General?
Answer :
a. Guide input.
B. Fill up from OLAP variables — use variables created in Bex .
C. ABAP recurring.
Question 132. What Is The Source For Har Extractor From R/three?
Answer :
BSID — Open invoices and BSAD — Cleared invoices.
Question 133. What Is The Source For Flap Extractor?
Answer :
BSIK — Open invoices and BSAK — cleared invoices.
Question 134. What Is The Transaction To Check Delta?
Answer :
RSA7.
Question 135. What Is Delta Update?
Answer :
Instead of updating whole facts, SAP makes use of a exchange log (for commercial enterprise content material extractor and Time stamp (CO-PA) to do delta replace.
Question 136. What Are The Delta Options Available When You Load From Flat File (you Set The Delta Mode In The Transfer Structure -update Mode Field)?
Answer :
a. New reputation only; this sends records of changed data; simplest ODS and dice can not be used.
B. Additive delta — just alternate in key figures is despatched; can be utilized in ODS and in cube.
Question 137. What Is A Repair Request?
Answer :
Assume which you have executed mit of delta and deltas for an ODS; you discover that there's a problem with sure loaded data and also you would love to do a complete load without destroying the delta imts; you first do a selective deletion of the facts from ODS and time table a complete load with this feature and make it repair request (Scheduler -> Repair full request).
Question 138. What Are The Update Modes Available?
Answer :
Full, imt of delta and delta.
Question 139. Define The Record Modes For Delta (assume For Example The Sales Qty Changed From 20 To 10)?
Answer :
a. Before Image : before the record were given modified; in this situation it's miles 20.
B. After photo: after the report got modified; in this example it is 10.
C. Additive picture: in this situation only the difference; ie -10.
D. Reverse photo — used for deletion; reverse with the qty to nullify.
E. Delete photo — simplest the ODS keys are given for deletion; no longer supported for cubes.
Question one hundred forty. What Are The File Formats Supported?
Answer :
CSV, ASCII.
Question 141. What Are The Steps To Configure Third Party (bapi) Tools?
Answer :
a. Outline the RFC connection; example outline the IP deal with, and so on the usage of SM59.
B. Outline the 1/3 birthday party supply system.
C. Assign to information assets.
D. Map and outline transformation policies .
E. Create info bundle and cargo statistics.
Question 142. Give Us Sample Third Party Eth Tools Supported By Sap?
Answer :
Ascential, Informatica, Mercator, etc.
Question 143. What Are The Steps To Extract Data From Rj3?
Answer :
a. Reflect the facts sources.
B. Assign to info source.
C. Keep communique shape and switch regulations.
D. Create information package deal.
E. Load information.
Question 144. What Is The Top Transaction For Extraction?
Answer :
SBIW.
Question 145. What Is The Transaction Code For Generic Extraction Tool?
Answer :
RSO2.
Question 146. What Are The Advantages Of Bw three.X Web Server (become)?
Answer :
a. Stronger scalability, use of IGS for charts, background processing.
B. Full SAP application server with ABAP run time.
C. HTTP server and patron functionality.
D. Native help for open protocols like HTTPS, SSL, SSO, etc.
E. No proprietary merchandise (no RFC) .
F. XMIJXSLT engine and included J2EE engine .
G. MIME items are cached now.
Question 147. What Is The Web Download Scheduler?
Answer :
This is a software that allows the customers to schedule the downloading of html reports from reporting marketers.
Question 148. How Would You Debug Web Reports?
Answer :
Transaction RSRT2.
Question 149. What Does The Variable_screen Url Parameter Do?
Answer :
An X will pressure the web record to display the variables entry display screen.
Question 150. How Do You Handle Language Dependent Texts?
Answer :
Use the tag SAP_B W_TEXT and specify this system name and key.
Question 151. How Would You Change The Default Template?
Answer :
You must now not alternate OQUERY_TEMPLATE; however you must make a copy the use of software RS_TEMPLATE_MAINTAIN and make the adjustments (call this new template like ZTEMPLATE); then move transaction SPRO to outline the brand new Z template as the default web
