Explore topic-wise InterviewSolutions in .

Interop.SAPbouiCOM.dll and Interop.SAPbobsCOM.dll are the two dll’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 label,combobox,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 accesed as, DIM objItem As SAPbobsCOM.Items

Interop.SAPbouiCOM.dll and Interop.SAPbobsCOM.dll are the two dll’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 label,combobox,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 accesed as, Dim objItem As SAPbobsCOM.Items

The ACRONYM of A/P INVOICE is Account Payable Invoice. For purchasing the goods.

following invoices are added in SAP Business One:

1. Purchase Quotation
2. Purchase Order
3. Goods Receipt PO
4. A/P Invoice

So A/P Invoice is the LAST process for the purchase department. When A/P Invoice is added, the ACCOUTING effect can be seen.

The acronym of A/P Invoice is Account Payable Invoice. For purchasing the goods.

following invoices are added in SAP Business One:

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

The ACRONYM of A/R Invoice is Account Receivable Invoice. For selling a product

FOLLOWING invoices are ADDED in SAP Business One:

1. Sales Quotation
2. Sales Order
3. Delivery
4. A/R Invoice

So A/R Invoice is the last process for the sales department. When A/R Invoice is added, the respective accouting entries are added. The report from the A/R Invoice is send as BILL along with the product.

The acronym of A/R Invoice is Account Receivable Invoice. For selling a product

following invoices are added in SAP Business One:

So A/R Invoice is the last process for the sales department. When A/R Invoice is added, the respective accouting entries are added. The report from the A/R Invoice is send as bill along with the product.

0 is the value RETURNED by a method when it EXECUTES successfully.

0 is the value returned by a method when it executes successfully.

In SAP BUSINESS One SDK,recordset object is USED for executing SQL queries and stored procedures.

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

The property VISUAL RowCount GIVES the total NUMBER of ROWS in the matrix.

The property Visual RowCount gives the total number of rows in the matrix.

OCRY table SAVES the DETAILS of COUNTRY.

OCRY table saves the details of country.

0 is returned when any METHOD of an DI API OBJECT executes SUCCESSFULLY.

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

For performing heavy duty operation DI server is suitable.The DI Server implements a CONNECTION pooling mechanism to enhance 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.

For performing heavy duty operation DI server is suitable.The DI Server implements a connection pooling mechanism to enhance 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.

DI SERVER EXECUTES on the server.

DI server executes on the server.

Following are the different PARTS of DI API:

1. COM Interface:The COM Interface provides the interface to the add-on application.
2. DI Core :The DI Core, which is the main component of the DI API, performs all the data logic operations.
3. 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.
4. Schema Generator :The Schema Generator creates XML SCHEMAS based on object interface descriptions. The schema generator also creates object validation lists.

Following are the different parts of DI API:

In OBServerDLL.DLL , the business OBJECTS of the SAP Business ONE client are COPIED.

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

Following are the LIMITATIONS of DI SERVER:

1. Meta data operations not SUPPORTED.
2. Different support for transaction handling than PLAIN DI API

Following are the limitations of DI server:

DBDataSource is used for storing data from database.DBDataSource is linked to 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 name is ORDR. Dim objDS As SAPbouiCOM.DBDataSource

objDS = SBO_Application.Forms.ActiveForm.DataSources.DBDataSources.Item(“ORDR”)

DBDataSource is used for storing data from database.DBDataSource is linked to 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 name is ORDR. Dim objDS As SAPbouiCOM.DBDataSource

objDS = SBO_Application.Forms.ActiveForm.DataSources.DBDataSources.Item(“ORDR”)

BUBBLEEVENT specifies whether the EVENT will be processed by SAP Business One or not.If BubbleEvent=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,click event of save button is handeled.When the USER CLICKS on the save button,then first the above code will execute and then it will be handeled 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.

BubbleEvent specifies whether the event will be processed by SAP Business One or not.If BubbleEvent=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,click event of save button is handeled.When the user clicks on the save button,then first the above code will execute and then it will be handeled 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.

FOLLOWING are the DIFFERENT types of TRANSACTIONS SUPPORTED by DI API:

1. Single Transaction
2. Global Transaction

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

FOLLOWING are the DIFFERENT objects in DI API :

1. BUSINESS Objects
2. Infrastructure Objects
3. Special Objects

Following are the different objects in DI API :

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

1. 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.
2. DI API provides ACCESS to business objects i.e. master data and transactional data.
3. 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.

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

Yes,datatable can be LOADED directly using SQL QUERY as follows:

