Scenario Package

The LS One SAP Business One HANA Scenario Package includes all scenarios needed for LS One to send and retrieve the required data to and from SAP Business One HANA. Each scenario makes use of SAP Business One HANA's API, the Service Layer, to send and receive data to and from SAP.

For some scenarios we use a service on top of the Service Layer, the Semantic Layer, which enables us to make direct calls through the Service Layer API to our customized HANA calculation view models.

We can divide the scenarios in the scenario package into three categories depending on their functionality. Below you can find a list of the LS One data scenarios, along with the names of the relevant HANA calculation views and a short description.

Data replication scenarios

The sync scenarios make calls via the Service Layer and most scenarios utilize the Semantic Layer to retrieve necessary data from the custom HANA calculation views stored in the SAP Business One HANA Client. They select data from the specified tables in the SAP Business One HANA database and send to LS One's SAP Business One HANA connector which then saves the data to the LS One database.

 

HANA Calculation View(s) or Service Layer object	LS One scenario	Description
BARCODE_SYNC	BarcodesSync	Retrieves item barcode data.
CURRENCY_SYNC	CurrencySync	Retrieves all currencies and their rounding settings.
CUSTOMER_SYNC, CUSTOMER_ADDRESS_SYNC	GetCustomers	Retrieves customer information (name, ID, addresses, tax information, etc.).
EXCHANGE_RATES_SYNC	ExchangeRatesSync	Retrieves currency exchange rates.
PRICE_GROUP_SYNC	PriceGroupSync	Retrieves the names of price lists and creates an LS One price group for each one.
RETAIL_GROUPS_SYNC	RetailGroupSync	Retrieves the names of item groups and creates an LS One retail group for each one.
RETAIL_ITEM_SYNC	RetailItemsSync	Retrieves item master data and creates an LS One retail item for each one, with the item's image (if there is one) from SAP Business One HANA.
UNIT_SYNC	UnitSync	Retrieves all units of measurements and creates an LS One unit for each one.
UNIT_CONVERSION_SYNC	UnitConversionSync	Retrieves the conversion factors from synced units of measurements.
TAX_GROUP_SYNC, TAX_VALUE_SYNC	TaxSync	Retrieves all tax groups and tax rates.
TRADE_AGREEMENT_SYNC	TradeAgreementSync	Retrieves price lists for each item in SAP Business One and creates a trade agreement entry in LS One.
InventoryTransferRequests	SyncInventoryTransfer- Requests	Gets inventory transfer requests from SAP and saves to LS One if there are new requests or any changes have been made to a request.
PickLists	SyncPickLists	Gets pick lists from SAP and saves to LS One if there are new pick lists or any changes have been made to a pick list.
InventoryTransfers	SyncInventoryTransfers	Gets inventory transfer documents from SAP and saves to LS One if there are new inventory transfers or any changes have been made to an inventory transfer document.

 

Data retrieval scenarios

The following scenarios are getting data from SAP Business One HANA in real time and used for initial setup of the integration and for viewing on-hand inventory status. Similarly to the previous scenarios, they use the Service Layer along with the Semantic Layer to make calls to custom HANA calculation views to retrieve the necessary data.

 

HANA Calculation View(s)	LS One scenario	Description
COMPANY_INFO_GET	GetCompanies	Retrieves information about your company such as name, address, phone number, currency code etc.
CREDIT_CARDS_GET	GetCreditCards	Retrieves all credit cards from SAP Business One HANA that then need to be manually mapped to an LS One payment and card type.
GL_ACCOUNT_GET, GL_ACCOUNT_PARENT_GET	GetGLAccounts	Retrieves the G/L Accounts and their respective parent accounts from SAP Business One HANA that are required for sending sales and returns back to SAP Business One HANA. These accounts need to be manually mapped before any transactions are posted.
INVENTORY_SYNC	GetInventoryStatus- ForItemAndStore	Retrieves the current inventory status of an item in a store.
WAREHOUSE_SYNC, LOCATION_SYNC	Warehouse	Retrieves all warehouses from SAP Business One HANA that then need to be manually mapped to an LS One store.

Data posting scenarios

LS One sends data to SAP Business One HANA using the following scenarios to create documents and payments on the SAP Business One HANA side. The Service Layer is used for posting data from LS One to SAP Business One HANA.

 

Service Layer API data object	LS One scenario	Description
CreditNotes	PostCreditNote	Creates a credit note document for each return transaction made in LS One that hasn't been posted yet and posts the documents to SAP Business One HANA.
Invoices	PostInvoice	Posts an invoice to SAP Business One HANA.
IncomingPayments	PostIncomingPayment	Posts unposted incoming payments to SAP Business One HANA.
VendorPayments	PostOutgoingPayment	Posts unposted outgoing payments to SAP Business One HANA.
InventoryTransfer- Requests	PostInventoryTransfer- Request	Posts inventory transfer requests to SAP Business One HANA.
PickLists	PostPickList	Posts sent LS One store transfer orders to SAP as pick list.
InventoryTransfers	PostInventoryTransfer	Posts received LS One store transfer orders to SAP as inventory transfers.

Other scenarios

There is one scenario that does not fit to any of the categories above and that is the Ping scenario. It is used to verify the connection between the LS One Site Manager to SAP Business One HANA and back.

 

LS One scenario	Description
Ping	Tests the connection between LS One Site Manager and SAP Business One HANA.