I'm a newbie so bear with me, please.
I have a requirement to process records in IT0167 (Life Insurance). The gist of what I need to do is pull back anyone who is enrolled in an optional life plan and will turn 40 or 60 the month subsequent to when the program is executed.
I've heard of PNPCE and macros but all I can find are macros that will give you the last active record for a period, for example (RP-PROVIDE-FROM-LAST, etc.). This seems like it'll only pull back one record at a time but I need to iterate over anyone who fits the criteria.
I'm told that doing a select on PA0167 isn't a good idea and that I should use the LDB + macros but I can't find what I need. I'd be happy if I could find one that pulled back anyone who's active and then I could iterate over that itab and process only those that meet my criteria.