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: 

ISU-tables

Former Member
0 Kudos

Hi Experts,

Can anyone please give me the table names used in IS Utilities in FI/CA, Billing, CCS along wth their inter relation ships?

thanks

Deep.

1 REPLY 1

Former Member
0 Kudos

Hi,

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,

Padmam.