Credit Card Clearing - Need table info

Kumar Amit Apr 12, 2012 4:29 PM

Currently Being Moderated

Hello experts,

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?

Regards,

Amit

Re: Credit Card Clearing - Need table info

Siegfried Krause Apr 16, 2012 12:40 PM (in response to Kumar Amit)

Currently Being Moderated

Maybe this fm will help PTRM_UTIL_IMPORT_TC_CLUSTER
Report Abuse

Like (0)
- Re: Credit Card Clearing - Need table info
  
  Kumar Amit Apr 18, 2012 11:44 AM (in response to Siegfried Krause)
  
  Currently Being Moderated
  
  Hi Siegfried,
  Thanks for your reply.
  As I mentioned in my question itself, I should not use PERNR to read cluster data because I am looking to check whether the Transaction ID already exist in database. The FM returns cluster data based on PERNR only, so if I don't mention that then it will return entire table entries. This will be a major performance issue in Production environment.
  
  Regards,
  Amit
  
  Report Abuse
  
  Like (0)
  - Re: Credit Card Clearing - Need table info
    
    Siegfried Krause Apr 18, 2012 4:21 PM (in response to Kumar Amit)
    
    Currently Being Moderated
    
    Normally there is a check of the accounting run no. (ABNUM) in the SAP standard. Also for me it is not clear if C_DOC a unique number.
    So for which do you need this addtional check? Which Credit Card Provider do you have here?
    
    Report Abuse
    
    Like (0)
    - Re: Credit Card Clearing - Need table info
      
      Kumar Amit May 16, 2012 7:08 AM (in response to Siegfried Krause)
      
      Currently Being Moderated
      
      As I could not find any alternate approach to read database entries, I am reading entire table now. But the issue is that I realised that C_DOC is not unique number, so we need to compare the Company ID also now. How can I get Company ID info for a specific transaction.? Any clue?
      
      Regards,
      Amit
      
      Report Abuse
      
      Like (0)

Go to original post