Show TOC

 View Grouping: Sales Document Aggregated Sales Data by Article Location

 

The views within this grouping provide aggregated sales item data by article location from the sales documents in an SAP ERP system. In addition, these views are reused in integration scenarios with Demand Data Foundation (DDF), as they can be used to obtain sales data for use in demand planning, similar to the SAP POS DM reporting to Demand Management Foundation (DMF).

Structure

Reuse Views

This view grouping contains the following main reuse views:

  • Sales document aggregated sales data by article location (SalesDocumentAggregatedSalesByArticleLocation)

    This view obtains sales item data by article location from SAP ERP sales documents, and aggregates this data based on the applicable attributes. It exposes information for all items with common attributes across all channels (in-store, Web, and so on).

  • Sales document aggregated sales data (SalesDocumentAggregatedSales)

    This view obtains the item data from SAP ERP sales documents, and aggregates this data based on the applicable attributes.

  • Sales document item offer (SalesDocumentItemOffer)

    This view obtains the sales document item information from SAP ERP, and determines the specific offer applicable to each line item. If the system cannot determine an offer, then no results will be provided for the line item. If the system finds multiple offers for a single line item, it then determines and selects the most relevant offer.

  • Sales document item (SalesDocumentItem)

    This view obtains the sales document item information from SAP ERP.

  • Promotion bonus buy product (PromotionBonusBuyProduct)

    This view provides promotion data for bonus buy products, such as the relevant areas for the promotion (for example, sales organization, distribution channel, plant), the promotion and bonus buy identifiers, the validity date range for the promotion or bonus buy, the applicable material and sales unit of measure, and the underlying DDF offer.

  • Promotion product (PromotionProduct)

    This view provides promotion data for non bonus buy products, such as the relevant areas for the promotion (for example, sales organization, distribution channel, plant, customer), the promotion and bonus buy identifiers, the validity date range for the promotion, the applicable material and sales unit of measure, and the underlying DDF offer.

  • Plant (Plant)

    This view obtains master data regarding the plant from SAP ERP for Retail.

  • Sales organization (SalesOrganization)

    This view obtains master data for the sales organization from SAP ERP for Retail.

  • Order channel (OrderChannel)

    This view obtains Customizing data regarding the order channel from SAP Customer Activity Repository.

Business Objects

These views are built on the sales document item business object.

Measures and Attributes

Some important measures and attributes are:

  • Sales document aggregated sales by article location (SalesDocumentAggregatedSalesByArticleLocation) view

    • The view provides general data such as the location (representing plant-customer), plant, order channel, offer (if applicable), promotion (if applicable), material number and group, sales organization, distribution channel, and the reporting date (sales document date).

    • The view provides information about values, such as the revenue tax amount, revenue net amount, and unit sales quantity in base and sales units of measure. The currency provided as an optional input parameter (P_DisplayCurrency) is used to display all amount measures, and any currency conversion is done automatically, based on the exchange rate type provided as an input parameter (P_ExchangeRateType). If no display currency is provided, then the currency defined for the associated plant’s sales organization company code is used instead.

  • Sales document aggregated sales item (SalesDocumentAggregatedSales) view

    • The view provides general data such as the location (representing plant-customer), plant, the order channel, the sales organization and distribution channel, the transaction (document) and company code currencies, the material number and base or sales unit of measures, the associated promotion (if any), the retail item category and subcategory, reporting date (sales document date), the sales document and item, and the sales document, item categories and types.

    • The view provides information about values such as the sales quantity in base or sales unit of measure, net amount, tax amount, and gross amount.

  • Sales document item offer (SalesDocumentItemOffer)

    • The view provides the offer determined for a specific SAP ERP sales document item.

  • Sales document item (SalesDocumentItem)

    • The view provides general data, such as the category and type for the sales document and item, material number and group, promotion (if applicable), sales document date, and plant.

    • The view provides information about values such as the quantity, sales amount, and tax amount.

Calculation of Measures

To interpret the sales document aggregated sales data by article location, it is important to understand the calculation of certain measures included in this view grouping:

Measure

Explanation of Calculation

GrossAmount

In view SalesDocumentAggregatedSales, this measure shows the gross sales amount for sale or return items, excluding any discount amount but including any item tax amount.

NetAmount

In view SalesDocumentAggregatedSales, this measure shows the net retail sales amount for sale or return items, excluding any discount or tax amount.

Filters

The views use the following filters:

  • The sales document aggregated sales by article location (SalesDocumentAggregatedSalesByArticleLocation) view filters data based on the filters used in its underlying views as described below.

  • The sales document aggregated sales item (SalesDocumentAggregatedSales) view filters the following:

    • Input parameter SAP client (SAPClient is P_SAPClient)

    • Input parameter location (Location matches P_Location)

    • Input parameter plant (Plant matches P_Plant)

    • Input parameter reporting date (ReportingDate is between P_ReportingDateStarting and P_ReportingDateEnding)

    • Document category (SDDocumentCategory is C or H). The document category must be a type of sales order or return.

  • The sales document item offer (SalesDocumentItemOffer) view filters the SAP ERP sales document item for the same filters defined for the sales document aggregated sales item (SalesDocumentAggregatedSales) view.

  • The promotion product (PromotionProduct) view used within the sales document item offer (SalesDocumentItemOffer) view filters the offer (Offer is not empty), so that only promotions having an associated offer are considered.

Used Tables and Views

  • /CAR/SALESDOCOC (sales document order channel derivation) — SAP Customer Activity Repository

  • VBAK (sales document header) — SAP ERP for Retail

  • VBUK (sales document header status) — SAP ERP for Retail

  • VBAP (sales document item) — SAP ERP for Retail

  • VBUP (sales document item status) — SAP ERP for Retail

  • WALE (material to store assignment to promotion) — SAP ERP for Retail

  • WAKH (promotion header data) — SAP ERP for Retail

  • WAKP (promotion item data) — SAP ERP for Retail

  • T001W (plant) — SAP ERP for Retail

  • TVKOV (sales organization) — SAP ERP for Retail

  • TVKOT (sales organization text) — SAP ERP for Retail

  • TVTWT(distribution channel text) — SAP ERP for Retail