[BEST & NEW] SAP Business One Interview Questions and Answers

Last updated on 17th Nov 2021, Blog, Interview Questions

If you are preparing for SAP Business One Interview, then you are at the right place. Today, we will cover some mostly asked SAP Business One Interview Questions, which will boost your confidence. SAP Business One is a web application firewall (WAF) that protects web applications and APIs from attacks that target known and unknown exploits and helps maintain compliance with regulations. Therefore, SAP Business One professionals need to encounter interview questions on SAP Business One for different enterprise SAP Business One job roles. The following discussion offers an overview of different categories of interview questions related to SAP Business One to help aspiring enterprise SAP Business One Professionals.

1. What is ERP?

Ans:

ERP stands for Enterprise Resource Planning Software and is an integrated computer-based system used to manage a company’s resources effectively. It ensures smooth information amongst various departments in an enterprise or a company and manages workflows.

2. What are the different types of ERP?

Ans:

• SAP
• Baan
• JD Edwards (now acquired by Oracle)
• Siebel
• Peoplesoft (now acquired by Oracle)
• Microsoft Dynamics

3. What is SAP?

Ans:

SAP is the name of the company originated in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the prominent ERP (Enterprise Resource Planning) software package.

4. Tell me briefly about SAP

Ans:

SAP stands for Systems Applications and Products in Data Processing. It was founded in 1972 by Wellenreuther, Hopp, Hector, Plattner, and Tschira and is a German Company.

SAP is the name of the company, as well as its ERP product.

SAP is #1 in the ERP market. As of 2010, SAP has more than 140,000 installations worldwide, over 25 industry-specific business solutions, and more than 75,000 customers in 120 countries.

5. What are the different SAP products?

Ans:

SAP R/3 – It succeeds SAP R/2 and is a market leader in ERP. R/3 stands for three-tier architecture, i.e., Presentation, Logic, and Data tier. It has many modules like SD, FI, HR, etc. which encompass almost all enterprise departments.

mySAP – It is a suite of SAP products which apart from SAP R/3 also includes SRM, PLM, CRM, SCM

6. What is NetWeaver?

Ans:

NetWeaver is an integrated technology platform such that all the products in the mySAP suite can run on a single instance of NetWeaver, known as SAP Web Application Server (SAP WEBAs).

The advantage of using NetWeaver is that you can access SAP data using the web (HTTP protocol) or even mobile. Thus, you can save on costs involved in training users on SAP Client-side GUI.

7. List the Different Modules in SAP?

Ans:

FI (Financial Accounting)

• CO(Controlling)
• EC (Enterprise Controlling)
• TR(Treasury)
• IM (Investment Management)
• HR (Human Resource)
• SD (Sales and Distribution)
• MM (Materials Management)
• PM (Plant Maintenance)
• PP (Production Planning)
• QM – Quality Management
• BW (Business Warehousing)

8. What is Metadata, Master data and Transaction data?

Ans:

Meta Data: Meta Data is data about Data. It tells you about the structure of data or MetaObjects.

Master Data: This Data is key business information like Customer information, Employee, Materials, etc. This is more like a reference data for Ex. If a customer orders 10 units of your product instead of asking the customer for his shipping address 10 times, the same can be referenced from the Customer Master Data.

Transaction Data: This is data related to day to day transactions.

9. Is SAP A Database?

Ans:

NO. SAP is not a database, but it’s an application that makes use of databases provided by other vendors like Oracle, SQL Server, etc.

10. How many SAP Sessions can you work on at a given time?

Ans:

At any given time for a particular client, you can work on 6 sessions at max.

11.What is a transaction in SAP terminology?

Ans:

In SAP terminology, a transaction is a series of logically connected dialog steps.

12. Can we run a business warehouse without SAP R/3 implementation?

Ans:

Yes, you can run a business warehouse without R/3 implementation. You have to simply transfer structures associated with business warehouse data sources (ODS table, Infocube) to the inbound data files or use third-party tools to connect your flat files and other data sources.

