|
|
SASUMMARY FILE
Sales Analysis Summary
The Sales Analysis Summary file includes the company, customer, item, and
booked factors. The company factors are process level, territory, and sales
representative. The customer factors are customer code, customer number, and
ship-to codes. The item factors are major sales class, minor sales class,
item, and ship-from location. The booked and actual factors are quantity,
sales, discount, and cost.
REFERENCED BY
SA00.2 SA260 SA270 SA280 SA290 SA80.1
SA80.2 SA80.3 SA90.1 SA90.2 SA90.3 SA261
SA271 SA281 SA291 SA262 SA272 SA282
SA292
UPDATED BY
SA100 SA101 SA110 SA300 SA310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SUM-COMPANY Numeric 4 SA100 SA110
Company The company number represents an SA300
established company and is entered on
all function codes.
SUM-YEAR Numeric 4 SA100 SA110
Year Contains the fiscal year for the data SA300
stored on this record.
SUM-PERIOD Numeric 2 SA100 SA110
Period Contains period when booked or actual SA300
sales occurred.
SUM-PROCESS-LEVEL Alpha 5 SA100 SA110
Process Level This field contains the process level, SA300
which is the reporting hierarchy below
company.
SUM-TERRITORY Alpha 4 SA100 SA110
Territory Sales Territory. SA300
SUM-SALESMAN Numeric 4 SA100 SA110
Salesman This field contains the code that SA300
represents the primary sales
representative of this line. If left
blank, this defaults from the order
header.
SUM-CUSTOMER-CODE Alpha 4 SA100 SA110
Customer Code Customer code. This is a code used to SA300
classify customers for Sales Analysis.
SUM-NAT-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
National Customer Indicates whether the customer is a SA300
national account customer.
SUM-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Customer This field contains the number that SA300
represents a customer.
SUM-SHIP-TO Numeric 4 SA100 SA110
Ship To This field contains the number SA300
representing the ship-to customer.
SUM-SALES-MAJCL Alpha 4 SA100 SA110
Major Sales Class This field contains the sales major SA300
class code.
SUM-SALES-MINCL Alpha 4 SA100 SA110
Minor Sales Class This field contains the sales minor SA300
class code within the major class.
SUM-ITEM Alpha 32 SA100 SA110
Item This field contains the item SA300
identifier.
SUM-INV-LOCATION Alpha 5 SA100 SA110
Inventory Location This field contains the location from SA300
which inventory is taken.
SUM-BOOKED-QTY Signed 13.4 SA100 SA110
Booked Quantity This field contains the quantity booked SA300
for this summarization by period.
SUM-BOOKED-SALES Signed 15.2 SA100 SA110
Booked Sales Sales amount booked for this SA300
summarization by period.
SUM-BOOKED-DISC Signed 15.2 SA100 SA110
Booked Discount Discount amount booked for this SA300
summarization by period.
SUM-BOOKED-COST Signed 15.2 SA100 SA110
Booked Cost Cost amount booked for this SA300
summarization by period.
SUM-ACTUAL-QTY Signed 13.4 SA100 SA110
Actual Quantity Actual quantity sold for this SA300
summarization by period.
SUM-ACTUAL-SALES Signed 15.2 SA100 SA110
Actual Sales Actual sales amount for this SA300
summarization by period.
SUM-ACTUAL-DISC Signed 15.2 SA100 SA110
Actual Discount Actual discount amount for this SA300
summarization by period.
SUM-ACTUAL-COST Signed 15.2 SA100 SA110
Actual Cost Actual cost for this summarization by SA300
period.
SASUMMARY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SUMSET1 COMPANY SA00.2 SA100
YEAR SA101 SA110
PERIOD SA260 SA270
PROCESS-LEVEL SA280 SA290
TERRITORY SA300 SA310
SALESMAN SA80.1 SA90.1
CUSTOMER-CODE
CUSTOMER
SHIP-TO
SALES-MAJCL
SALES-MINCL
ITEM
INV-LOCATION
SUMSET2 COMPANY Duplicates SA260 SA270
YEAR SA280 SA290
PROCESS-LEVEL SA80.1 SA90.1
TERRITORY
SALESMAN
PERIOD
SUMSET3 COMPANY Duplicates SA261 SA271
YEAR SA281 SA291
CUSTOMER-CODE SA80.2 SA90.2
NAT-CUSTOMER
CUSTOMER
SHIP-TO
PERIOD
SUMSET4 COMPANY Duplicates SA262 SA272
YEAR SA282 SA292
SALES-MAJCL SA80.3 SA90.3
SALES-MINCL
ITEM
INV-LOCATION
PERIOD
|