suse technical webinar: build b1 apps in the framework of the sap and suse campaign

SAP Business One and SAP HANA IntegrationEddy Neveux – Solution Architect – North America

2014

© 2013 SAP AG. All rights reserved. 2Public

Topic 3: User Interface API

Topic 4: SAP Business One Development Tools

Topic 1: Introducing SAP Business One SDK

Topic 2: Data Interface API

Topic 5: Add-Ons Packaging & Deployment

Topic 6: SAP Business One Integration Framework

Topic 7: SAP Business One on SAP HANA

Introducing SAP Business One Integration

© 2013 SAP AG. All rights reserved. 3Internal

A Complete Business ERP Solution PlatformThe purpose of ERP is to facilitate the flow of information between all business functions inside the boundariesof the organization and manage the connections to outside stakeholders

Enhance solutionenablementfor partners

Cover standard businessprocesses end-to-end

Orchestrate integrationand collaboration

Run completely in-memory technology

Manage TCOExtend thesolution scope

Full flexibilityon deployment

Aerospace – Automotive – Chemical - Consumer Products - EC&O - Food and Beverage – Healthcare – IMC - LifeSciences – Manufacturing - Mill Products – Oil and Gas - Professional Services – Retail/AFS - Wholesale Distribution


SAP Business One - Technology and Interfacing

SAP® Business One

Server

RDBMS

Integration

Services

Client

Interfaces

Continuous and integrated solutionWindows look & feel (SAP style)Simple navigationAbility to drill down to details“Drag and relate” feature

Two-tier client-server architecture (fat client)Microsoft Windows 32 based, 64 Bit supp.Microsoft SQL Server / SAP HANA Server

Ease of Use

ProductArchitecture

CustomizingForm SettingsQueries / ReportsUser-Defined Tables and FieldsLinkage of input fields to queriesUser-Defined Objects (UDOs)

Microsoft Excel, Word (out)Microsoft Outlook (in / out)

Adaptations

MS OfficeIntegration

File-based (built-in)XS Engine, Service LayerAPIs (COM, web services)User-Defined objects (UDOs)Integration (not only) to SAP systems

Interfaces

SDK (COM)

GUI

Email

Backup

MicrosoftSQL Server/SAP HANA

SDK (COM)

SDK (DI Server)

License


SAP Business One SDK - Motivation

Customizationcapabilities arepowerful!

Customizationcapabilities cannotsolve everyrequirement.

Source code notaccessible!

Use SDK!

SAPAdd-Ons

SoftwareDevelopment Kit

PartnerAdd-Ons

SAPBusiness One


SAP Business One SDK – Terminology and Packaging

The SDK consists of 2 major packages:The Runtimes (i.e. the APIs)

The runtimes (DI API + UI API) are installed together with the SAP Business One clientapplication

DI API can be installed stand-alone (separate installer package available)

The documentation (samples, helpfiles, utilities) named „SDK Installation“









Introducing SAP Business One SDK


SAP Business One SDK – Data Interface API

Provides objects and methods (add, update etc.) to work on data level – installing the SAPBusiness One client application is not required

Provides access to business objects (e.g. master data and transactional data) and crossfunctionalities (services)

Performs the same checks as the SAP Business One client application

Links existing third-party solutions “as-is”

Use COM capable development tools (e.g. Microsoft Visual Studio)

SAP Business OneCompanyDatabase

DI API(or JCo

orDI Server)

UDO

3rd PartyApplication

SAPBusiness One


DI API – Object Categories

Business ObjectsMaster Data Objects

BusinessPartnersItems…

Transactional Data ObjectsJournal EntriesDocuments: Order, Invoice,……

Infrastructure ObjectsCompany objectExtended Functionality Objects

RecordSetDataBrowserSBObob

Meta Data ObjectsUserTablesMDUserKeysMDUserFieldsMDUserObjectsMD

Special ObjectsService Type Objects

CompanyServiceAccountsServiceBusinessPartnersServiceFormPreferencesServiceMessagesServiceReportLayoutsServiceSeriesService

Definition Objects related to SAPBusiness One GUI

ChooseFromListDynamicSystemStringsFormatted SearchesMultiLanguageTranslationsUserQueries


Data Interface API – Use cases

There are a couple of scenarios where Data Interface API is engaged:

