--- title: How to Extract Data into SAP BW/4HANA Using Generic DataSources description: Learn how to extract data from SAP S/4HANA to SAP BW/4HANA using generic DataSources. image: https://blog.sap-press.com/hubfs/How%20to%20Extract%20Data%20into%20SAP%20BW4HANA%20Using%20Generic%20DataSources%202.png --- [![rheinwerk-sappress-logo-header-1](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://blog.sap-press.com/) [Blog](https://blog.sap-press.com) - Books - Get an overview of our books and courses on every relevant SAP topic. - [Programming](https://sap-press.com/programming/) - [Administration](https://sap-press.com/administration/) - [BI](https://sap-press.com/business-intelligence/) - [Finance](https://sap-press.com/finance-controlling/) - [Logistics](https://sap-press.com/logistics/) - [HR](https://sap-press.com/human-resources/) - [CRM & Sales](https://sap-press.com/marketing-sales/) - [HANA](https://sap-press.com/hana/) - [Introductions](https://sap-press.com/introductions/) - [E-Bites](https://sap-press.com/e-bites/) - [Certification Guides](https://www.sap-press.com/certification-guides/) - [Rheinwerk Courses](https://www.sap-press.com/online-courses/) - Book Subscription - Get unlimited access to all SAP PRESS books! - [SAP PRESS Subscription](https://sap-press.com/subscriptions/) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) # How to Extract Data into SAP BW/4HANA Using Generic DataSources ![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg) by [SAP PRESS](https://blog.sap-press.com/author/sap-press) In this blog post, we’ll walk through extracting data from SAP S/4HANA using generic DataSources and transferring that data to SAP BW/4HANA. ## Replicate the DataSource Follow these steps to begin replication of the DataSource: 1. Replicate the DataSource based on the application component (see figure below). To do so, log onto the [SAP BW/4HANA](https://learning.sap-press.com/sap-bw4hana) system, right-click the source system, and select **Replicate** to start the job for DataSource replication. ![Replication](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-47-58-5363-PM.png?width=831&height=717&name=image-png-Sep-12-2024-12-47-58-5363-PM.png) 1. The screen will list all the DataSources that can be replicated, with the option to select and deselect DataSources. Choose the DataSource that you need to replicate, click **Select Displayed Datasources**, and then choose **Next**, as shown. ![Choose Next and Finish](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-48-22-9990-PM.png?width=1014&height=682&name=image-png-Sep-12-2024-12-48-22-9990-PM.png) 1. Before starting the replication process, first check the header table for the [SAP BW](https://learning.sap-press.com/sap-data-management#SAP-Business-Warehouse) DataSource, which is RSDS. Enter the name of the DataSource—for this example, “ZRKGENDS1”—in the **DataSource** You’ll see that table RSDS doesn’t have that specific field, as shown in the figure below. Zero entries met the selection criteria. ![Before Replication](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-48-42-1886-PM.png?width=1152&height=603&name=image-png-Sep-12-2024-12-48-42-1886-PM.png) 1. Meanwhile, the replication job should have finished. When the replication is successful with the activation and the DataSource is saved in SAP BW/4HANA (next figure), you can open the DataSource and activate it using the icon if it isn’t active. ![Job Finished](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-49-00-3418-PM.png?width=1197&height=412&name=image-png-Sep-12-2024-12-49-00-3418-PM.png) 1. After the completion of the replication job, check table RSDS again. The DataSource is now available in in **M** and **A** versions, as shown below. ![A and M Versions](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-49-19-2509-PM.png?width=1185&height=316&name=image-png-Sep-12-2024-12-49-19-2509-PM.png) 1. To validate the DataSource replication, you need to search for the DataSource name in Eclipse and then open it. You can see that **Adapter** is set to **Extraction from SAP System by Operational Data Provisioning** and the **ODP Context** is based on **DataSource/Extractors**. you can see the operational data provider with the name of the DataSource, **ZRKGENDS1** (see the next figure). **![Eclipse DataSource](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-49-45-5130-PM.png?width=1165&height=562&name=image-png-Sep-12-2024-12-49-45-5130-PM.png)**   ## Data Modeling for Generic DataSources in SAP BW/4HANA With the DataSource available, you can create the SAP BW data model using these steps: 1. Start with the creation of an aDSO with reference to the DataSource, as shown in the next figure. In this example, to start, right-click the **RKPBGEN** InfoArea and choose to create an aDSO. You’ll see the aDSO creation wizard. Name the aDSO “ZADGEN” and provide the description. You can see that the aDSO is based on the DataSource, so choose **Browse** in the **DataSource** field and select **ZRKGENDS1** as the DataSource template. Once you choose the DataSource, the source system will be assigned by default. In this example, the source system is **S4SCLNT100**, which is the SAP S/4HANA system. ![aDSO Template](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-50-20-8633-PM.png?width=1446&height=926&name=image-png-Sep-12-2024-12-50-20-8633-PM.png) Once the aDSO is created, activate it using the icon. Create a transformation for the aDSO with the source as DataSource ZRKGENDS1 and activate it. Create the DTP for the aDSO from the transformation; you can see that the transformation is based on the same generic DataSource (ZRKGENDS1). Activate the transformation and DTP as shown. ![DTP for Generic Extraction](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-51-52-3212-PM.png?width=1508&height=412&name=image-png-Sep-12-2024-12-51-52-3212-PM.png) The final dataflow that can be seen from the aDSO level is shown in the next figure. The source system is S4SCLNT100, and it sends data to the ZRKGENDS1 DataSource. The ZADGEN aDSO fetches data using this DataSource. You can see the transformation and DTP in the dataflow between the DataSource and aDSO. ![Display Data Flow](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-52-11-5940-PM.png?width=415&height=798&name=image-png-Sep-12-2024-12-52-11-5940-PM.png) 1. Now execute the DTP using . You can see the request status in the web cockpit. Once you choose **Manage Request**, you can see the entries in the inbound table. ![Inbound Table](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-52-40-9719-PM.png?width=852&height=358&name=image-png-Sep-12-2024-12-52-40-9719-PM.png) 1. From the **Manage Request** area, you can activate the aDSO request. To do so, select the **Activate** After the activation is completed, you can see the data in the active table, as shown. ![Active Data Table Content](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-53-01-0484-PM.png?width=917&height=433&name=image-png-Sep-12-2024-12-53-01-0484-PM.png) 1. You can also check the active table for the aDSO based on the generic DataSource; as you know, the active table will end with 2. (See next figure.) In this example, the active table is /BIC/AZADGEN2 and it has 3,402 entries. ![Active Table Contents](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-53-20-5217-PM.png?width=1178&height=658&name=image-png-Sep-12-2024-12-53-20-5217-PM.png) 1. You can remove 200 from the **Maximum No. of Hits** field and click **Execute** or press (F8) to see the total contents of the active table, as shown in the next figure. The total number of records in the table (3,402) is shown in the upper-right corner. **![Table Contents](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-53-41-2190-PM.png?width=1090&height=626&name=image-png-Sep-12-2024-12-53-41-2190-PM.png)**   ## Checking the ODQ After the DTP is successful, you can see the status of the extraction job in the source system. Log onto SAP S/4HANA and execute Transaction ODQMON for the ODP-based delta queue. You’ll see that the queue (**ZRKGENDS1**) for the generic DataSource is created in the queue view. If you need to see the queue name that was created, set **Request Select** to **All**: this will ensure that the full request is also selected and the respective queues are displayed.   ![Transaction ODQMON](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-55-06-7165-PM.png?width=1447&height=918&name=image-png-Sep-12-2024-12-55-06-7165-PM.png)   From the queue view, you can get to the subscription view and then the request view. Finally, in the units view, you’ll see the total number of rows is 3,402, matching the total number of records extracted using this DataSource. When you double-click that row, you can see the actual records that were sent to SAP BW/4HANA, and you’ll see that **Storage** is now set to **ODQDATA\_F** for a full upload.   ![Units](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-55-26-6881-PM.png?width=1512&height=615&name=image-png-Sep-12-2024-12-55-26-6881-PM.png)   The contents of table ODQDATA\_F can be viewed as shown in the final figure. You can see this table in Transaction SE16. ![Table ODQDATA_F](https://blog.sap-press.com/hs-fs/hubfs/image-png-Sep-12-2024-12-55-45-0813-PM.png?width=1510&height=493&name=image-png-Sep-12-2024-12-55-45-0813-PM.png) Editor’s note: This post has been adapted from a section of the book *[Operational Data Provisioning with SAP BW/4HANA](https://www.sap-press.com/operational-data-provisioning-with-sap-bw4hana_5676/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2406_chapter10&utm_content=2406)* by Renjith Kumar Palaniswamy. ## Recommendation [![Operational Data Provisioning with SAP BW/4HANA](https://blog.sap-press.com/hs-fs/hubfs/social-suggested-images/2406-Final-3-1-1-1-2.jpg?width=170&name=2406-Final-3-1-1-1-2.jpg)](https://www.sap-press.com/operational-data-provisioning-with-sap-bw4hana_5676/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2406_chapter10&utm_content=2406) **Operational Data Provisioning with SAP BW/4HANA** Operational data provisioning (ODP) is the new standard for data staging and extraction in SAP BW/4HANA—are you ready for it? Use ODP to extract information from SAP S/4HANA and connect to other key data sources, including SAP HANA calculation views, CDS views, open ODS views, and SAP BW. Use SAP Landscape Transformation Replication Server to replicate data, and review the prerequisites for SAP BW/4HANA remote conversion projects. With detailed instructions throughout, this hands-on guide has all the information you need to master ODP! [Learn More](https://www.sap-press.com/operational-data-provisioning-with-sap-bw4hana_5676/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2406_chapter10&utm_content=2406) ![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg) **by [SAP PRESS](https://blog.sap-press.com/author/sap-press)** SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP IBP, intelligent technologies, SAP Business Technology Platform, and more! [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-extract-data-into-sap-bw4hana-using-generic-datasources%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](https://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-extract-data-into-sap-bw4hana-using-generic-datasources%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-extract-data-into-sap-bw4hana-using-generic-datasources%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-extract-data-into-sap-bw4hana-using-generic-datasources%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fhow-to-extract-data-into-sap-bw4hana-using-generic-datasources%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fhow-to-extract-data-into-sap-bw4hana-using-generic-datasources%3Futm_medium%3Dsocial%26utm_source%3Demail) ### Comments ### Latest Blog Posts [![How to Create an Operational Data Provisioning (ODP) Source System for SAP S/4HANA and SAP ERP](https://blog.sap-press.com/hs-fs/hubfs/How%20to%20Create%20an%20Operational%20Data%20Provisioning%20(ODP)%20Source%20System%20for%20SAP%20S4HANA%20and%20SAP%20ERP.png?height=600&name=How%20to%20Create%20an%20Operational%20Data%20Provisioning%20(ODP)%20Source%20System%20for%20SAP%20S4HANA%20and%20SAP%20ERP.png)](https://blog.sap-press.com/how-to-create-an-operational-data-provisioning-odp-source-system-for-sap-s4hana-and-sap-erp) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) ## [How to Create an Operational Data Provisioning (ODP) Source System for SAP S/4HANA and SAP ERP](https://blog.sap-press.com/how-to-create-an-operational-data-provisioning-odp-source-system-for-sap-s4hana-and-sap-erp) [Read More](https://blog.sap-press.com/how-to-create-an-operational-data-provisioning-odp-source-system-for-sap-s4hana-and-sap-erp) [![How to Use Transaction ODQMON to Upload Logistics Data to SAP BW/4HANA](https://blog.sap-press.com/hs-fs/hubfs/How%20to%20Use%20Transaction%20ODQMON%20to%20Upload%20Logistics%20Data%20to%20SAP%20BW4HANA.png?height=600&name=How%20to%20Use%20Transaction%20ODQMON%20to%20Upload%20Logistics%20Data%20to%20SAP%20BW4HANA.png)](https://blog.sap-press.com/how-to-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) ## [How to Use Transaction ODQMON to Upload Logistics Data to SAP BW/4HANA](https://blog.sap-press.com/how-to-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana) [Read More](https://blog.sap-press.com/how-to-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana) **Subscribe to our blog!**Get notified about future blog updates. - - - - - ### The official SAP PRESS Blog As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. Explore ABAP, FICO, SAP HANA, and more! ### SAP Blog Topics - [All Topics](https://blog.sap-press.com) - [Logistics](https://blog.sap-press.com/tag/logistics) - [Programming](https://blog.sap-press.com/tag/programming) - [FICO](https://blog.sap-press.com/tag/fico) - [Administration](https://blog.sap-press.com/tag/administration) - [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) - [What Is?](https://blog.sap-press.com/tag/what-is) - [Featured](https://blog.sap-press.com/tag/featured) - [CRM & Sales](https://blog.sap-press.com/tag/crm-sales) - [Video](https://blog.sap-press.com/tag/video) - [Human Resources](https://blog.sap-press.com/tag/human-resources) ### Blog curated by [![Rheinwerk Publishing & SAP PRESS Logo](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://sap-press.com) [Visit the SAP PRESS Store](https://sap-press.com) ### About - [Home](https://sap-press.com/) - [About Us](https://sap-press.com/the-publisher/) - [Contact](mailto:info@rheinwerk-publishing.com) - [Legal Notes](https://sap-press.com/legal-notes/) - [Privacy Policy](https://sap-press.com/privacy/) - [Terms of Use](https://sap-press.com/terms/) - [Guest Posting](https://blog.sap-press.com/guest-posting) © 2026 Rheinwerk Publishing, Inc. | Change Privacy Options ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "SAP PRESS", "url" : "https://blog.sap-press.com/author/sap-press" }, "dateModified" : "2024-10-17T13:15:37.948Z", "datePublished" : "2024-10-15T13:00:00.000Z", "headline" : "How to Extract Data into SAP BW/4HANA Using Generic DataSources", "image" : [ "https://blog.sap-press.com/hubfs/How%20to%20Extract%20Data%20into%20SAP%20BW4HANA%20Using%20Generic%20DataSources%202.png" ], "mainEntityOfPage" : { "@id" : "https://blog.sap-press.com/how-to-extract-data-into-sap-bw4hana-using-generic-datasources", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.sap-press.com/hubfs/Logo-1.jpg" }, "name" : "Rheinwerk Publishing, Inc." } } ```