Skip to Content
avatar image
Former Member

Write-off Document in DFKKOP.

Hi Gurus,

I have created a write-off document using transaction FP04. I cannot find this document in DFKKOP. Please help. Please be informed that i can find this document in DFKKOPK.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Nov 04, 2016 at 11:19 AM

    Hi Rajeev,

    Write-off document is an offset entry document and not any receivables document and so you will not find any separate entry in DFKKOP table for the same. It will always appear as a clearing document against the receivable document for which write-off was performed.

    Moreover,.for write-off, the credit entry is in DFKKOP, (Cr A/R) by offsetting the receivables. and debit entry is in DFKKOPK (Dr bad Debt Expense)

    Thanks,

    Amlan

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 12:30 PM

    Hi Rajeev,

    In a normal scenario, both the table DFKKOP and DFKKOPK gets updated when you are posting a non-statistical transaction in SAP, say an ISU Invoice. DFKKOP contains the BP related details, where as DFKKOPK contains the GL A/c relevant details for the particular document.

    If you are posting a statistical transactions, say, a SD request, then only DFKKOP will be updated with BP relevant details, however, DFKKOPK will not get updated as statistical transactions don't have a GL component.

    Now, when you are performing a write-off, it will be a Credit A/R and Debit Bad debt Expense.

    So, the write-off document that gets posted will clear the outstanding receivables and will be there in the field DFKKOP-AUGBL (Credit A/R)

    The other side of the entry is to post a debit bad debt expense and will be there in DFKKOPK-OPBEL.

    Hope it clarifies.

    Thanks,

    Amlan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2016 at 05:10 PM
    -1

    I am trying to find out the table which contains this document.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2016 at 07:51 PM

    Where/how have you looked for the data? a write off is not a normal document and would only be shown as a clearing document.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 11:49 AM

    Hi Rajeev,

    If you have performed a write-off, you will find the write-off document in DFKKWOH table.

    Thanks,

    Amlan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 12:00 PM

    Thanks for the answer alman. I am really confused between DFKKOP and DFKKOPK. this write-off document is there in OPK but not is OP. How these two table are populated?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 04:21 PM

    Hi Amlan,

    Thanks for your explanation. When I posted the FICA Document, I could see debit(partner) details in DFKKOP and credit in DFKKOPK(Revenue).

    But when I posted write off I can see only debit(Write-off) in DFKKOPK. I cannot see any credit information saved anywhere.

    In FPE3 i can see my FICA document displayed as a credit item(Cleared Items). But i cannot find the same in any DB table.

    Ideally write-off posting should have both debit and credit entry in some table. Similar to FICA document. Please explain.

    Thanks,

    Rajeev.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10 at 02:09 PM

    Hi Amlan/William,

    My client have a requirement, wherein, we need to write off the Debit/Credit amount during the 12th(Settlement) month for a Budget Bill Plan customer.

    Is there any event where i can implement this logic so that during invoicing of 12th month bill, the credit or debit item would be written off.

    Could you please tell me what other things we need to take care of before implementing this solution ?

    Thanks,

    Pankaj

    Add comment
    10|10000 characters needed characters exceeded