|
|
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
SA202 SA260 SA270 SA280 SA290 SA80.1
SA80.2 SA80.3 SA90.1 SA90.2 SA90.3 SALD.1
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
Element: Company Identifies the AP company if the SA03.1 SA03.2
resource type = V. Identifies the HR SA04.1 SA04.2
company if the resource type = E. It is
blank for type A, P or Q resources.
SBD-YEAR Numeric 4 SA02.1 SA02.2
Element: Last Closed YeContains 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
Element: Last Closed PeContains period when booked or actual SA03.1 SA03.2
sales occurred. SA04.1 SA04.2
SBD-PROCESS-LEVEL Alpha 5 SA02.1 SA02.2
Element: 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
Element: Sales TerritorSales Territory. SA03.2 SA04.2
SBD-SALESMAN Numeric 4 SA02.1 SA02.2
Element: Salesman NumbeThis 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
Element: 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
Element: Customer NumbeIndicates whether the customer is a
national account customer.
SBD-CUSTOMER Alpha 9 (Right Justified) SA02.2 SA03.1
Element: Customer NumbeThis field contains the number that SA03.2 SA04.2
represents a customer.
SBD-SHIP-TO Numeric 4 SA02.2 SA03.1
Element: Ship-to Code This field contains the number SA03.2 SA04.2
representing the ship to customer.
SBD-SALES-MAJCL Alpha 4 SA02.2 SA03.2
Element: Major Class This field contains the sales major SA04.1 SA04.2
class code.
SBD-SALES-MINCL Alpha 4 SA02.2 SA03.2
Element: Minor 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
Element: Item Number This field contains the item SA04.1 SA04.2
identifier.
SBD-INV-LOCATION Alpha 5 SA02.2 SA03.2
Element: Location Code This field contains the location from SA04.1 SA04.2
which inventory is taken.
SBD-BUDGET-QTY Signed 13.4 SA02.1 SA02.2
Element: Quantity Quantity budgeted for this SA03.1 SA03.2
summarization by period. SA04.1 SA04.2
SBD-BUDGET-SALES Signed 18.2 SA02.1 SA02.2
Element: Intl Amt Sales dollars budget for this SA03.1 SA03.2
summarization by period. SA04.1 SA04.2
SBD-BUDGET-DISC Signed 18.2 SA02.1 SA02.2
Element: Intl Amt Discount amount budget for this SA03.1 SA03.2
summarization by period. SA04.1 SA04.2
SBD-BUDGET-COST Signed 18.2 SA02.1 SA02.2
Element: Intl Amt 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
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
PERIOD And NAT-CUSTOMER = Spaces SA270 SA280
PROCESS-LEVEL And CUSTOMER = Spaces SA290 SA80.1
TERRITORY And SHIP-TO = Zeroes SA90.1 SALD.1
SALESMAN And SALES-MAJCL = Spaces
CUSTOMER-CODE And SALES-MINCL = Spaces
CUSTOMER And ITEM = Spaces
SHIP-TO And INV-LOCATION = Spaces
SALES-MAJCL
SALES-MINCL
ITEM
INV-LOCATION
SBDSET3 COMPANY Subset SA03.1 SA03.2
YEAR Where PROCESS-LEVEL = Spaces SA203 SA261
PERIOD And TERRITORY = Spaces SA271 SA281
PROCESS-LEVEL And SALESMAN = Zeroes SA291 SA80.2
TERRITORY And SALES-MAJCL = Spaces SA90.2 SALD.1
SALESMAN And SALES-MINCL = Spaces
CUSTOMER-CODE And ITEM = Spaces
CUSTOMER And INV-LOCATION = Spaces
SHIP-TO
SALES-MAJCL
SALES-MINCL
ITEM
INV-LOCATION
SBDSET4 COMPANY Subset SA04.1 SA04.2
YEAR Where PROCESS-LEVEL = Spaces SA204 SA262
PERIOD And TERRITORY = Spaces SA272 SA282
PROCESS-LEVEL And SALESMAN = Zeroes SA292 SA80.3
TERRITORY And CUSTOMER-CODE = Spaces SA90.3 SALD.1
SALESMAN And NAT-CUSTOMER = Spaces
CUSTOMER-CODE And CUSTOMER = Spaces
CUSTOMER And SHIP-TO = Zeroes
SHIP-TO
SALES-MAJCL
ITEM
INV-LOCATION
|
