---
description: "A standard DSO has three transparent tables on the database. Activation Queue: Holds the records that are to be updated, not yet been activated. Active Data:Table which holds active data. Change Log:"
title: What is Standard DSO in SAP?
image: https://www.guru99.com/images/what-is-standard-dso-in-sap.png
---

[Skip to content](#main)

**⚡ Smart Summary**

A Standard DSO in SAP BW stores consolidated, cleansed transaction data at detailed level across three tables, the activation queue, active data, and change log, supporting overwrite, delta loads, and detailed-level reporting.

- 🗃️ **Three Tables:** A standard DSO has an activation queue, an active data table, and a change log.
- 🔁 **Activation:** Data moves from the new table to the active table and then to the change log.
- 📝 **Change Log:** The change log records delta history and supports delta loads to other targets.
- 🔑 **Key and Data Fields:** Key fields make records unique; data fields hold attributes and key figures.
- ⚙️ **Settings:** Options control SID generation, unique records, and automatic activation.
- 🤖 **AI Assistance:** AI monitors load and activation jobs and flags data quality issues early.

Read More

![What is Standard DSO in SAP](https://www.guru99.com/images/what-is-standard-dso-in-sap.png)

## What is a Standard DSO?

A standard DSO is the most common DataStore Object. It has three transparent tables on the database:

1. **Activation Queue:** holds the records that are to be updated but have not yet been activated.
2. **Active Data:** the table that holds active data.
3. **Change Log:** holds the change history for delta loads.

## Process of Data Transfer to a DSO

- Data is first loaded into the activation queue, also called the new data table.
- Upon activation, data is transferred from the new data table to the active data table.
- And then to the change log table. The change log table holds the changed or corrected data.

**Note:** the data in the change log table is stored redundantly and can be deleted after the records have been activated.

[![Process of Data Transfer to DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_1.jpg)

## Creation of a Standard DSO

**Step 1)**

1. Go to transaction code RSA1.
2. Click the OK button.

[![Creation of Standard DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_2.jpg)

**Step 2)**

1. Navigate to the Modeling tab -> InfoProvider.
2. Right click on InfoArea.
3. Click on “Create DataStore Object” from the context menu.

[![Creation of Standard DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_3.jpg)

**Step 3)**

1. Enter the Technical Name.
2. Enter the Description.
3. Click on the “Create” button.

[![Creation of Standard DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_4.jpg)

**Don't Miss:**

- [How To Create an Infoarea in SAP BW/BI](https://www.guru99.com/how-to-create-an-infoarea.html)
- [How to Create an InfoObject Catalog in SAP BI/BW](https://www.guru99.com/how-to-create-an-infoobject-catalog.html)
- [How to Load Master Data From ECC in SAP BI/BW](https://www.guru99.com/how-to-load-master-data-from-ecc.html)
- [RSA5 Tcode in SAP BW: Load ECC Transaction Data](https://www.guru99.com/how-to-load-transaction-data-from-ecc.html)

## Settings in a DSO

1. **Type of DataStore Object:** changes the type of DSO. By default, Standard DSO is chosen. This can be changed to write-optimized or [direct-update DSO](https://www.guru99.com/what-is-direct-update-dso-how-to-create-one.html).
2. **SID Generation upon Activation:** generates the Surrogate ID (SID) for each master data value when this option is checked.
3. **Unique Data Records:** used when the DSO will never hold duplicate values.
4. **Set Quality Status to OK Automatically:** sets the quality status after data loading completes.
5. **Activate Data Automatically:** automates DSO activation.
6. **Update Data Automatically:** loads the data in the DSO to target objects automatically.

## Including Key Fields and Data Fields in the DSO

A DSO contains two kinds of fields: key fields and data fields. The key field is used to make records unique. Other fields can be included as data fields.

**Step 1)** Right click on “Key fields” and choose the option “InfoObject Direct Input”.

[![Including Key Fields and Data Fields in the DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_5.jpg)

**Step 2)** The following pop-up opens. Here you can input the technical names of the [InfoObjects](https://www.guru99.com/all-about-infoobject-infoarea-infoobject-catalog.html) to include and press Enter.

[![Including Key Fields and Data Fields in the DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_6.jpg)

Below shown are the key fields added in the DSO.

[![Including Key Fields and Data Fields in the DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_7.jpg)

**Step 3)** Navigational attributes are viewed in the DSO by default, but the ON/OFF check box has to be chosen if a navigational attribute is to be used in reporting.

**Step 4)** The DSO structure design is complete. Activate the DSO by clicking the Activate button.

[![Including Key Fields and Data Fields in the DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_9_8.jpg)

## FAQs

🔁 What happens during standard DSO activation?

During activation, records move from the activation queue (new table) to the active data table, and the before-and-after images are written to the change log. The change log enables delta updates to InfoCubes and other targets.

🆚 What is the difference between a standard and a write-optimized DSO?

A standard DSO has three tables and requires activation, which allows overwrite and delta handling. A write-optimized DSO has only the active table, needs no activation, and loads faster, but it cannot overwrite records.

🔑 What is SID generation upon activation in a DSO?

When SID Generation upon Activation is checked, SAP creates Surrogate IDs for each master data value during activation. This speeds up later reporting but slows activation. It can be switched off if the DSO only stages data.

🤖 Can AI optimize DSO loading and activation?

Yes. Intelligent automation schedules loads and activation, while machine learning predicts long-running jobs and flags failures. The SAP Joule AI copilot can answer setup questions, reducing manual monitoring of nightly DSO loads.

🧠 How does AI improve data quality in a standard DSO?

Machine learning checks incoming records for duplicates, missing keys, and outliers before activation. This intelligent cleansing raises the trustworthiness of the active data that feeds InfoCubes and BEx queries.

#### Summarize this post with:

ChatGPTPerplexityGrokGoogle AI

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.**

##### Sign up for the newsletter

Subscribe for Free

You have successfully subscribed.  
Please check your inbox.

![AI-Newsletter]() Chosen by over **350,000+** professionals

[Scroll to top](#wrapper)

×

Search for:

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/what-is-standard-dso-in-sap.png","url":"https://www.guru99.com/images/what-is-standard-dso-in-sap.png","width":"700","height":"250","caption":"What is Standard DSO in SAP?","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/sap-bi","name":"SAP - BI"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html","name":"What is Standard DSO in SAP?"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#webpage","url":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html","name":"What is Standard DSO in SAP?","dateModified":"2026-10-09T16:19:27+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/what-is-standard-dso-in-sap.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/editorial","name":"Editorial Team","url":"https://www.guru99.com/author/editorial","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/favicon-new-logo.png","url":"https://www.guru99.com/images/favicon-new-logo.png","caption":"Editorial Team","inLanguage":"en-US"},"sameAs":["https://www.guru99.com/editorial-team"],"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"SAP - BI","headline":"What is Standard DSO in SAP?","description":"A standard DSO has three transparent tables on the database. Activation Queue: Holds the records that are to be updated, not yet been activated. Active Data:Table which holds active data. Change Log:","keywords":"sap-bi","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/editorial","name":"Editorial Team"},"dateModified":"2026-10-09T16:19:27+05:30","image":{"@id":"https://www.guru99.com/images/what-is-standard-dso-in-sap.png"},"copyrightYear":"2026","name":"What is Standard DSO in SAP?","subjectOf":[{"@type":"HowTo","name":"What Is Standard DSO in SAP? How To Create One?","description":"A standard DSO has three transparent tables on the database.","step":[{"@type":"HowToStep","name":"Step 1) Go to transaction code RSA1","text":"Click the OK button.","image":{"@type":"ImageObject","url":"https://cdn.guru99.com/images/sap/SAP_BI/sap_bi_9_2.jpg"},"url":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#step1"},{"@type":"HowToStep","name":"Step 2) Navigate to Modeling tab->InfoProvider.","text":"Right click on InfoArea.","image":{"@type":"ImageObject","url":"https://cdn.guru99.com/images/sap/SAP_BI/sap_bi_9_3.jpg"},"url":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#step2"},{"@type":"HowToStep","name":"Step 3) Enter the Technical Name.","text":"Enter the Description.","image":{"@type":"ImageObject","url":"https://cdn.guru99.com/images/sap/SAP_BI/sap_bi_9_4.jpg"},"url":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#step3"}]},{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What happens during standard DSO activation?","acceptedAnswer":{"@type":"Answer","text":"During activation, records move from the activation queue (new table) to the active data table, and the before-and-after images are written to the change log. The change log enables delta updates to InfoCubes and other targets."}},{"@type":"Question","name":"What is the difference between a standard and a write-optimized DSO?","acceptedAnswer":{"@type":"Answer","text":"A standard DSO has three tables and requires activation, which allows overwrite and delta handling. A write-optimized DSO has only the active table, needs no activation, and loads faster, but it cannot overwrite records."}},{"@type":"Question","name":"What is SID generation upon activation in a DSO?","acceptedAnswer":{"@type":"Answer","text":"When SID Generation upon Activation is checked, SAP creates Surrogate IDs for each master data value during activation. This speeds up later reporting but slows activation. It can be switched off if the DSO only stages data."}},{"@type":"Question","name":"Can AI optimize DSO loading and activation?","acceptedAnswer":{"@type":"Answer","text":"Yes. Intelligent automation schedules loads and activation, while machine learning predicts long-running jobs and flags failures. The SAP Joule AI copilot can answer setup questions, reducing manual monitoring of nightly DSO loads."}},{"@type":"Question","name":"How does AI improve data quality in a standard DSO?","acceptedAnswer":{"@type":"Answer","text":"Machine learning checks incoming records for duplicates, missing keys, and outliers before activation. This intelligent cleansing raises the trustworthiness of the active data that feeds InfoCubes and BEx queries."}}]}],"@id":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#schema-31698","isPartOf":{"@id":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/what-is-standard-dso-how-to-create-one.html#webpage"}}]}
```