Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.

0
Interface++SD+Material+Master

Practice SAP ABAP-SD

Material Master Z* Interface Functional Spec

https://www.tutorialspoint.com/sap-sd-ricef-
objects-and-development-with-functional-
specs/index.asp

https://www.linkedin.com/in/santharamz/
Functional Design Documents Version: 1.0

Table of Contents

Functional Design ......................................................................................................................................... 3

Document Information ................................................................................................................................... 3
Document History .......................................................................................................................................... 3
Change Log ............................................................................................................................................... 3
Approval/Sign-off ....................................................................................................................................... 3
Overview and Scope ..................................................................................................................................... 4
Functional Description ............................................................................................................................... 4
Assumptions .............................................................................................................................................. 4
Detailed Functional Requirements ................................................................................................................ 4
Functional Specification ............................................................................................................................. 4
Process Flow Diagram .............................................................................................................................. 6
Extension Layout ....................................................................................................................................... 6
Input and Output ........................................................................................................................................ 6
Required SAP Transactions .................................................................................................................. 6
Input Parameters ................................................................................................................................... 6
Method to Retrieve Input Parameters .................................................................................................... 7
Output Parameters................................................................................................................................. 7
Method to Release Output Parameters (Output Type) .......................................................................... 7
Method to Update Existing Run Parameters with Latest Run Information ............................................ 7
Reporting ................................................................................................................................................... 7
NA 7
Initial Data Set-Up/Conversion Requirements........................................................................................... 7
Existing Sample Program(s) ...................................................................................................................... 8
Process and Operational Considerations .................................................................................................. 8
Network Integration ................................................................................................................................ 8
Performance .......................................................................................................................................... 8
Processing Type .................................................................................................................................... 8
Re-use Details ....................................................................................................................................... 8
Expected Transaction Volumes ............................................................................................................. 8
Error Handling ........................................................................................................................................ 8
Security and Authorization ..................................................................................................................... 8
Purge and Archive Considerations ........................................................................................................ 8
Multi-company, Multi-jurisdiction Considerations .................................................................................. 8
Other ...................................................................................................................................................... 8
Change Management Requirements ........................................................................................................ 8
Testing Requirements ................................................................................................................................... 9
Key Business Test Conditions ................................................................................................................... 9
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Technical Test Conditions ......................................................................................................................... 9

Testing Considerations/Dependencies ...................................................................................................... 9
Outstanding Issues ....................................................................................................................................... 9
Appendix ....................................................................................................................................................... 9
Glossary of Terms ..................................................................................................................................... 9
Additional Supporting/Reference Documentation ..................................................................................... 9
Solution Review Board input ......................................................................................................................... 9
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Functional Design

Document Information
Extension Name Material Master Interface
Functional Area SD
Functional Designer Siva
Developer Ram

Document History
Change Log
Name Change Date Version

Approval/Sign-off
Name Role Date Signature
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Overview and Scope

This document includes functional requirements and some implementation details. It is possible that
some implementation details might be adjusted in the technical design.

Functional Description
The purpose of this Interface development is to create a Flat file in AL11 reference to the Materials used
in Sales order document created. This enables users to process the last used active material in Sales
Order.

Additional requirements to download the flat file at AL11.

Processing within SAP

A custom transaction code, ZSD_MAT_AL11, will be created and linked to an ABAP program
ZSD_MAT_AL11_TRN to create an FF reference to active Materials used in sales document.

Dependencies/Constraints

Assumptions

The volume of Materials is created and processed based on additional sales org & plants view.

Detailed Functional Requirements

Functional Specification

Source

The source of Material master data comes from multiple systems. The output file will contain material
master and data pertaining to multiple sales Order lines.

File specification:
AL11 Data download

SAP Process

This program will have the following fields in the selection screen:
• File Name: Input the Flat file name data to process.
Fields entered in selection screen are validated and any errors are reported leads to execution stoppage.
 Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Fields from the following need to be in the Flat file report in the following order:

Materi Mater Indus Plan Maint Storag Fiscal Sales Short Mat Sale Dist Divi
al ial try t enanc e Year of order Text erial s ribut sion
Numb Type secto e Locatio Curren docu grou org ion
er r status n t ment p Cha
Period nnel
000000 ZVSH P 1000 VDB 0001 2021 00000 vasu 017 1000 10 00
000000 00011
000504

Output of the Report: AL11 file downloaded.

Log
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Process Flow Diagram

MM data extract
ZSD_MAT_AL11_T
RN
Program

Material Master Storage Location, Purchase

(MARA/MARC) order (MARD/VBAK/VBAP)

AL11 output Download

Extension Layout
None required.

Input and Output

Required SAP Transactions

ZSD_MAT_AL11 & SE38.

Input Parameters

Input (Parameters) Needed Description and Prior Dependency Validation

Flat file (Mandatory) No flat file input at selection screen. Information msg:
WRONG
PARAMETER:
FILE_NAME
Material (Optional) Input FF location and Material is blank Error msg: Enter
Material
Flat file, Material is filled Input FF, Material details Success msg: File
downloaded
successfully.
Flat file Material is filled Input FF, Invalid Material details Error msg: Invalid
material.
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Method to Retrieve Input Parameters

Output Parameters

Output (Parameters) Needed Description and Post Dependency

Screen output of report None
ALV report of line item display. None
Download report contents to None
presentation server

Method to Release Output Parameters (Output Type)

Program log may be printed or downloaded to file using standard SAP menu:

Method to Update Existing Run Parameters with Latest Run Information

The program log should be examined to ensure that the right Orders get displayed in the report. For
further details, please see the ‘Error Handling’ section.

Reporting

NA

Initial Data Set-Up/Conversion Requirements

After extraction of Material Master reference to SO, if the Sales order record is not found then those
materials should mark as inactive in Material master. ( a real time Business use case)
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Existing Sample Program(s)

No sample program available.

Process and Operational Considerations

Network Integration
No network integration considerations.

Performance
Performance is dependent on the number of records retrieved. Foreground processing of the report
should not exceed time out setting for online processing. Report can also be run in background.

Processing Type
Foreground & Background processing should be possible.

Re-use Details
Rerun the program for the same selection.

Expected Transaction Volumes

This will vary based on the number of Orders created for the processing period.

Error Handling

In case of errors, rerun the program for the same selection.

Security and Authorization

The transaction code should be featured in the same authorization profiles as Report transaction, SE38.

Purge and Archive Considerations

Multi-company, Multi-jurisdiction Considerations

Other

Change Management Requirements

Range of use

Number of Line items

There is no limit to the number of line items that can be present in an Order and displayed in report
output.
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Testing Requirements
Key Business Test Conditions

ID Condition Expected results Actual

Result
1 Input field validations for all fields Input field validation is done and
standard field validation errors
handled.
2 Msg list displayed. Check fields displayed in output after
data validation.
3 Error with program execution Rerun the program for the same
selection.

Technical Test Conditions

ID Condition Expected results Actual

Result

Testing Considerations/Dependencies

Outstanding Issues
Issue Description Assigned To Status Impact Resolution
No

Appendix
Glossary of Terms
Term Definition

Additional Supporting/Reference Documentation

Solution Review Board input

Input Comments
Technical Details This document contains functional requirements and some technical
implementation details. These implementation details are subject to
change in the technical design.
Functional Design Form MM Data InterfaceRICEF_FS+Z- Version: 1.0
Interface++SD+Material+Master

Input Comments
Estimate An estimate of work effort needs to be included in the technical
design. The design of this solution should be kept technical simple
and we should encourage users to minimize the use of the upload
process.