Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

SAP-FORMAT-NAME      Alpha 10                                    SA01.2
Format 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
Column               The column on the formatted inquiry
                     form this compute is for.  Must be 1
                     through 4.

SAP-COMPUTE-STMT     Alpha 20                                    SA01.2
Compute Statement    Actual compute statement as entered on
                     the form.

SAP-HEADING-LINE1    Alpha 15                                    SA01.2
Heading Line 1       First line of column heading.

SAP-HEADING-LINE2    Alpha 15                                    SA01.2
Heading Line 2       Second line of column heading.

SAP-CMP-NBR          Alpha 6 Occurs 15 Times                     SA01.2
Compute Number       Compute number.

SAP-OP-CODE          Numeric 2 Occurs 15 Times                   SA01.2
Operator Code        Operation 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