Dim obJECT as SAPbouiCOM.DataTable Dim strQuery as String strQuery=”SELECT * FROM OITM” obJECT.ExecuteQuery(strQuery)

Yes,datatable can be loaded directly using sql query as follows:

Dim obJECT as SAPbouiCOM.DataTable Dim strQuery as String strQuery=”SELECT * FROM OITM” obJECT.ExecuteQuery(strQuery)

The FOLLOWING are the DIFFERENT TYPES of DATASOURCES :

1. DATATABLES
2. DBDataSources
3. UserDataSources

The following are the different types of DataSources :

The following are the uses of company object in SAP Business ONE:

1. Access Data in an SAP Business One DATABASE.
2. Connect to and disconnect to customer database.
3. Start and END global transactions.
4. Work with XML data

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

Company object REPRESENTS SAP Business One database.Is USED to ESTABLISH a CONNECTION to a Microsoft SQL Server database.

Company object represents SAP Business One database.Is used to establish a connection to a Microsoft SQL Server database.

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 project.UI API is used for ACCESSING the controls that are DISPLAYED on the form.

Following are the functions of UI API:

1. Provides objects and methods to access screen objects of the User Interface.
2. Provides access to internal system events of the user interface.
3. Provides ability to modify or add menus, windows, or fields.
4. Provides one integrated user interface.
5. USE COM capable development tools (Microsoft Visual …)

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 project.UI API is used for accessing the controls that are displayed on the form.

Following are the functions of UI API:

In SAP Business ONE,DI SERVER is DCOM service that runs on the SAP Business One server and accepts XML data PACKED in SOAP (Simple Object ACCESS Protocol)

In SAP Business One,DI Server is DCOM service that runs on the SAP Business One server and accepts XML data packed in SOAP (Simple Object Access Protocol)

GRAPHICAL user INTERFACE and the business object CLASSES connecting to the database are the different components of SAP Business One client SOFTWARE .

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

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).

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).

In the recordset ,data can be filled in the recordset using the sub-routine DoQuery.The sample ILLUSTRATES this in detail , Dim objRS As SAPbobsCOM.Recordset

objRS = objCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

objRS.DoQuery(“SELECT * FROM OITM”)

Learn SAP BUSINESS One Course makes an emphasis on all that is REQUIRED to manage critical business functions across sales.

In the recordset ,data can be filled in the recordset using the sub-routine DoQuery.The sample illustrates this in detail , Dim objRS As SAPbobsCOM.Recordset

objRS = objCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

objRS.DoQuery(“SELECT * FROM OITM”)

Learn SAP Business One Course makes an emphasis on all that is required to manage critical business functions across sales.

The standard behaviour or the convensional flow of SAP Business ONE can not be altered USING SDK.Some or other ERROR will occur.So it is advisable not to DISTURB the convensional flow of SAP Business One using SDK.

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

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.Event logger will give you detailed list of events that fired while operating SAP.Event logger is very useful tool while devleloping add-ons in SDK.Coding can be done as PER the events that are shown in event logger.For devleoping ROBUST applications in SAP Business One SDK,event logger is useful tool since ENTIRE programming in SAP Business One SDK is event driven.

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.Event logger will give you detailed list of events that fired while operating SAP.Event logger is very useful tool while devleloping add-ons in SDK.Coding can be done as per the events that are shown in event logger.For devleoping robust applications in SAP Business One SDK,event logger is useful tool since entire programming in SAP Business One SDK is event driven.

SCREEN painter is USED for developing FORM in SAP BUSINESS One SDK.Screen painter is provided as add-on by SAP and it can be used to designing and developing forms.The files created by screen painter has srf extension and these files should be renamed to xml for deploying then in SAP Business One.

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

If we remove EventFilters,then the all the events will fire.While programming in SDK,the unneccessary events should be neglected since it will DECLINE the performance of the application.When EventFilter is APPLIED to the SAPbouiCOM.Application object,then the events will fire as PER the requirement of the user and thus ENHANCING the performance of the application.

If we remove EventFilters,then the all the events will fire.While programming in SDK,the unneccessary events should be neglected since it will decline the performance of the application.When EventFilter is applied to the SAPbouiCOM.Application object,then the events will fire as per the requirement of the user and thus enhancing the performance of the application.

Interop.SAPbouiCOM.dll and Interop.SAPbobsCOM.dll are the TWO dll’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 label,combobox,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 accesed as, Dim objItem As SAPbobsCOM.Items

Interop.SAPbouiCOM.dll and Interop.SAPbobsCOM.dll are the two dll’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 label,combobox,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 accesed as, Dim objItem As SAPbobsCOM.Items