07-06-2009 6:33 AM
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
07-06-2009 7:26 AM
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
07-06-2009 7:25 AM
07-06-2009 7:26 AM
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
07-06-2009 8:07 AM
07-06-2009 8:17 AM
DFKKCOMA Correspondence Dunning
DFKKCOMAKT Correspondence Dunning Activities
TFK047A Dunning Procedure
Regards,
Prajakta
07-06-2009 7:59 AM
Hi Vinod,
Check these links.
http://www.esnips.com/web/mokusz-SAP
or
http://www.esnips.com/doc/9bd50e96-ecae-4327-9b69-1effba953140/isu_tables
Hope this resolves.
Regards,
Manish