SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Important FICA Tables

Former Member
0 Kudos

Experts,

Can you please provide the Important FICA tables that we use. Including dunning,Payment run, payment lot, refund, creditworthiness etc.

Await quick reply on this

Kind regards,

Vinod Khelani

1 ACCEPTED SOLUTION

Former Member

Below are the list of tables in FICA DFKKOP Items in contract account document DFKKOPK Items in contract account document DFKKKO Header Data in Open Item Accounting Document DFKKREP05 Payment History: Reversals and Write-Offs DFKKREP06 Tax Report Data (Invoicing Time or Triggered) DPAYCHKH Header: Accounting Using Creation of Payment Media DPAYCHKH1 Supplemental Assignments with Creation of Payment Media Table fields Short descriptn DPAYC Payment program - administrative records DPAYCHKH Header: Accounting Using Creation of Payment Media DPAYCHKH1 Supplemental Assignments with Creation of Payment Media DPAYCHKP Header: Accounting Using Creation of Payment Media DPAYG Payment program - payment group DPAYH Payment program - data for payment DPAYP Payment program - data on paid item DPAYV Payment program: Variants for payment medium and list TFK042Q Payment Medium: Note of First Direct Debit TFK042U Payment Medium: Internal Note to Payee TFK042X Payment Program: Company Codes blocked by Payt Run YZFKKMAKO Dunning History Header FKCRPO Clarification Worklist Credit DFKKCFPAYRUN Clarif. Worklist: Payt Program DFKKCIBW FICA: Extraction of Cleared Items DFKKCOLFILE_H_W Subm. of Receivable for Collection: Header Data Buffer DFKKCOLFILE_P_W Subm. of Receivable for Collection: Item Buffer DFKKCOLFILE_T_W Subm. of Receivable for Collection: Trailer Data Buffer DFKKCOLLHBW_ST Collection Agency Extraction - Status Table DFKKCOLLHBW_TMP Collection Agency Extraction - Blocked Interval DFKKCOLLH_I_W Buffer: Collection Agency Information File (Header Data) DFKKCOLLP_IM_W Buffer: Coll. Agency Info File (Item Master Data Change) DFKKCOLLP_IP_W Buffer: Collection Agency Info File (Item for Payments) DFKKCOLLP_IR_W Buffer: Collection Agency Info File (Item for Callback) LAUFD Date ID DFKKCOLLT_I_W Buffer: Collection Agency Information File (Footer) DFKKCOMA Correspondence Dunning DFKKCOMAKT Correspondence Dunning Activities DFKKCRP Creditworthiness Record: Generating Actions DFKKDDA Debit Memo Notification (England) DFKKENQ Temporary Lock Entries for Mass Activities DFKKLOCKS FI-CA: Business Locks DFKKMACFCSMK FICA Dunning - Blocked Accounts DFKKOPCOLL Collection: Log of Receivables Submitted LAUFD Date ID DFKKOPKC Card Data Appendix for FICA Document DFKKORDERHIST Requests: Document History DFKKORDOPHIST Standing Requests: Document History DFKKPNBKC Prenotification file creation run: administration data DFKKPOH Payment Order: Header Data DFKKRDI Revenue Distribution DFKKRPL Link from Mass Run Interval for Application Log DFKKSTAT Table for Temporary Statistics Data, for Mass Activities LAUFD Date ID DFKKTAXEX Table of FI-CA Tax Exemptions DFKKTAX_EXEMPT Table of FI-CA Tax Exemptions DFKKUR Update Run: Run Data DFKKURE Update Run: Defective Data Records DFKKWOH Write-Off History DFKKZW2 Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg DFKKZWPT Log Table for Mass Activ. for Tfr Posting of Dbt Rec/IVAs DFK_JC_CNTR Container for Related Jobs DFKKCFRLS Clarification Cases: Returns Lots DFKKCFZST Clarification Cases from Payment Lot

Regards,

Siva

View solution in original post

5 REPLIES 5

Former Member
0 Kudos

