RIS Information Structures 

Data from the operational applications in SAP Retail is updated to the RIS Information Structures.

The RIS occasionally uses information structures that serve only as auxiliary structures for the purposes of adjustment between movement and stock data and in which data cannot be updated. When standard analyses that access an auxiliary structure are executed, data is read from an information structure containing movement data and one containing stock data. The system performs a back calculation for stock, and thus determines the calculated key figures. The data from the auxiliary structure forms the basis for planning.

This procedure applies to the following information structures:

Auxiliary Structure

Movement Data

Stock Data

S079 (STRPS)

S077

S078

S082 (Purchasing)

S080

S081

S085 (Article)

S083

S084

S107 (Article)

S105

S106

The conversion of the corresponding update rules could look like this for information structure S082:

The standard R/3 System provides the following information structures in the Retail Information System:

This information structure contains the data basis for creating short-term retail profitability statements and thus also forms the basis for the STRPS standard analysis.

The information structure S079 is the central information structure of the Retail Information System and represents the sales view.

The lowest data aggregation level is the merchandise category. The information structures for the article provide more detailed data.

This information structure provides data relevant to Purchasing. It therefore provides the data basis for the Purchasing standard analysis. The lowest data aggregation level is the merchandise category. The information structures for the article provide more detailed data.

This information structure provides data, which enables you to analyze data right down to article level from the perspective of Sales and of Purchasing, and also to determine cause and effect. It provides the data basis for the article standard analysis.

The information structure S086 provides the data basis for the promotion standard analysis. It provides data concerning the logistics processes and the sale of promotional merchandise and thus forms the basis for analyzing promotion transactions.

This information structure provides the data basis for the article/add-on standard analysis. It contains additional, detailed information that is not available in the information structure S085. S087 provides the basis for analyzing inventory differences or increased goods clearing.

The information structure S107 provides the data basis for the season standard analysis, and supplies information that supports the purchase/sale of fashionable articles. This information structure only provides data concerning articles that are either seasonally fashionable or limited by season. The purpose of this information structure is to concentrate on supporting the area of textiles (size and color evaluations). For this reason, key figures and characteristic criteria are added to the characteristics section of the information structure as additional selection and drill-down parameters. In this way, you can obtain additional information about the characteristics of the information structure. This also enables you to select articles which have a specific color, size, or fashion ID.

The information structure S108 is used for updating articles that have been provided with additionals. In this way, it is possible to analyze the costs incurred due to the fixing of these additionals.

The information structure S110 is chiefly used in LIS Flexible Planning (planning of open-to-buy) and can be used for the planning of seasonal articles and fast-moving articles. It helps you to determine the open volume of the purchasing budget (open-to-buy).

This information structure contains key figures which are planned with the help of flexible planning, as well as key figures which are updated from the operative application. You can use the information structure S110 to create Exceptions with the help of the Early Warning System. In this way you can accurately check for weak points between the planned seasonal budget and the actual seasonal budget.

Information about how to use the Early Warning System can be found in the general LIS documentation under Early Warning System

Additional information about open-to-buy can be found in the R/3 Retail Documentation in the section on the planning system under Open-To-Buy (OTB)

This information structure forms the data basis for the standard analyses of subsequent settlement. The information structure S015 is updated when the events "invoice receipt for a purchase order" (vendor business volume) or "subsequent settlements of an arrangement (income) by credit memo/billing document" take place.

The main characteristic of these information structures is the customer. Both information structures are therefore particularly relevant to the wholesale trade and also the retail sector, if the customer is known (in the furniture sector, for example). The key figures are derived from sales and distribution processes, and include key figures such as sales (absolute) and key figures referring to third-party orders.

S123 is filled with data up to the aggregation level merchandise category. S124 enables detailed analyses and provides data up to the aggregation level article.

This information structure is used by the standard analyses of the rough workload preview. It contains the data basis for performing workload considerations for all warehouse processes.

The overall structure for rough workload estimate constitutes the upper level of the dual-level design of rough workload estimate.

This is a general structure that comprises all warehouse processes and only contains those characteristics that can be interpreted in the same way for all warehouse processes.

The period unit of this information structure is Day and cannot be changed. If required, you can copy this information structure to create a self-defined information structure.

