To share know-how, news, experience, and information regarding technology, software, hardware, programming, Python, ABAP/4, product, high-performance computing, grid, cluster, ERP, SAP R/3, SAP NetWeaver, and many more.

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’.

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.

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.

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.

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.

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.