Data level integration of existing applications:Easily read or write data from / to SAP Business One – when needed

Data Import / Export scenarios – which are not covered through SAP tools – and where thecapabilities of the SAP Business One application are not sufficient.

Depending on the architecture of the overall solution you might consider to use DI Serverthough.

Handling data in an Add-On that uses UI API (see next unit) beyond UI API‘s capabilities.Essentially writing data to the SAP Business One database by default requires usage of DIAPIEven though other techniques may be faster when it comes to reading data from thedatabase – usage of DI API is often a good choice regarding usability (no need to requestadditional credentials etc) and data coherence (imagine that the required data might bestored in various tables).


The User Defined Object offers partners the ability to:Add own Business Objects to the application’s object collection.Use the set of services that the application offers, such as:

Connect a Form to the Object; use Find, Add, and Update modes and other predefinedservices.Optionally the predefined behavior of the services can be modified and extendedthrough implementing a class that inherits (C++) from a business object base class in aDLL and overriding virtual methods.

SAP Business One supports two types of main Objects:Master Data ObjectDocument Object

SAP Business One SDK – User Defined Object (UDO)

Object Collection

AddFind

Remove…..

New partnerobject

Register theobject forservices

UDO


SAP Business One SDK – User Interface API

Provides objects and methods to access screen objects of the User Interface

Provides access to internal system events of the user interface

Provides ability to modify or add menus, windows, or fields

Provides one integrated user interface

Use COM capable development tools (Microsoft Visual …)

SAP Business OneCompanyDatabase

DataInterface

API

Use

rInt

erfa

ceA

PI

UDO

3rd PartyApplication

SAPBusiness One


User Interface API – Use Cases

User Interface API is usually used to:

Reach a „seamless“ integration of additional functionality with SAP Business One(usually requested by customers)

…including hooking on SAP Business One standard processes…including adding own GUI elements into SAP Business One standard forms…including adding own forms and plugging the corresponding data behind

Manipulate SAP Business One standard functionality (when standard options do notapply to the customer‘s processes (or the branch the customer works in))

…including hiding SAP Business One GUI elements…including blocking SAP Business One events


Inquiry

Vendor

Name

Contact Employee

Phone

Vendor Ref. No.

Inquiry No.

Inquiry Date

Item Number Item Description Quantity Price

Document Type

# Tax

Total Sum

Add Cancel

Inquiry Ref. No.

User Interface API

Control flow of applications

Change existing screen layout:Add/Remove ControlsChange Control Properties

Add new screens

Add/Modify/Remove menus

Summary: UI API provides the capability for seamless integration maintaining theuniform “look and feel” of SAP Business One


UI API – Object Overview

Menus

Forms

Controls (“Items”) onForms

Connection ObjectsSboGuiAPIApplication

Desktop

Menu

FormItems

ComboBoxEditTextMatrixGridActiveX…

DataSourcesDBDataSourceDataTableUserDataSourceCollection Obj.


SAP Business One Studio Suite

Developer Consultant Customer IT

SAP Business One Studio for Microsoft VisualStudio

SAP Business One StudioSuite

UX Designer

• SAP Business One Studio

• SAP Business One Studio for Microsoft Visual Studio

Target Users


SAP Business One Studio - Highlights

Reduce development effort

Offer better user experience by drag & drop

Cover user/UDO/system forms (compatible screen painter file format)

Open platform for functions like SAP Business One Workflow


SAP Business One Studio for Microsoft Visual Studio -Highlights

