|
What are the difference between
SELECT-OPTIONS & RANGES?
Here both SELECT-OPTIONS & RANGES works for the same purpose. They both are used for the range selection from selection screen. The main diff. between them is, while we use SELECT-OPTIONS system implicitly creates the select options internal table which contains the fields of SIGN,OPTION,LOW & HIGH. But in case of RANGES, this internal table should be defined explicitly. Eg. to SELECT-OPTIONS :
REPORT YARSELECT.
APPEND VENDOR. - - - -
Eg. to RANGES:
REPORT YARRANGE.
- - - -
SELECT LIFNR LAND1 NAME1 FROM LFA1
INTO TABLE ITAB
Here with RANGES user has
to design an internal table with fields -
---------------------------------------------------------------------------------------------------------> Example: select-options: bukrs for zstock-bukrs. Should the user fill in 'ABFI' in BUKRS on the selection screen, BUKRS will look like this: IEQABFI This is because BUKRS is set as a table as follows: begin of bukrs occurs 0,
Now, when you create the following range, it will have the exact same fields set inside its table: Ranges: bukrs for zstock-bukrs. The difference is, because ranges doesn't show on the selection screen, you will have to fill it yourself, meaning you will have to fill bukrs-sign, bukrs-option, bukrs-low & bukrs-high all manually. Some tips:
ranges: bukrs for zstock-bukrs. bukrs-sign = 'E'.
"Exclude
Always remember to APPEND your range when you fill it, as the WHERE clause checks against the lines of the range table, not against the header line. Hope this explains it well enough. ---------------------------------------------------------------------------------------------------------> What does SIGN "I" & "E" mean? The "I" stands for Include, and the "E" for Exclude. The easiest way to learn how the range selections work is, create the following dummy program: report dummy.
Run this program, and fill in a lot of junk into MATNR. Fill in some includes, some excludes, some ranges, etc., and you will soon realise how the system builds ranges (select-options). Once you know that, you can fill your own ranges quickly and efficiently. ABAP Tips by : Venkata A Raju Kankipati / Sam Hearn
Fast Links:
Get help for your ABAP problems
SAP Books
ABAP Tips
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|