I am using two table zle_ca_id_tmp and likp.My requirement is create a program and below logic
If ZLE_CA_ID_TMP.VBELN is not in LIKP.VBELN then delete the row the zle_ca_id_tmp in a single shot.
This should be done in a single read statement in m...
Thanks sandra.rossi ,I have done the testing and it is going to dump for the code in test environment so I will go with the OPEN CURSOR technique as per your suggestion.
Hello sandra.rossi / raymond.giuseppi ,I have modified the query as per your suggestion.Kindly please find below.SELECT * FROM zle_ca_id INTO TABLE li_zle_ca_id PACKAGE SIZE 1000
WHERE NOT EXISTS
( SELECT vbeln FROM likp
...
Hello raymond.giuseppi / sandra.rossi , I have one question for this issue.If I use the below code in my development,SELECT * FROM zle_ca_id
INTO TABLE li_zle_ca_id PACKAGE SIZE 1000
WHERE NOT EXISTS
( SELECT vbeln FROM likp
...