Reports Overview Note
You
must have authorization
to view specific cost
objects or profit
centers in order to run
this report. Displaying
the Fund Analysis Report Use the following navigation path from the SAP User Menu
screen or type in the transaction code from any screen:
Navigation
Path: - User Menu Transaction
Code : /nzfm8 Result: The "Fund Analysis" screen is displayed so
that you can enter selection criteria for the report. Scroll
down to see the entire screen. Type in or select one or more of the fields listed in the
following table. Remember, more precisely defined reports
generally take less time to run.
Field Name Description Profit Center Type in or select the profit center (your department
number prefaced by the letter "P" ). Profit Center Group Type in or select the profit center group.
Note
You
can only use profit center groups beginning
with PCMIT. For more information on how to find the profit centers
included in a profit center group, see Reports:
Reporting Fundamentals: Selection Options for Profit
Center Groups. Supervisor MIT ID Type in the supervisor's MIT ID or search for it using
the Matchcode button.
Note
To
use this field, you must also enter the
corresponding profit center or profit center
group and WBS element or internal order.
Order All the internal orders are the default. To change
them, type in or select an individual internal order
or range of internal orders, making sure they are within
the profit center you selected. WBS Element All the WBS elements are the default. To change them,
type in or select an individual WBS element or range
of WBS elements, making sure they are within the profit
center you selected. Pool Code Type in or select the pool code or range of pool codes.
Used to identify the type of fund that the cost object
belongs to. FS Code Type in or select the FS codes or range of FS codes
you want to appear on your report. The Financial Statement
(FS) code shows how restricted MIT is in using the funds. Legend Code Type in or select the legend codes (expense and revenue
types) or range of legend codes you want to appear on
your report. From Calendar Month/Year The beginning calendar month and year for the current
fiscal year is the default. Closing Period Type or select the closing period for June only. Use
the same fiscal closing period for all reporting period
fields. Closing periods 13 through 16 are used after the close
of the fiscal year to accommodate transactions associated
with the recently closed fiscal year but which have
been recorded after the actual closing date.
Note
If
you enter the closing period and the month
is not June, the report will run but the
message, "From closing period cleared ("from"
month not JUN)" will appear in the Status
bar. To Calendar Month/Year The ending calendar month and year for the current
fiscal year is the default. To change them, type over
them. Closing Period Type in or select the closing period for June only.
Use the same fiscal closing period for all reporting
period fields. Closing periods 13 through 16 are used after the close
of the fiscal year to accommodate transactions associated
with the recently closed fiscal year but which have
been recorded after the actual closing date.
Note
If
you enter the closing period and the month
is not June, the report will run but the
message, "To closing period cleared ("to"
month not JUN)" will appear in the status
bar. Sort by You can sort the report on three fields in ascending
or descending order. You can also choose a subtotal
after each field. 1. Click on the Matchcode button beside a Sort by
or then by field. 2. Click on a field from the displayed list and then
on the Enter button 3. Click on either Asc or Desc.
Note
If
sorting by Profit Center Group, then Profit
Center Group must be entered as the first
sort field. 4. Click on Subtotal. If you subtotal on a field, that
field will appear in a horizontal colored line on the
report, not as a column on the report. Report Title Type in the text to appear in the third line of the
report title, if desired. Generate cover page Check the box to display a cover page listing selection
criteria for your report on the screen. A cover page
is always generated when the report is printed. You can customize the appearance of
your report using the Change Layout button
either before or after the report is
run. 1. Click the Result: A window displays the
fields, columns, and column lengths on the
report. 2. Type in the numbers under Column in the order that
you want columns to appear on the report.
You can also display Profit Center, Supervisor
Name, and Begin Date and End Date fields
on the report by typing a number beside them. The default
for these fields is blank.
3. To hide the columns, delete the
number with the Backspace key, Delete key,
space bar, or by entering 0 (zero). 4. To change the column length of the Supervisor and
Fund Name (the Len boxes are in white), type in a number
under Len. You can change the column length for these
two fields only. 5. Click in the empty box to the left of a field to "freeze"
the field on the report. (For example Fund Name is
highlighted in orange in the screen above.) This means that
the Fund Name will not move as you scroll the report to the
right. 6. Click in the empty box next to Horizontal lines,
Vertical lines, and/or Shading to add lines
and shading to the report. Horizontal lines will separate
each fund, vertical lines will place a line between each column,
and shading will put horizontal gray shading on every other
fund. 7. Click the Enter button Column Layout Description Clears out the column numbers and resets the width
to 0. To run the report, click the Execute button The screen capture below shows the bottom of the report with
report totals and legend codes. Fund
Analysis Report screen (SEE
FULL SCREEN)
Note
If
you chose to generate a cover sheet, your selection
criteria will be listed first on the screen. Press
the Page Down key three times to see the report
data. Scroll to the right using the horizontal
scroll bar to view all the columns. As you scroll,
the report will remain stationary at the field
you "froze" using the Column Layout button. Field
Name Description Profit Center The profit center or profit center group you selected
on the report entry screen. Supervisor Name Supervisor of the fund. Begin Date Beginning date of the fund. End Date Ending date of the fund. W Indicates whether the cost
object is a WBS element (W) or an
internal order (I). Fund # Lists internal orders and WBS
elements in the 2000000 to
4999999 range from within the
selected profit center(s) or
profit center group(s). Fund
Name Name of the internal order or
WBS element. FS Code The Financial Statement (FS)
code shows the degree of
restriction that MIT has in using
the funds. U = Unrestricted T = Temporarily restricted R = Permanently restricted N = Non-MIT (agency) PC Used to identify the type of fund that the cost object
belongs to. Click on the Pool Code Matchcode
buttonon the report entry screen for a list of values. Pool
Units Determines the number of
shares a fund holds in MIT's Pool
A endowment fund. PI The letter "P" or "I"
indicates whether the line
describes balances and activity
relating to Principal (P) or
Expendable Income (I). Balance as
of The opening balance of the
cost object as of the selected
beginning date of the reporting
period. Gifts and other
Receipts The amount of money received
as gifts and other receipts
posted to the account during the
selected reporting period. Transfers Amount of money transferred
out of or into the fund cost
object during the selected
reporting period. Expenses Amount of expenses charged
directly to the fund cost object
during the selected reporting
period. Note
Employee
Benefits and
Overhead are
calculated
based upon the
Costing Sheets
maintained by
CAO.
Other
Charges Other charges to the fund cost
object for the period. Balance as
of The ending balance of the fund
cost object as of the selected
end date and fiscal period of the
reporting period. Report
Total Total amount for each column. Legend A list of all codes identifying the expense or revenue
types. Each dollar amount displayed in the
report, with the exception of those
displayed in the Balance columns, is shown
with a legend code such as ES or GG. The
legend code is a two-letter code
identifying the expense or revenue type
used to compile the reported figure. 1. To see a further breakdown of
expense and revenue types into cost
elements, click the legend code. Result: A list of cost elements
comprising the legend code appears. 2. You can review the Master Data for
the selected cost element, if you have the
authorization, by clicking on one of the
cost elements. Result: The "Display Cost
Element: Initial" screen appears. 3. Click the Back button 4. Click on the Cancel button Note
To
see the cost elements comprising all the legend
codes, click the You can access the Summary Statement,
the Account Managers Report (AMR), and
Master Data to obtain more detailed
information on a particular cost
object. 1. Double-click on an item under these
columns. Column
Heading Drill
down to: Fund # Master Data Balance as of
[beginning fiscal
period] Summary Statement Gifts and Other
Receipts Account Managers
Report (Detail
Listing) Transfers Account Managers
Report (Detail
Listing) Expenses Account Managers
Report (Detail
Listing) Other Charges Account Managers
Report (Detail
Listing) Balance as of
[ending fiscal
period] Summary Statement Note
Master
Data screens provide
general information
about the cost object
such as supervisor,
addressee, date the cost
object was first set up,
termination date, and
authorizations. 2. When you have finished reviewing these reports, click
on the Back button Button
Name Function Allows you to sort the report on up to three fields
in ascending or descending order and with or without
subtotals. (This button performs the same function as
the Sort by fields on the report entry screen.) 1. Click on the Sort button 2. Click on the Matchcode button in a field under the
Sort Field. 3. Choose a field to sort on. 4. Click on the buttons under A for ascending
or D (descending). 5. Click in the box under the Subtotal button
6. Click the Enter button The report is rerun and the data is sorted according
to your criteria. Allows you to download the
report to a spreadsheet. For
instructions on using the
Download button, see the section
Reporting
Fundamentals: Downloading
Reports: Using the Download
Button. Shows the cost element group structure for CEMIT-B,
Fund Analysis, so that you can see the individual cost
elements for all the legend codes. For information on viewing the
cost element hierarchy and
displaying information for cost
elements, see Selection
Options for Cost Element
Groups. Rearranges the columns and
appearance of the report. This is
the same button that is on the
report entry screen. For
instructions, see Changing
the Column Layout. 1. Click the Print button Result: The "Print Parameters" screen is displayed.
For more information on printing, see Reports:
Reporting Fundamentals: Printing Reports. You can save the values that you
entered in the report entry screen as a
report variant, but not the report layout.
For information on report variants, see
Reports:
Reporting Fundamentals: Report
Variants.
..
Fund
Analysis Report
Displaying
the Fund Analysis Report
Entering
the Fields on the Report
Changing
the Column Layout
Executing
the Report
Reading
the Fund Analysis Report
Drill
Down to Detailed Cost Element Information
Drill
Down to Detailed Cost Object Information
Using
the SAP Report Buttons
Printing
the Report
Saving
the Report as a Variant
Overview
The Fund Analysis Report shows cost object activity
for a profit center or a profit center group for types of revenue
and expense cost elements. The cost objects include the SAP
internal orders and WBS elements between 2000000 and 4999999.
Principal (MIT's endowment) and expendable funds are shown separately.
The report can be run either by profit center or by profit center
group. For each cost object, the report displays pool units
(today's value, not historical units), beginning and ending
balances (for the specified date), gifts and other receipts,
transfers, expenses, and other charges. The Fund Analysis Report
is based on information available from the former GL53 report
in the SumMIT system.
- Role ZMIT
- Reports
- Profit Ctr Reports
- Fund Analysis
In some fields, you can use the Matchcode 
(PC: 
)
search function to find the data you want. (See Getting
Started: Matchcodes.) Many fields offer Multiple Selections
for entering nonconsecutive numbers or multiple ranges of
data. (See Reporting
Fundamentals: Selection Options for Setting Report Parameters.)
Select the appropriate
company code from the Matchcode list. You can run the
report with more than one company code if you have the
authorization. Use the Multiple Selection button to enter
more than one company code.
(Either Profit Center
or
Profit Center Group is required)
(Either Profit Center
or
Profit Center Group is required)
(optional)
(Either an Internal
Order or a WBS Element is required)
(Either an Internal
Order or a WBS Element is required)
(optional)
(optional)
(optional)
(required)
(required if you select
June)
(required)
(required if you select
June)
(optional)
.
(optional)
(optional)
button.
.
Executing
the Report
Button
Recalculates the width of the columns. Type the width
of the column in the Column field, then click the
button.
Saves your selected layout. This layout will
become the standard one whenever you use this report.
Returns to the default layout; the one that appeared
when you first ran the Fund Analysis.
to restore all the columns, or
.
(F8). While the report is running, the status bar at the bottom
of the screen shows runtime progress information.
or
Profit Center Group
(if
you selected it with the Column layout button)
(if
you selected it with the Column layout button)
(if
you selected it with the Column layout button)
(if
you selected it with the Column layout button)
I
(Pool Code)
(beginning fiscal
period)
(ending
fiscal period)
(on bottom)
(on bottom)
to return to the "Cost elements for legend code" dialog box.
to return to the report screen.
Drill
Down to Detailed Cost Object Information
button
.
[for the period
prior to the beginning
fiscal period]
until you return to the Fund Analysis Report.
.
The following dialog box is displayed.
if you want a subtotal for a field.
.
on the Toolbar.
SAP for MIT Documentation on the Web
Valid From: 05/21/2001