Runtime Variables Overview for SAP Cloud Platform Integration (HCI)

This is an overview of useful and commonly used (dynamic) variables and runtime parameters of SAP Cloud Platform Integration (f.k.a. SAP HCI) based on Apache Camel´s expression language.

SAP Help: Headers and Exchange Properties

Those variables can be used in Integration Flows (e.g. in artifacts as Content Modifier, Router, Channels, …):

ParameterDescription
${in.body} or ${body}Message Payload
${header.var1}Message Header Variable (var1)
${property.prop1}Exchange Property (prop1)
${date:now:yyyy-MM-dd}Current Date/Time with format
${property. SAP_MessageProcessingLogID}Message Guid
${CamelFileName}File Name
${CamelHttpUri}HTTP URI (URL with QueryString)
${CamelDestinationOverrideUrl}SOAP Adapter URL
${exception.message}Error Message
${exception.stacktrace}Error Stacktrace

WHINT B2G VAT Check

Businesses in the European Union can check the VAT (value added tax) identification number (id) of their trading partners to make sure the companies are still operating, in business and the information provided is valid.

Our solution enables companies using SAP to automate the checks directly from their ABAP-based (ERP, CRM, SRM, S/4HANA) system.

Highlights

  • Business-To-Government Communication (B2G)
  • Turn-key Integration Content
  • Automatic check of European VAT id based on the master data or single id
  • Service Providers
    • BZSt (Germany) – Bundeszentralamt für Steuern: Bestätigungsverfahren Umsatzsteuer-Identifikationsnummer (USt-IdNr.)
    • VIES (European Commission) – VAT Information Exchange System: VIES VAT number validation

Prerequisites

  • The government services are publicly available, no further charges apply
  • Cloud Edition: You need an existing CPI (f.k.a. HCI) tenant from SAP where you can deploy our content. Please contact us in case you haven´t any.

Cloud Edition
Integration Content for SAP Cloud Platform Integration

Configuration Guide for CPI

  1. Import the ZIP Archive provided by Whitepaper InterfaceDesign into your SAP Cloud Platform Integration Tenant
  2. Deploy both artifacts (Integration Flow & Value Mapping) without changing anything.
    • In case you prefer certificate-based authentication from your SAP ABAP system, you have to change the Authorization in the SOAP Sender Channel from “User Role” to “Client Certificate”
  3. Check the SOAP URL under Monitoring ->  Manage Integration Content -> “WHINT B2G VAT Check EU ID” and note it down for the SAP ABAP system configuration

You can obtain the Integration Content here:


On-Premise Edition
Integration Content for SAP Process Integration (PI) / SAP Process Orchestration (PO)