Leverage Visual Studio (SAP Business One 9.0 supports C# only.)Design and develop user/UDO/system forms and event handling by drag & dropAdd-On code generation based on SDK UI Object Level EventShared input and output between Studio and Studio for VS


Typical Use Cases

Case1: consultant designs a Add-On form in Studio, a developer programs thisform in Studio for VS.

Case2: customer IT designs and implement a UDO in Studio for VS.

Case3: developer implements a Add-On from scratch in Studio for VS.

Case4: consultant/UI designer draw a form in Studio; a developer loads it by rawAPI.

Case5: continue developing old SRF generated from ScreenPainter in Studio forVS.






Topic 5: Add-Ons Packaging, DeploymentTopic 6: SAP Business One Integration Framework




Add-On Packaging

Pack Add-On components (including registration data file, setup etc.)

Create Add-On Installer, that must be 1 (one!) executable file

Provide Documentation

Describe User-defined fields and tables

Describe the User-defined objects you define in your Add-On (if applicable)

List where you modify SAP Business One standard functionality (if appropriate):

List where you interfere in the control flow of SAP Business One standard functionality (ifappropriate)


Add-On Deployment

Register / Install / Administrate

Develop / Create Package

Register (and install) the Add-On

Create registration data file

Create installation program

Set User Preferences

Set Company Preferences

Run-time

Compile the Add-On program

Run or Stop the Add-On

Assign Add-On Licenses to Users (if appropriate)


Add-On Administration

The Add-On Administration tool is designed to help administrators deploy and manage add-on applications on end-users workstations.

Add-Ons on the server NOTassigned to current company.

Add-Ons assigned tocurrent company.


SAP Business One Integration – B1if

Network of Solutions Supporting Network of Business and People

B1i as the platform for integration & collaboration

Integrates business partners, employees across system environmentsUnifies business processes, and automates operations across the ecosystem


B1if Components

© 2013 SAP AG. All rights reserved. 31Internal

B1i – Integration Framework of SAP Business One

B1i

The main task for B1if is to enable SAP B1to publish/send data to external systemsand to allow SAP B1 to consume/accessdata from external data provider.

ConnectivityTypesDI APIFileJDBCSMTP, IMAP, POP3

RFCHTTPWeb Service, SOAPRESTFTP

Get you up and running faster with a lower TCO

Lightweight architecture to address especially Small

Businesses (Apache Tomcat comes with B1if and installed)

Scalable due to parallel processing (by programming

model)

Multiplatform support (OS, DB … allows for connectivity

to multiple OS’s and database types)

Tailored deployment (S, M, L, – local, centralized, cloud)

Based on established integration standards (XML, XSLT,

HTTP … common technologies in the marketplace …

nothing new to learn)

Robustness due to pluggable apps/scenarios (Isolation

concept … each business scenario can run independent of

others)

Browser based administration (Remote administration)

SW logistics (Packaging, Hot Deployment, Incremental)


B1BC: Intercompany Solution

• Enables businesses running SAP Business One to manage intercompany transactions formore than one company.

• Automatically replicates corresponding transactions across multiple company databases.Automating the replication of such transactions significantly reduces the amount of end-user effort and manual rekeying of data to maintain intercompany trading financialstatements.


Market Need Solution Features Globality Technology

Data sharing

Master Data Replication

Supported SAP Business One

localizationsAustralia, Austria, Belgium, Brazil, Canada,

Chile, China, Costa Rica, Cyprus (EN), Czech

Republic, France, Germany, Guatemala,

Hungary, Ireland, Israel, Italy, Mexico,

Netherlands, New Zealand, Panama, Poland,

Russia, Singapore, Slovakia, South Africa,

Spain, Switzerland, UK, USA

Multi-CurrencyTransactions in foreign as well as local

currencies are supported

Cross LocalizationIntegration and consolidation of subsidiaries

which use different country localizations is

possible.

Bi-directional Text Support for

Israel localization

Integration

Framework

of SAP Business

One

&

add-on

components

Service Contract and Customer Equipment

Replication

UDFs and UDTs Replication

Standardizedbusinessprocessesacrosscompanies

Intercompany Trade

G/L Allocations

A/P Service Invoice Allocations

Centralized Payments

Overview overoperationsacross thegroup

Multi-Level Financial Consolidation

Intercompany Reports:Branch Inventory in Warehouse ReportConsolidated Balances by Business PartnerReportConsolidated Sales Analysis ReportBranch Balances ReportUn-posted Transaction Report

Remote Query Execution

Improvecontrol &collaborationbeyondcompanyborders

Consolidated Credit Limit Check

Intercompany Message Log

Business Transaction Notifications (Alerts)

Intercompany Workflow

How Intercompany Integration Solution tackles theneeds


B1iSN: Subsidiary & Intercompany integration


Why SAP Business One on SAP HANA

SAP HANA technology relies on main memory for computer data storage, providing fasterand more predictable performance than database management systems that employ adisk storage mechanism.The analytical features powered by SAP HANA:

Perform enterprise searches based on the SAP HANA database.Access dashboards based on the SAP HANA database.Generate pre-defined and customized Crystal reports based on SAP HANA.Perform Microsoft Excel interactive analysis.

Import and deploy customized SAP HANA models.


What is SAP Business One 9.0, version for HANA


SAP Business One 9.0, version for HANA: Architecture


What we have today … … the future

DI API for SAP HANA Service Layer for HANAUse the full power of SAP HANA on the server side without COM mediation

Reuse the standard SAP Business One business logic and localizations

Proprietary UI API Standard off-the-shelf HTML5Standard tools and technology to develop your presentation layer

Develop beautiful user experiences

Microsoft COM OData web-services

Standard state-of-the-art OData protocolDevelop web applications that are natively mobile


What we have today … … the future

Visual Studio .NET HANAStudio

Leverage the full SAP HANA development environmentUse all its advanced capabilities such as: XS, OData, XMLA, BFL and PAL, R integration, etc.

Client based integration Server sideintegration

Stay closer to your dataLeverage the multithreading capability of Service Layer: scalability and performance

Add-ons HANA extremeapplications

Go native with SAP HANABring your innovation closer to your data

Easily consume it in SAP Business One, in a browser or on your mobile


SAP Business One Service Layer - APIs format

The URI and content of HTTP request and response follow OData protocolThe payload follows JSON format.

Operation URI Request Content Response Contenton success

Login POSThttp://localhost/b1s/Login.js

Object JSON Object JSON

Logout GET/POSThttp://localhost/b1s/Logout.js

(Empty) (Empty)

Add POSThttp://localhost/b1s/Items

Object JSON Object JSON

Get GET http://localhost/b1s/Items(‘I101') (Empty) Object JSON

Update POST http://localhost/b1s/Items(‘I101') Object JSON {}

Delete DELETE http://localhost/b1s/Items('I101') (Empty) {}


Some theory - OData

http://www.odata.org

Web protocol for querying and updating data.Based on Web technologies such as HTTP, Atom Publishing Protocol (AtomPub) and JSON.

Any OData client can accessdata provided by any ODatadata source.

• Largely follows the conventions definedby REST, which define how HTTPverbs are used.

• Data can be serialized usingAtom/AtomPub or JSON.

• Allows access to an entire application-defined data model.

• Clients are free to query thismodel in any way they finduseful.

• The application's creator still hascontrol over what's exposed bydesigning the data model.

http://localhost/b1s/Login.js

http://localhost/b1s/Logout.js

http://localhost/b1s/Items


SAP Business One Extreme App Framework

A jump start development methodology and framework to enable partnerof SAP Business One ecosystem to build lightweight web application(Extreme App, or X-App) based on SAP HANA’s XS engine(ExtendedApplication Services).

http://www.odata.org/

http://www.w3.org/Protocols/

http://www.ietf.org/rfc/rfc4287.txt

http://json.org/


SAP Business One Extreme App Framework

Scope:

• Empower SAP Business One ecosystem to build easy to extend,lightweight, high performance, web-based, analyticalapplications providing business insights to actions with superbuser experiences

Value Proposition for Customers:

• Optimize the efficiency of business processes• Run directly on SAP HANA appliance with minimized TCO and

excellent performanceValue Proposition for Partners:

• Enrich traditional add-ons by web-based analytical applicationson the new lightweight framework & embed them into add-ons;

• Leverage the built-in strengths of SAP HANA and XS withintegrated SAP Business One services to develop apps in a lowcost of development on a lean stack with big data processing;explorer new businesses

9.0, version for HANA 2014

Build essentialservices andintegration with XSand access tosemantic layer

Service Layer – 9.1

Extreme app life cyclemanagement enhancement

Delivery Plan from SAP Business One:

Physical Table

Client

HANA SERVER

Crystal Report Pervasive Analysis Interactive AnalysisBOBJ Extreme Apps …

Query View

Sem

antic

Laye

rReuse View SQLScript

Control flow (JavaScript)Control Flow (JavaScript)

XSEn

gine

HTTP(S) / oDATA, XMLA, SQL, MDX

Control

flow(JavaScri

pt)BO

DIS

erve

r+**

/Ser

vice


SAP HANA XS Engine: Architecture

Consumptionmodel

Persistencemodel

JavaScript

Enable application development/deployment:• http-based UI• Run on SAP HANA• No external app. server• Best possible performance

Broaden implementation base:• Small Web-based apps

in lightweight environments• Complex, high-speed business apps

in robust environments


SAP HANA XS Engine: Built in Services

• Odata(Version 2.0)• Standardized data exchange• Drastic code reduction• Restful HTTP commands: Atom/AtomPub

or JSON

• XMLA(XML for Analytics)• Standard analytical data access

• SAP UI5• SAP UI development toolkit for HTML5• extensible UI component mode

• Server-side scripting in JavaScript• Easy Language• Built-in extensibility

• Inbound channel: http(s)• Outbound connectivity: http, smtp


SAP Business One Extreme App Framework – LoginService

RESTful web service that provides authenticationverification.It logs in the business user.

SAP Business One Extreme App Framework – LoginService Sample

<!DOCTYPE html><html>

<head><script src="jquery.js"></script><script>

$(function () {/*Login service sample code*/$("#login").click(function () {

var button = $(this);$.ajax({type: "POST",url: "../../../platform/login",data: {

"company": $("#company").val(),"username": $("#b1user").val(),"password": $("#b1pwd").val(),"language": $("#b1language").val()

},error: function (xhr, status, error) {

window.alert("login failed: " + xhr.responseText);},success: function () {

window.alert("login successfully.");}

});});

});</script>

</head>

<body><div id="container">

<h1>Login Service</h1>

<p><label for="company" style="display: block">B1 Company: </label><input type="text" id="company" value="SBODEMOUS" /><br /><label for="b1user" style="display: block">B1 User: </label><input type="text" id="b1user" value="manager" /><br /><label for="b1pwd" style="display: block">B1 Password: </label><input type="password" id="b1pwd" value="manager" /><br /><label for="language" style="display: block">B1 Language:

</label><input type="text" id="b1language" value="en-US" /><br /><input type="button" value="Login" id="login" />

</p></div>

</body></html>


SAP Business One Extreme App Framework – QueryService

RESTful web service that executes predefineduser-defined queries (UDQ) and user-definedstored procedures (UDSP).


SAP Business One Extreme App Framework – Lifecyclemanagement

• Package your extreme app.Export the package, containing the design-time artifacts and the

master data definition, from a development system.

• Deploy your extreme app.Import the package into a productive/development system, and

run it in SAP Business One.


SAP Business One Extreme App Framework – LifecyclemanagementPackaging Extreme Apps

• Section 5.2 of SAP HANA Developer Guide to set up a delivery unit.

• Section 14.3 of SAP HANA Developer Guide to assign your extreme app artifacts into a delivery unit (forexample, HTML, JavaScript, CSS, OData definition files and so on).

• Package Master Data of User-Defined Queries and Stored Procedures - Develop an add-on throughSAP Business One DI API to package the master data using the UserQueries object.

• Create Extension Registration File - run ExtensionRegDataGen.exe from SAP Business One SDK tools.


SAP Business One Extreme App Framework – Lifecyclemanagement - Deploying Extreme Apps

• Deploy the extreme app artifacts into SAP HANA.See Section 14.4 of SAP HANA Developer Guide.

• Register the extreme app to SAP Business One.

SAP Business One client Tools Extreme App Center.

• Deploy the extreme app to companies.

• Authorize users in the companies for the extreme app.• Run the extreme app in SAP Business One, for example from a browser widget.


SAP Business One Extreme App Framework – Lifecyclemanagement - Deploying Extreme Apps


Useful Links

SAP Business One 9.0 Central Informationhttp://sappartneredge.com/B1/90

B1 Innovationshttps://service.sap.com/smb/sbo/innovations

SAP Business One Integration Capabilitieshttp://sappartneredge.com/B1/b1i

SDN B1if key topic pagehttp://scn.sap.com/community/business-one-integration-technology

SAP Business One on SAP HANA Productshttp://sappartneredge.com/B1/hana


Q & A

http://sappartneredge.com/B1/90

https://service.sap.com/smb/sbo/innovations

http://sappartneredge.com/B1/b1i

http://scn.sap.com/community/business-one-integration-technology

https://websmp207.sap-ag.de/partneredge/B1/hana