How to build Fiori apps for SAP Business One on HANA – part3

Hi Mostafa,

     Thank you for your reply.  We plan to shift to your approach of using both Web IDE and Hana Studio.

1. Could I confirm that this should be the typical steps for a Friori application using B1 Service Layer application

   a) Create a project within Web IDE

   b)  Import the B1 metadata.xml file into local file system

   c)  Create mock data

   d)  Create xml views and their controllers

   e)  Test with mock data using mockserver.js

   f)   Create an XSJS project into Hana Studio

   g)  Import the code from Web IDE

   h)  Add the code for login, session handling - as seen in your B1SLLogic.xsjs and create html code to login for authentication

   i)   Add the business logic code - as seen in your callSL.js

   j)   Add the B1SL.xshttpdest file

   k)  Modify Component.js / manifest json for data source, disable the mock service.

2. Since the same xml views are also used in Hana Studio, how are the relationships between different entities (e.g. SO header, SO Items, BP) enforced?  In step 1e) above (within Web IDE), the mockserver.js uses the local copy of the metadata.xml to enforce the associations for the mock data? The code in B1S1Logic.xsjs and callSL.js appear to to be ODATA rest calls. But by themselves they cannot enforce the relationships in the xml views? Or am I wrong?

3.  CORS

     From B1 Service Layer with JavaScript - Handling B1 Objects without .Net (nor DI API)

     there was an instruction to add 2 lines in b1s. conf file in the server  a) CorsEnable : true and b) CorsAllowedOrigins : (various IP sources).  Is this necessary still?

   Thank you.

   Chong Chin

Hi Mostafa,

      Thank you. Our team appreciate your effort. I am still not clear on paragraph 2 of your answer, about the use of ODATA calls instead of service layer calls.

1. Binding B1 data to xml views. Please confirm that the following code in your SLFlori example, uses ODATA services and not the service layer, and therefore do not depend on the metadata.xml of the service layer.

  a)  In Detail.controller.js, in the OnInit function, there are 2 references to "idItemsTable" and "IdColListItems" in the xml view

  var oItemsTbl = this.getView().byId("idItemsTable");

  var oColListItem = this.getView().byId("idColListItem");

  oItemsTbl.setModel(oModel);

  oItemsTbl.bindItems(context.sPath + "/DocumentLines", oColListItem);

  b)  These 2 IDs are found in your Detail.view.xml, and you use the "path" parameter to reference DocumentLines

<Table id="idItemsTable"

  inset="false"

  items="{

  path: '/DocumentLines',

  sorter: {

  path: 'ItemCode'

  }

  }">

   c) In callSL.js, the following line is used to get "Orders" and the related "DocumentLines"

      var xsjsUrl = "xsjs/B1SLLogic.xsjs?cmd=Get&actionUri=Orders&filter=DocumentStatus&sessionID=" + document.cookie;

2.   Data integrity for insert and update to B1 standard tables

      In .NET development, we have been instructed by SAP never to write directly to SAP B1 standard tables, but use the DI API instead. If now, we do not use the service layer to insert / update  SAP standard tables, but use ODATA calls instead, will the data of standard B1 tables  be correctly updated ?

    Thank you again

     Chong Chin

Hi Mostafa,

     Sorry for not asking these questions in 1 go.

1.  Our trial Friori application is to be finally installed on a mobile device e.g. tablets for managers, to approve sales orders when they are not in the office.

2.  WEB IDE provides a "Hybrid Application Toolkit" (HAT) for mobile development. Can HAT be used for the above approach (Web IDE + Hana Studio) that you demonstrated with the SLFriori example?

   Thank you

   Chong Chin