10-14-2008 12:41 AM
Hi,
the following code throws the exception CX_SY_NO_HANDLER. Could it be that my Netweaver server does not support joins?
Or is there a semantic error in my code:
SELECT A~PRODUCT_ID A~PROD_INST_ID A~PRICE_CURRENT B~PRODUCT_NAME
FROM GP1_PROD_INST AS A
INNER JOIN GP1_PRODUCTS AS B ON A~PRODUCT_ID = B~PRODUCT_ID
INTO CORRESPONDING FIELDS OF TABLE PRODUCT_DETAILS
WHERE A~PRODUCT_ID = 1 .
If have the two tables GP1_PRODUCT ( attributes: PRODUCT_ID, PRODUCT_NAME )
and GP1_PROD_INST (attributes: PRODUCT_ID, ROD_INST_ID A~PRICE_CURRENT ).
and the internal table PRODUCT_DETAILS with all that fields and some other fields.
Thanks,
Christian
10-14-2008 2:06 AM
I solved the problem, it was a wrong data element used in the structure for the internal table.
Regards,
Christian