Detailed SAP Interface Design Fundamental Document
Detailed SAP Interface Design Fundamental Document
Detailed SAP Interface Design Fundamental Document
doc
In real-time business scenario a company can have a centralized system where all
related information can be maintain (like financial data, HR Master data etc.) There is
always a need to communicate with the third party vendors or with legacy systems
to supply information from the centralized information system .Need could be to
provide employee detail to the third party vendor (lets say CIGNA)so that ,they can
run the benefit function on behalf of company. Or employee data needs to be passed
on to legacy system to run the payroll. Similarly partial hiring process could be
handling by third party vendor and then data can feed over to SAP.
This document talks about such scenarios where SAP is the Centralized information
system. One of the ways to establishes a communication from SAP to Legacy/Vendor
system or from Legacy/Vendor systems to SAP could be by designing an interface
between the two systems.
Types:-
Interface can be of categories in 2 types depending upon the direction of data flow.
Inbound – If SAP is the receiver system with respect to the Legacy systems/Vendor
system then this would be an inbound interface.
Outbound – When SAP is the sender system i.e. data is going from SAP to legacy
system /Vendor system then this would be an outbound interface.
Use of Middleware: - Interface can be designed to directly send data to third party
or by using a middleware like XI, depending upon the business requirement. For
example if employee data to be send on regular basis to different banks for
processing employee salary and information format differ for each bank while data
remains the same. Here XI, as a middleware suffices the purpose by formatting data
in required format as per different third party systems. While if business need is to
just send lets say education data to Data Mart then it can directly be send to Data
Mart without using middleware .So it depends upon the context. There are number of
middleware available in the market for that matter.
These exchanges take file/s from SAP and put it into the third party server
(Outbound) OR take file from the third party server and place it to SAP Application
server (Inbound) and that how the process gets automated.
1. Do we have to send full file (entire population data) or change file or both?
2. If change file required- comparison needed between current data and prior
run data. Do we want to do previous file vs. current file comparison or should
we add previous entries to custom table?
3. What should be the naming convention of files (Full /change files)?
4. What should be the file format (Fixed or Variable file format)?
5. Any header requires preceding the file or following the file?
6. What should be the file length i.e. how many characters?
7. What should be the naming convention of generated file?
8. Is there data and time stamp needed with the file name?
9. What should be the file type i.e. whether it would be txt file, excel file or CSV
file etc.?
10. Should it go to EDI?
11. If yes, do we need to have option of check box to decide when to send and
not to send it to EDI?
12. Whether the total file length included header character or not?
13. What would be the selection criteria (i.e. for active/inactive pernr or Molga
etc)?
14. Whether it would require fetching latest record or require multiple record
handling?
15. What should be the corresponding field mapping to SAP?
16. Do we require mechanism to handle special characters in data?
17. What should be the run date –system date or record Changed date?
18. Do we need to have date range option in the selection screen?
Testing:-
If Outbound:-
4. Do the generated files contain the expected fields?
5. Do the generated files fetching the appropriate data from different
infotypes/tables?
6. Does all headers appearing in correct text/name, in correct sequence.
7. Does data under every header column appearing correcting?
8. Dose the generated file contains required no of characters?
9. Dose every field is of desired length?
10. Check if file is going into right directory?
11. Check for the file format.
12. If archiving the file then check is it getting "replaced "or "copied "(as per
the requirement)?.
13. Do the file is going to EDI/MQ FTE server when option to send them
selected?
14. Is the third party vendor receiving the file?
If it inbounds:-