How to Archive Info Structures in SAP for Retail

  • by Sandeep Kumar, Lead Consultant, Infosys
  • Manojkumar Radhakrishnan, Consultant, Infosys
  • March 11, 2014
In a major retail site or store, data from point of sale (POS), the front-end system in the retail industry, is stored in multiple SAP tables and shares relevant data as a single POS database, known as an information structure (info structure). Because the database grows rapidly, it slows the SAP retail system and requires archiving of info structures. Learn how to improve SAP for Retail performance by archiving sales and transactional POS data and having it available for retrieval if necessary. This works for all info structures, including S920, S906, and S907.
Learning Objectives

By reading this article, you will learn how to:

  • Archive point-of-sale (POS) info structures from the SAP for retail system
  • Write, store, delete, and retrieve POS info structures
Key Concept
Data archiving moves unwanted data from a place where space is required to a place from where it can be extracted in case it is needed in the future. SAP provides a way of archiving standard objects and tables through transaction code SARA, but there is no way of archiving info structures, which store data received from outside the SAP system.

SAP provides archiving functionality for some standard objects, such as site, article, purchase order, deliveries, and bills of material. However, for many objects there is no standard transaction or program for data archiving, including archiving information structures. We explain the process of data archiving of info structure S920 as an example. Info structure S920 holds the critical data for every sales transaction. Therefore it grows very quickly and requires timely data archiving.

This example requires that you have an SAP for Retail system that receives point-of-sale (POS) data. This process requires some understanding of SAP materials management (MM).

Note
We focus on archiving standard and custom info structures. We do not describe generic archiving, but an archiving process specific to IS Retail in which data is received from POS and stored in the form of info structures.

Because there is no standard functionality, we explain the end-to-end process of archiving an info structure. This process archives all the data in the info structure and makes it search efficient.

The data archival process can be broken into five activities.

  1. Manage
  2. Write
  3. Store
  4. Delete
  5. Reload

 

Sandeep Kumar

Sandeep Kumar is a lead consultant with Infosys with more than 17 years of experience working in the automotive, aeronautical, and hi-tech manufacturing industries. He specializes in implementing SAP in the manufacturing industry domain. He holds a master's degree in financial management and a bachelor’s degree in production and industrial engineering.

See more by this author

Manojkumar Radhakrishnan

Manojkumar Radhakrishnan is a consultant at Infosys. He has more than nine years of experience in implementation, upgrades, and production support in the areas of SAP-MM, SAP for Retail, and data archiving.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.