Using standard SAP extractors to load SD data

I am trying to use the standard SAP extractors to load SD data. Do you know if transaction OLI7BW allows selection by date?

Jay Narayanan
Published: 30 Aug 2007

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

I am trying to use the standard SAP extractors to load SD data. Do you know if transaction OLI7BW allows selection by date? I need to extract only one month of data because of space restrictions on our test server. The only selection options I am aware of are "Sales Org," "Comp code" and "Doc number."

OLI7BW doesn't allow selection by date. You may have to check the program, make a copy of the program and add the necessary logic to make a date selection.

Related Q&A from Jay Narayanan

How to change the characteristics of an SAP InfoCube

An SAP user is looking to change the values of a characteristic in an SAP InfoCube and wants to know if it's possible to use virtual InfoCubes to ... Continue Reading

Sizing hardware for SAP BW applications

An SAP user is looking to assess the hardware requirements for an SAP BW application and wants to know what the parameters are of sizing hardware for... Continue Reading

Should we install SAP BW on the same server running SAP R/3 4.7?

Find out if a department running SAP R/3 4.7 needs an additional server to install SAP Business Information Warehouse (SAP BW). Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

Oracle strengthens autonomous cloud positioning

Oracle announced a host of new features for EPM, ERP and HCM clouds, including machine learning OCR and new jobs for the Oracle ...

Sigfox network provides cheap, efficient connectivity for IoT

IoT applications for manufacturing and supply chain don't require 5G networks to send small packets of data. Sigfox believes ...

Oracle ERP Cloud expands its digital assistants

The Oracle ERP Cloud is increasing its use of digital assistants. These systems will interact with AI-type systems to help move ...

SearchOracle

Oracle applications development VP on Fusion, SaaS and what's ahead

Steve Miranda discusses lessons learned from Oracle Fusion Applications, SaaS, best-of-breed apps vs. suites and Oracle's ...

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle ...

The roots of Oracle's cloud evolution: A 20-year review

Oracle, like other prominent on-premises software vendors, has traced a long path into the cloud. These 10 events over the past ...

SearchDataManagement

Swim DataFabric platform helps to understand edge streaming data

Swim released its new Swim DataFabric, which integrates with Microsoft Azure to help users organize and gain insights from ...

Dremio Data Lake Engine 4.0 accelerates query performance

Dremio issues a new platform update, defining itself as data lake engine technology that looks to help users connect and query ...

Weighing the use of third-party database administration tools

Database expert Chris Foot details the key reasons why DBAs should consider using third-party database administration to fill ...

SearchAWS

Review latest investments to AWS' machine learning platform

Improved deep learning capabilities lead this machine learning roundup. Learn how AWS is targeting both machine-learning-savvy ...

Set AWS security automation in motion with these practices

Enterprises need to continuously improve their cloud security posture. Catch up on the latest expert advice on AWS security tools...

New details emerge about AWS Outposts as launch nears

AWS Outposts will ship later this year. In advance of that launch, AWS has given customers a sense of what they can expect from ...

SearchBusinessAnalytics

Qlik exec discusses AI and its role in the future of BI

The next major trend in business intelligence will be the increasing impact of augmented intelligence and machine learning, ...

SAP BI platform stays strong due to cloud-based architecture

A cloud-native BI platform along with domain-specific applications that can be embedded to serve the needs of various industries ...

Tableau 2019.3 highlighted by enhanced AI, new data catalog

Tableau released its third-quarter update Wednesday, featuring Explain Data, an enhanced augmented intelligence tool, and Tableau...

SearchContentManagement

Icelandair turns to headless CMS to improve CX

The right CMS makes a big difference for CX, so Icelandair moved off its on-premises content server to a headless CMS – with one ...

Microsoft 365 Business update targets nonprofits

Microsoft announced this month that it is releasing new updates and offerings for nonprofits, addressing concerns customers had ...

Nintex launches no-code workflow automation tool

Nintex has launched a no-code workflow automation tool, Workflow Generator, in an effort to bridge the gap between IT departments...

SearchHRSoftware

10 ingredients in a killer employee experience strategy

Improving the employee experience is a must for modern organizations and their HR teams, but where should you start? Here are 10 ...

SuccessFactors customers to see big Qualtrics impact

SuccessFactors is rethinking its HCM suite as it works to integrate Qualtrics into its applications. But HR managers are ...

HiQ Labs vs LinkedIn case OKs robot monitoring of employees

A U.S. Court of Appeals ruled on the LinkedIn vs HiQ lawsuit, which could help shape how services gather information on social ...

Dig Deeper on SAP Business Warehouse

Related Q&A from Jay Narayanan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.