22 September, 2020
Are you planning to attend an interview for the SAP B1 Developer role but confused on how to crack that interview and also what would be the most probable SAP B1 Interview Questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked SAP B1 Interview Questions which are often asked in multiple interviews.
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.
Ans: Manual says we can do format using HTML and Java Script [not css].
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.
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
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.
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.
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.
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.
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.
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
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).
Ans: Graphical user interface and the business object classes connecting to the database are the different components of SAP Business One client software.
Ans: In context to SAP BW/BI 3.x
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
Ans: The following are the uses of company object in SAP Business One -
Ans: The following are the different types of DataSources -
Ans: Following are the functions of the Data Interface API (DI API) -
Ans: Following are the different types of transactions supported by DI API -
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.
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.
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")
Ans: Textbox can be binded to datasource as follow
Ans: Following are the limitations of DI server
Ans: In OBServerDLL.DLL, the business objects of the SAP Business One client are copied.
Ans: Following are the different parts of DI API
Ans: DI server executes on the 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.
Ans: 0 is returned when any method of a DI API object executes successfully.
Ans: The OCRY table saves the details of the country.
Ans: The property VisualRowCount gives the total number of rows in the matrix.
Ans: In SAP Business One SDK, the recordset object is used for executing SQL queries and stored procedures.
Ans: 0 is the value returned by a method when it executes successfully.
Ans: The acronym of A/R Invoice is Account Receivable Invoice. For selling a product, the following invoices are added in SAP Business One
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.
Ans: The acronym of A/P Invoice is Account Payable Invoice. For purchasing the goods, the following invoices are added in SAP Business One
So A/P Invoice is the last process for the purchasing department. When A/P Invoice is added, the accounting effect can be seen.