Ansicht
Dokumentation

05296 - Are other libraries available from SAP?

05296 - Are other libraries available from SAP?

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Material Data  
This documentation is copyright by SAP AG.
SAP E-Book

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

PERFORM Short Reference   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 1204 Date: 20240221 Time: 184925     sap01-206 ( 3 ms )