Interview Questions.

Question 1. What Is The T-code To See Log Of Transport Connection?

Answer :

In RSA1 -> Transport Connection you can collect the Queries and the Role and after this you could shipping them (permitting the transport in SE10, import it in STMS

RSA1
Transport connection (button on the left bar menu)
Sap transport -> Object Types (button on the left bar menu)
Find Query Elements -> Query
Find your question
Group essential item
Transport Object (vehicle icon)
Release transport (SE10 T-code)
Load shipping (STMS T-code)
Question 2. How Can You Navigate To See The Error Idocs?

Answer :

If it is great check the IDOCs in source system visit BD87->supply Ur person ID and date->execute->you may locate Red reputation Idocs pick the misguided Idoc->Rt.Click and choose Manual process.

You need to reprocess this IDOC which can be RED. For this you could take help of Any of your Team (ALE IDOC Team or Basis Team) Or Else

you may push it manually. Just seek it in bd87 display screen handiest to reprocess.

Also, attempt to find why this Idocs are caught there.

SAP BO Interview Questions
Question three. Difference Between V1, V2, V3 Jobs In Extraction?

Answer :

V1 Update: each time we create a transaction in R/three(e.G.Sales Order) then the entries get into the R/three Tables (VBAK, VBAP..) and this takes vicinity in V1 Update.

V2 Update: V2 Update begins some seconds after V1 Update and in this replace the values get into Statistical Tables, from where we do the extraction into BW.

V3 Update: Its purely for BW extraction.

Question four. What Are Statistical Update And Document Update?

Answer :

Synchronous Updating (V1 Update)

The statistics update is made synchronously with the report update.

While updating, if problems that result in the termination of the information update occur, the authentic files are NOT stored. The purpose of the termination must be investigated and the problem solved.

Subsequently, the documents may be entered once more. Radio button: V2 updating

SAP BO Tutorial
Question 5. How Can You Decide The Query Performance Is Slow Or Fast?

Answer :

You can take a look at that in RSRT tcode.

Execute the question in RSRT and after that follow the under steps

Go to SE16 and in the ensuing screen deliver table call as RSDDSTAT for BW 3.X and RSDDSTAT-DM for BI 7.Zero and press enter you may view all of the information about the question like time taken to execute the question and the timestamps

SAP ABAP Interview Questions
Question 6. What Is Statistical Setup And What Is The Need And Why?

Answer :

Follow these steps to filling the installation table.

Go to transaction code RSA3 and notice if any information is available associated with your DataSource. If records is there in RSA3 then go to transaction code LBWG (Delete Setup facts) and delete the facts via getting into the application name.
Go to transaction SBIW --> Settings for Application Specific Datasource --> Logistics --> Managing extract structures --> Initialization --> Filling the Setup table --> Application precise setup of statistical records --> carry out setup (applicable software)
In OLI*** (for instance OLI7BW for Statistical setup for old files: Orders) deliver the name of the run and execute. Now all of the available statistics from R/3 could be loaded to setup tables.
Go to transaction RSA3 and test the data.
Go to transaction LBWE and make sure the update mode for the corresponding DataSource is serialized V3 update.
Go to BW gadget and create infopackage and below the replace tab pick out the initialize delta manner. And schedule the package. Now all the records to be had within the setup tables at the moment are loaded into the records goal.
Now for the delta facts go to LBWE in R/3 and exchange the replace mode for the corresponding DataSource to Direct/Queue delta. By doing this report will skip SM13 and directly visit RSA7. Go to transaction code RSA7 there you may see green light # Once the brand new information are delivered without delay you can see the file in RSA7.
Go to BW machine and create a new infopackage for delta masses. Double click on on new infopackage. Under replace tab you may see the delta update radio button..
Now you can go to your information target and spot the delta report.
Question 7. Why We Have Construct Setup Tables?

Answer :

The R/three database shape for accounting is tons extra less complicated than the Logistical shape.

Once you put up in a ledger this is finished. You can correct, however that supply just another posting.

BI can get information direct out of this (quite) simple database structure.

In LO, you can have an order with more than one deliveries to more than one transport addresses. And the payer also can be special.

When 1 object (order line) changes, this will have its reflection on order, deliver, transport, bill, and so forth.

Therefore a unique file structure is constructed for Logistical reports. And this structure now is used for BI.

In order to have this special structure filled with your beginning function, you need to run a fixed-up. From that moment on R/3 will hold filling this LO-database.

If you would not run the setup. BI would begin with facts from the instant you begin the filling of LO (with the logistical cockpit)

SAP ABAP Tutorial SAP BW Interview Questions
Question eight. How Can You Eliminate The Duplicate Records In Td, Md?

Answer :

Try to test the machine logs via SM21 for the equal.

Question 9. What Use Marker In Mm?

Answer :

Marker update is just like take a look at factor.

Ie it'll supply the photo of the inventory on a particular date ie whilst changed into the marker up to date.

Because we are the usage of Non cumulative key parent it'll lot of time to calculate the modern-day stock for instance at record time. To overcome this we use marker update

Marker updates do now not summarize the records.. In inventory management eventualities, we have to calculate beginning stock and final stock on a every day basis. In order to facilitate this, we set a marker if you want to add and subtract the values for each report.

In the absence of marker replace, the data may be delivered up and will now not offer the appropriate values.

SAP BPC Interview Questions
Question 10. Tell Me Web Template?

Answer :

You get records on where the net template info are saved from the subsequent tables :

RSZWOBJ Storage of the Web Objects

RSZWOBJTXT Texts for Templates/Items/ Views

RSZWOBJXREF Structure of the BW Objects in a Template

RSZWTEMPLATE Header Table for BW HTML Templates

You can check these tables and look for your net template access . However, If I apprehend your query efficaciously, you will have to open the template within the WAD after which make the corrections in the identical to accurate it.

SAP BW Tutorial
Question 11. About Dtp ?

Answer :

Data Transfer Process:

Data switch method (DTP) masses facts inside BI from one object to any other object with appreciate to modifications and filters. In short, DTP determines how information is transferred between two continual objects.

It is used to load the facts from PSA to data target (dice or ods or infoobject) consequently, it changed the records mart interface and the Info Package.

SAP BODS Interview Questions
Question 12. What Is Difference Between Psa And Idoc?

Answer :

BI7 is PSA used best for Data load from Source System into BW

SAP BO Interview Questions
Question 13. What We Do In Business Blue Print Stage?

Answer :

SAP has defined a enterprise blueprint section to assist extract pertinent information about your agency that is vital for implementation. These blueprints are within the form of questionnaires that are designed to explore for statistics that uncovers how your employer does commercial enterprise. As such, they also serve to report the implementation. Each business blueprint report essentially outlines your destiny business approaches and commercial enterprise necessities.

SAP BPC Tutorial
Question 14. How Do We Decide What Cubes Have To Be Created?

Answer :

Its depends in your challenge requirement. Customized cubes are not mandatory for all the initiatives. If your business requirement is differs from given state of affairs (BI content material cubes) then most effective we will choose custom designed cubes. Normally your BW customization or creation of new information vendors all are depending on your source gadget. If your supply system other that R3 then you definitely must go with customization of your all objects. If your source gadget is R3 and your customers are using only R3 popular business situations like SD, MM or FI... Etc., you then don’t need to create any info vendors otherwise you don’t want to beautify anything in the existing BW Business Content. But 99% this is not feasible. Because truly they should have blanketed their new enterprise situation or new enhancements. 

Question 15. Give Me One Example Of A Functional Specification And Explain What Information We Will Get From That?

Answer :

Functional Specs are necessities of the commercial enterprise user.Technical Specs translate these requirements in a technical style.Let's say Functional Spec says,

the consumer have to be able to input the Key date, Fiscal Year, Fiscal Version.
The Company variable need to be defaulted to USA however then if the person desires to trade it, they can test the drop down list and select other international locations.
The calculations or formulation for the document will be displayed in precision of 1 decimal factor.
The record ought to go back values for one year of information relying at the monetary year that the user enters Or it must show in quarterly values. Functional specs also are called as Software requirements.
Now from this Technical Spec follows, to resolve each of the road gadgets indexed above.

To give the option of key date, Fiscal yr and Fiscal Version – positive Info Objects must be to be had inside the gadget. If available, then ought to we create any variables for them - so that they're used as user access variable. To create any variables, what's the method, in which do you do it, what's the technical of the items you may use, what'll be the technical call of the gadgets you will Crete due to this report.
Same rationalization is going for the rest. How do you set up the variable,
What changes in houses will you do to get the precision.
How will you get the one year of statistics. What may be the technical and show name of the document, who'll be authorized to run this file, etc are really precise inside the technical specs.
SAP BDC Interview Questions
Question sixteen. What Is Customization? How Do We Do In Lo?

Answer :

How to do fundamental LO extraction for SAP-R3-BW

Go to transaction code RSA3 and see if any statistics is to be had related to your DataSource. If records is there in RSA3 then go to transaction code LBWG (Delete Setup facts) and delete the records by using coming into the application name.
Go to transaction SBIW --> Settings for Application Specific Datasource --> Logistics --> Managing extract systems --> Initialization --> Filling the Setup desk --> Application specific setup of statistical records --> perform setup (applicable software)
In OLI*** (for example OLI7BW for Statistical setup for old files : Orders) provide the call of the run and execute. Now all the to be had facts from R/3 will be loaded to setup tables.
Go to transaction RSA3 and check the facts.
Go to transaction LBWE and make sure the update mode for the corresponding DataSource is serialized V3 replace.
Go to BW system and create infopackage and beneath the update tab pick the initialize delta method. And agenda the package. Now all of the information available in the setup tables are now loaded into the statistics goal.
Now for the delta records go to LBWE in R/3 and trade the update mode for the corresponding DataSource to Direct/Queue delta. By doing this record will skip SM13 and without delay visit RSA7. Go to transaction code RSA7 there you could see inexperienced light # Once the brand new statistics are added at once you may see the record in RSA7.
SAP BODS Tutorial
Question 17. Change Attribute Run.

Answer :

Generally characteristic exchange run is used while there may be any alternate inside the master facts. It's miles used for realignment of the master information. Attribute exchange run is not anything but adjusting the grasp statistics after its been loaded sometimes in order that it is able to change or generate or regulate the Sid’s in order that u might not have any problem whilst loading the transaction records in to data targets. The element explanation approximately Attribute alternate run. The hierarchy/characteristic exchange run which activates hierarchy and characteristic changes and adjusts the corresponding aggregates is split, into 4 stages:

Finding all affected aggregates
Set up all affected aggregates again and write the bring about the new mixture table.
Activating attributes and hierarchies
Rename the brand new combination table. When renaming, it isn't always viable to execute queries.
In some databases, which can't rename the indexes, the indexes are also created on this section.

SAP BW on HANA Interview Questions
Question 18. How To Convert A Bex Query Global Structure To Local Structure (steps Involved)

Answer :

BeX query Global structure to local shape Steps; ***a nearby structure while you want to feature structure factors which are specific to the precise query. Changing the worldwide structure adjustments the shape for all the queries that use the global shape. That is reason you pass for a nearby shape.Coming to the navigation component--In the Bex Analyzer, from the SAP Business Explorer toolbar, pick the open question icon (icon that looks like a folder) On the SAP Bex Open conversation container:Choose Queries.Select the desired Info Cube Choose New.On the Define the query display screen:In the left frame, extend the Structure node.Drag and drop the preferred structure into both the Rows or Columns body.Select the worldwide structure.Right-click and pick out Remove reference.A nearby structure is created.Remember that you can not revert again the changes made to global shape in this regard. You will must delete the local shape after which drag and drop international shape into query definition.*When you try to keep a global structure, a speak container prompts you to verify modifications to all queries. This is how you discover a worldwide structure*

SAP ABAP Interview Questions
Question 19. How To Create Condition And Exceptions In Bi.7.Zero? But I Know In Bw3.Five Version?

Answer :

From a question call or description, you will not be able to decide whether the question is having any exception. There are  ways of finding exception in opposition to a query:1. Execute queries separately, the one that is having historical past coloration as exception reporting are with exceptions.2. Open queries in the BEX Query Designer. If you're finding exception tab on the right aspect of filter and rows/column tab, the question is having exception.

SAP BW on HANA Tutorial
Question 20. The Fi Business Flow Related To Bw. Case Studies Or Scenarios

Answer :

FI Flow Basically there are five main subjects/areas in FI,

GL Accounting -related tables are SKA1, SKB1 Master Database and BSAS are the Transaction Data
Account Receivables- related to Customer All the SD related records while transferred to FI those are created. Related Tables BSID and BSAD
Account Payable - associated Vendor All the MM related documents records when transferred to FI these are created Related Tables BSIK and BSAK All the above six tables statistics is present in BKPF and BSEG tables You can hyperlink these tables with the help of BELNR and GJAHR and with Dates additionally.
Special Purpose Ledger. That's rarely used.
Asset Management In CO there are Profit center Accounting Cost middle Accounting can be there.
Sap Bapi Interview Questions
Question 21. What Are Various Ways To Make Generic Extractor Delta Enabled?

Answer :

This field from the extraction shape of a DataSource meets one of the following standards:

The discipline has the subsequent kind: Time stamp. New records to be loaded into the BW the usage of a delta upload have a better access on this area than the time stamp of the remaining extraction.
The discipline has the subsequent type: Calendar day. The equal criteria applies to new statistics as within the time stamp area.
The field has some other kind. This case is most effective supported for SAP Content DataSources. In this situation, the maximum fee to be read ought to be displayed using a DataSource-unique exit while starting statistics extraction.
Question 22. What Are Various Ways To Track Delta Records?

Answer :

RSA7, LBWQ, Idocs and SMQ1.

Question 23. What Is The Purpose Of Table Usr02?

Answer :

This desk stores User IDs and passwords.

Sap Business One Interview Questions
Question 24. How Do You Create A Password Exception List?

Answer :

Place the answers in table USR40.

SAP BW Interview Questions
Question 25. What Is The Purpose Of Table Tadir?

Answer :

Table TADIR carries object listing entries.

Question 26. What Are The Transaction Codes Associated With Changing Requests, Request Headers, Or Request Object Lists?

Answer :

The following tables keep records approximately change requests.

E070 Change request headers

E071 Change request item lists

Question 27. How Can You Get A List Of The Users With Development Access On A Particular System?

Answer :

Table DEVACCESS

SAP BPC Interview Questions
Question 28. Where Can You Find A List Of Object Keys Included In A Transport?

Answer :

E071K Object keys contained inside transports

Question 29. How Can You Tell If A Transport Entry Is In The Process Of Being Imported?

Answer :

Check table TRBAT

Question 30. How Can You Find A List Of Objects That Have Been Repaired In The System?

Answer :

ADIRACCESS List of repaired gadgets and their get entry to keys

Question 31. How Do You Disable Multiple Logins In The Same Client?

Answer :

To disable more than one consumer logins within the same consumer put into effect this parameter in the instance profile:

login/disable_multi_gui_login = 1
Question 32. What Are The Advantages Of An Extended Star Schema Of Bw Vs. 'the Star Schema?

Answer :

Uses generated numeric keys and aggregates in its own tables for faster get admission to.
Uses an outside hierarchy.
Supports a couple of languages.
Contains master statistics not unusual to ;dl cubcs.
Supports slowly changing dimensions.
Question 33. How Maliy Tliniensio~is Are There Ill A Cube?

Answer :

There are a complete of 16 dimensions in a culx. Of these sixteen, 3 are predefined via SAP and thcsc arc timc, unit and request. This leaves the customer uri th 1 3 dimensions.

SAP BODS Interview Questions
Question 34. What Is The Transaction For The Administrator Work Bench?

Answer :

Transaction RSA1

Question 35. Wliat Is Tlie "myself Data Mart"?

Answer :

A BW gadget feeding data to itself is known as the myself data mart. It is created mechanically and ilscs ALE for facts switch.

Question 36. What Is A Calculated Key Figure?

Answer :

A calculated key discern is used to do complex calculations on key figures along with mathematical features, percent features and total functions. For example, you may have a calculated key discern to calculates ales tax primarily based on your sale fee.

SAP BDC Interview Questions
Question 37. What Is The Enlia~icement User Exit For Best Reporting?

Answer :

RSR00001

Question 38. What Is A Condition?

Answer :

If yo11 need to filter on key figures or do a ranked evaluation you then use a situation. For instance, you can use a circumstance to report on the pinnacle 10 customers, or clients with more than one million greenbacks in annual sales.

Question 39. What Are The Data Types Supported By Characteristics?

Answer :

NUMC              Numeric
CHAR (up to 60)   IJp to 60 characters
DATS              Date
TIMS              Time
 

Question 40. What Are The Types Of Attributes?

Answer :

Display handiest - These attributes are most effective for show and no evaluation can be done.

Navigational attributes - These attributes behave like normal characteristics.

For example, anticipate that we've customer characteristics with u . S . As a navigational attribute, you'll then have the ability to research the records using purchaser and united states. In the BEx question you may create filters or variables for country and you can also use the drill down feature.

SAP BW on HANA Interview Questions
Question forty one. What Is Meant By Compounding?

Answer :

Compounding defines the superior information item, which have to be mixed to outline an item. For example, while you define a price middle, the controlling place is the compounding (superior) item.

Question forty two. What Are Title 10 Decision Points Of Data Warehousing?

Answer :

Identify a reality desk.
Identify the measurement tables.
Define the attributes of the entities.
Define the granularity of the reality table (how detailed do you want the statistics to be).
Define pre-calculated key figures.
Identify slowly converting dimensions.
Identify aggregates.
How long will the statistics be saved.
How frequently is the information extracted.
From which system is the records to be extracted.
Sap Bapi Interview Questions
Question forty three. What Options Are Available In The Transfer Rule?

Answer :

Assign an Infoobject - direct transfer, no transformation
Assign a steady eg. If you are loading facts from a special us of a from a flat report, you could make the usa (17s) as a constant and assign the fee explicitly
ABAP ordinary eg. If you want to do some complex string manipulation, count on which you are getting a flat file from legacy information and the value middle is in a field and you have to "massage" the records to get it in. In this case the usage of an ABAP ordinary is most appropriate 
Formula - for easy calculations usc components eg. If you need to transform all lower casc cl~uractcrst o top case, use the TOUPPER formula. You can use formilla builder to help positioned your formulation together.
 

Question forty four. What Is Compression Or Collapse?

Answer :

This is the technique via which we delete the request IDS which ends up in area savings. All the everyday requests are saved within the F desk. When you compress, the request ID is deleted and facts is moved from the F desk to the E table. This saves area and improves overall performance however the disadvantage is that you can't delete the compressed requests in my opinion. You can, but, nonetheless use selective deletion.

If you are the usage of noncumulative key figures in a dice, the dice need to be compressed as often feasible to enhance overall performance.

Question 45. What Is An Infoset?

Answer :

An InfoSet is an info issuer giving information by way of becoming a member of records from different sources like ODs and grasp statistics. You can also do an outer be part of in an InfoSet. InfoSets also can be used to mix transactional data with master information. For example, when you have cli~anti tying the transaction facts and you've got price as an attribute of the cloth. Then you can have an InfoSet with transaction information and fabric where you may be able to do calculations based on cloth price in BEx.

Another usage is, if you have ODs you may disable BEx reporting (inside the putting) and use the ODs in the InfoSet for reporting, which ends up in progressed overall performance

Question forty six. What Are Lion Cumulative Key Figures?

Answer :

These are key figures that aren't summarized (in contrast to income, etc.). Examples are head remember and inventory amount. They are always shown in relation to a point in time. For example, we are able to ask how many employees we had as of ultimate quarter. We do not add up the pinnacle rely.

Question forty seven. What Perfornialice Improvement Call We Do For Reporting?

Answer :

Aggregates
OLAP cache
Pre-calculated net templates
Use small amount or result statistics as place to begin of any queries and do the drill down.
Avoid reporting on ODs and use InfoSet containing ODs for reporting.
If you use exclusion in reporting (< >), the indices aren't used. So avoid the use of the exclusion however use inclusion.
Use the study mode "H" examine whilst navigating and expanding hierarchies".
Use compression on Infocubes for the reason that E desk is optimized for queries.
Create additional indexes.
Run DB data frequently.
Use secondary indexes on ODS active table.
Use RSRT transaction to examine the "Explain Plan" announcement.
If you are strolling a question on an data provider with non cumulative key determine then suppress precis line gadgets (totals)
Question forty eight. What Are The Best Options For Characteristics Like F4 Help For Query Definition And Execution?

Answer :

This defines how the facts is displayed in the query definition screen or while the question is completed. Options are from the statistics displayed, from master information table (all facts) and from measurement statistics. For example let us expect which you have a hundred merchandise in general for your cloth master, 10 products to be had in a cube and in BEx you display a query for two products; the subsequent options for the product will display one of a kind records:

Selective facts only will show 2 products
Dimension information will display 10 merchandise
From grasp statistics will display all a hundred products
Question 49. What Is The Difference Between Amount /quantity Number Type Key Figures?

Answer :

Amount /quantity is continually mixed with devices. For instance, sales can be related to forex and inventory could be connected to amount in gadgets. In your design in case you don't want units then you ought to use number or integer to enhance overall performance.

Question 50. Will Coding The Abap Transfer Rule, What Are The Important Variables You Make Use Of?

Answer :

RESULT                  This receives the end result of the ABAP code.
RETURN CODE        You set this to zero if the whole thing is OK; else this file is skipped.
 ABORT                   Set this to a cost no longer zero, to abort the centric bundle.
Question fifty one. What Is The Use Of Time Distribution Option In The Update Rule?

Answer :

This choice is used to distribute records in keeping with time. For example, if the source contains calendar week and the goal incorporates calendar day, time information is break up for every calendar day. Here you could select both the normal calendar or the manufacturing unit calendar.

Question 52. What Is A "marker" In Non Cumulative Cubes?

Answer :

Non cumulatives are saved the usage of a "Marker" for the modern duration. A marker is not anything however pointer relating to a time period. For example an inventory dice marker can also refer to the inventory ranges as of the day gone by.

Question 53. What Is The Use Of A Colon ':' As An Authorization Value?

Answer :

It enables queries that don't incorporate an authorization relevant object that have been checked into the Infocube.
It lets in precis data to be displayed if the user does no longer have get right of entry to to distinct information. For example, in case you create 2 authorizations for one user: one with Sales Org * and clients : and 2nd with income org one thousand and clients *, the person sees all clients for sales org 1000 and simplest summarized record for different income org.
Question 54. What Are Start Routines, Transfer Routines And Update Routines?

Answer :

Start Routines: The begin recurring is administered for each DataPackage after the records has been written to the PSA and before the switch guidelines had been executed. It lets in complex computations for a key discern or a feature. It has no go back price. Its motive is to execute initial calculations and to store them in worldwide DataStructures. This structure or desk may be accessed in the different workouts. The whole DataPackage within the switch structure format is used as a parameter for the ordinary.

Transfer / Update Routines: They are defined on the InfoObject level. It is just like the Start Routine. It is unbiased of the DataSource. We can use this to define Global Data and Global Checks.

Question fifty five. What Is The Difference Between Start Routine And Update Routine, When, How And Why Are They Called?

Answer :

Start routine may be used to get admission to InfoPackage even as update exercises are used while updating the Data Targets.

Question fifty six. What Is The Table That Is Used In Start Routines?

Answer :

Always the table shape will be the shape of an ODS or InfoCube.

For example if it's miles an ODS then energetic desk structure could be the desk.

Question 57. Explain How You Used Start Routines In Your Project?

Answer :

Start routines are used for mass processing of records. In begin recurring all of the information of Data Package is to be had for processing. So we can method some of these statistics collectively in begin ordinary. In considered one of situation, we desired to apply size % to the forecast information. For example if cloth M1 is forecasted to mention 100 in May. Then after making use of size %(Small 20%, Medium 40%, Large 20%, Extra Large 20%), we desired to have 4 information in opposition to one single document this is coming within the info package. This is executed in begin routine.

Question fifty eight. What Are Return Tables?

Answer :

When we need to return a couple of data, as opposed to unmarried fee, we use the go back table within the Update Routine. Example: If we've got general phone cost for a Cost Center, the use of a go back table we are able to get rate according to employee.

Question fifty nine. How Do Start Routine And Return Table Synchronize With Each Other?

Answer :

Return desk is used to return the Value following the execution of start routine

Question 60. What Is Compression?

Answer :

It is a process used to delete the Request IDs and this saves space.

Question sixty one. What Is Rollup?

Answer :

This is used to load new Data Packages (requests) into the InfoCube aggregates. If we've not performed a rollup then the new InfoCube records will now not be available whilst reporting at the combination.

Question 62. What Is Table Partitioning And What Are The Benefits Of Partitioning In An Infocube?

Answer :

It is the approach of dividing a table which might permit a brief reference. SAP makes use of reality file partitioning to enhance performance. We can partition simplest at 0CALMONTH or 0FISCPER. Table partitioning helps to run the file faster as records is saved in the relevant partitions. Also table renovation turns into easier. Oracle, Informix, IBM DB2/390 helps table partitioning at the same time as SAP DB, Microsoft SQL Server, IBM DB2/400 do no longer support table portioning.

Question sixty three. How Many Extra Partitions Are Created And Why?

Answer :

Two partitions are created for date before the begin date and after the stop date.

Question 64. What Are The Options Available In Transfer Rule?

Answer :

InfoObject
Constant
Routine
Formula
Question 65. How Would You Optimize The Dimensions?

Answer :

We ought to outline as many dimensions as viable and we must take care that no unmarried dimensional crosses more than 20% of the truth desk size.

Question 66. What Are Conversion Routines For Units And Currencies In The Update Rule?

Answer :

Using this selection we will write ABAP code for Units / Currencies conversion. If we permit this flag then unit of Key Figure appears within the ABAP code as an additional parameter. For example, we will convert gadgets in Pounds to Kilos.

Question sixty seven. Can An Infoobject Be An Infoprovider, How And Why?

Answer :

Yes, whilst we want to report on Characteristics or Master Data. We must right click on on the InfoArea and select “Insert characteristic as facts target”. For example, we are able to make 0CUSTOMER as an InfoProvider and document on it.

Question sixty eight. What Is Open Hub Service?

Answer :

The Open Hub Service allows us to distribute records from an SAP BW machine into external Data Marts, analytical packages, and other packages. We can ensure controlled distribution the use of several systems. The significant item for exporting information is the InfoSpoke. We can outline the source and the goal item for the statistics. BW becomes a hub of an organization facts warehouse. The distribution of records becomes clear thru imperative tracking from the distribution fame in the BW machine.

Question sixty nine. How Do You Transform Open Hub Data?

Answer :

Using BADI we will rework Open Hub Data in line with the destination requirement.

Question 70. What Is Ods?

Answer :

Operational DataSource is used for distinct garage of records. We can overwrite records within the ODS. The information is stored in obvious tables.

Question seventy one. What Are Bw Statistics And What Is Its Use?

Answer :

They are institution of Business Content InfoCubes which are used to degree performance for Query and Load Monitoring. It additionally indicates the use of aggregates, OLAP and Warehouse management.

Question 72. What Are The Steps To Extract Data From R/3?

Answer :

Replicate DataSources
Assign InfoSources
Maintain Communication Structure and Transfer policies
Create and InfoPackage
Load Data
Question 73. What Are The Delta Options Available When You Load From Flat File?

Answer :

The three alternatives for Delta Management with Flat Files:

Full Upload
New Status for Changed information (ODS Object most effective)
Additive Delta (ODS Object & InfoCube)
Question seventy four. What Are The Inputs For An Infoset?

Answer :

The inputs for an InfoSet are ODS objects and InfoObjects (with grasp information or text).

Question 75. What Internally Happens When Bw Objects Like Infoobject, Infocube Or Ods Are Created And Activated?

Answer :

When an InfoObject, InfoCube or ODS object is created, BW keeps a saved model of that object but does now not make it to be had to be used. Once the item is activated, BW creates an lively model that is available to be used.

Question seventy six. What Is The Maximum Number Of Key Fields That You Can Have In An Ods Object?

Answer :

16

Question seventy seven. What Is The Importance Of 0requid?

Answer :

It is the InfoObject for Request ID. OREQUID permits BW to distinguish between distinctive records information.

Question 78. Can You Add Programs In The Scheduler?

Answer :

Yes. Through occasion handling.

Question seventy nine. What Does A Data Idoc Contain?

Answer :

Data IDoc incorporates:

Control Record à Contains administrator facts along with receiver, sender and patron.
Data document
Status Record à Describes repute of the record e.G., modified.
Question eighty. What Is The Importance Of The Table Roidocprms?

Answer :

It is an IDOC parameter source gadget. This desk contains the details of the records switch like the supply system of the facts, statistics packet size, maximum variety of lines in a data packet, etc. The facts packet size can be modified via the manage parameters alternative on SBIW i.E., the contents of this desk may be changed.

Question eighty one. When Is Idoc Data Transfer Used?

Answer :

IDOCs are used for communication among logical systems like SAP R/three, R/2 and non-SAP systems the usage of ALE and for verbal exchange among an SAP R/3 machine and a non-SAP gadget. In BW, an IDOC is a data box for statistics exchange among SAP structures or among SAP structures and outside systems based on an EDI interface. IDOCs guide limited file size of one thousand bytes. So IDOCs aren't used while loading data into PSA seeing that records there's greater targeted. It is used while the report length is lesser than a thousand bytes.

Question 82. When An Ods Is In 'overwrite' Mode, Does Uploading The Same Data Again And Again Create New Entries In The Change Log Each Time Data Is Uploaded?

Answer :

No.

Question 83. What Is The Function Of 'selective Deletion' Tab In The Manage Contents Of An Infocube?

Answer :

It permits us to choose a specific cost of a particular area and delete its contents.

Question 84. When We Collapse An Infocube, Is The Consolidated Data Stored In The Same Infocube Or Is It Stored In The New Infocube?

Answer :

When the cube is collapsed the statistics is stored inside the identical cube, statistics is stored in F desk before the compress and in E table after the compression. These two tables are for the identical dice.

Question eighty five. What Happens When You Load Transaction Data Without Loading Master Data?

Answer :

The transaction facts receives loaded and the master statistics fields remain blank.

Question 86. When Given A Choice Between Using An Infocube And A Multiprovider, What Factors To Consider Before Making A Decision?

Answer :

One could have to see if the InfoCubes are used in my view. If those InfoCubes are often used in my opinion, then it's far higher to head for a MultiProvider with many InfoCubes because the reporting might be quicker for an person InfoCube query in preference to for a massive InfoCube with lot of facts.

Question 87. How Many Hierarchy Levels Can Be Created For A Characteristic Infoobject?

Answer :

Maximum of ninety eight degrees.

Question 88. What Is The Function Of 'reconstruction' Tab In An Infocube?

Answer :

It reconstructs the deleted requests from the InfoCube. If a request has been deleted and we want the information facts of that request to be introduced to the InfoCube, we can use the reconstruction tab to feature the ones information. It goes to the PSA and brings the records to the InfoCube.

Question 89. What Are Secondary Indexes With Respect To Infocubes?

Answer :

It is an Index created further to the primary index of the InfoCube. When you prompt a desk inside the ABAP Dictionary, an index is created at the primary key fields of the desk. Further indexes created for the table are known as secondary indexes.

Question 90. What Is Db Connect And Where Is It Used?

Answer :

DB join is a database connecting application. It is used in connecting 0.33 birthday party gear with BW for reporting reason.

Question ninety one. What Is The Common Method Of Finding The Tables Used In Any R/3 Extraction?

Answer :

By using the transaction LIST SCHEMA we are able to navigate the tables.

Question 92. What Is The Difference Between Table View And Infoset Query?

Answer :

An InfoSet Query is a query the use of flat tables while a view desk is a view of one or extra current tables. Parts of these tables are hidden, and others continue to be visible.

Question ninety three. How To Load Data From One Infocube To Another Infocube?

Answer :

Through DataMarts data can be loaded from one InfoCube to some other InfoCube.

Question ninety four. What Is The Difference Between Extract Structure And Datasource?

Answer :

DataSource defines the facts from different source system, in which an extract structure contains the replicated facts of DataSource and wherein we outline extract rules and transfer regulations

Extract Structure is a file format of InfoObjects.
Extract Structure is created on SAP BW machine.
Question ninety five. What Is Entity Relationship Model In Data Modeling?

Answer :

An ERD (Entity Relation Diagram) may be used to generate a bodily database.

It is a excessive stage facts model.

It is a schematic that suggests all of the entities inside the scope of integration and the direct relationship between the entities.

Question 96. What Is Datamining Concept?

Answer :

Process of locating hidden patterns and relationships in the facts.

With traditional information analysis requirements fulfilled via information warehouses, business customers have an concept of what records they need to look.

Some possibilities embody statistics discovery necessities, in which the business user wants to correlate sets of statistics to decide anomalies or patterns in the records.

Question 97. How Does The Time Dependent Work For Bw Objects?

Answer :

Time Dependent attributes have values which are valid for a particular variety of dates (i.E., legitimate period).

Question ninety eight. What Is I_isource?

Answer :Name of the InfoSource

Question 99. What Is I_t_fields?

Answer :

List of the switch structure fields. Only these fields are sincerely filled in the information desk and can be sensibly addressed in the program.

Question a hundred. What Is C_t_data?

Answer :

Table with the data obtained from the API inside the format of supply structure entered in table ROIS (subject ROIS-STRUCTURE).

Question 101. What Is I_updmode?

Answer :

Transfer mode as requested within the Scheduler of the BW. Not usually required.

Question 102. What Is I_t_select?

Answer :

Table with the selection standards saved in the Scheduler of the SAP BW. This is not usually required.

Question 103. What Are The Different Update Modes?

Answer :

Direct Delta: In this method, extraction information from document postings is transferred directly to BW delta queue.

Queued Delta: In this technique, extraction records from record postings is gathered in an extraction queue, from which a periodic collective run is used to transfer the statistics to BW delta queue. O The switch collection and the order in which the data become created are the equal in each Direct and Queued Delta.

Unserialized V3 Update: In this approach, the extraction records is written to the update tables after which is transferred to the BW delta queues with out taking the collection under consideration.

Question 104. What Are The Different Ways Data Transfer?

Answer :

Full Update: All the data from the InfoStructure is transferred in line with the selection criteria defined inside the scheduler in the SAP BW.

Delta Update: Only the records that has been modified or is new because the closing replace is transferred.

Question one hundred and five. Which Object Connects Aggregates And Infocube?

Answer :

ReadPointer connects Aggregates and InfoCube. We can view the ReadPointer in desk RSDDAGGRDIR, the sector name is RN_SID, on every occasion we are rolling up the facts, it consists of the request range, it'll test with the subsequent request for second roll up. Just follow the desk for a specific InfoCube and roll up the information.

Question 106. What Is Switching On And Off Of Aggregates? How Do We Do That?

Answer :

When we switch off an combination, it isn't available to supply facts to queries, however the data remains in the mixture, so if required, we will turn it on and update the information, in preference to re-aggregating all of the facts. However if we deactivate an combination, it isn't to be had for reporting and additionally we lose the aggregated facts. So while you set off it, it begins the aggregation anew. To try this pick the relevant aggregate and pick out the Switch On/Off (pink and inexperienced button). An combination this is switched off is marked in column Filled/Switched off with Grey Button.

Question 107. While Creating Aggregates System Gives Manual Or Automatic Option. What Are These?

Answer :

If we pick out the automatic alternative, machine will suggest aggregates based on the BW statistics. I.E., how regularly the InfoCube is used to fetch facts, and so on. Else we will manually choose the dataset which should form the mixture.

Question 108. What Are The Options When Defining Aggregates?

Answer :

Manual
Automatic
Question 109. What Are Aggregates And When Are They Used?

Answer :

• An aggregate is a materialized, aggregated view of the information in an InfoCube. In an aggregate, the dataset of an InfoCube is stored redundantly and constantly in a consolidated form. Aggregates make it possible to get entry to InfoCube information quickly in Reporting. Aggregates can be used in following cases:

To speed up the execution and navigation of a selected question.
Use attributes often in queries.
To speed up reporting with feature hierarchies with the aid of aggregating precise hierarchy stages.
Question one hundred ten. When I Run Initial Load It Failed Then What Should I Do?

Answer :

Deletion of an preliminary load may be accomplished in the InfoPackage. First set the QM popularity of the request to crimson if now not but executed, then delete it from all information objectives. After that we visit the InfoPackage and pick from menu scheduler à “initialization alternatives for the supply machine”. There you should see your purple request. Mark it and delete it. Accept deletion question and receive submit facts message. Now the request need to be deleted from the initialization options. Now you can run a brand new init.

You can also run a repair request. That's a full request. With this you accurate your records within the data target because of failed deltas or wrong inits. You do that inside the InfoPackage too. Choose menu scheduler repair full request. But if you want to use the init/delta load you need to make a a hit init first.

Question 111. What Are The Inverted Fields In Data Source?

Answer :

They permit to do opposite posting. It would absolutely multiply the sphere by using -1.

Question 112. What Are Setup Tables And Why Should We Delete The Setup Tables First Before Extraction?

Answer :

Setup tables are packed with information from utility tables. They are the OLTP tables storing transaction document. They interface among the application tables and extractor. LO extractor takes statistics from Setup desk while initialization and full add. It isn't had to get entry to the application table for information selection. As setup tables are required simplest for complete and init load we are able to delete the records after loading so as to keep away from reproduction information.

Question 113. What Are The Setup Tables? Why Use Setup Tables?

Answer :

In LO Extraction Mechanism whilst we fill the setup tables the extract shape is full of the information. When we time table InfoPackage using FULL / INITI DELTA from BW, the facts is picked from the setup tables

Question 114. When Filling The Set Tables, Is There Any Need Of Delete The Setup Tables?

Answer :

Yes. By deleting the setup tables we're deleting the statistics this is within the setup tables from the previous update. This avoids updating the information two times into the BW.

Question 115. Why We Need To Delete The Setup Table First Then Filling?

Answer :

During the Setup run, those setup tables are stuffed. Normally it's a terrific exercise to delete the existing setup tables earlier than executing the setup runs which will keep away from reproduction facts for the same picks.

Question 116. With What Data The Setup Table Is Filling (is It R3 Data)?

Answer :

The init loads in BW pull facts from the Setup tables. The setup tables are most effective utilized in case of first init/complete hundreds.

Question 117. Will There Be Any Data In The Application Tables After Sending Data To Setup Tables?

Answer :

There can be information in software tables even after replenish of setup tables. Setup tables are simply temp tables that refill from application tables for putting in place Init/Full masses for BW.

Question 118. How To Work Master Data Delta?

Answer :

 We always do complete load for Master Data. It would constantly overwrite the preceding entries.

Question 119. Master Data Is Stored In Master Data Tables. Then What Is The Importance Of Dimensions?

Answer :

Dimension tables hyperlink Master Data tables with the reality table thru SID's.

Question 120. I Replicate The Data Source To Bw System. I Want To Add One More Field To Data Source. How Do I Do It?

Answer :

Add the field to extract shape and reflect the Data Source again into BW and this area will seem in BW also.

Question 121. Suppose One Million Records Are Uploaded To Infocube. Now I Want To Delete 20 Records In Infocube. How Can We Delete 20 Records?

Answer :

This you could do with selective deletion

Question 122. What Is The Infocube For Inventory?

Answer :

InfoCube: 0IC_C03

Question 123. What Is The Maintenance Of Data Source?

Answer :

It is the renovation of required fields in a specific Data Source for which there are reporting necessities in BW and records for the same wishes to be extracted.

Question 124. What Is The Maintenance Of Extract Structure

Answer :

Extract structures are maintained in case of LO Data Sources. There are multiple extract structures for every Data Source in the LO for unique applications. Any upgrades to Data Source in case of LO are achieved using renovation of extract systems.

Question a hundred twenty five. What Are Mc Ekko, Mc Ekpo In The Maintenance Of Datasource?

Answer :

These are shopping related communique systems.

Question 126. How Is The Delta Load Different For An Infocube And Ods?

Answer :