13. Mention what do you mean by datasets?

Ans:

The data sets are sequential files processed on the application server. They are used for file handling in SAP.

14. What are the variables?

Ans:

Variables are parameters of a query set in the parameter query definition and are not filled with values until the queries are entered into the workbooks.

15. Mention what the different types of variables are?

Ans:

Variables are used in the different application are:

• Characteristics variable
• Hierarchies
• Hierarchy nodes
• Text
• Formulas
• Processing Types
• Replacement Path
• User entry/default type

16. Mention some of the setbacks of SAP?

Ans:

It is expensive

• Demands highly trained staff
• Lengthy implementation time
• Interfaces are a little bit complex
• Does not determine where master data resides

17. Mention where are t-code name and program values stored? Explain how can you find a list of all t-codes in the SAP system?

Ans:

To view transaction table TSTC, you can use transaction code st11, and you can define a new t-code using transaction se93.

18. Mention what the difference between OLAP and Data Mining is?

Ans:

OLAP: OLAP stands for Online Analytical Processing it is a reporting tool configured to understand your database schema, dimensions, and composition facts

Data Mining: It is an analytic process to explore data in search of consistent patterns or systematic relationships between variables.

19.Mention what are the three stages of data mining?

Ans:

Three stages of data mining include:

• Initial Exploration
• Model building
• Deployment

20. Mention what are the different layers in the R/3 system?

Ans:

Different layers in the R/3 system includes

• Presentation Layer
• Database layer
• Application layer

21. Mention what is the process to create a table in the data dictionary?

Ans:

To create a table in the data dictionary, you have to follow this step.

• Creating domains (data type, field length, range)
• Creating data elements (properties and type for a table field)
• Creating tables (SE 11)

22. Mention what is AWB?

Ans:

AWB stands for Administrator Workbench. It is a tool for monitoring, controlling, and maintaining all the processes connected with data staging and processing in the business information warehousing.

23. Explain what is Bex?

Ans:

Bex means Business Explorer. It allows the end-user to locate reports, analyze information, view reports, and can execute queries. The queries in the workbook can be saved to their respective roles in the Bex browser. It has the following components Bex analyzer, Bex Map, and Bex web.

24. Mention what is the importance of ODS in BIW?

Ans:

An ODS object serves to store debugged and consolidated transaction data on a document level. It defines a consolidated dataset from one or more info-sources. This dataset can be evaluated with a Bex query or an Infoset query. The data of an ODS object can be updated with a delta update into InfoCubes or other ODS objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in the ODS object is stored in transparent, flat database tables.

25. Mention what is the difference between Domain and Data Element?

Ans:

Data Element: It is an intermediate object between domain and table type

Domain: It defines attributes such as length, type, and possible value range

26. Mention what are SET parameters and GET parameters?

Ans:

To use parameter IDs, you need to “set” values in the global memory area and then “get” values from this parameter ID memory area. In the case of the online program, you have to “Set” values from screen fields, and you will “get” these values for screen fields.

27. Mention what is LUW (Logical Unit of Work)?

Ans:

LUW is a span of time during which database records are updated, either commit or rollback.

28. Mention what is BDC stands for? How many methods of BDC are there?

Ans:

BDC stands for Batch Data Communication. The methods of BDC are

• Direct Input Method
• Batch Input Session Method
• Call transaction Method

29.Mention what is meant by a “baseline data” in SAP AR and AP?

Ans:

The baseline date is the date from which the payment terms apply. Usually, it is the document date on the invoice but can also be the date of entry or posting date from the ledger.

30. Mention what do you mean by one-time vendors?

Ans:

In specific industries, it is not possible to create new master records for every vendor trading partner. One-time vendor enables a dummy vendor code to be used on invoice entry, and the information that is normally stored in the vendor master is keyed on the invoice itself.

31. Mention what are the standard stages of the SAP Payment Run?

