ABAP Logical Database Program Comparison

ABAP Logical Database Program Comparison

Find below 2 programs performing the same task. The following program does not use a logical database.

REPORT ZEX_LOGICALDAT .

DATA: WA_SPFLI TYPE SPFLI,
      WA_SFLIGHT TYPE SFLIGHT.

SELECT-OPTIONS: SEL_CARR FOR WA_SPFLI-CARRID.

SELECT CARRID CONNID CITYFROM CITYTO
            FROM SPFLI
            INTO CORRESPONDING FIELDS OF WA_SPFLI
            WHERE CARRID IN SEL_CARR.

           WRITE: / WA_SPFLI-CARRID,
                         WA_SPFLI-CONNID,
                         WA_SPFLI-CITYFROM,
                         WA_SPFLI-CITYTO.

SELECT FLDATE
            FROM SFLIGHT
            INTO CORRESPONDING FIELDS OF WA_SFLIGHT
            WHERE CARRID = WA_SPFLI-CARRID and
            CONNID = WA_SPFLI-CONNID.

            WRITE: / WA_SFLIGHT-FLDATE.

ENDSELECT.
ENDSELECT.

The following program uses a Logical Database F1S.

REPORT ZEX_LOGICALDAT1 .

NODES: SPFLI, SFLIGHT.

GET SPFLI FIELDS CARRID CONNID CITYFROM CITYTO.

WRITE:/ SPFLI-CARRID,
        SPFLI-CONNID,
        SPFLI-CITYFROM,
        SPFLI-CITYTO.

GET SFLIGHT FIELDS FLDATE.

WRITE:/ SFLIGHT-FLDATE.