Solved

Arithmatic Operation within Select Query

Posted on 2004-09-08
3
269 Views
Last Modified: 2013-12-08
Hi abapers,
            I want to write a query like this.
 
data: pday type i. *(contains some day value).
*AB contains date value
Select AB from tabname where sy-datum - AB >= pday.

but system is not allowing me to subtract AB from sy-datum within the Select statement.

I don't want to write a subquery..

Please help me it is urgent..
0
Comment
Question by:yuve
3 Comments
 
LVL 1

Accepted Solution

by:
iamderek earned 125 total points
ID: 12065961
Rephase your code like this:

data: pday type i. *(contains some day value)
data pdate type d.

*AB contains date value
pdate = sy-datum - pday.
Select AB from tabname where AB <= pdate.

Derek
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
Read about achieving the basic levels of HRIS security in the workplace.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now