database view

[Manoj_B_Gaikwad]

Hi everyone,

While creating a Database view in SE11 we can set 'selection conditions' which work like filter/sorting

can we do the same thing in SE38 when using inner join?

Please refer to the following screenshots and source code.

SE11 Screen

TABLES: LFA1, EKKO.

SELECTION-SCREEN: BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-000.
SELECT-OPTIONS: S_LIFNR FOR LFA1-LIFNR.
SELECTION-SCREEN: END OF BLOCK B1.

TYPES: BEGIN OF TY_FINAL,
LIFNR TYPE LIFNR,
NAME1 TYPE NAME1_GP,
ORT01 TYPE ORT01_GP,
PSTLZ TYPE PSTLZ,
EBELN TYPE EBELN,
AEDAT TYPE ERDAT,
ZTERM TYPE DZTERM,
END OF TY_FINAL.

DATA: WA_FINAL TYPE TY_FINAL,
IT_FINAL TYPE TABLE OF TY_FINAL.

SELECT LFA1~LIFNR
LFA1~NAME1
LFA1~ORT01
LFA1~PSTLZ

EKKO~EBELN
EKKO~AEDAT
EKKO~ZTERM

FROM LFA1 INNER JOIN EKKO
ON LFA1~LIFNR = EKKO~LIFNR INTO CORRESPONDING FIELDS OF TABLE IT_FINAL
WHERE LFA1~LIFNR IN S_LIFNR .

LOOP AT IT_FINAL INTO WA_FINAL.

WRITE:/ WA_FINAL-LIFNR,
20 WA_FINAL-NAME1,
60 WA_FINAL-ORT01,
80 WA_FINAL-PSTLZ,
100 WA_FINAL-EBELN,
120 WA_FINAL-AEDAT,
140 WA_FINAL-ZTERM.

ENDLOOP.

ABAP Development

[raymond_giuseppi · Accepted solution]

Just add some WHERE criteria in the SELECT statement, what's your exact requirement?

[Manoj_B_Gaikwad · Accepted solution]

can you give me complete syntax