12-21-2006 7:55 AM
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.
12-21-2006 7:57 AM
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
12-21-2006 7:58 AM
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
12-21-2006 7:58 AM
SELECT * FROM BSIS INTO TABLE T_IBSEG WHERE BUKRS IN P_BUKRS
AND BELNR IN P_BELNR.
12-21-2006 7:58 AM
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.
12-21-2006 8:00 AM
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.
12-21-2006 8:05 AM
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.
12-21-2006 8:14 AM
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.