Ans:

While executing the SAP Payment Run the standard stages of SAP includes

• Entering of parameters: It includes entering company codes, vendor accounts, payment methods, etc.
• Proposal Scheduling: The system proposes a list of invoices to be paid
• Payment booking: Booking of the actual payments into the ledger
• Printing of Payment forms: Printing of payment forms

32. Mention what is the difference between the “residual payment” and “partial payment” methods of allocating cash in account receivable?

Ans:

The difference between the residual and partial payment includes

• Partial payment: For example, let say invoice A456 exits for $100 and customer pay $70. With the partial payment, it offsets the invoice leaving a remaining balance $30
• Residual Payment: While in residual payment, invoice A456 is cleared for the full value of $100, and a new invoice line item is produced for the remaining balance of $30.

33. Mention what are internal tables, check tables, value tables, and transparent table?

Ans:

It is the standard data type object; it exists only during the runtime of the program.

Check the table will be at field level checking.

Value table will be at domain level checking

The transparent table will exist with the same structure both in the dictionary as well as in the database exactly with the same data and fields

34. Mention what is an application, presentation, and database servers in SAP R/3?

Ans:

The application layer of a R/3 system is made up of the application server and the message server. Application programs in an R/3 system run on application servers. Using the message server, the application servers communicate with presentation components, the database, and also with each other. All the data are stored in a centralized server, which is known as a database server.

35. Explain what is a company in SAP?

Ans:

Company in SAP is the highest organizational unit for which financial statements like profit and loss statements, balance sheets can be drawn according to the requirement of organizations. A single company contains one or many company codes. All the company codes in SAP must use the same COA (chart of accounts) and fiscal year.

36.Mention what is the difference between SAP BASIS and SAP ABAP?

Ans:

SAP ABAP is the programming language used within SAP to customize, generate forms, generate reports, etc. While SAP basis is, the administration module of SAP used to control code changes, upgrades, database admin, network setup, etc.

37. List out the different types of source systems in SAP?

Ans:

The different types of the source system in SAP includes

• SAP R/3 source system
• SAP BW
• Flat files
• External Systems

38. Explain what is Extractor?

Ans:

In the SAP source system, extractors are a data retrieval mechanism. It can fill the extract structure of a data source with the data from the SAP source system datasets.

39. Explain what is extended star schema?

Ans:

The star schema consists of the fact tables and the dimension tables. The master data related tables are kept in separate tables, which has reference to the characteristics in the dimension tables. These separate tables for master data are termed as the Extended Star Schema.

40. Explain what should be the approach for writing a BDC program?

Ans:

The approach to writing BDC program is to Create recording

Convert the legacy system data to a flat file into the internal table referred as “Conversion.”

Transfer the Flat file into the SAP system called “SAP Data Transfer.” Depending upon the BDC type CALL TRANSACTION or CREATE SESSIONS

41. Mention what are the major benefits of reporting with BW over R/3?

Ans:

Business Warehouse uses a data warehouse and OLAP concepts for analyzing and storing data While the R/3 was intended for transaction processing. You can get the same analysis out of R/3, but it would be easier from a BW.

42. Mention the two types of services that are used to deal with communication?

Ans:

To deal with communication, you can use two types of services.

• Message Service: In order to exchange short internal messages, this service is used by the application servers
• Gateway Service: This service allows communication between R/3 and external applications using CPI-C protocol.

43. Mention what are reason codes used in Account Receivable?

Ans:

“Reason Codes” are tags that can be allocated to describe under/overpayments during the allocation of incoming customer payments. They should not be mixed up with “void reason codes” used when outgoing cheques are produced.

44. Mention what is the protocol does SAP Gateway process use?

Ans:

The SAP gateway process uses TCP/IP protocol to communicate with the clients.

45. Mention what is pooled tables?

Ans:

Pooled tables are used to store control data. Several pooled tables can be united to form a table pool. Table tool is a solid table on the database in which all the records of the allocated pooled tables are stored.

