|
|
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 SA261 SA262 SA270 SA271
SA272 SA280 SA281 SA282 SA290 SA291
SA292 SA80.1 SA80.2 SA80.3 SA90.1 SA90.2
SA90.3 SALD.1
UPDATED BY
SA100 SA101 SA110 SA300 SA310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SUM-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.
SUM-YEAR Numeric 4 SA100 SA110
Element: Last Closed YeContains the fiscal year for the data SA300
stored on this record.
SUM-PERIOD Numeric 2 SA100 SA110
Element: Last Closed PeContains period when booked or actual SA300
sales occurred.
SUM-PROCESS-LEVEL Alpha 5 SA100 SA110
Element: Process Level This field contains the process level, SA300
which is the reporting hierarchy below
company.
SUM-TERRITORY Alpha 4 SA100 SA110
Element: Sales TerritorSales Territory. SA300
SUM-SALESMAN Numeric 4 SA100 SA110
Element: Salesman NumbeThis 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
Element: 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
Element: Customer NumbeIndicates whether the customer is a SA300
national account customer.
SUM-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Element: Customer NumbeThis field contains the number that SA300
represents a customer.
SUM-SHIP-TO Numeric 4 SA100 SA110
Element: Ship-to Code This field contains the number SA300
representing the ship to customer.
SUM-SALES-MAJCL Alpha 4 SA100 SA110
Element: Major Class This field contains the sales major SA300
class code.
SUM-SALES-MINCL Alpha 4 SA100 SA110
Element: Minor Class This field contains the sales minor SA300
class code within the major class.
SUM-ITEM Alpha 32 SA100 SA110
Element: Item Number This field contains the item SA300
identifier.
SUM-INV-LOCATION Alpha 5 SA100 SA110
Element: Location Code This field contains the location from SA300
which inventory is taken.
SUM-BOOKED-QTY Signed 13.4 SA100 SA110
Element: Quantity This field contains the quantity booked SA300
for this summarization by period.
SUM-BOOKED-SALES Signed 18.2 SA100 SA110
Element: Intl Amt Sales amount booked for this SA300
summarization by period.
SUM-BOOKED-DISC Signed 18.2 SA100 SA110
Element: Intl Amt Discount amount booked for this SA300
summarization by period.
SUM-BOOKED-COST Signed 18.2 SA100 SA110
Element: Intl Amt Cost amount booked for this SA300
summarization by period.
SUM-ACTUAL-QTY Signed 13.4 SA100 SA110
Element: Quantity Actual quantity sold for this SA300
summarization by period.
SUM-ACTUAL-SALES Signed 18.2 SA100 SA110
Element: Intl Amt Actual sales amount for this SA300
summarization by period.
SUM-ACTUAL-DISC Signed 18.2 SA100 SA110
Element: Intl Amt Actual discount amount for this SA300
summarization by period.
SUM-ACTUAL-COST Signed 18.2 SA100 SA110
Element: Intl Amt 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 SA261
PROCESS-LEVEL SA262 SA270
TERRITORY SA271 SA272
SALESMAN SA280 SA281
CUSTOMER-CODE SA282 SA290
CUSTOMER SA291 SA292
SHIP-TO SA300 SA310
SALES-MAJCL SA80.1 SA80.2
SALES-MINCL SA80.3 SA90.1
ITEM SA90.2 SA90.3
INV-LOCATION SALD.1
|
