Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SACOMPUTE


                             SACOMPUTE FILE

                         SA Compute Statements

The Sales Analysis Compute Statements file stores the compute statements for
user-defined inquiry formats.

REFERENCED BY

SA201     SA90.1    SA90.2    SA90.3

UPDATED BY

SA01.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SAP-COMPANY            Numeric 4                                 SA01.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

SAP-FORMAT-NAME        Alpha 10                                  SA01.2
Element: Base Name     This field contains the identifier for
                       a user-defined setup file indicating
                       which data fields appear on the form
                       when  maintaining items.

SAP-COLUMN             Numeric 1                                 SA01.2
Element: Au Flag       The column on the formatted inquiry
                       form this compute is for.  Must be 1
                       through 4.

SAP-COMPUTE-STMT       Alpha 20                                  SA01.2
Element: Compute StatemActual compute statement as entered on
                       the form.

SAP-HEADING-LINE1      Alpha 15                                  SA01.2
Element: Heading Line1 First line of column heading.

SAP-HEADING-LINE2      Alpha 15                                  SA01.2
Element: Heading Line1 Second line of column heading.

SAP-CMP-NBR            Alpha 6 Occurs 15 Times                   SA01.2
Element: Cmp Nbr       Compute number.

SAP-OP-CODE            Numeric 2 Occurs 15 Times                 SA01.2
Element: Operation CodeOperation code.

                         SACOMPUTE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SAPSET1   COMPANY                                                SA01.1  SA01.2
          FORMAT-NAME                                            SA201   SA90.1
          COLUMN                                                 SA90.2  SA90.3

                         SACOMPUTE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Saformat       SAFORMAT     Required

                            SAP-COMPANY        -> SAF-COMPANY
                            SAP-FORMAT-NAME    -> SAF-FORMAT-NAME