FSDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD

FSD Sample

1. Functional Specification document
Project Identification

2. Project Name Project Code
Tex4life 951
Customer Name Customer Number
Yunus Textile Mills -
TMC Project Manager Customer Project Manager
Zia Abdullah Asghar Amin
Version Control
Version # Revision date Revision Author Description
Approval
Role Name Designation Signature and Date
Author Abbas Rana Associate CO - Consultant
06.12.2024
Reviewers
Approver
Distribution
Name Role / Position

3. Description of Business Requirement
The purpose of report is to see the P&L of goods transferred from spinning to weaving, local and
Export at Unit wise level (Storage location wise bifurcated).
PNL Plant
Profit
Centre
Storage
locations
Cost Centre Ranges for Selling/ Admin
and Other Operating Expenses (From-To)
Spinning YTM6
Unit 1 1000 1000 1037 & 10381006010101 1006010318 
Spinning YTM6
Unit 2 1000 1000 1042 & 10431006020101 1006020318 
Spinning YTM6
Unit 5:
Autocoro 1000 1000 1046 & 10471006050101 1006050318 
YTM 9 Unit 1:
Consolidated1100 1100 1125 & 11261109010101 1109010407  
Impact If WRICEF Not Implemented
Standard Functionality Availability

4. Technical Requirements
Type of Object
W-Workflow R- Report
I – Interface C - Conversion
E-Enhancement F-Form
R
Priority H
File and location of the attached Format
Tables/Info type Used
Specify the Selection Criteria to trigger
the Approval
Create Sample Data to Run the report
after development to see the results
Additional Details If Available
Enhancement Type

5. FM Exit
Screen Exit
BADI
Table Enhancement
Menu Exit
BTE
Field exit
Append Search help
Implicit Enhancement
Process Requirements (Validations/ Selection Criteria)
Controlling area (One Controlling area: 1000)
company code (One company code: 1000)
plant (We have 2 plants i.e 1000 and 1100)
Storage location (The P&l is required unit wise and we have unit wise storage locations as mentioned
above)
Period
Fiscal Year
Financial Cost 
Formulas/ Calculations/ Rules

6. Output Fields Description
Report Field Name
Field Location
(Specify field location on SAP with t-code and steps required to read this field.
Mention the formulae, in case if this is calculation field)
Net Sales The net sales will be distinguished into Local /Transferred/ Export and
wastages.
The formula for net sale calculation will be sales price multiply by the sales
quantity.
Sales Price logic:
Price Per lbs.
(Transferred)
Total Quantity of lbs. transferred to weaving
[Total transfer Qty from 1000/1100 to 2000/2100 plant]
Get the Total quantity (ERFMG) transfer from Plant 1000 to 2000 & 2100 plant
from table MSEG, where BWART = ‘351’, WERKS = ‘1000’, Storage location:
‘LGORT’ (1037,1038) to UMWRK(Plant) = ‘2000 & 2100’ & Storage location
‘UMLGO’ for the month from posting date (BUDAT_MKPF) which is to be equal
to Period provided in input-selection parameter, from the table (MSEG).
Sales amount: Total Quantity multiply by Price per Lbs

