Connect SAP B1 bidirectional with SAP ERP

Business Challenge

Customer is running SAP NetWeaver including some SAP R/3 systems and SAP XI. The customer’s policies do not allow direct connection to their R/3 systems. Task is to connect SAP B1 bidirectional. The customer has old fashioned EDI interfaces for inbound from an external system and is providing data for external systems in an oracle database.


Send SAP B1 changes to SAP R/3

We are leveraging the customer’s existing EDI like Flat File interface of SAP XI to send data from SAP B1 to SAP R/3. This is possible by introducing a B1iSN integration scenario “SAP B1 to File”. The inbound is SAP B1 event triggered, the outbound is defined as TXT formatted outbound file. Automatically the data is converted to the required format by the defined outbound control document. The complete conversion is based on definitions (position, length, default values, left/right justify, leading zeros, etc.). This guarantees real-time updates from SAP B1 in SAP R/3 with minimal implementation effort, high change friendliness, aligned with the customer’s policies and optimal reuse of existing interfaces.

Send R/3 data to SAP B1

The SAP R/3 is maintaining tables in an oracle database. We create a new B1iSN integration scenario “DB to SAP B1”. With each new record SAP R/3 is maintaining an ‘open’ flag. In the ‘db inbound’ we specify the scheduler to retrieve data on an hourly basis and the sql-statement to retrieve the data of interest. The ‘where clause’ makes sure to retrieve only new not yet retrieved data which is flagged as ‘open’. By the definition of the clear statement, B1iSN will automatically set this flag to ‘closed’ after successful data import in the same transaction. By xsl transformation the data is formatted to the SAP B1 XML format and imported to SAP B1 by the DI API.

Related Topics

B1i Integration Services

Business One Integration Framework (B1if)

Business One Branch Consolidation (B1BC)

Business One integration with SAP NetWeaver (B1iSN)

Integration Services

CitiXsys provides application integration services to large corporations with SAP ERP having subsidiaries, vendors and associated companies running SAP Business One.

Few companies using B1i Framework

Few companies using B1i Framework

Supply chain management applications (for managing inventory and shipping), customer relationship management applications (for managing current and potential customers), business intelligence applications (for finding patterns from existing data from operations), and other types of applications (for managing data such as human resources data, health care, internal communications, etc) typically cannot communicate with one another in order to share data or business rules. For this reason, such applications are sometimes referred to as islands of automation or information silos. This lack of communication leads to inefficiencies, wherein identical data are stored in multiple locations, or straightforward processes are unable to be automated.

Enterprise application integration (EAI) is the process of linking such applications within a single organization together in order to simplify and automate business processes to the greatest extent possible, while at the same time avoiding having to make sweeping changes to the existing applications or data structures. In the words of the Gartner Group, EAI is the “unrestricted sharing of data and business processes among any connected application or data sources in the enterprise.”

B1i Framework is the only integration framework with SAP Business One DI Adapter and integrates seamlessly SAP Business One with any application. CitiXsys is the leader of B1i integration services with largest number of B1i consultants globally engaged in several projects.

Leave a Reply