What is the syntax for appending a row to an internal table. I'm getting an error trying to do this and I can't find anything out there that will tell me how to do it. I've seen how to move one internal table to another but not how to append certain values.
Here is my code:
SELECT LIFNR into (vendor_num) FROM BSEG
WHERE ZLSCH = 'Z' AND AUGDT between beg_clearing_date AND
SELECT SINGLE ADRNR into (addr_num)
WHERE LIFNR = vendor_num.
SELECT SINGLE SMTP_ADDR into (email_recipient)
WHERE ADDRNUMBER = addr_num AND SMTP_ADDR IS NOT NULL.
INSERT INTO w_vendor_info ( vendor_num email )
VALUES ( vendor_num email_recipient ).