Show TOC

Handling Transaction Data from Retailers Locate this document in the navigation structure

 

The following DataStore objects (DSO) of the propagation layer are used as the central InfoProviders for reporting on aggregated sales data or stock snapshot data:

  • Aggregated Sales Propagation (/DDF/DS11)

  • Stock Snapshot Propagation (/DDF/DS12)

Both DSOs contain the following key fields:

  • Time Dimension

    Time Stamp From (/DDF/TIME_FROM) and Generic Time (Time Stamp To) (/DDF/TIME) define the interval of the timestamps with reporting-relevant time characteristics as attributes (for example, calendar day, week, or the posting periods of a fiscal year variant defined in Customizing).

  • Product Dimension

    Internal Source Product (/DDF/PRODUCT) with all local attributes, units of measure, and the attributes (Product (/DDF/GPID), Source Product (/DDF/PRODREF), and Manufacturer Product (0MATERIAL)) to link to the attributes or hierarchies of those objects.

  • Location Dimension

    Internal Source Location (/DDF/LOCATION) with geographical attributes like country (0COUNTRY), region (0REGION), city (/DDF/CITY), attributes of the data delivery agreement (data origin, data provider, context), and the attributes Location (/DDF/GLID), Source Location (/DDF/LOCREF), and Account (0CUSTOMER) to link to the attributes or hierarchies of those objects.

There are additional transaction-specific key fields to separate different types of sales data (/DDF/SALGRP) for aggregated sales data or different types of stock (/DDF/STOCKTYPE) for stock snapshot data.

Note Note

These fields are defined in Customizing. They are important for the data enrichment process, because the value 0001 for the field Type of Sales is reserved for data records that have been created during sales data enrichment to distinguish them from regular sales (1000) or promotional sales (1001). Similarly, the Stock Type 00 is reserved for data records created during stock data enrichment.

End of the note.

This graphic is explained in the accompanying text.

Data Model for Transaction Data (Simplified Overview)

More Information

Example: Use of CompositeProviders for Sales Data

Data Enrichment

BI content documentation: