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

Epicor debuts EVA, an AI virtual assistant for ERP

Epicor users will soon be able to talk to or text their ERP systems through Epicor Virtual Agent, a new AI-based voice command UI...

10 blockchain problems supply chains need to look out for

Blockchain is proving to be useful in the supply chain, but without a strong understanding of it and a viable use case, your ...

Del Monte Foods makes SAP ERP migration to AWS

Thanks to an acquisition, Del Monte Foods' IT had both on-premises and hosted systems, which proved costly and inflexible. It has...

SearchOracle

Oracle cloud adoption and hybrid cloud adoption pros and cons

More businesses are adopting cloud systems or thinking about it. But cloud and hybrid cloud setups have pluses and minuses that ...

Oracle Digital Assistant unifies use of enterprise chatbots

With Oracle Digital Assistant, users are able to create digital assistants with multiple chatbots that handle different tasks to ...

Oracle Database 19c new features and what users need to know

Oracle Database 19c is the last update to the 12c Release 2 line of Oracle's database software. This handbook examines its new ...

SearchDataManagement

Google takes a run at enterprise cloud data management

New Google Cloud boss Thomas Kurian is putting databases and data management at the forefront at Google. The vendor has forged ...

4 factors to consider in a Hadoop distributions comparison

Examine the key characteristics necessary to evaluate in a Hadoop distribution comparison, focusing on enterprise features, ...

Kafka at center of new event processing infrastructure

Events are as important as data in emerging applications underlying many e-commerce efforts. Streams of events tell a company ...

SearchAWS

Azure-to-AWS migration tool aims to lure Microsoft workloads

Customers might appreciate the flexibility of a new AWS tool that pulls in Azure VM workloads but should be mindful of the big ...

Centralize DevOps and development on AWS with CodeStar

Learn how to set up AWS CodeStar to centralize your dev toolchain. The service is built to be a place for developers to start, ...

Oracle vs. AWS: Compare cloud databases, PaaS and SaaS

Oracle and AWS gear their clouds toward different users, so it's important to know where your organization falls. See which ...

SearchBusinessAnalytics

How to integrate Power BI and SharePoint via embedded reports

Expert Brien Posey explains two methods for including Power BI reports on pages in SharePoint Online's cloud service: publishing ...

Data-rich organizations turn focus to ethical data mining

As data analytics have increasingly become a core component of organizations' strategies, concerns have arisen around how data is...

Cloud AutoML, BigQuery ML upgrades expand Google stake in ML

Google introduced a raft of updates to its cloud-based machine learning and AI products, including expanded capabilities for its ...

SearchCRM

Business software strategies strengthen the inbound marketing process

It's not enough to just purchase new marketing software. Your overall business strategy will determine your company's needs and ...

Sensible contact center infrastructure updates for 2017

Contact center infrastructure evolves quickly and updates are inevitably necessary. Here's how to identify and make the changes ...

Guide to call center operations

Call center operations have been affected in numerous ways by the growth of social media and mobile, particularly with new ...

SearchContentManagement

How cloud services can empower the future of work

The Akumina Employee Experience Platform and Templafy show how cloud services are changing the way employees work, whether the ...

Business objects are the future of content services platforms

The focus of enterprise content management must shift from a CSP-based approach to a business object services model in order to ...

5 unusual ways to use AI in content management

AI offers great opportunity for enhancing enterprise content management. Here are some more unusual use cases for AI that ...

SearchHRSoftware

Diversity in hiring a key to eradicating AI bias

HR is turning to AI systems to help rank and sort job candidates. But the systems like these are mostly designed by men, who may ...

Technology can aid diversity and inclusion in HCM, with caveats

Vendors are increasingly building AI applications to be bias-free to address concerns around diversity and inclusion. The ...

As baby boomers exit, AR and VR tools help to capture their expertise

Demand for virtual and augmented reality tools is soaring, and the need to capture expertise from retiring baby boomers may be ...

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.