Configuration Guide for PI/PO

  1. Import the TPZ Archive provided by Whitepaper InterfaceDesign into your ESR
  2. Configure the iFlow/Integrated Configuration/Receiver Determination manually using the following artifacts of ESR Software Component “WHINT_VAT 2017.04 of whitepaper-id.com”
    1. Sender System: <Your SAP ABAP System>
    2. Sender Interface: VATIDCheckQueryResponse_Out (http://whint.de/xi/VAT/SAP)
    3. Sender Communication Channel: Apply Template
    4. Receiver Party: BZSt
    5. Receiver System: BZSt_API
    6. Content Based Routing: XPath //ProviderID=”BZSt”
    7. Operation Mapping: VATIDCheck_BZST (http://whint.de/xi/VAT/B2G/DE)
    8. Receiver Communication Channel: Apply Template REST_RCV_<version> (http://whint.de/xi/VAT/B2G/DE)
    9. Receiver Party: EuropeanCommission
    10. Receiver System: VIES_API
    11. Operation Mapping: VATIDCheck_VIES (http://whint.de/xi/VAT/B2G/EU)
    12. Receiver Communication Channel: Apply Template SOAP_RCV_<version> (http://whint.de/xi/VAT/B2G/EU)
    13. Content Based Routing: XPath //ProviderID=”VIES”

You can obtain the Integration Content here:


Configuration Guide: SAP Business Suite (ABAP)

  • Import the ABAP Transport provided by Whitepaper InterfaceDesign by
    1. extracting the ZIP file into the directories /usr/sap/trans<data/cofiles>
    2. adding the transport via transaction STMS (Extras->Other requests->Add)
  • On-Premise Edition (SAP PI/PO)
    • no further setup necessary as long as your ABAP proxy runtime is configured to exchange data with your PI/PO Integration Engine/Adapter Engine
  • Cloud Edition (SAP Cloud Platform Integration)
    1. Enter the “Web Service Configuration” (transaction SOAMANAGER -> Service Administration)
    2. Select Consumer Proxy “/WHINT/CO_VATIDCHECK_QUERY_RES”
    3. Create Logical Port (name e.g. “CPI”) as “Manual Configuration”
    4. Mark the Logical Port as Default
    5. Select the Authentication
      1. User ID/Password: (S-User which is enabled on your CPI tenant with User Role “ESBMessaging.send”) or
      2. X.509 SSL Client Certificate
    6. Enter the URL under Transport Binding (URL Path, Host, Port, Proxy (If necessary))
    7. Select “Suppress ID Transfer” in Message ID Protocol
    8. Activate

 

WHINT InterfaceCatalog as a Service (IFC aaS)

 

You are interested in Transparency about your Interface Landscape on SAP PI/PRO and would like to receive an Interface Catalog with all your flows including their routing and mapping information as well as a Channel Catalog which shows you all your Communication Channels? Then you need the WHINT InterfaceCatalog.

In case you hesitate installing the solution into your landscape, you can also retrieve this information on demand as a service.

IFCaaS6

In this case, SAP HCI is retrieving the Integration Configuration from your SAP PI/PO system(s) and sends you an E-Mail with the Excel Sheets attached.

IFCaaS5

If your SAP PI/PRO system allows HTTPS inbound communication from the internet (via an external IP-Adress, e.g. using SAP WebDispatcher and/or a Decentral AdapterEngine), we can start right away. If not, you can make use of the convenient SAP Cloud Connector, which creates a lightweight VPN tunnel from your On-Premise landscape into the SAP Cloud. Please follow the configuration below.

What we need in any case is a service user to access your SAP PI/PRO system (having the roles SAP_XI_API_DISPLAY_J2EE and SAP_XI_APPL_SERV_USER) as well as the URL of your system (externally exposed or the internal host via Cloud Connector).

Please contact us under: solutions@whint.de


This schema shows the Onboarding process for the WHINT InterfaceCatalog as a Service:

IFCaaS1


Configuration Guide for SAP Cloud Connector:

  1. Install SAP Cloud Connector from https://tools.hana.ondemand.com/#cloud. In case you have a Cloud Connector in place already, you can add an additional account – please proceed with step 3
  2. Launch Admin Cockpit on https://localhost:8443/
    • First time login using initial credentials Administrator/manage
  3. Add the account provided by whitepaper.id to your dashboard (Define Account)
  4. Add the SAP PI/PO system you want to expose (Cloud To On-Premise: SAP Process Integration)
  5. Add the URL Services (Resources)
  6. Connect to https://account.hana.ondemand.com/cockpit and check the status of the Cloud Connector

IFCaaS7

IFCaaS2

IFCaaS3

IFCaaS4

WHINT PaymentReporting Ingenico (Cloud Edition)

This Integration Package for SAP HANA Cloud Integration (HCI) is a turn-key solution which seamlessly integrates Ingenico ePayment reporting data into SAP FI (Ingenico ePayments was formerly known as GlobalCollect).
It enables the automatic processing of the Ingenico Collection Appendix Report as SAP FI documents with state-of-the-art integration technology. No changes or developments are required on SAP ERP side, only a few configuration steps are needed (ALE IDoc inbound processing).The accounting documents will be created automatically via a standard IDoc. Other Reports (Financial Statements) can be picked up automatically as well and e.g. sent via E-Mail.

It enables the merchant to process and reconcile payment processing data and match it with his transactional order-related data in SAP Finance.

PRI_HCI


Highlights

  • Turn-key Solution: Pre-Packaged Integration Content for SAP HANA Cloud Integration (HCI)
  • Mapping, Connectivity and Interface Processing just needs to be activated with a few steps
  • Data provider for Payment Reporting 
    • Ingenico ePayments is the online and mobile commerce division of Ingenico Group – connecting merchants and consumers, enabling businesses everywhere to go further beyond today’s boundaries, creating the future of global commerce
  • How it works
    • The regular sales transactions (e-commerce, retail, …) are posted into SAP Finance using the transaction id of Ingenico against credit card/payment type specific G/L accounts (Debit)
    • The payment reporting data is also posted into SAP Finance against the same G/L accounts using the same allocation number (Credit). Like this, the postings can be reconciled easily. The total balance is posted on a receivables G/L account (Debit) which can be reconciled against the financial statement coming from the electronic bank statement.
    • The solution handles the creation of the SAP FI accounting document by picking up the Ingenico Collection Appendix Report and converting (mapping) it automatically.

Prerequisites

  • SAP HANA Cloud Platform, integration service (SAP HCI)

Configuration Guide: SAP Cloud Platform Integration (CPI aka HCI)

  1. Import Integration Package into your HCI tenant
  2. Configure Integration Package
  • Select the scheduling according to your needs, e.g. daily at 10 PM or every hour.
  • Check the SFTP Address and provide your credentials
  • Add User Credentials under Monitoring -> Security Artefacts
  • Add the SFTP Public Key into the known_hosts file and deploy it under Monitoring -> Security Artefacts
  • Configure the SAP Business System Connectivity
  • Maintain the Value Mappings for Account Determination, … tbd.

Configuration Guide: SAP Business Suite 

  1. Check if IDoc-XML Messages can be received
  2. Create ALE Logical System
  3. Create partner profile for IDoc

Transaction SALE: Add your logical system name which represents the data provider (e.g. INGENICO)

CR_C1

Transaction WE20: Maintain Message Type ACC_DOCUMENT for partner (LS) INGENICO with process code BAPI.


Monitoring the Message Flow

Transaction BD87 shows the processed IDoc

Transaction FB03 finally shows the accounting document in SAP.