WHINT PaymentReporting Ingenico (On-Premise Edition)

This Integration Package for SAP Process Orchestration (PRO)/ SAP PI is a turn-key solution which seamlessly integrates Ingenico ePayment reporting data into SAP FI.
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.


Highlights

  • Turn-key Solution: Pre-Packaged Integration Content for SAP Process Orchestration (PO)/SAP PI
  • 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 PI 7.1 and higher

Configuration Guide: SAP PI/PO

  1. Import Integration Content (tpz) into your ESR: WHINT_PRI, <version> of whitepaper-id.com
  2. Configure the Process Integration Scenario
  • Define the account determination via value mapping (Integration Builder or NWDS/Eclipse)
  • Select the scheduling according to your needs, e.g. daily at 10 PM.
  • Configure the SAP Business System Connectivity (IDoc)

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. 


Bitcoin Currency Rates now available from Blockchain

We have enhanced our cloud edition of WHINT CurrencyRates with a new provider: Blockchain.info.

The API provides bitcoin exchange rates for the major currencies and integrates automatically into SAP (e.g. ECC/ERP/CRM).

WHINT CurrencyRates (On-Premise Edition)

This Integration Package for SAP Process Orchestration (PRO)/ SAP PI is a turn-key solution to retrieve currency rates from different data feeds into SAP Business Suite. No additional development is needed on SAP side, only a simple ALE IDoc inbound processing partner profile needs to be configured. You will receive an automatic update of the exchange rates into SAP (table TCURR) via a standard IDoc.

CRO1


Highlights

  • Turn-key Solution: Pre-Packaged Integration Content for SAP Process Orchestration (PRO)/SAP PI
  • Mapping, Connectivity and Interface Processing just needs to be activated with a few steps
  • Data provider for Currency Rates
    • ECB – European Central Bank with daily reference rates against the Euro
    • OANDA – FX Feed provides a wide range of over 190 currencies and commodities with daily, weekly, monthly or custom time periods as well as historical rates dating back to 1990

Prerequisites

  • SAP PI 7.1 and higher
  • The data from ECB is available publicly, but for other providers you might need a subscription (e.g. with OANDA)

Pricing

Terms & Conditions (On-Premise)

Yearly Subscription


Configuration Guide: SAP PRO/PI

  1. Import the Integration Content (tpz file) ESR. Result: Software Component WHINT_CRO 2016.06 will be visible.
  2. Configure the Integration Package in Integration Directory/NWDS Integration Designer by starting the wizard for Process Integration Scenario WHINT_CurrencyRates (http://whint.de/xi/CRO).
  • Select the scheduling according to your needs, e.g. daily at 10 PM.
    • In case you use WHINT MessageTrigger Job, you define this in the NWA Job Sceduling
    • If not, you set up a FILE Sender Channel, which is polling a dummy file in Test mode which is scheduled in the communication channel monitor
  • Check the FX Rates Provider URL and add your API key or credentials (if necessary)
  • Configure SSL connectivity to the https/SSL URL by downloading the CA´s and updating them into your keystore
  • Configure the SAP Business System Connectivity

CR_C8

In this example, the two CA´s (DigiCert) have to be imported into the NWA keystore (view TrustedCAs).

CRO2


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 SRTIDOCActivate Service /sap/bc/srt/idoc by executing variant IDOC_STANDARD. This is only necessary for HTTP IDoc communication. For Standard tRFC communication this step can be skipped.

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

CR_C1

Transaction WE20

CR_C2 CR_C3


Monitoring the Message Flow

Transaction BD87

CR_C4

Transaction OB08 finally shows the contents of table TCURR, the central exchange rates table in SAP. 

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. 


WHINT CurrencyRates (Cloud Edition)

SAP_ICC_Cloud

This Integration Package for SAP HANA Cloud Integration (HCI) is a turn-key solution to retrieve currency rates from different data feeds into SAP Business Suite. No additional development is needed on SAP side, only a simple ALE IDoc inbound processing partner profile needs to be configured. You will receive an automatic update of the exchange rates into SAP (table TCURR) via a standard IDoc.

CR_C5

CR_C7


Highlights

  • Turn-key Solution: Pre-Packaged Integration Content for SAP HANA Cloud Integration (HCI)
  • SAP Cloud Certified Integration Package
  • Mapping, Connectivity and Interface Processing just needs to be activated with a few steps
  • Safe and secure connectivity fully integrated in SAP´s cloud middleware – connecting to your On-Premise SAP world
  • Data provider for Currency Rates
    • ECB – European Central Bank with daily reference rates against the Euro
    • OANDA – FX Feed provides a wide range of over 190 currencies and commodities with daily, weekly, monthly or custom time periods as well as historical rates dating back to 1990
    • Blockchain.info Exchange Rates API: Currency data from the major bitcoin exchanges

Prerequisites

  • You need an existing HCI tenant from SAP where you can deploy our content. Please contact us in case you haven´t any.
  • The data from ECB is available publicly, but for other providers you might need a subscription (e.g. with OANDA)
  • You need a connectivity from SAP HCI to your On-Premise SAP system. This can be achieved e.g. with an inbound proxy like the SAP Web Dispatcher or using SAP HANA Cloud Connector. We support you getting there if needed.

Configuration Guide: HCI

  1. Import Integration Package into your HCI tenant
  2. Configure Integration Package

CR_C6

  • Select the scheduling according to your needs, e.g. daily at 10 PM.
  • Check the FX Rates Provider URL and add your API key or credentials (if necessary)
  • Configure SSL connectivity to the https/SSL URL by downloading the CA´s and updating them into your keystore
  • Configure the SAP Business System Connectivity

CR_C8

In this example, the two CA´s (DigiCert) have to be imported into the keystore which has to be deployed.

CR_C9


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 SRTIDOCActivate Service /sap/bc/srt/idoc by executing variant IDOC_STANDARD

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

CR_C1

Transaction WE20

CR_C2 CR_C3


Monitoring the Message Flow

Transaction BD87

CR_C4

Transaction OB08 finally shows the contents of table TCURR, the central exchange rates table in SAP.