Ansicht
Dokumentation
05314 - Are other libraries available from SAP?
rdisp/max_wprun_time - Maximum work process run time General Data in Customer MasterThis documentation is copyright by SAP AG.
Are other libraries available from SAP?
Stan, Desmond, and Volker:
Thanks so very much for the input. Through a combination of all
responses, we have created the following code which functions
properly:
REPORT ZBC_TEST_NATIVE_SQL2.
DATA: pITEMNO(6) type p decimals 0.
DATA: BEGIN OF iINVMAS,
iITEMNO(6) type p decimals 0,
iUPCNDC(11) type p decimals 0,
END OF iINVMAS.
pITEMNO = 54707.
EXEC SQL PERFORMING output-option.
SELECT ITEMNO, UPCNDC
INTO :iINVMAS
FROM KERRDATA/INVMAS
WHERE :pITEMNO = ITEMNO
ORDER by ITEMNO
ENDEXEC.
FORM output-option.
WRITE: / pITEMNO, iINVMAS-iITEMNO, iINVMAS-iUPCNDC.
ENDFORM.
And the output shows:
Test native SQL statement
54,707 54,707 64,921,554,707
The thing that seems to make it work is putting the ABAP variable
BEFORE the host table's field name in the WHERE clause. Flip/Flop
the two and you get a short dump. I couldn't find this little tidbit
of information anywhere else.
Thanks again for all of the help.
Robert Clay
Durban Tours - Südafrika Safari
RFUMSV00 - Advance Return for Tax on Sales/Purchases PERFORM Short Reference
This documentation is copyright by SAP AG.
Length: 1497 Date: 20240425 Time: 165754 sap01-206 ( 2 ms )