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

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

Last-mile delivery challenges in the age of omnichannel

The last-mile delivery problem is getting more difficult as customers demand lightning-speed product fulfillment. Here's hope.

Finance transformation efforts soar with cloud ERP

Although some CFOs resist moving financials to the cloud, the process can help streamline processes and save money. Here's a look...

Top 6 2020 supply chain trends

Supply chain technology is growing more complex and so are partnerships. Here are the most important trends leaders must ...

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

Hitachi Vantara acquires data catalog vendor Waterline Data

With the acquisition of Waterline Data, Hitachi Vantara is bringing new data catalog capabilities that will expand the Lumada ...

New Confluent Platform release boosts event streaming quality

Based on the open-source Kafka event streaming platform, the Confluent Platform 5.4 update adds new capabilities to help meet ...

Where InfluxDB time series database is going

Users need more than SQL for querying databases, according to Paul Dix, co-founder and CTO of InfluxData. That's why the vendor ...

SearchAWS

New themed Amazon pop-up stores built on consumer data

In its never-ending quest to establish unique physical locations, Amazon has plans to launch a chain of themed pop-up stores that...

AWS security faces challenges after a decade of dominance

After a decade of dominating the public cloud market and influencing cloud security, AWS is faced with new challenges stemming ...

AWS AI tools focus on developers

AWS sells many AI products, tools and services aimed at developers, including several for AI newcomers, such as DeepRacer, ...

SearchBusinessAnalytics

How to compare and choose augmented analytics tools

Choosing an augmented BI and analytics vendor can be difficult when their offerings are so similar. Analysts at Gartner and ...

ThoughtSpot IPO could be coming after vendor adds first CFO

Hiring of a CFO for the first time signals that ThoughtSpot may be positioning itself for an IPO and comes six months after what ...

5 ways enterprises adapt to the data scientist shortage

Where are all the data scientists? Coping with the data scientist shortage is a struggle for many enterprises. Here are five ways...

SearchContentManagement

4 popular content collaboration platforms to consider

Companies need to be organized if they want to be efficient. Content collaboration platforms are useful, but first, ensure that ...

AI can enhance content security with a bit of planning

Microsoft and Box both use AI technologies to keep content secure in the cloud. But before using such tools, businesses first ...

Ex-SAP exec steers Episerver CMS toward digital experience market

Alex Atzberger discusses leaving the helm of SAP's CX platform to become Episerver CEO. Now, Episerver looks to reinvent itself ...

SearchHRSoftware

6 candidate journey mapping secrets savvy recruiters know

A journey map can be a critical tool for uncovering what it takes to provide your candidates with great experiences. Here's ...

Critical tips for managing contingent workers

Contingent workers save companies both time and money, so it's important to manage them in a win-win way. Here is what HR teams ...

Impact of AI on jobs goes on the presidential campaign trail

The impact of AI on jobs is a major issue for employers, who are struggling with how to address it. Robots, automation and AI ...

Getting started with writing sales order code for SAP ABAP, BW

SAP cancels NetWeaver BW 7.2 release, plans to roll features into 7.3 release

PPQ velvet Blackberry pouch in aid of Macmillan Cancer Support

Best career path for a pro with .NET experience

Please create a username to comment.