Credit Card Clearing - Need table info
I am using program RPRCCC00 for clearing Credit Card transaction using flat file. I need to put an extra validation to check whether the Transaction ID(field C_DOC) has been processed before or not. If yes then I want to identify that record in flat file and display appropriate log.
My doubt is that I don't know how to check whether the transaction has been processed before. When I searched for table that stores this data, I came across cluster PCL1(TC) which can be read only using PERNR. So this approach will be big performance issue as I will have to read the entire table. Is there any alternate approach that can be used to get this functionality?