11-06-2007 4:20 PM
Hi,
I have the following dinamic sql sentence:
<Code>
select single (p_campo) into vt_salida
from vt_table
</Code>
The type of p_campo is any. Which should be the type of vt_salida ?
I need that it never happens an error.
Thanks
11-06-2007 4:23 PM
Try with this code:
DATA: ITAB TYPE REF TO DATA.
FIELD-SYMBOLS: <ITAB> TYPE STANDARD TABLE.
DATA: TABLE_NAME(20).
DATA: BEGIN OF LT_FIELDS OCCURS 0,
FIELD(20),
END OF LT_FIELDS.
TABLE_NAME = 'MARA'.
LT_FIELDS = 'MATNR'.
APPEND LT_FIELDS.
LT_FIELDS = 'MATKL'.
APPEND LT_FIELDS.
CREATE DATA ITAB TYPE STANDARD TABLE OF (TABLE_NAME).
ASSIGN ITAB->* TO <ITAB>.
SELECT (LT_FIELDS) "matnr MATKL
INTO CORRESPONDING FIELDS OF TABLE <ITAB>
FROM (TABLE_NAME)
UP TO 10 ROWS.
Regards,
Naimesh Patel
11-06-2007 4:23 PM
Try with this code:
DATA: ITAB TYPE REF TO DATA.
FIELD-SYMBOLS: <ITAB> TYPE STANDARD TABLE.
DATA: TABLE_NAME(20).
DATA: BEGIN OF LT_FIELDS OCCURS 0,
FIELD(20),
END OF LT_FIELDS.
TABLE_NAME = 'MARA'.
LT_FIELDS = 'MATNR'.
APPEND LT_FIELDS.
LT_FIELDS = 'MATKL'.
APPEND LT_FIELDS.
CREATE DATA ITAB TYPE STANDARD TABLE OF (TABLE_NAME).
ASSIGN ITAB->* TO <ITAB>.
SELECT (LT_FIELDS) "matnr MATKL
INTO CORRESPONDING FIELDS OF TABLE <ITAB>
FROM (TABLE_NAME)
UP TO 10 ROWS.
Regards,
Naimesh Patel
11-06-2007 4:26 PM
Hello,
I think it should be string...or a numeric char something like
DATA vt_salida(8) TYPE N.
OR
DATA vt_salida TYPE STRING
check this sample.
DATA: wa TYPE spfli,
ftab TYPE TABLE OF STRING.
APPEND 'CITYFROM' TO ftab.
APPEND 'CITYTO' TO ftab.
SELECT DISTINCT (ftab)
FROM spfli
INTO CORRESPONDING FIELDS OF wa
WHERE
carrid = 'LH'.
WRITE: / wa-cityfrom, wa-cityto.
ENDSELECT.
Bye
Gabriel
11-07-2007 8:26 AM
Sorry but I don´t find the radio buttons to award points to replies...