46. Explain what is an update type with reference to a match code ID?

Ans:

If the data in one of the base tables of a matchcode ID changes, the matchcode data has to be updated. The update type stipulates when the match-code has to be updated and how it has to be done. The update type also defines which method is to be used for building match-codes.

47. Explain what the .sca files and mention their importance?

Ans:

. sca stands for SAP component Archive. It is used to deploy the Java components, patches, and other java developments in the form of. sca,. sda,.war and .jar.

48. Explain what is meant by “Business Content” in SAP?

Ans:

Business Content in SAP is a pre-configured and pre-defined model of information contained in the SAP warehouse, which can be used directly or with desired modification in different industries.

49. Explain what is dispatcher?

Ans:

A dispatcher is a component that takes the request for client systems and stores the request in the queue.

50. Mention what are the common transport errors?

Ans:

The common transport errors include:

Return code 4: Imported with warnings, generation of program, columns or row missing

Return code 8: Imported with a syntax error, program generation error, dictionary activation error, etc.

Return code 12: Indicates import cancelled due to object missing, object not active, etc.

Return code 18: Indicates import cancelled due to system down while import, user expired during import, and insufficient roles or authorization.

51. What is SAP B1?

Ans:

B1 = Business One SAP Business One is an integrated enterprise resource planning (ERP) solution for small and medium-sized businesses, as well as divisions and subsidiaries of larger companies.

52. Can we format BEx reports/graphs using HTML and CSS?

Ans:

Manual says we can do format using HTML and Java Script [not css].

53. Why is there a restriction of 16 Dim tables in an Info Cube and 16 critical fields in an ODS?

Ans:

In all of the database systems, there is a maximum number of fields allowed to create a primary key (composite key) is 16. An in the case of a cube, to fetch a single record a combination of all dimensions is used, so this is the reason behind having maximum no. of dimension in the cube is 16 only.

54. Which is the DLL’s used in SAP Business One SDK?

Ans:

Interop.SAP bouiCOM.dll and Interop.SAP bobs COM.dll are the two dell’s used in SAP Business One SDK. Interop.SAPbouiCOM.dll is used for accessing the user controls that are displayed over the form. Different controls such as labels, combo boxes, matrix, etc. can be accessed using Interop.SAPbouiCOM.dll. Interop.SAPbobsCOM.dll is used for accessing objects that are used in SAP. For eg, item object can be accessed as, Dim objItem As SAPbobsCOM.Items

55. What are SAP and ERP?

Ans:

SAP is the name of the company that supplies the leading ERP software released as SAP BW, SAP ERP, and various other SAP applications. The company was founded in Germany in 1972 and has released various versions of its ERP software. There are currently over eight million SAP users around the world.

ERP is an acronym for Enterprise Resource Planning. ERP applications are applications that are designed to create a real-time view of the core business processes within a company so that the company can monitor and manage its processes efficiently. ERP software tracks the day to day transactions and processes within a company. ERP software tracks various business resources like cash, raw materials, production capacity, and sales. Data is shared between the various company departments. ERP packages are therefore often integrated applications that span the various business processes within the business. Databases are the most popular storage method for shared information. For more information on SAP basics, you can read the SAP Basics and Resources to Help You Learn More article available on the Udemy blog.

56. Why we have only 16 Dimension tables in a cube. Is there any reason. Is it a limitation?

Ans:

SAP BI Info Cube Can have a maximum 16 Dimension, Why because a Cube shape will have only 16 Dimensions and also Normal database table will have only 16 key fields. When we create the Info Cube system is going to create tables like F-table and E-table So, we should follow that database concept Because Info Cube will Have only 16 Dimensions.

57. Why we are going for customization? Give me a scenario?

Ans:

For Requirement as per company

• Reporting As Per Module
• Remove Complexity From End-User

58. Where do you store the master data in BI 7.0?

Ans:

