Sales Explorer Data Dictionary

Last updated on: 10/07/2024

BOBJ Field BOBJ Definition Incorta Folder Incorta Field Incorta Description not in BOBJ
Date_Dim Date The date for the year. Format M/D/YY Calendar year / week
Date_Dim Week The week number in the year. Format W example: 1, 2, 3 etc. Current Month/ Prev Month, Cal. Year / month
Date_Dim Month The month number in the year. Format M example: 1 for January Calendar month Shows the month as the Number within the year. Example: January is 1, February is 2, etc. Date_Dim Calendar Month The calendar month in the year. Format MM example: 01 is January Calendar year Data based on calendar year not fiscal. Format is YYYY Date_Dim Calendar Year The calendar year. Format YYYY example: 2024 Calendar year/week Date format is WK/YYYY where the week is the # of the week out of 52. Example: 27/2013 is the 27th week of 2013. Date_Dim Calendar Year Week Number The calendar year with the week number. Format: YYYYWW example: 202401 for week 1 of 2024. Calendar year/month Shows the dates as MM/YYYY at top of columns Date_Dim Calendar Year Month Number The calendar year with the month. Format: YYYYMM example: 202405 May of 2024 Calendar year/quarter Shows dates as YYYY/Q at top of columns Date_Dim Calendar Year Quarter Number The calendar year with the quarter number. Format: YYYYQ example: March 2023 would be 20233

Date_Dim Fiscal Month Fiscal month in the format of MM. example: July would be 01 Fiscal year/period Fiscal year and month. Format is XXX/YYYY XXX is in the alpha abbreviation of the month. Date_Dim Fiscal Year Month Fiscal year and month in the format of YYYY-MM. example: August 2023 would be 2024-02 Current Quarter/Previous Quarter, Cal year / quar
Date_Dim Fiscal Quarter Fiscal quarter in the format of QQ. Example: Q1 = July -Sept Current Fisc year // Prev Fiscal Year Date is YYYY format Date_Dim Fiscal Year Fiscal year in the format of YYYY. Example: 2024 (july-june) When using this with the sales measures it is looking at the material availability date.

Material_Dim Material Concatenation of the material number and description. Format material number : material description. (concat(SAPECC_MM_MD.MAKT.MATNR, ' : ', SAPECC_MM_MD.MAKT.MAKTX)) Material This is the item #s. NOTE: if you do not filter on ZFIN (see material type below) you will get packaging, flavoring and all raw material types as well (SAPECC_MM_MD.MAKT.MATNR) Material_Dim Material Number Material number

Material_Dim Material Description The description of the material Material Type ZFIN is finished goods; DIEN is a service material (we use these in Vistex flat fee agreements); VERP is packing; HALB is semi finished goods or WIP; UNBW is non valued items such as tape, labels, etc. (SAPECC_MM_MD.MARA.MTART) Material_Dim Material Type This field is ZFIN.