http://kkrumi.googlepages.com/sapis-u

Please go to this link

Regards,

Prajakta

Former Member

Below are the list of tables in FICA DFKKOP Items in contract account document DFKKOPK Items in contract account document DFKKKO Header Data in Open Item Accounting Document DFKKREP05 Payment History: Reversals and Write-Offs DFKKREP06 Tax Report Data (Invoicing Time or Triggered) DPAYCHKH Header: Accounting Using Creation of Payment Media DPAYCHKH1 Supplemental Assignments with Creation of Payment Media Table fields Short descriptn DPAYC Payment program - administrative records DPAYCHKH Header: Accounting Using Creation of Payment Media DPAYCHKH1 Supplemental Assignments with Creation of Payment Media DPAYCHKP Header: Accounting Using Creation of Payment Media DPAYG Payment program - payment group DPAYH Payment program - data for payment DPAYP Payment program - data on paid item DPAYV Payment program: Variants for payment medium and list TFK042Q Payment Medium: Note of First Direct Debit TFK042U Payment Medium: Internal Note to Payee TFK042X Payment Program: Company Codes blocked by Payt Run YZFKKMAKO Dunning History Header FKCRPO Clarification Worklist Credit DFKKCFPAYRUN Clarif. Worklist: Payt Program DFKKCIBW FICA: Extraction of Cleared Items DFKKCOLFILE_H_W Subm. of Receivable for Collection: Header Data Buffer DFKKCOLFILE_P_W Subm. of Receivable for Collection: Item Buffer DFKKCOLFILE_T_W Subm. of Receivable for Collection: Trailer Data Buffer DFKKCOLLHBW_ST Collection Agency Extraction - Status Table DFKKCOLLHBW_TMP Collection Agency Extraction - Blocked Interval DFKKCOLLH_I_W Buffer: Collection Agency Information File (Header Data) DFKKCOLLP_IM_W Buffer: Coll. Agency Info File (Item Master Data Change) DFKKCOLLP_IP_W Buffer: Collection Agency Info File (Item for Payments) DFKKCOLLP_IR_W Buffer: Collection Agency Info File (Item for Callback) LAUFD Date ID DFKKCOLLT_I_W Buffer: Collection Agency Information File (Footer) DFKKCOMA Correspondence Dunning DFKKCOMAKT Correspondence Dunning Activities DFKKCRP Creditworthiness Record: Generating Actions DFKKDDA Debit Memo Notification (England) DFKKENQ Temporary Lock Entries for Mass Activities DFKKLOCKS FI-CA: Business Locks DFKKMACFCSMK FICA Dunning - Blocked Accounts DFKKOPCOLL Collection: Log of Receivables Submitted LAUFD Date ID DFKKOPKC Card Data Appendix for FICA Document DFKKORDERHIST Requests: Document History DFKKORDOPHIST Standing Requests: Document History DFKKPNBKC Prenotification file creation run: administration data DFKKPOH Payment Order: Header Data DFKKRDI Revenue Distribution DFKKRPL Link from Mass Run Interval for Application Log DFKKSTAT Table for Temporary Statistics Data, for Mass Activities LAUFD Date ID DFKKTAXEX Table of FI-CA Tax Exemptions DFKKTAX_EXEMPT Table of FI-CA Tax Exemptions DFKKUR Update Run: Run Data DFKKURE Update Run: Defective Data Records DFKKWOH Write-Off History DFKKZW2 Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg DFKKZWPT Log Table for Mass Activ. for Tfr Posting of Dbt Rec/IVAs DFK_JC_CNTR Container for Related Jobs DFKKCFRLS Clarification Cases: Returns Lots DFKKCFZST Clarification Cases from Payment Lot

Regards,

Siva

0 Kudos

Thanks a lot,

Anything dunning specific i know two FKKMAZE & FKKMAKO

0 Kudos

DFKKCOMA Correspondence Dunning

DFKKCOMAKT Correspondence Dunning Activities

TFK047A Dunning Procedure

Regards,

Prajakta

Former Member
0 Kudos