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?

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

MillerCoors ERP lawsuit begins harshly, ends softly

MillerCoors and IT services firm HCL have reached an 'amicable' agreement regarding the brewer's $100 million ERP implementation ...

Cloud ERP system selection: How to evaluate your company needs

This article can help you evaluate your business needs and make sure you're getting the right cloud ERP system for your ...

Oracle Autonomous Data Warehouse aiding analytics developers

Early adopters of Oracle's new AI-based, partly self-managing data warehouse say it can free up time to develop value-adding ...

SearchOracle

DataScience.com set to drive Oracle cloud analytics efforts

Oracle's cloud strategy includes machine learning jobs that differ from the usual SQL analytics. The company is turning to its ...

Oracle Cloud IaaS security gets superhero status from Ellison

TechTarget editors discuss security updates to Oracle Cloud Infrastructure and company leader Larry Ellison's vivid depiction of ...

What the 3 versions of Oracle Cloud at Customer offer users

Oracle's Cloud at Customer service lets users run its cloud technologies in their data centers. Here's what users get in the ...

SearchDataManagement

SearchAWS

DynamoDB pricing option makes it a go-to for serverless apps

DynamoDB had its drawbacks, but the addition of on-demand billing and ACID transactions makes it a solid database option for ...

AWS enterprise strategy targets industry verticals

AWS could soon add services specialized for industries such as healthcare and finance. It might be lucrative, but not everyone ...

COBOL applications can go serverless on AWS Lambda

More business-critical applications can now move to a serverless architecture in the cloud with the arrival of COBOL support in ...

SearchBusinessAnalytics

Tips for creating curated data sets for self-service BI users

Data curation initiatives can help streamline BI processes by reducing the amount of time users spend locating and preparing data...

What the Tableau Hyper engine does and how it was developed

Tableau's new Hyper data engine is designed to boost processing speeds in its BI and data visualization software. Making it work ...

Deep learning in big data analytics with Sisense Hunch

Sisense Hunch, a new Sisense BI tool, enables big data analytics for IoT devices by using deep learning to automatically extract ...

SearchCRM

8 tips for getting rich mystery shopping survey data

Mystery shopping data is only as good as the overall strategy for collecting it and setting up realistic customer experiences. ...

Mystery shopping software key to CX management

Businesses use mystery shopping platforms, comment cards, brand reputation management and more to identify customer pain points ...

Guidelines for navigating the sales software market

Figuring out whether your organization needs sales force automation, sales enablement or sales forecasting tools can be ...

SearchContentManagement

Payless ShoeSource switches digital asset management tools

A new DAM tool from Cloudinary helps the shoe seller get ready for the holiday shopping rush by automating the management of ...

Cloud collaboration benefits the future of work

The future of work relies on cloud collaboration abilities to keep employees and content connected, both inside and outside ...

5 benefits of PowerApps forms for SharePoint

Microsoft PowerApps has been around since 2015, but it is just now beginning to beat out its predecessor, InfoPath -- originally ...

SearchHRSoftware

6 HR vendors make Glassdoor's Best Places to Work

HR tech vendors make tools designed to improve a company's employee experience. So, it makes sense that a handful should appear ...

Ideas to curb bad candidate experience, including a free tool

Your hiring efforts should monitor job applicant resentment, which happens when candidates feel spurned by a company's ...

New employee engagement tools replacing annual surveys

Say goodbye to annual employee surveys. New approaches and better technology are coming to places like Mission Health System and ...

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.