Unlike the older version of BW which uses star schema, BI 7.0 uses the extended star schema. In this, master data is stored outside the cube. In the star schema, both master data and transaction data reside inside the cube bringing many problems: master data not reusable, computing of alphanumeric values, and analysis is limited. In BI 7.0 Master data is stored outside the cube which makes it reusable, and alphanumeric values can be computed and many more analyses are possible.

59. What are the common Transport errors in SAP BW?

Ans:

NOT CORRECT USAGE. Reason: When we change the structure of any cube which has Business Warehouse Accelerator Indexes created for it. Change in structure could mean a change as simple as adding a navigational attribute. solution: Delete the Indexes (BWA Indexes)first then transport and then rebuild the indexes Info Object not available inactive version. Reason: We get this error when we try to transport the Info Object Catalogs without transporting the info objects. Solution: As a prerequisite first transport the info objects then transport info object catalogs. The navigational attribute does not exist Reason: If we mark an object in the cube as a navigational attribute and the navigational attribute does not exist as navigational in the target system. Solution: Transport the info object with navigational attribute and then re-import this transport.

60. What advantage of ic with aggregates?

Ans:

if we create aggregates on info cube then query performance will be improved if our query accessing attributes data frequently. The sequence when we execute the query is: Query first goes into cache if it finds relevant data in the cache will fetch data otherwise it goes into BI ACCELERATOR(BIA) Aggregates Finally it goes into IC if the data is not available in the above 3 stages. If we maintain aggregates or BIA OLAP no needs to come up to IC. So time will be reduced. Query performance will be improved.

61. What is used in SDK for developing a form?

Ans:

Screen painter is used for developing form in SAP Business One SDK. Screen painter is provided as an add-on by SAP and it can be used to designing and developing forms. The files created by the screen painter have srf extension and these files should be renamed to XML for deploying then in SAP Business One.

62. Which tool is provided by SAP for keeping the track of events?

Ans:

SAP Business One Event Logger is a tool provided by SAP for keeping the track of events. Both SAP Business One and event logger should be executed simultaneously. The event logger will give you a detailed list of events that fired while operating SAP. Event logger is a very useful tool while developing add-ons in SDK. Coding can be done as per the events that are shown in the event logger. For developing robust applications in SAP Business One SDK, event logger is a useful tool since entire programming in SAP Business One SDK is event-driven.

63. Is it possible to alter the standard behavior of SAP Business One using SDK?

Ans:

The standard behavior or the conventional flow of SAP Business One can not be altered using SDK. Some or other errors will occur. So it is advisable not to disturb the conventional flow of SAP Business One using SDK.

64. What is the et_FORM_DATA_ADD event in SAP Business One SDK?

Ans:

et_FORM_DATA_ADD event fires when the add button is clicked. This event adds a new record in SAP. This event can be used for validating the input received by the user. This event fires in two sessions. In the first session, an event fires before the successful execution of the event I .e.ActionSuccess.The code is as,

BusinessObjectInfo.EventType = SAPbouiCOM.BoEventTypes.et_FORM_DATA_ADD ANDBusinessObjectInfo.ActionSuccess = False
The second session occurs when the action is executed successfully i.e.
SAPbouiCOM.BoEventTypes.et_FORM_DATA_ADD ANDBusinessObjectInfo.ActionSuccess = True

65. How is SAP Business One implemented?

Ans:

SAP Business One is implemented as a two-layer architecture. The system is based on a Microsoft SQL Server database where data is stored centrally. The business logic is mostly processed on the client software (fat client).

66. What are the different components of SAP Business One client software?

Ans:

Graphical user interface and the business object classes connecting to the database are the different components of SAP Business One client software.

67. Explain the difference between transfer rule&update rules?

Ans:

In context to SAP BW/BI 3.x

transfer rules: mapping the fields in the data source to the info objects in Info source or target fields. it helps you to distinguish which all fields in the data source are required in the info objects in the Info source.

