Hello people,
I have a function that receives a table as a parameter.
I need to check if each enter in this table exists in table in database. If it exists, I need to mark "X" in the last column in this table. Liek this:
SELECT WERKS MATKL 'X'
INTO CORRESPONDING FIELDS OF TABLE T_LISTA
FROM yswerks_matkl
FOR ALL ENTRIES IN T_LISTA
WHERE WERKS = T_LISTA-WERKS
AND MATKL = T_LISTA-WERKS.
Is it possible?
Thanks a lot!