Ansicht
Dokumentation

05314 - Are other libraries available from SAP?

05314 - Are other libraries available from SAP?

Vendor Master (General Section)   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

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

Addresses (Business Address Services)   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 1497 Date: 20240304 Time: 182720     sap01-206 ( 2 ms )