update rules: to update something. here it revolves around a source(info source)and a target(data target). update rules are used to update the data targets.you have to create update rules if you supply a data target from an Info-Source with a flexible update.

68.What is the function of UI API i.e. User Interface API?

Ans:

UI API stands for User Interface Application Program.Dll is provided by SAP i.e. Interop.SAPbouiCOM.dll.The reference of this dll is added in the project to access it in the project. UI API is used for accessing the controls that are displayed on the form. The following are the functions of UI API

• Provides objects and methods to access screen objects of the User Interface.
• Provides access to internal system events of the user interface.
• Provides the ability to modify or add menus, windows, or fields.
• It provides one integrated user interface.

69. What is the use of a company object in SAP Business One?

Ans:

The following are the uses of company object in SAP Business One –

• Access Data in an SAP Business One database.
• Connect to and disconnect to the customer database.
• Start and end global transactions.
• Work with XML data.

70. What are the different types of DataSources?

Ans:

The following are the different types of DataSources –

• Data Tables
• DB Data Sources
• User DataSources

71. What are the functions of the Data Interface API (DI API)?

Ans:

Following are the functions of the Data Interface API (DI API) –

• DI API provides objects and methods i.e. add, update, Remove, for performing various data level operations. This can be done without installing SAP Business One client.
• DI API provides access to business objects i.e. master data and transnational data.
• DI API can be used in COM capable development tools (e.g. Microsoft Visual Studio). Dll SAPbobsCOM.dll is provided by SAP. Just by adding the reference of this dll, you can perform data level operations.

72.What are the different types of transactions supported by DI API?

Ans:

Following are the different types of transactions supported by DI API:

• Single Transaction
• Global Transaction

73. What is Bubble Event?

Ans:

Bubble Event specifies whether the event will be processed by SAP Business One or not.If Bubble Event=True, then SAP Business One will process the event else the execution will terminate.

• For eg,
• If pVal.EventType = BoEventTypes.et_CLICK And pVal.Action_Success = True And pVal.FormUID = “F_32” And pVal.ItemUID = “btnSave” Then
• BubbleEvent=False<
• End If

In the above code, the click event of the save button is handled. When the user clicks on the save button, then first the above code will execute and then it will be handled by SAP Business One. Here I have set BubbleEvent=False.So the click event will terminate and SAP Business One will not handle the event.

74. What is DBDataSource?

Ans:

DBDataSource is used for storing data from the database.DBDataSource is linked to a database table and it represents tabular data.DBDataSource is used by all system forms. You can get DBDataSource as follows –

Here I have assumed that I have opened the form of Sales Order and I want to get the database details of the sales order. The table’s name is ORDER.

• Dim objDS As SAPbouiCOM.DBDataSource
• objDS = SBO_Application.Forms.ActiveForm.DataSources.DBDataSources.Item(“ORDR”)

75. How to bind a textbox with datasource ?

Ans:

Textbox can be binded to datasource as follow

• Dim objForm As SAPbouiCOM.Form
• Dim txtDocEntry As SAPbouiCOM.EditText
• objForm = SBO_Application.Forms.ActiveForm
• objForm.DataSources.UserDataSources.Add(“DocEntry”, SAPbouiCOM.BoDataType.dt_LONG_NUMBER)
• txtDocEntry = objForm.Items.Item(“txtDocEntry”).Specific
• txtDocEntry.DataBind.SetBound(True, “”, “DocEntry”)
• In the above code,I have considered the textbox txtDocEntry.I want this textbox to accept numeric input only.So I have binded it with dt_LONG_NUMBER as shown above.

76.What are the limitations of the DI server?

Ans:

Following are the limitations of DI server

• Metadata operations not supported.
• Different support for transaction handling than plain DI API.

77. What is the function of OBServerDLL.DLL?

Ans:

In OBServerDLL.DLL, the business objects of the SAP Business One client are copied.

78. What are the different parts of DI API?

Ans:

Following are the different parts of DI API

