SAPERFORM FILE
Performance Trend Summary
The Performance Trend Summary file stores the performance statistics used to
calculate and report on fill rates by Sales Analysis fiscal periods.
REFERENCED BY
SA00.2 SA257
UPDATED BY
SA100 SA101 SA110 SA300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SPF-COMPANY Numeric 4 SA100 SA110
Company The company number represents an SA300
established company and is entered on
all function codes.
SPF-YEAR Numeric 4 SA100 SA110
Year Sales Analysis fiscal year. SA300
SPF-PERIOD Numeric 2 SA100 SA110
Period Contains period when booked or actual SA300
sales occurred.
SPF-LOCATION Alpha 5 SA100 SA110
Location Contains a valid stock location within SA300
the company inventory.
SPF-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Customer Contains the number that represents a SA300
customer.
SPF-ITEM Alpha 32 SA100 SA110
Item Contains the item identifier. SA300
SPF-NBR-OF-ORDERS Numeric 6 SA100 SA110
Number of Orders Total number of orders taken with at SA257 SA300
least one shipment against them.
SPF-NBR-OF-SHIPMNT Numeric 6 SA100 SA110
Number of Shipment Number of full shipments. No partials SA257 SA300
are included.
SPF-NBR-OF-CXL Numeric 6 SA100 SA110
Number of Cancel Number of orders canceled. SA257 SA300
SPF-TTL-RQST-DAYS Signed 9.0 SA100 SA110
Total Request Days The total customer request late days. SA257 SA300
Late days is calculated by subtracting
the actual ship date from the customer's
requested dates.
SPF-TTL-EXP-DAYS Signed 9.0 SA100 SA110
Total Expected Ship Total expected ship date late days. SA257 SA300
Late Days This is calculated by subtracting the
actual ship date from the expected ship
date.
SAPERFORM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SPFSET1 COMPANY SA00.2 SA100
YEAR SA101 SA110
PERIOD SA257 SA300
LOCATION
CUSTOMER
ITEM
SPFSET2 COMPANY
YEAR
LOCATION
CUSTOMER
ITEM
PERIOD
|