7. (Local)
Total Quantity. sold locally with reference to Sale Order:
Get the Material (MATNR) by Plant (WERKS: 1000) for Storage locations
(LGORT:1037 & 1038) and the Profit Centre (PCTNR: 1000), read the Billing
Document (VBELN), sales document (AUBEL) and Distribution Channel
(VTWEG_ANA: 20-local) and Fetch the Sales/Net value (NETWR), for the period
from Posting date (FKDAT_ANA) which should be equal to Period provided in the
selection Parameter from table "VBRP”.
(Export)
Total Quantity. Sold externally with reference to Sale Order
Get the Material (MATNR) by Plant (WERKS: 1000) for Storage locations
(LGORT:1037 & 1038) and the Profit Centre (PCTNR: 1000), read the Billing
Document (VBELN), sales document (AUBEL) and Distribution Channel
(VTWEG_ANA: 10-Export) and for the period from Posting date (FKDAT_ANA)
which should be equal to Period provided in the selection Parameter and Fetch
the Sales/Net value (NETWR), from table "VBRP".
(Wastages: direct sales amount will be fetched from the below logic)
(Wastages): Fetch sales amount field (NETWR) for Plant (WERKS:1000) from
Storage Location (LGORT: 1037 & 1038) for Billing type (FKART_ANA: ZYRW)
for the period from Posting date (FKDAT_ANA) which should be equal to Period
provided in the selection Parameter. (ZWST)
Cost Of Sales Apply the formula for cost of sales for all the materials used separately for local
sales, Transfer and export.
(Material cost per qty * Total Quantity Transferred/ Locally sold/ Exported)
The logic for Material Cost per Qty will be same for all three.
(New logic:
Pick the Cost Price from field "VERPR" for the Material by Field "MATNR" which
is equal to the "MATNR" in the sales Logic for the Plant "BWKEY" which is
equivalent to the Plant in selection Parameter. From table MBEW)
Material cost per Quantity: Fetch the cost per quantity of Material from Table
“/FMP/V_MP_CR_E”, use field material (MATNR) for its Cost/PUP (PVPRS) for
the period (POPER: the period should be the one mentioned on the Selection
screen input) and Fiscal year (BDATJ: the Fiscal year should be the one
mentioned on the Selection screen input) ( The plant should be equal to the plant
in VBRP and MSEG table Plant for the Material (MATNR) ; In table
“/FMP/V_MP_CR_E” use Field Plant/Valuation Area (BWKEY).
I.Quantity Transferred: (The quantity transferred from Plant (1000) to
Plant (2000) via Storage Location (LGORT: 137 & 138), Get the Material’s
(MATNR) and its total quantity from Field Quantity (ERFMG) from Sender
Plant (WERKS: 1000), where the Profit Centre (PRCTR: 1000) by the field
movement type (BWART: 351) to the Receiving Plant (UMWRK: 3000),
for the month from posting date (BUDAT_MKPF) which is to be equal to
Period provided in input-selection parameter, from the table (MSEG).

8. II.Quantity Locally sold:
Get the total Quantity sold for Material (MATNR) by field Billing Qty in
SKU (FKLMG) from Plant (WERKS: 1000) by Storage locations
(LGORT:1037 & 1038) and the Profit Centre (PCTNR: 1000), read the
Billing Document (VBELN), sales document (AUBEL) and take filter on
Distribution Channel (VTWEG_ANA: 20-local) for the period from Posting
date (FKDAT_ANA) which should be equal to Period provided in the
selection Parameter from table "VBRP”.
Quantity Exported: Get the total Quantity sold for Material (MATNR) by
field Billing Qty in SKU (FKLMG) from Plant (WERKS: 1000) by Storage
locations (LGORT:1037 & 1038) and the Profit Centre (PCTNR: 1000),
read the Billing Document (VBELN), sales document (AUBEL) and take
filter on Distribution Channel (VTWEG_ANA: 10-export) for the period
from Posting date (FKDAT_ANA) which should be equal to Period
provided in the selection Parameter from table "VBRP”.
Wastages: Fetch Cost field (WAVWR) for the Material (MTNR) for Plant
(WERKS:1000) from Storage Location (LGORT: 1037 & 1038) for Billing type
(FKART_ANA: ZYRW) for the period from Posting date (FKDAT_ANA) which
should be equal to Period provided in the selection Parameter
Gross Profit
Sales revenue – Cost of Sales (Respectively for Transferred, Locally and
Externally)
Selling Expenses
[Cost Centre/Cost elements for Selling expense]
YTM 6 PLANT 1000 Unit 1 PNL: Use Selling Cost Centre “1006010319”
by Field (KOSTL) with amount field (WTGBTR) for the specified period
on selection screen by Field (PERIO) and Fiscal Year (GJAHR) from
table and filter the data with Value Type field (WRTTP: “11”) from the
table (COEP). For the Cost elements via field : KSATR:( Use the
following General ledger account from the above table
“61400002,60900005 and 60900002 for the cost centre “1006010319” –
local and for export, the cost element will be changed to 61100003,
61100004, 61100005, 61200001 ,61400001
And 61500001.
Selling expenses of wastage= (sum of all sales / sum of selling expenses) * Wastage
sales
Selling expenses of Transfer= ( Sum of all sales / sum of selling expenses) * Transfer
Sales
Administrative expenses
YTM 6 PLANT 1000 Unit 1 PNL: Use Admin Cost Centre 1006150505
by Field (KOSTL). Get the value from amount field (WTGBTR) for the
specified period on selection screen by Field (PERIO) and Fiscal Year
(GJAHR) and filter the data with Value Type field (WRTTP: “11”) from
the table (COEP). (Use the following General ledger account from the
above table “”)

9. Other operating expenses WPPF: Profit before taxation * 5%
WWF: Total sales*4% *2% = 10,000
Profit From Operations Gross Profit – (Selling expenses + Administrative+ Other operating expenses)
Financial Cost
A formula will also be applicable to create the financial cost through cost object:
There will be two financial cost i) Financial cost Stock
ii) Financial Cost Debtor.
i) Financial Cost Stock formula: ((Monthly Raw material closing stock *
Markup Rate)/12)). It will multiply the total stock Quantity with the
Moving average Price of the material and take the sum from Table
(MBEWH) for the Material Field (MATNR) Range from-to
(1100000000- 1199999999) Multiply by Rate (0.007) and divide by
(12). (Apply the rate at plant level then divide on the units on basis
of sales).
ii) Financial Cost Debtor: Use the amount from Field Net sales
(aforementioned) and multiply by the 7% then divide by 12.
The Total cost of financial stock is to be distributed based on sales of Local,
Transfer, Export and wastage)
Profit Before Taxation Profit from Operations – (Financial Cost)
Taxation
A field is required at input screen for inserting a rate e.g. (2%) to calculate tax.
(The tax will be applied on sales revenue respectively for Transferred, local and
export.)
Profit After taxation PBT - Taxation
Assumptions/Notes
The Spindle and Profit per spindle section is cross-module dependent. The cross-module logic shall be
developed once provided by the cross-module team.
Technical Specification

10. [This area will be filled by ABAP Consultant with program flow, BAPI, Dictionary Object,
flowchart)]
Business Test Conditions
Input Selection Criteria Expected Result Status (Passed/ Failed)
Controlling area 
company code 
plant
Storage location
material
Cost center
Financial Cost 
period fiscal year
tax
P&L of goods transferred from
spinning to weaving