Material_Dim Material Group (SAPECC_MM_MD.MARA.MATKL) Material group 5 We are going to put a few miscellaneous indicators in this field. (MD, PC, PE)(SAPECC_MM_MD.MVKE.MVGR5) Material_Dim Material group 5
Valuated Stock Qty Same as dollar value but in base UOM (cs, ea., pallet) values Material_Dim Valuated Quantity Gross inventory on hand. Brand Brand that item is designed to. (SAPECC_MM_MD.T179T_LVL1.VTEXT) Material_Dim Brand Brand of finished products. This is the 1st level in the product hierarchy. Example: Mike and Ike, Multi, Jelly Beans, Hot Tamales Flavor All products should have a flavor even if unflavored (SAPECC_MM_MD.T179T_LVL2.VTEXT) Material_Dim Flavor Flavor of finished products. This is the 2nd level in the product hierarchy. Example: Original, Zours, Variety Mix, Berry Blast, Jolly Joe Product category This is the third level of our product hierarchy and groups items as changemaker, small theater box, SUB and more. List of how we package our products. (SAPECC_MM_MD.T179T_LVL3.VTEXT) Material_Dim Category Category of finished products. This is the 3rd level in the product hierarchy. Example: Count Good, Laydown Bag, Club/Bulk, Sm Peg Bag Case Type Is either open case or display. Display is defined as an off shelf vehicle. (SAPECC_MM_MD.T179T_LVL4.VTEXT) Material_Dim Case Type This is either the open case or display. This is the 4th level in the product hierarchy. Example: Open and Display Retail pack size Fifth level of the product hierarchy that indicates the size of the retail unit. (SAPECC_MM_MD.T179T_LVL5.VTEXT) Material_Dim Retail Pack Size
Retail pack size of the finished product. This is the 5th level in the product hierarchy. Example: 5 in, 9 in, 10 ct, 1.76 oz Color Color if applicable. Not all items have a color indicator. Example: Mike and Ike with multi colors would not have a color assigned (Group 1)(SAPECC_MM_MD.TVM1T.BEZEI) Material_Dim Color Color of finished products. Example: Blue, Yellow, Pink Shape This indicator is used to group items by likeness of physical shape. NOTE: PM90 is the size of the Hot Tamale piece; PM75 is the size of the Mike and Ike piece. Group 2 (SAPECC_MM_MD.TVM2T.BEZEI) Material_Dim Shape Shape of finished products. Example: Bunny, Chick, Mixed, Pinmold Season This indicator (including everyday) is given to each material based on when the product is sold. Group 3 (SAPECC_MM_MD.TVM3T.BEZEI) Material_Dim Season Season of finished products. Example: everyday, easter Product form This groups data by Molded, marshmallow, bar (for Peanut Chews), sugar free, jelly beans, Teenee Beanee. NOTE: There is a hierarchy built on this value to total together molded, helly beans and Teenee Beanee. Also totals together marshmallow and SF. Material Group 4 (SAPECC_MM_MD.TVM4T.BEZEI) Material_Dim Product Form Example: marshmallow, bar, jelly bean

Sales Organization The system is currently set up with just one sales organization. (SAPECC_SD.MV_Ptest_SD.Sales_Org) Customer_Dim Sales Org The system is currently set up with just one sales organization. (SAPECC_SD.MV_Ptest_SD.Sales_Org) Example: 1010 Distribution Channel We only have one and this is not applicable to how our system is set up. 10 Customer_Dim Dist Channel This is set to 10. Division 10 is domestic and 20 is international Customer_Dim Division 10 is domestic and 20 is international.

Customer_Dim Ship To Customer Number Ship to customer number example: 100012

Customer_Dim Ship To Customer Name Ship to customer name example: Amazon.com Services Inc Ship to Party This is the ship to location for each customer Customer_Dim Ship To Customer Ship to customer number and name. example: 100012: Amazon.com Services Inc

Customer_Dim Ship To Broker Number Ship to broker number example: 300036

Customer_Dim Ship To Broker Name Ship to broker name example: Shankman and Assoc Ship to Party SH Broker This is the indicator used to PAY COMMISSIONS. DO not use this for sales reports. You will get the wrong volumes where brokers receive split commissions but do not have volume responsibility. Customer_Dim Ship To Broker Ship to broker example: 300036: Shankman and Assoc

Customer_Dim Ship To Sales Office Number Ship to sales office number example: 565

Customer_Dim Ship To Sales Office Name Ship to sales office name example: Special Markets Ship to Sales Office Field sales region responsible for the MVP volume Customer_Dim Ship To Sales Office Ship to sales office example: 565: Special Markets

Customer_Dim Ship To Sales Group Number Ship to sales group number example: 084

Customer_Dim Ship To Sales Group Name Ship to sales group name example: All-State Brokerage Ship to Sales Group This represents the ship to sales group. Customer_Dim Ship To Sales Group Ship to sales group example: 084:All-State Brokerage

Customer_Dim Ship To Class of Trade Code Ship to class of trade code example: CD

Customer_Dim Ship To Class of Trade Name Ship to class of trade name example: Candy Dist, Conv Sto

Customer_Dim Ship To Class of Trade Ship to class of trade example: CD: Candy Dist, Conv Sto

Customer_Dim Sold To Customer Number Sold to customer number example: 100012

