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

Benefits and challenges of blockchain food supply chain growth

Using blockchain in the food supply chain may improve consumer safety, but experts say reluctance from suppliers and a lack of ...

ERP vendor IFS makes a near-merger with Acumatica

EQT Partners, which owns ERP vendor IFS, has acquired Acumatica, another ERP vendor. Both firms will be working together, sharing...

Blockchain food supply chain growth depends on clean data

Traceability to ensure freshness, safety and compliance is an obvious benefit of blockchain in the food supply chain, but it ...

SearchOracle

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new...

How to connect to a pluggable database in Oracle Multitenant

Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they...

Creating an Oracle Multitenant container database and PDBs

Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the ...

SearchDataManagement

Building leaner, meaner BI data sources

As business intelligence analysis and reporting platforms become increasingly important in the enterprise, so does the data that ...

A comparison of open source, real-time data streaming platforms

With so many real-time data streaming tools, how do you know which is right for your organization? Experts compare Spark ...

Data virtualization tools promote anywhere, anytime data access

This online handbook examines data virtualization software and how organizations are deploying and using the technology as part ...

SearchAWS

Secure Lambda functions and meet cloud compliance standards

While AWS Lambda itself is secure, users are responsible for the functions they run with the service. Set up CloudWatch, KMS and ...

AWS re:Inforce agenda underscores cloud security challenges

AWS re:Inforce this month in Boston is the first dedicated security conference by the industry's largest cloud provider. Here's ...

AWS partner program targets cloud migration of ISV workloads

A new AWS cloud migration program is geared to bring ISV application workloads to the platform, and offers a financial incentive ...

SearchBusinessAnalytics

Power BI update firms up Microsoft analytics market

With its latest update to Power BI, Microsoft showed its commitment to its business intelligence platform and maintained its ...

MicroStrategy product development advances after Voice.com sale

Analytics and BI vendor MicroStrategy sells the Voice.com domain name and moves forward with product R&D in a competitive market ...

Social media analytics applications live and die by the data

This handbook provides insight and advice on how to use analytics to get information on customer sentiment and marketing ...

SearchContentManagement

Acquia Content Cloud is here, in private beta version

Acquia Content Cloud is a cloud-based headless content management system built on Drupal. The content-as-a-service product is ...

Dropbox Business gets integrations with G Suite, Slack and Zoom

Dropbox Business has been overhauled in an attempt to make it a hub for business communication and collaboration. The updates ...

5 Microsoft PowerApps use cases in the enterprise

Organizations use Microsoft PowerApps to simplify a number of tasks, including employee onboarding, inspections, new user setups,...

SearchHRSoftware

HR execs express anxiety, interest about AI in HR

AI in HR is getting a lot of attention at the annual SHRM conference. The trade show floor is filled with vendors pitching AI ...

Startup applies AI in hiring to contracting niche

AI is gaining ground in recruiting, hiring and now in contracting. A London-based firm provides some insight about what the ...

Evaluate your current HRMS software before buying a new system

Replacing HRMS software can be expensive and time-consuming, but it isn't your only option. Review your current system first to ...

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.