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.

Dig Deeper on SAP Business Warehouse

Getting started with writing sales order code for SAP ABAP, BW A SearchSAP.com reader is new to SAP ABAP and SAP BW, and wants to know how to write a correct piece of code in trying to write a clear work statement.

SAP cancels NetWeaver BW 7.2 release, plans to roll features into 7.3 release SAP has cancelled its NetWeaver BW 7.2 ramp-up program, planned for next month, and instead opted to scrap the release and consolidate functionality in a NetWeaver BW 7.3 release.

PPQ velvet Blackberry pouch in aid of Macmillan Cancer Support

Best career path for a pro with .NET experience I have been working with .NET for the past three years. I am thinking of either selecting NetWeaver (XI and EP) or SAP BW.

Is it too late to land a decent career involving SAP BW? I have C, C++ and COBOL experience. I am learning SAP BW on my own. Is it the right time for to change to SAP BW or am I too late?

Can SAP BW be installed on SAP R/3 with an Oracle database? I am currently using SAP R/3 with an Oracle database installed on the server. I am thinking of going for BW training. Is BW a completely different package or can I use my existing SAP R/3 for BW?

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

A look inside the new Redwood Oracle UI design

The two designers who head Oracle's Redwood user experience and branding effort explain the philosophy behind the new look and ...

Process mining software pulls back curtains on how processes work

Here's what two vendors, Celonis and Signavio, offer in the emerging field of process mining software, which enables ...

Epicor ERP system focuses on distribution

Companies like Jergens Industrial Supply are favoring purpose-built ERP systems like Epicor Prophet 21 for distributors over ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Aerospike 4.8 advances database persistent memory support

Aerospike 4.8 adds full support for Intel's Optane persistent memory, enabling the NoSQL database to run both the index and data ...

Data warehouse technologies evolve as vendors look skyward

The need for high-speed analytics and low latency are pushing data warehousing vendors to create and reinvent their platforms and...

How to streamline feature engineering for machine learning

Structured data is necessary in machine learning, but sifting through data is time consuming. Streamlining the feature ...

SearchAWS

AWS seeks niche in the cloud UC market

AWS could play a bigger role in the cloud UC market in 2020 and beyond by targeting developers and existing AWS customers.

National Australia Bank cashes in on AWS training and certification

Structured training got nearly 1,000 National Australia Bank employees certified on AWS, while AWS-honed tactics such as ...

Overcome these VMware Cloud on AWS migration challenges

Plan ahead for a VMware-to-AWS cloud migration with this breakdown on common challenges organizations face during the move to ...

SearchBusinessAnalytics

Government IT pros: Hiring data scientists isn't an exact science

There's no such thing as a data science unicorn, U.S. government experts caution. You'll need more than programmers and technical...

Tableau 2020.1 unveiled for beta testing

Featuring improvements to Explain Data, an AI product that aims to explain the reasons behind data points, the update is made up ...

Data scientist vs. data analyst: What's the difference?

Data scientists and data analysts have a lot of crossover in their roles, but they're certainly not the same. Here's a look at ...

SearchContentManagement

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

New capabilities added to Alfresco Governance Services

The updates are intended to secure electronically stored information residing across different locations in light of recent ...

SearchHRSoftware

H-1B lottery change may drive increase in visa applicants

The U.S. is launching an H-1B electronic registration system in March. It should make the process of applying for a visa easier, ...

As hiring booms, HR survey raises warning for recruiters

Job candidates will reject a job offer if the employer makes missteps in the recruiting process, a new HR survey reports.

AI in hiring: Why HR should beware of bias

AI in hiring may seem like the perfect solution to remove conscious and unconscious biases that already exist in people, but ...

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.