This information structure is used by the standard analyses of the rough workload estimate. It contains the data basis for performing workload considerations for the warehouse processes picking/goods issue and returns to vendor.

The goods issue structure for rough workload estimate constitutes the lower level of the dual-level design of rough workload estimate.

This is a general structure that only contains data from the warehouse processes picking/goods issue and returns to vendor. All characteristics and key figures from the overall structure are also contained in this information structure. It also contains characteristics that are only of relevance for the two warehouse processes picking/goods issue and returns to vendor.

The period unit of this information structure is Day and cannot be changed. If required, you can copy this information structure to create a self-defined information structure.

Information structure S160 serves as the basis for the operative application component Perishables Planning. This supplementary component of the standard system enables you to control the process flow for perishables. It covers the requirements of both the retail sector and of wholesale trade.

The period unit of this information structure is Day and cannot be changed. If required, you can copy this information structure to create a self-defined information structure.

This information structure enables you to build up a collection of key figures which provide you with the following two options for analyzing physical inventories with respect counting results and difference results for articles and merchandise categories:

For the time before posting of the physical inventories, information structure S200 acts as a tool which you can use to search the perpetual inventory procedures up to article level to ascertain the differences that may be expected. This is possible from the initial counts onwards.

The Early Warning System can also be used to analyze this information structure. This means that you can detect and avert possible errors in the logistical process before the inventory differences finally defined.

The list of inventory differences that already exists is not replaced by information structure S200!

If differences do occur for physical inventory items, you can branch to the list of inventory differences from the standard analysis of S200. This will provide you with more detailed information on the differences.

After the inventory differences have been posted, you can use information structure S200 to create evaluations on recurring inventory differences and the reason why they occur. You can create periodic evaluations for articles, merchandise categories or sites.

Information Structures for the Sales Audit

The following information structures allow you to analyze POS data. They are all updated on a daily basis in the standard system and provide the data basis for the standard analysis of the same name.

The information structure S120 provides data relating to sales at the POS which can be used as the basis for performing shopping basket analyses and for planning shifts for cashiers. This structure enables analysis of the average sales per transaction or of price reductions, via a variety of characteristics such as cashier, article, store, customer, or hour of sale. This information structure therefore provides detailed data on the lowest aggregation level and contains an immense volume of data.

S120 also enables you to perform detailed analyses, based on the data provided by the two information structures S121 and S122.

This information structure provides aggregated POS data at the aggregation level of article and store. It allows you to access the sales analysis at POS level. This means that you can compare articles and merchandise categories store-by-store and then branch directly to information structure S120 to perform a detailed analysis if you find deviations, for example.

The POS-specific information structure S122 concentrates on the POS and the cashier. S122 therefore contains data concerning POS differences, void transactions and cancellations throughout the different stores.

This information structure has two purposes:

In order to minimize the system load for information structures S121 and S122, you should create an index for the data selection of the characteristics you require for your specific situation.

You can find further information about updating these information structures and about the POS interface in RIS under POS Interface.

Information Structures for Market-Basket Analysis

You can use information structures S117 and S119 to evaluate transaction data.

Both information structures are supplied with data via Copy Management from the POS information structure S120.

The information structure S117 is generated from S120 in an initial Copy Management (CM) run. S117 supplies the information structure S119 with data.

Use the following SAP methods to supply the information structures S117 and S119 with data:

The information structure S117 delivers data on the market-basket level, that is, on the level of the receipt or article. It enables you to analyze the composition of shopping baskets. For example, this could involve the analysis of companion sales or a check on the effectiveness of advertising.

S119 delivers data on the cumulated shopping basket level, in other words, a data record represents a complete transaction or purchasing activity of a customer . This information structure enables you to analyze the purchasing behavior of customers.

Exception reporting enables you to perform a self-defined grouping of customers, for example, based on master data or customers who prefer special offers.

You can perform a more detailed analysis of this customer group by switching to the detailed shopping basket level (S117) using Change info structure.

In addition, the "key figure matrix" function enables you to perform a meaningful customer frequency analysis.

A full list of the characteristics and key figures of the standard analyses in the Retail Information System can be found in Characteristics and Key Figures: Retail Information System.

You can find notes relating to the calculation of key figures in How Key Figures Are Calculated.