Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Removing of select and end select

Former Member
0 Kudos

Hi experts how to remove select and end select for following logic?

T_IBSEG is internal table

SELECT * FROM BSIS WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR.

CHECK BSIS-BUDAT IN P_BUDAT.

MOVE-CORRESPONDING BSIS TO T_IBSEG.

APPEND T_IBSEG.

ENDSELECT.

7 REPLIES 7

Former Member
0 Kudos

If T_IBSEG has the type of BSIS:

SELECT * FROM BSIS

INTO TABLE T_IBSEG

WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR.

AND BUDAT IN P_BUDAT.

Else:

SELECT * FROM BSIS

INTO CORRESPONDING FIELDS OF TABLE T_IBSEG

WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR.

AND BUDAT IN P_BUDAT.

Regards

Wenceslaus

Former Member
0 Kudos

Hi

You put Table key word in select stmnt

SELECT * FROM BSIS into table t_ibseg WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR.

Thats all

SantoshKallem
Active Contributor
0 Kudos

SELECT * FROM BSIS INTO TABLE T_IBSEG WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR.

Former Member
0 Kudos

HI,

Try this:

SELECT * INTO CORRESPONDING FIELDS OF TABLE T_IBSEG

FROM BSIS

WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR.

CHECK BSIS-BUDAT IN P_BUDAT.

Former Member
0 Kudos

hi,

for removing endselect just specify the table<internal table>

SELECT * FROM BSIS INTO TABLE T_IBSEG WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR.

Former Member
0 Kudos

Hi sanjana,

do the following to remove select-endselect:-

SELECT * FROM BSIS into table T_IBSEG

WHERE BUKRS IN P_BUKRS AND

BELNR IN P_BELNR and

BUDAT IN P_BUDAT.

jayanthi_jayaraman
Active Contributor
0 Kudos

Hi,

data t_ibseg type standard table of bsis.

SELECT * FROM BSIS into table i_ibseg WHERE BUKRS IN P_BUKRS

AND BELNR IN P_BELNR and BUDAT IN P_BUDAT.