• COM Interface – The COM Interface provides the interface to the add-on application.
• DI Core – The DI Core, which is the main component of the DI API, performs all the data logic operations.
• Data Manager – The Data Manager stores temporary object data, converts object data to internal data formats, retrieves data from the database, and controls the database transactions.
• Schema Generator – The Schema Generator creates XML schemas based on object interface descriptions. The schema generator also creates object validation lists.

79. Where does DI server execute i.e. client or server?

Ans:

DI server executes on the server.

80. For performing heavy-duty operations what is a suitable DI API or DI server?

Ans:

For performing heavy-duty operation DI server is suitable. The DI Server implements a connection pooling mechanism to enhance the performance and scalability of the server. As DI Server is a SOAP-based interface it does not limit the client to a COM interface but allows a wide range of possible client technologies.

81. What is the value returned when any method of a DI API object executes successfully?

Ans:

0 is returned when any method of a DI API object executes successfully.

82. Which table saves the details of the country?

Ans:

The OCRY table saves the details of the country.

83. Which property of the matrix gives the total number of rows in the matrix?

Ans:

The property VisualRowCount gives the total number of rows in the matrix.

84. In SAP Business One SDK, which object is used for executing SQL queries and stored procedures?

Ans:

In SAP Business One SDK, the recordset object is used for executing SQL queries and stored procedures.

85. Can we format BEx reports/graphs using HTML and CSS

Ans:

Manual says we can do format using HTML and Java Script [not css].

86. What is A/R Invoice?

Ans:

The acronym of A/R Invoice is Account Receivable Invoice. For selling a product, the following invoices are added in SAP Business One

• Sales Quotation
• Sales Order
• Delivery
• A/R Invoice
So A/R Invoice is the last process for the sales department. When the A/R Invoice is added, the respective accounting entries are added. The report from the A/R Invoice is sent as a bill along with the product.

87. What is A/P Invoice?

Ans:

The acronym of A/P Invoice is Account Payable Invoice. For purchasing the goods, the following invoices are added in SAP Business One

• Purchase Quotation
• Purchase Order
• Goods Receipt PO
• A/P Invoice

So A/P Invoice is the last process for the purchasing department. When A/P Invoice is added, the accounting effect can be seen.

88. Explain difference between transfer rule&update rules?

Ans:

In context to BW/BI 3.x

transfer rules – mapping the fields in the datasource to the infoobjects in Infosource or target fields. it help you to distinguish which all fields in the datasource are required in the infoobjects in the Infosource.

update rules – to update something. here it revolves around a source(infosource)and a target(data target). update rules are used to update the data targets.you have to create update rules if you supply a data target from an InfoSource with flexible update.

In BI 7.0 Transforamtion – (Tranfer and update rules)

89. Explain process chain failure notifications?

Ans:

Create a job at that time when all the process chains have ended. This job will send you a email alert what process chains have errors.

• red – failure.
• black – start the next process.

90. How to schedule the process chain “in a month first five days “i have to schedule the process chain? how?

Ans:

Every process it has own variant .selecting the variant it will give the time period i..e immediate or time/date.

91. Can we load delta load directly without full load? How? What are the steps?

Ans:

Yes we can.

Because of for capturing deltas we need to do something before load the deltas.

Before going to set the delta mode. you should initialize delta process without data transfor process. ofter finishing the this initiazation keep the delta mode. and exectue the infopackage.

Before going to execute info package check weather data source is reay to capture deltas or not. by using the t-code rsa7.

92. Where do you store the master data in bi 7.0?

Ans:

Unlike the older version of BW which uses star schema, BI

7.0 uses the extended star schema. In this, master data is stored outside the cube.

In the star schema, both master data and transaction data resides inside the cube bringing many problems: master data not reusable, computing of alphanumeric values and analysis being limited.

In BI 7.0 Master data is stored outside the cube which makes it reusable, and alphanumeric values can be computed and many more analysis are possible.