Customer_Dim Sold To Customer Name Sold to customer name example: Amazon.com Services Inc Sold-to party This is the headquarter customer; the parent Customer_Dim Sold To Customer Sold to customer number and name. example: 100012: Amazon.com Services Inc

Customer_Dim Sold To Broker Number Sold to broker number example: 300036

Customer_Dim Sold To Broker Name Sold to broker name example: Shankman and Assoc Sold to Party SP Broker This is the indicator used to PAY COMMISSIONS. DO not use this for sales reports. You will get the wrong volumes where brokers receive split commissions but do not have volume responsibility. Customer_Dim Sold To Broker Sold to broker example: 300036: Shankman and Assoc

Customer_Dim Sold To Sales Office Number Sold to sales office number example: 565

Customer_Dim Sold To Sales Office Name Sold to sales office name example: Special Markets Sold to Sales office Field manager assigned to HQ for a customer. Pulling volume via this indicator will give the ENTIRE sales for the customer, regardless of the ship to broker. Customer_Dim Sold To Sales Office Sold to sales office example: 565: Special Markets

Customer_Dim Sold To Sales Group Number Sold to sales group number example: 084

Customer_Dim Sold To Sales Group Name Sold to sales group name example: All-State Brokerage Sold to Sales Group This is same as ship to but at the HQ level. This indicates the broker assigned at the HQ level. Customer_Dim Sold To Sales Group Sold to sales group example: 084:All-State Brokerage

Customer_Dim Sold To Class of Trade Code Sold to class of trade code example: CD

Customer_Dim Sold To Class of Trade Name Sold to class of trade name example: Candy Dist, Conv Sto Customer group This is the customer class of trade. Example: BR Brokers, CB Club stores, CD Candy Dist Conv sto, etc.. Customer_Dim Sold To Class of Trade Sold to class of trade example: CD: Candy Dist, Conv Sto

Not in BOBJ
Sales_Data Document Date The document date is the date the document was received/sent. (VBAK.AUDAT) Created on Date the SAP transaction occurred Sales_Data Creation Date The date the sales document was created in SAP. If you want to run your data based on the creation date you will need to add this field to the filter and select the date range you need. (VBAK.ERDAT) Not in BOBJ
Sales_Data Sales Document Number The order number given through SAP when an order is created. (VBAP.VBELN)

Sales_Data Customer_PO The PO number that is entered in SAP. Not in BOBJ
Sales_Data Requested Delivery Date Date the customer is requesting the order to be delivered. (VBAK.VDATU) Not in BOBJ
Sales_Data Material Availability Date The date the material will be available. The date dimensions are looking at this field when calculating the measures. (VBEP.MBDAT) Sales Dollars This is a total dollar amount of the original order that is place BEFORE shipments, adjustments, or cuts if any occur Sales_Data Sales Dollars by Creation Date All orders that are in SAP, including cancelled and rejected. Subtotal 1 from pricing procedure for condition. (VBAP.KZWI1) Sales Quantity in Base UOM
Sales_Data Sales Quantity in Base UOM The total quantity in base unit of measure. (VBAP.KWMENG*VBAP.UMVKZ)/VBAP.UMVKN
Based on Order Date.
Sales Qty in EA This is the total eaches ordered from the original order that is place BEFORE shipments, adjustments or cuts if any occur. Sales_Data Sales Quantity in UOM EA This is the total ordered from the original order that is place BEFORE shipments, adjustments or cuts if any occur in a each unit of measure. Based on Order Date. Sales Qty in Case This is the total cases ordered from the original order that is place BEFORE shipments, adjustments or cuts if any occur. Sales_Data Sales Quantity in UOM CS This is the total ordered from the original order that is place BEFORE shipments, adjustments or cuts if any occur in a case unit of measure. Based on Order Date. Sales Qty in Pallet This is the total pallets ordered from the original order that is place BEFORE shipments, adjustments or cuts if any occur. Sales_Data Sales Quantity in UOM PAL This is the total ordered from the original order that is place BEFORE shipments, adjustments or cuts if any occur in a pallet unit of measure. Based on Order Date. Sales Qty Gross Weight
Sales_Data Sales Gross Weight Package + Candy weight for all sales orders. (VBAP.BRGEW) Sales Qty Net Weight Same as CS but is the total gross weight shipped Sales_Data Sales Net Weight Candy weight for all sales orders.

