Specialised Customer Group Topics

hello John SinghIntegrating into SAP using Netweaver Gateway ODATA services

SPAR Group LTD

about John SinghJohn Singh is a Senior Systems Analyst at the SPAR Group LTD. John has a Bsc in Computer Science.He has over 20 years of software development experience with 5 of those years in an SAP environment.John has been actively involved in designing and building the integration architecture at SPAR for thelast 10 years. His current focus is on integration into SAP from various enterprise systems that updateor require SAP data.

Agenda

Spar landscape and context

Brief introduction to ODATA services

SAP Developer Tools

Lookup Services

ODATA Business Partner Service

Extending the standard business partner service

Authorizations

Lessons Learnt

SPAR Landscape

BPM UI – IIS

Angular App

HTML5

MDM data access

.net APIs

MDM Database

SQL Server

BPM Process

IBM Process

Server

Integration Broker

IBM

Integration

Bus

PDF Doc Store

Sharepoint

Online

SAP Back End

SAP Hana

17.09 ABAP

SAP Front End

SAP Gateway

PDF Generator

Docmosis

Master Data Business Process

Create Business Process

StartSubmit

Request

DC

Approver

Gate

Keeper

Create

MDM

Create

SAP

Create

AS400

Introduction to Netweaver Gateway

ODATA

SAP Gateway

SAP BUSINESS SUITE

FI PM

Modern Business Application

Integration

Security

Lower TCO

Introduction to ODATA

Rest

Client Server Architecture

Statelessness

Rest

Cacheability

Layered System

Rest

Uniform Interface

Code on demand

REST commands

PUT

POST

GET

MERGE

PATCH

DELETE

SAP Developer Environment and Tools

Frontend Server

Gateway, Launchpad, Fiori apps

/IWFND/MAINT_SERVICE: Create

route to ODATA service on backend.

Also has HTTP client for testing

Backend Server

Business Logic (RFCs, database)

SEGW: Create the ODATA service on

the backend server. Consume

existing code or create new code.

Trusted

Connection

SE80: ABAP Workbench – Create

new code as required by the ODATA

services

HTTP Client

Service Gateway

Service Lookups

BPM UI – IIS

Angular

App

HTML5

Gateway FrontEnd Gateway BackEnd

Store

Format

Store

Status

Country

Lookup

Province

Lookup

Country

Lookup

Address

Types

BEE Cat

BEE

Level

Bank

Names

Branch

Code

CompnyAccount

Clerk

Comp

Type

Country

Lookup

Currency

Payment

Method

Payment

Term

Sales

Org

ODATA RFC

ABAP Class

ABAP

Method

SAP TABLES

SQL

Business Partner Design

Store Group Partner Type

ZSSG

Store

Partner Type ZSTC

Store Account Partner Type

ZSSA

Store Account Partner Type

ZSSA

Store

Partner Type ZSTC

Store Account Partner Type

ZSSA

Business Partner LUW

Extending Standard BP API

Accounts: Store accounts with different payment methods

Communication Notes – Use for storing contact names

Credit Management – Credit limit information

Customer fields not on standard BP API

Customer Company fields not on standard BP API

Sales organization fields not on standard BP API

Supplier fields not on standard BP API

Supplier Company fields not on standard BP API

High Level Design

Integration Bus

POST JSON PAYLOAD

ACTION = CREATE or

UPDATE MIGRATE

Create Store

BP

Create 1 to

N Account

BP’s

Create

Update Update

Store BP

Update 1 to

N Account

BP’s

MigrateMigrate

Store BP

Create 1 to

N Store BP’s

Enhancement Spots

CV

I cu

sto

m M

ap

pe

r

Map BP To Customer

Map BP To Vendor

USER Authorizations

ROLE DESCRIPTION

ZE:IT:BPM_TRUSTED_RFC Enabler role for BPM trusted RFC

ZE:IT:BPM_WEBSERVICE Enable role for BPM Web Service System Users

ZS:FI:BP:COMMON_DSP_ALL FI:BP – Business Partner Common Display

ZS:FI:BP:MSTR_DATA_MNT FI:BP – Vendor and Customer Master data maintenance

ZE:IT:BPM_RFC Enabler role for BPM RFC Function Groups

ZS:MM:RTL:SITE_MNT MM:RTL – Site Maintenance

ZE:FI_ALL_DSPL Display enable role for all company codes

ZE:FI:ALL_MNT Display enabler role for all company codes.

Lessons Learnt

1

Standard ODATA services may not meet requirements.

Good skilled resources are hard to find.

2

Take time to understand the requirements and blueprint.

It will always take longer than you think.

3

Ensure that internal skills are developed during the project.

Work out the roles and authorizations as early as possible

contactdetailsName : John Singh

Company : SPAR Group LTD

Email : john.singh@spar.co.za

Contact # : 082 922 6361

Website : Http://johnsingh.biz

thank you