topic Re: ABAP QUERY in Application Development and Automation Discussions

ABAP QUERY

Former Member — Thu, 11 May 2006 16:08:06 GMT

Hi everyone.

Simple question ...

How to set default values for a selection field in an ABAP Query?

Thanks.

Re: ABAP QUERY

rahulkavuri — Thu, 11 May 2006 16:08:49 GMT

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME.

SELECT-OPTIONS: S_VBELN FOR VBAK-VBELN.
PARAMETERS: P_VBTYP LIKE VBAK-VBTYP DEFAULT 'C'.

SELECTION-SCREEN END OF BLOCK B1.

SELECTION-SCREEN BEGIN OF BLOCK B2 WITH FRAME.
PARAMETERS: LIST RADIOBUTTON GROUP G1,
            GRID RADIOBUTTON GROUP G1.

SELECTION-SCREEN END OF BLOCK B2.

The above is for parameters, this is for select values..

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

SELECT-OPTIONS: S_VBELN FOR VBRK-VBELN,
                S_FKDAT FOR VBRK-FKDAT,
                S_MATNR FOR VBRP-MATNR.

SELECTION-SCREEN END OF BLOCK B1.


<b>INITIALIZATION.

  STR_DATE = SY-DATUM - 200.
  S_FKDAT-LOW = STR_DATE.
  S_FKDAT-HIGH = SY-DATUM.
  S_FKDAT-SIGN = 'I'.
  APPEND S_FKDAT.</b>

Re: ABAP QUERY

Former Member — Thu, 11 May 2006 16:09:06 GMT

hii

FOR PARAMETERS YOU CAN PASS IT THERE ITSELF,

FOR SELECT OPTIONS SHOULD PASS IN INITIALIZATION.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

PARAMETERS : P_VBELN TYPE VBAK-VBELN DEFAULT '1234556',

SELECT-OPTIONS: S_ERDAT TYPE VBAK-ERDAT .

SELECTION-SCREEN END OF BLOCK B1.

DATA: INITIAL_DATE TYPE SY-DATUM ,

FINAL_DATE TYPE SY-DATUM .

INITIALIZATION.

S_ERDAT-LOW = INITIAL_DATE.

S_ERDAT-HIGH = FINAL_DATE.

S_ERDAT-SIGN = 'I'.

S_ERDAT-OPTION = 'I' .

APPEND S_ERDAT .

Hope This helps

Thanks&Regards

Naresh

Re: ABAP QUERY

Former Member — Thu, 11 May 2006 16:14:45 GMT

OK, but that's pure ABAP ...

My question is from ABAP Query construction ... by means of transactions SQ01, SQ02 ... how can i set a default value for a specific field.

Your awnser is ABAP Programming point of view ... i also knew that ... but thanks anyway!

Re: ABAP QUERY

Former Member — Thu, 11 May 2006 17:15:36 GMT

Its quite simple. Go to SQ02. Go to Selections tab. Double click on the field for which you want to set the default value.

If say you want to set the default value to XXXX then just type in Extras field

DEFAULT 'XXXX'.

Please award points if useful