SOFTWARE DESIGN DOCUMENT
for
Automation of Exchange Rate Update in SAP
1. INTRODUCTION
This software design document (SDD) is a formal architectural blueprint for the project:
Automation of Exchange Rate update in SAP (ERS). The functions which constitute the
design of this application are discussed in detail within this document. The layout is
structured to help the reader recognize the requirements imposed upon the system and
how these requirements are being met.
1.1. Purpose
This document describes all the standards and design of ERS to be used by the
developers to follow in the implementation phase. The SDD is an important reference
not only for developers, but also for the testing programmers and editors of
documentation. With the help of standards and specifications described here, team
members can be more efficient and successful in implementing the product.
1.2. Scope
ERS is a Windows compatible application that automates exchange rate updates in SAP.
ERS will fetch exchange rate on daily basis or as per business defined frequency from
https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_r
ates/html/index.en.html website and update same in SAP. It considerably reduces the
amount of time and effort required to manually read / get data from the European Central
bank website and update in SAP. Our goal is to implement this product adhering to the
specifications, execution environment and company policy of the customer.
1
2. ARCHITECTURAL DESIGN
The following details specify which processes will be assigned to which processors,
where the data will be stored, and how much communication is required between
processors. Details provide insight to scope, concepts, logical organization of the
software and interaction between each of the software components.
2.1. The scope of the software
ERS is strictly responsible for providing a way to fetch exchange rates from
European Central Bank website on daily/weekly basis and update same in
SAP ERP
2.2. The concepts used to develop the software
ERS will be written in C# language using .Net 4.5 or above framework.
ERS will be compatible with Windows OS only.
MS SQL 2008 will be used for database purpose to log daily extraction and
SAP updates.
ABAP language will be used in SAP to create RFC which will be used to
fetch data from ERS and update SAP Database (OB08 T-Code)
2
3. SYSTEM INTERFACE DESIGN
The requirements that are proposed for ERS interface are as follows:
3.1. Application Overview
ERS is a console-based application which will be scheduled as a task on windows
platform that will fetch exchange rate information from European central bank’s website
and update in SAP. This application is not intended to be used by business user with
interface as it will be executed in background.
4. DATABASE DESIGN
At database level, there will be 2 tables defined. 1 table will act as log table for ERS data
fetching from European central bank website and other table will be used for logging
ERS’s interaction with SAP
5. FEASIBILITY AND RESOURCE ESTIMATES
This section should contain a summary of the computer resources required to build,
operate and maintain the software. (See SRS Section 2.4)
Client:
Connection to the internet/intranet (access to the Server described below)
Server:
Hard Drive Space: 200 MB
Ram: 512 MB
3
Operating System: Windows 7 and above
Supporting Software:
Web Browser
.Net Client 4 or above
MS SQL Server 2008 or above
4
6. Process Flow
