Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SAPERFORM


                             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
Element: Company       Identifies the AP company if the          SA300
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

SPF-YEAR               Numeric 4                                 SA100   SA110
Element: Last Closed YeSales Analysis fiscal year.               SA300

SPF-PERIOD             Numeric 2                                 SA100   SA110
Element: Last Closed PeContains period when booked or actual     SA300
                       sales occurred.

SPF-LOCATION           Alpha 5                                   SA100   SA110
Element: Location Code Contains a valid stock location within    SA300
                       the company inventory.

SPF-CUSTOMER           Alpha 9  (Right Justified)                SA100   SA110
Element: Customer NumbeContains the number that represents a     SA300
                       customer.

SPF-ITEM               Alpha 32                                  SA100   SA110
Element: Item Number   Contains the item identifier.             SA300

SPF-NBR-OF-ORDERS      Numeric 6                                 SA100   SA110
Element: Nbr Returns   Total number of orders taken with at      SA257   SA300
                       least one shipment against them.

SPF-NBR-OF-SHIPMNT     Numeric 6                                 SA100   SA110
Element: Nbr Returns   Number of full shipments.  No partials    SA257   SA300
                       are included.

SPF-NBR-OF-CXL         Numeric 6                                 SA100   SA110
Element: Nbr Returns   Number of orders canceled.                SA257   SA300

SPF-TTL-RQST-DAYS      Signed 9.0                                SA100   SA110
Element: Ttl Rqst 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
Element: Ttl Rqst Days Total expected ship date late days.       SA257   SA300
                       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