sy-datum low and high definitions

abap opensql
user3001094 picture user3001094 · Nov 17, 2013 · Viewed 20.7k times · Source

I have an ABAP program with below sample code which should select data from an SAP table based on a date column.

INITIALIZATION. 
select-OPTIONS: so_date FOR sy-datum.  
START-OF-SELECTION. 
so_date-sign = 'I'. 
so_date-option = 'BT'. 
so_date-low = sy-datum. 
so_date-high = '99991231'. 
APPEND so_date.

and my select stmt is:

select c1,c2,c3 
from <sap_table>
where <date_column> in so_date.

I want to know the purpose of setting so_date-high = '99991231' and how it will behave.

Answer

knut picture knut · Nov 17, 2013

BT means between. 99991231 is a date in the internal format YYYYMMDD (Year-month-day), it is the 31th december 9999. Your setting of the select option hits any date between today and a date far in the future.

TheG already mentioned: It should be better at INITIALIZATION, so your selection is already visible on selection-screen and can be modified if you need it.

select-OPTIONS: so_date FOR sy-datum.  
INITIALIZATION. 
  so_date-sign = 'I'. 
  so_date-option = 'BT'. 
  so_date-low = sy-datum. 
  so_date-high = '99991231'. 
  APPEND so_date.

Remark: This presetting works only in dialogue, not in batch (but when you call it in batch, you can set the default in the variant for the batch job).

But for this easy default values, you should use the default-option of select-options:

SELECT-OPTIONS: so_date FOR sy-datum DEFAULT sy-datum to '99991231'.

Or to say 'everything in the future':

SELECT-OPTIONS: so_date FOR sy-datum DEFAULT sy-datum OPTION GE.

GE means greater equal.

Related questions

Most efficient way to select data set conditional upon each other from multiple tables

I have an internal table like: TYPES: BEGIN OF gty_min_jobs, orgeh TYPE zgerpt_rnk_min-orgeh1, mnsty TYPE zgerpt_rnk_min-mnsty, mshort TYPE zgerpt_rnk_min-mshort, position TYPE hrp1001-sobid, job TYPE hrp1001-sobid, job_grade TYPE hrp9003-jobgr, …

Read More
SELECT FOR ALL ENTRIES vs LOOP SELECT SINGLE in ABAP

I am comparing the SELECT FOR ALL ENTRIES vs LOOP SELECT SINGLE and I am having a big difference between results. Somebody can help me with this? What is the difference? SELECT ekko~ebeln ekpo~ebelp ekko~bstyp ekko~bsart …

Read More
Multiple conditions in a SELECT statement?

First off, I have no experience with ABAP, I'm operating on guesswork here. I want to add a condition to a SELECT in an existing report. The existing code looks like this: SELECT SINGLE * FROM EKPO WHERE EBELN = GT_MSEG-EBELN …

Read More