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?

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.

This was last published in August 2007

Related Q&A from Jay Narayanan

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

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

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

Finding the right ERP consultants is key to project success

With ERP implementations, choosing the right or wrong project consultants can be the difference between success and failure, so ...

Cummins and Noble Plastics see factory of the future vision

When it comes to manufacturing, Cummins and Noble Plastics are embracing technological innovation. But with new technologies come...

How to obtain the skills needed in a smart factory

As factories continue to evolve with the use of innovative technologies, manufacturers must ensure that their workers are ...

SearchOracle

Click-to-launch tools pull apps through Oracle Cloud Infrastructure marketplace

Oracle has made it easier for customers to choose and launch third-party software onto its cloud. Now, the question is whether ...

Rewards program provider taps Oracle IaaS for app migration

Oracle struggles in IaaS against AWS and Azure, but one Oracle cloud customer said its move there is a success, albeit within an ...

Future of Oracle centers on the cloud, AI and automation

Oracle deepened its embrace of cloud computing, AI software and IT automation tools in 2018. What can users expect from it in ...

SearchDataManagement

Originators form group to boost Presto SQL query engine

The Presto engine arose as an alternative to Hive for big data queries. Now, the Presto Software Foundation has formed to promote...

5 best practices for managing real-time data integration

Real-time data integration isn't like traditional data integration -- "it's moving, it's dirty and it's temporal," cautions one ...

Web integration platform eases way to machine learning models

StoryFit data scientists employ machine learning algorithms to gauge film script scenarios' prospects. They use Import.io tools ...

SearchAWS

Use AWS Firecracker to build micro VMs for containerized apps

Firecracker has many of the benefits of containers and VMs, without some of their limitations. Here are a few things to know if ...

AWS Lambda functions become more flexible, but use caution

AWS Lambda added custom runtimes and longer timeouts. Review the benefits, such as flexibility and easier migration, along with ...

AWS' blockchain approach takes divergent paths

AWS was slow to embrace blockchain but now offers two approaches to the concept. Review the specs of Quantum Ledger Database and ...

SearchBusinessAnalytics

Information Builders CEO on cloud-first approach, machine learning

Information Builders' new CEO, Frank Vella, said the company's focus on cloud and machine learning will help it solidify a firm ...

New Information Builders CEO targets modern CX, development

In Q&A, new CEO Frank Vella discusses how Information Builders is modernizing its WebFocus platform to make it easier to use and ...

Tableau Ask Data gives BI users simple NLP data query tool

Tableau's new Ask Data software uses natural language processing to enable users of any skill level to more easily search for ...

SearchCRM

CEO plots course for Televerde women's prison call centers

Working at a Televerde women's prison call center outpays many inmate jobs and sets agents up for careers on the outside. CEO ...

Giving inmates a second chance as prison call center agents

Televerde staffs contact centers with incarcerated women, where they are paid the federal minimum wage. CEO Morag Lucey and COO ...

6 reasons why self-service options fail

Customer self-service platforms free up live agents for more complicated issues, but if this software is not kept up to date, ...

SearchContentManagement

Personalized content solidifies the customer experience

Today's customers expect customized, curated digital experiences. Learn how to deliver what customers need and stay ahead of the ...

Create a winning personalized customer journey

Web content management platforms, customer data platforms and matchmaking can all help companies create and implement a ...

Google, WordPress develop a CMS for news

Google is funding a WordPress-based content management system aimed at helping small news publishers juggle the demands of ...

SearchHRSoftware

Cybersecurity education: How HR can plan for the inevitable

Cybersecurity is a major concern for any organization, but employees continue to be a top threat. HR can help mitigate insider ...

LinkedIn's recruiting platform billed as 'Intelligent Hiring Experience'

LinkedIn's use of AI requires the sharing of data. It is one reason why the company is combining its talent tools into one system...

HR chatbots take on recruitment, benefits tasks

HR chatbots are taking on straightforward administrative tasks in recruitment and benefits. And that could be a good thing for HR...

Related Resources

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.