Ansicht
Dokumentation
05296 - Are other libraries available from SAP?
Vendor Master (General Section) Addresses (Business Address Services)This documentation is copyright by SAP AG.
Are other libraries available from SAP?
Stan,There are over 1/2 million records in this file and I only want to
return the values from one. I can't seem to get a "where" portion of
the SQL statement to take. Any suggestions?
Based on your example, I came up with this code which is
syntactically correct but bombs out when run:
REPORT ZBC_TEST_NATIVE_SQL .
DATA: V_ITEMNO(6) type p decimals 0.
DATA: BEGIN OF i_item,
v_item(6),
v_upcndc(11),
END OF i_item.
V_ITEMNO = 56023.
EXEC SQL PERFORMING output-option.
SELECT itemno, upcndc
INTO :i_item
FROM kerrdata/invmas
WHERE itemno = :v_itemno
ENDEXEC.
FORM output-option.
WRITE: / v_itemno, i_item-v_item, i_item-v_upcndc.
ENDFORM.
Thanks for your help.
Robert Clay
Durban Tours - Südafrika Safari
Vendor Master (General Section) rdisp/max_wprun_time - Maximum work process run time
This documentation is copyright by SAP AG.
Length: 1204 Date: 20240426 Time: 174915 sap01-206 ( 2 ms )