Sales_Data Sales Required Delivery Quantity Base UOM
Confirmed Dollars by Ship Dt (ship date is a system generated date for Operations to know when product must be ready to ship) Stock is confirmed when the following occurs: 1. The order is NOT on credit hold, 2. Uncommitted (meaning no other orders have been placed against the stock) Stock exists in the warehouse, 3. OR stock is in transit, 4. OR a firm production schedule exists in the system (planned ins system from 1 day (typically for Peanut Chews) to 3 weeks (molded and marshmallow) Sales_Data Confirmed Sales Dollars Stock is confirmed when the following occurs: 1. The order is NOT on credit hold, 2. Uncommitted (meaning no other orders have been placed against the stock) Stock exists in the warehouse, 3. OR stock is in transit, 4. OR a firm production schedule exists in the system (planned ins system from 1 day (typically for Peanut Chews) to 3 weeks (molded and marshmallow) Based on RAD Date.

Sales_Data Confirmed Quantity Base UOM The total confirmed quantity in base unit of measure. Based on RAD Date.

Sales_Data Confirmed Quantity in UOM EA The total number of each for confirmed orders. Based on RAD Date. Confirmed CS by ship date Same as dollars but in case values Sales_Data Confirmed Quantity in UOM CS The total number of cases for confirmed orders. Based on RAD Date.

Sales_Data Confirmed Quantity in UOM Pal The total number of pallets for confirmed orders. Based on RAD Date.

Sales_Data Confirmed Gross Weight Package + Candy weight for all confirmed orders.

Sales_Data Confirmed Net Weight Candy weight for all confirmed orders. Unconfirmed Dollars by ship dt Opposite of confirmed. Either the order is on credit hold or none of the three conditions regarding stock exists Sales_Data Unconfirmed Sales Dollars The total dollars from orders for items not been assigned inventory yet. Based on RAD Date.

Sales_Data Unconfirmed Quantity Base UOM The total unconfirmed quantity in base unit of measure. Unconfirmed qty are orders that have not been assigned inventory yet. Based on RAD Date.

Sales_Data Unconfirmed Quantity in UOM EA The total number of each for unconfirmed orders. Based on RAD Date. Unconfirmed CS by ship date Same as unconfirmed dollars but in cs values Sales_Data Unconfirmed Quantity in UOM CS The total number of cases for unconfirmed orders. Based on RAD Date.

Sales_Data Unconfirmed Quantity in UOM Pal The total number of pallets for unconfirmed orders. Based on RAD Date.

Sales_Data Unconfirmed Gross Weight Package + Candy weight for all unconfirmed orders.

Sales_Data Unconfirmed Net Weight Candy weight for all unconfirmed orders.

Sales_Data Sales Open Dollars Order dollars is original order dollars as requested by customer. This is without cuts, changes, additions. It is also not really filtered by all the other order types or rejection codes, etc.

Sales_Data Sales Open Quantity Base UOM Quantity from orders that have been confirmed but has not yet been shipped to a customer in base unit of measure. Based on RAD Date.

Sales_Data Sales Open Gross Weight Gross weight (includes candy and packaging) from orders that have been confirmed but has not yet been shipped to a customer. Based on RAD Date.

Sales_Data Sales Open Net Weight Net weight of candy from orders that have been confirmed but has not yet been shipped to a customer. Based on RAD Date. Reason for order
Sales_Data Reason For Order
Reason for rejection A reason for rejection is put on an item when we cannot ship for various reasons. The reason chosen identifies the cause of the cut Sales_Data Reason for Rejection A reason for rejection is put on an item when we cannot ship for various reasons. The reason chosen identifies the cause of the cut

Sales_Data Sales Order Type This is the type of order we received. Z001: JB Standard Order. We have excluded Z002-Z007 from the orders already

Sales_Data Sales List Price Per Base Unit

Sales_Data Sales List Price Per Sales Unit

Sales_Data Sales List Price/Base UOM

Sales_Data Partner Customer Number

Sales_Data Sales Gross Weight / Per Base UOM

Sales_Data Sales Net Weight / Per Base UOM
Open Order Dollars Dollar value of all orders in a status that is not shipped or invoiced Sales_Data Order Dollars All order processed (confirmed + unconfirmed). (order quantity base UOM * sales list price/base UOM)

Sales_Data Order Gross Weight Package + Candy weight for all orders processed. (order qty base UOM * sales gross weight/per base UOM)

Sales_Data Order Net Weight Candy weight for all orders processed. (order quantity base UOM * sales gross eight/per base UOM)

Sales_Data Order Quantity in Sales Unit

Sales_Data Order Quantity Base UOM

Shipment_Data Delivered Quantity Base UOM

Delivered Sales Dollars

Delivered Gross Weight

Delivered Net Weight
Shipped not invoiced CS Same as dollar but in cs value
Shipped Not Invoiced Quantity Base UOM
Shipped not invoiced Dollar amount that we have received a ship notice from the warehouse (945) but have not yet invoiced
Shipped Not Invoiced Dollars

Shipped Not Invoiced Gross Weight

Shipped Not Invoiced Net Weight

Invoice_Data Billing Date Date the Invoice was created in SAP

Invoice_Data Billing Document Number
Invoice Dollars by Posting Date This is the amount invoiced to the customer. The date represents the day/month/year the amount is credited to the Company in our general ledger (GL). With few exceptions, this usually is the same date as the shipment was made. Invoice_Data Sales Invoice Dollars

Invoice_Data Proforma Invoice Dollar

Invoice_Data SAP Actual Invoice Dollar All invoice types are included in this total not just the ones related to sales revenue. Invoice Qty in EA Same as CS but in retail unit totals Invoice_Data Invoice Quantity in EA Qty that was invoiced to a customer in eaches Invoice Qty in Case This is the amount invoiced to the customer in CS. Invoice_Data Invoice Quantity in CS Qty that was invoiced to a customer in cases Invoice Qty in Pallet Same as CS but is pallet quantities invoices Invoice_Data Invoice Quantity in PAL Qty that was invoiced to a customer in pallets

Invoice_Data SAP Actual Invoiced Quantity

Invoice_Data Sales Invoice Net Weight Total weight of candy for invoiced orders.
Invoice Qty in Net Weight Same as CS but is net weight of invoice Invoice_Data Net Weight Total weight of candy for all invoiced orders including all invoice types (there is no filtering).

Invoice_Data Sales Invoice Gross Weight Total weight of candy including packaging for all invoiced orders.
Invoice Qty in Gross Wt Same as CS but is gross weight of invoice Invoice_Data Gross Weight Total weight of candy including packaging for all invoiced orders including all invoice types (there is no filtering).

Invoice_Data Sd Document Category Category used to control how the system processes an invoiced document.

Invoice_Data Billing Type Type of bill we need to send. example: F2 (standard), F5 (performa), BV (cash sales), GS (credit memo), L2 (debit memo), S1 (cancelled) and S2 (returns)

Invoice_Data Order Reason

Invoice_Data Posting Period

Invoice_Data GB Invoiced Dollars
Condition Type This divides off-invoice into reasons for the off-invoice allowance Invoice_Data Billing Condition

Budget Dollars The dollar value of the budget submitted 1x per year. This is a upload from an excel spreadsheet prepared from the budgeting process. Dollars values should be based on list price but these values are on the spreadsheet and NOT determined by the list price in SAP. Budget_Data Budget Dollar The dollar value of the budget submitted 1x per year. This is a upload from an excel spreadsheet prepared from the budgeting process. Dollars values should be based on list price but these values are on the spreadsheet and NOT determined by the list price in SAP. Budget Quantity Same as dollars but the case quantity Budget_Data Budget Quantity Total quantity budgeted Budget Pound Same as dollars but the gross pound value Budget_Data Budgetpounds Total pounds budgeted

Budget_Data Budget Quantity in UOM PAL Total quantity budgeted in pallets

Broker Forecast Dollars Dollar Value of the forecast submitted by the brokers. Forecast_Data Broker Forecast Dollars Dollar Value of the forecast submitted by the brokers. Broker forecast = BRK (Broker Forecast) + APR (Approved Demand Alert) Broker Forecast Quantity Case quantities of the broker forecast Forecast_Data Broker Forecast Quantity Qty entered in the BRk +APR broker forecast in cases Broker Forecast Pounds Net Weight Net weight of the broker forecast Forecast_Data Broker Forecast Pounds Net weight of the broker forecast Broker Forecast in Gross Weight Gross weight of the broker forecast Forecast_Data Broker Forecast in Gross Weight Gross weight of the broker forecast Broker Forecast in Pallet Pallet quantities of the broker forecast Forecast_Data Broker Forecast in Pallet Qty in pallets of the broker forecast SAP Forecast Dollars Same as CS but the measurement is the dollar value of the forecast based on the list price in SAP; NOTE: If no list price exists, the forecast will not be valued. FOR (Final Forecast) = BFC (Base Forecast) + APR (Adjustment - Promotions) + AAN (Adjustment - Analyst) Forecast_Data Consensus Forecast Dollars Consensus forecast is calculated as follows FOR (Final Forecast) = BFC (Base Forecast) + APR (Adjustment - Promotions) + AAN (Adjustment - Analyst) SAP Forecast Quantity This is the massaged sales forecast in CS. IN most instances this the same amount that is passed to the Operations team for production purposes. Forecast_Data Consensus forecastqty Qty entered in the BRK + APR broker forecast in cases SAP Forecast Pounds Net Weight Same as CS but the measurement is net weight of forecast Forecast_Data Consensus Forecast Pounds Net weight of the consensus qty SAP Forecast Pounds Gross Wt Same as CS but the measurement is gross weight of forecast Forecast_Data Consensus Forecast Pounds Gross Weight Gross weight of the consensus qty SAP Forecast in Pallets Same as CS but the measurement is # of pallets the forecast represents Forecast_Data Consensus Forecast Qty in Pallets Consensus qty in pallets SAP Model Forecast Dollars This is simply the SFC (Statistical Forecast) (nothing added together) and will appear in Incorta as "Statistical Forecast" Forecast_Data Statistical Forecast Dollars This is simply the SFC (Statistical Forecast) (nothing added together) and will appear in Incorta as "Statistical Forecast" SAP Model Forecast Quantity This is simply the SFC (Statistical Forecast) (nothing added together) and will appear in Incorta as "Statistical Forecast" Forecast_Data Statistical Forecast Quantity Qty entered in the statistical forecast version in cases SAP Model Forecast in Pallet Same as CS but the measurement is # of pallets the forecast represents Forecast_Data Statistical Forecast Qty in Pallets Qty in pallets

Forecast_Data Retailpacksize

Forecast_Data Plant

Forecast_Data salesorganization

Forecast_Data Broker Name

Forecast_Data Broker Number

Forecast_Data Customer Number

Formulas
Potential Dollars (pivot table) sum(Sales_Explorer.Invoice_Data.Sales_Invoice_Dollar)
+ sum(Sales_Explorer.Shipment_Data.Shipped_Not_Invoiced_Dollars)
+ sum(Sales_Explorer.Sales_Data.Unconfirmed_Sales_Dollars)
+ sum(Sales_Explorer.Sales_Data.Sales_Open_Dollars) ago is a time function that calculates the aggregated value from a specified date to a specified time period. ago(date exp, int rollBack, string datePart)
sum(Sales_Explorer.Invoice_Data.Sales_Invoice_Dollar,
ago(Sales_Explorer.Date_Dim.Date, 1,'Year' ))
toDate is a time function that calculates the aggregated value from the start of specified date part to a specified date.

Change Control

Date

Modification Made

Version

User

5/2/2024

Changed the label for the following fields:

Case changed to Case Type

Unit changed to Retail Pack Size

Year changed to Calendar Year

Diana Weaver

10/7/2024 Added fields:
Customer PO,
Sales Invoice Net Weight,
Sales Invoice Gross Weight.

Diana Weaver/George Boose