--- title: How to Use Transaction ODQMON to Upload Logistics Data to SAP BW/4HANA description: Learn how to upload logistics data to SAP BW/4HANA using transaction ODQMON. Monitor extraction status, understand the process, and more. image: https://blog.sap-press.com/hubfs/How%20to%20Use%20Transaction%20ODQMON%20to%20Upload%20Logistics%20Data%20to%20SAP%20BW4HANA.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 Use Transaction ODQMON to Upload Logistics Data to SAP BW/4HANA ![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg) by [SAP PRESS](https://blog.sap-press.com/author/sap-press) When the DTP is executed in SAP S/4HANA, it creates a request for extraction and is sent to the source system—S4SCLNT100 in our case.   You can use Transaction ODQMON to monitor the status of the extraction during the runtime. With the DTP job completed, let’s check the transaction in [SAP S/4HANA](https://learning.sap-press.com/sap-s4hana) to understand the extraction process. Now, log into SAP S/4HANA and execute Transaction ODQMON.   The figure below shows these details of the transaction: 1. In the **Provider** field, choose **BW DataSource** as you’re using the SAP-delivered DataSource for extraction. 2. The subscriber is [SAP BW/4HANA](https://learning.sap-press.com/sap-bw4hana), so you need to choose **[SAP Business Warehouse](https://learning.sap-press.com/sap-data-management#SAP-Business-Warehouse)** for the **Subscriber Type**. 3. Choose the **Subscriber**; in our case, it’s the system ID of SAP BW/4HANA, which is **CB4CLNT100**. 4. In **Request Select**, choose **Subscriptions Only (Delta Init + Delta)**. There is also an option to choose **All** from the dropdown. 5. In the **Queue** area, you can see the queue description. If you need to see the technical name, then you need to press the wrench icon (9). 6. In **Queue: Status**, you can see if the queue is active or inactive. 7. You can see the total subscriptions in the **Subscrptns** 8. The total request count can be derived from the **Requests** 9. When you click the wrench icon, the queue descriptions (5) will change to technical names. Most often, SAP BW consultants prefer to use technical names instead of descriptions. ![Transaction ODQMON in SAP S/4HANA](https://blog.sap-press.com/hs-fs/hubfs/2406_05_129.png?width=892&height=433&name=2406_05_129.png)   Click the wrench icon (9) and you’ll see the queue technical names, which include the DataSource names 2LIS\_11\_VAHDR and 2LIS\_11\_VAITM, as shown in this figure.   ![Transaction ODQMON with Technical Names](https://blog.sap-press.com/hs-fs/hubfs/2406_05_130.png?width=891&height=427&name=2406_05_130.png)   Double-click **2LIS\_11\_VAHDR**, which has 12 subscriptions and one request. That will take you to the **Subscriptions** details screen shown in the next figure, with the **Subscription** time stamp and the **Last TSN Confirmed** date and the **Created On** date. Note that the subscription is created by an SAP BW background user for the source system: **ALEREMOTE1**.   ![Transaction ODQMON: Subscriptions](https://blog.sap-press.com/hs-fs/hubfs/2406_05_131.png?width=966&height=341&name=2406_05_131.png)   You can click the **Subscription** row to see more details, as shown in the following figure. ![Transaction ODQMON: Request Details](https://blog.sap-press.com/hs-fs/hubfs/2406_05_132.png?width=968&height=209&name=2406_05_132.png)   Note that in Transaction ODQMON the composite request time is based on PST, but in SAP BW/4HANA it was CST, so there will be a difference of two hours between the two time zones (i.e., CST is two hours ahead of PST).   Now let’s walk through the details of the **Requests** screen: 1. The **Requests** button is greyed out, indicating you are in the requests area. 2. The **Composite Request** column number is filled with the PST time stamp. 3. The **Composite Request Status** column has a green checkmark. 4. The **Subscription** column is filled with the time stamp. 5. The **Upper Limit for TSN** column is selected based on the subscription time stamp. 6. The request that is generated from SAP BW/4HANA is filled in the **Extractions Request** 7. The final status of the extraction request is shown as successful. 8. The **Extraction Mode** is **Initial Data** because it’s the first load. 9. The SAP BW/4HANA extraction request will trigger a job for ODP extraction, and that job name will start with ODQR\*. 10. The table where the data is stored, table ODQDATA\_C, will be used for this initial load. If you need to recheck the time stamp, you can have a quick look in the DTP extraction monitor in the web cockpit. The **ID** field shows the timestamp.   ![Request ID in SAP BW/4HANA](https://blog.sap-press.com/hs-fs/hubfs/2406_05_133.png?width=503&height=212&name=2406_05_133.png)   As shown earlier, in Transaction ODQMON, from the queue view, you can go to the units view. There, click the **Composite Request** number and it will take you to the units section, as shown in this figure. ![Transaction ODQMON: Units](https://blog.sap-press.com/hs-fs/hubfs/2406_05_134.png?width=968&height=225&name=2406_05_134.png)   You can see the following details on this screen: 1. **Units** is greyed out, which means you’re in the units section. 2. Timestamp ID is generated based on the extraction time. 3. Because the DTP is executed for the first time, this is a delta initialization, which sets the time. 4. The TSN is based on the extraction time. 5. The transaction ID is again based on the time. 6. The unit number increased based on extraction. 7. The rows count (6,712) gives you the total number of data records. You can validate this in the SAP BW/4HANA aDSO. 8. The original size will be compressed in ODP. In this case, the rate is 97.7. 9. The storage is in table ODQDATA\_C. 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_chapter5&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_chapter5&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_chapter5&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-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana%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-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana%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-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana%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-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fhow-to-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana%3Futm_medium%3Dsocial%26utm_source%3Demail) ### Comments ### Latest Blog Posts [![How to Extract Data into SAP BW/4HANA Using Generic DataSources](https://blog.sap-press.com/hs-fs/hubfs/How%20to%20Extract%20Data%20into%20SAP%20BW4HANA%20Using%20Generic%20DataSources%202.png?height=600&name=How%20to%20Extract%20Data%20into%20SAP%20BW4HANA%20Using%20Generic%20DataSources%202.png)](https://blog.sap-press.com/how-to-extract-data-into-sap-bw4hana-using-generic-datasources) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) ## [How to Extract Data into SAP BW/4HANA Using Generic DataSources](https://blog.sap-press.com/how-to-extract-data-into-sap-bw4hana-using-generic-datasources) [Read More](https://blog.sap-press.com/how-to-extract-data-into-sap-bw4hana-using-generic-datasources) [![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) **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" : "2026-08-25T14:01:17.830Z", "datePublished" : "2024-03-27T13:00:00.000Z", "headline" : "How to Use Transaction ODQMON to Upload Logistics Data to SAP BW/4HANA", "image" : [ "https://blog.sap-press.com/hubfs/How%20to%20Use%20Transaction%20ODQMON%20to%20Upload%20Logistics%20Data%20to%20SAP%20BW4HANA.png" ], "mainEntityOfPage" : { "@id" : "https://blog.sap-press.com/how-to-use-transaction-odqmon-to-upload-logistics-data-to-sap-bw4hana", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.sap-press.com/hubfs/Logo-1.jpg" }, "name" : "Rheinwerk Publishing, Inc." } } ```