2011 Sep 14 12:41 PM
Hi Experts,
Can anyone explain me what is the table DFKKRP is used for.
i need to check for number of returned checks in last quarter but as i am unfamiliar with the table and its use unable to figure out the way to do it.
thanks in advance.
2011 Sep 14 1:07 PM
As far as I know about DFKKRP, it stores the line item data of return lot.
You will find Return lot id, number of line in return lot and the payment document number which got returned, its amount etc. in this table.
Also there is DFKKRK for header data of return lot.
Below are related tables
DFKKRF Returns Lot: Reconciliation Key
DFKKRH Returns History
DFKKRK Returns lot: Header data
DFKKRP Returns lot: Data for payment
DFKKRP3 Returns: Manual Posting Specifications
DFKKRP3H Returns: History for Manual Posting Items
2011 Sep 14 1:07 PM
As far as I know about DFKKRP, it stores the line item data of return lot.
You will find Return lot id, number of line in return lot and the payment document number which got returned, its amount etc. in this table.
Also there is DFKKRK for header data of return lot.
Below are related tables
DFKKRF Returns Lot: Reconciliation Key
DFKKRH Returns History
DFKKRK Returns lot: Header data
DFKKRP Returns lot: Data for payment
DFKKRP3 Returns: Manual Posting Specifications
DFKKRP3H Returns: History for Manual Posting Items
2011 Sep 15 6:28 AM
Hi,
I'm not sure if you mean to find Checks refunded or Check Payments which were returned.
If you want to find Check Payments returned in last quarter, you have to check for all reversed payment in last quarter with main transaction for Payment (generally 0600) and Document type for Check lots (generally CQ).
Thanks.
Ravi
2011 Sep 15 10:11 AM
Hello,
if you need the number of returned checks you should use table DFKKRH (history table).
Best regards.
Christiane
2011 Sep 15 6:02 PM
DFKKRP is the table , where in you can find the details of checks returned which were created through FP09 . It basically contains the details of returns lot posted through FP09 .
Well in case if you are only using FP09 then DFKKRP would be sufficient else , you will have to look up for tables as per your practice .
Cheers ,
Dewang
2011 Sep 16 7:17 AM
Hi,
As Dewang suggested, if FP09 is the only way you return. then look for all the return lot items in table DFKKRP for which Return reason is Dishonored Cheque (A02 and C29) whichever valid in your business process.
Thanks.
Ravi
2011 Sep 21 11:47 AM
HI,
Let me explain the whole this i need to figure out the number of checks that are returned in last quarter due to any reason.
now i need to determine the count of these checks based on contract accounts and business partner.
so can anyone tell me what field i should use to link it with business partner and kontract accounts.
Thanks and regards
shashank