Dynamic WHERE Clause in ABAP/4
You can apply internal table for create dynamic where clauses.
Example
DATA i_where(100) OCCURS 0 WITH HEADER LINE.
APPEND ’vbeln LIKE ’’%1’’’ to i_where.
APPEND ’matnr LIKE ’’%M’’’ to i_where.
TABLE lips.
DATA i_lips TYPE TABLE OF lips WITH HEADER LINE.
SELECT * FROM lips INTO TABLE i_lips
WHERE werks = ’1000’
AND (i_where).
Above Example is look like:
TABLE lips.
DATA i_lips TYPE TABLE OF lips WITH HEADER LINE.
SELECT * FROM lips INTO TABLE i_lips
WHERE werks = ’1000’
AND vbeln LIKE ’%1’
AND matnr LIKE ’%M’.
- thitima's blog
- Add new comment
- Read more
- 7060 reads
Altair Engineering Releases PBS Professional(TM) 7.0SP1
PBS Professional(TM) 7.0SP1 supports HP MPI and LAM-MPI.
Altair Engineering, Inc., a global leader in innovative product development, advanced engineering software and grid computing technology, today announced the release of PBS Professional(TM) 7.0SP1, the next generation of the company’s PBS Professional technology. PBS Professional technology optimizes the utilization of enterprise computing resources by aggregating hardware and software assets, and intelligently scheduling computational workloads based on business policies.
- sugree's blog
- Add new comment
- Read more
- 1065 reads
Google of in this early morning (Bangkok time). However, Google Updater bundled with that I installed 4 days ago doesn"t notify me about software update.
Probably Google Earth for PC has been released unofficially prior to Google Pack... Otherwise, this is a bug.
- sugree's blog
- Add new comment
- 933 reads
How to Copy File on Windows by ABAP/4
If you want to copy file on PC windows, you can use function "WS_FILE_COPY".
Example
*&---------------------------------------------------------------------*
*& Form COPY_FILE
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* -->PAR_SOURCE text
* -->PAR_DESTINATION text
*----------------------------------------------------------------------*
FORM copy_file USING par_source
par_destination.
- thitima's blog
- Add new comment
- Read more
- 2728 reads
How to Display Field Value as Checkbox in ABAP/4
When you want to display value of filed as checkbox in ABAP report, you can use WRITE statement by using option "AS CHECKBOX".
Example
DATA: ch1(1) TYPE C,
ch2(1) TYPE C VALUE ’X’.
WRITE: / ’Checkbox 1 ’, ch1 AS CHECKBOX,
/ ’Checkbox 2 ’, ch2 AS CHECKBOX.
- thitima's blog
- Add new comment
- 1243 reads
Dynamic Table Name in ABAP/4
In ABAP/4, you can specify table name in SELECT statement by dynamically.
Example
DATA table_name(10) TYPE C.
DATA num_rows TYPE I.
table_name = ’BKPF’.
SELECT COUNT( * ) FROM (table_name) INTO num_rows.
WRITE: ’Table Name ’, table_name, ’have rows ’, num_rows.
- thitima's blog
- Add new comment
- 1072 reads
Recent comments
3 years 3 weeks ago
3 years 8 weeks ago
3 years 9 weeks ago
3 years 9 weeks ago
3 years 9 weeks ago
3 years 11 weeks ago
3 years 11 weeks ago
3 years 12 weeks ago
3 years 12 weeks ago
3 years 12 weeks ago