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