SAP for Insurance Discussions
Engage in conversations about risk management, customer experience, and digital transformation using SAP in the insurance industry. Join the discussion!
cancel
Showing results for 
Search instead for 
Did you mean: 

Table list of SAP Insurance

former_member199435
Participant
0 Kudos

Hi experts,

I've join the Insurance project, and I need to remodel BW of insurance, would you mind give me main table list about FSPM, FSCD, FSCM, FSICM, reinsurance, MSGPM? or other resource about that! thanks!

best regards,

Evans.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
6 REPLIES 6

Former Member
0 Kudos

Hope this help you - http://scn.sap.com/thread/3238458

Former Member
0 Kudos

The SAP system contains various types of table like;
1) Application table (master and transaction data)
2) Customizing table, maintenance only by customer etc.

you can use tcode se16 to identify the tables through their description.


The most commonly used FS CD tables are ( just to name a few)

CA Document
DFKKKO Document Header
DFKKOP BP (Open) items in CA document
DFKKOPK GL items in CA document

Totals Tables (Reconciliation Key)
DFKKSUM Posting Total Records
DFKKSUMC Control details for posting totals

Payment lots
DFKKZK

Payment lot data
DFKKZP

Payment lot, reconciliaton key
DFKKZF

Payment Plan
VVSCPOS FS-CD Scheduler – Header
VVSCITEM FS-CD Scheduler – Item
PPPOS_REV Reversal table for payment plan items

Returns lot - reconciliaton key
DFKKRF

Returns lot
DFKKRK

Dunning history
FKKMAKO

Dunning items
FKKMAZE

Collection history
DFKKCOLLH

--------

As Sagar Mentioned the tables. I am mentioning the Tcodes. Hope it will help you to find more..

FPL9Account Display
FPMAAutomatic Clearing
INSODISPInsurance Object
INSOCREATECreate Insurance Object
INSOCHANGEChange Insurance Object
FPY1Payment Run
FPE1Post Document
CAA1Contract Account Creation
CAA2Contract Account change
CAA3Contact Account Display
FP05Payment Lot
VYSPAPay Plan Posting
VPVADunning Run
VPVBDunning Activity Run
VPVCEnd Dunning Activity Run
FP08Reverse Document
FP09Returns Request
ACB1Account Balance Display
FPM3Dunning History
FP06Accounts Maintenance
FPU5Carry Forward Transfer
FP40Transfer Items
FPVZAgree Payment Amounts
FP25Check Lot
FPCHRCheck management
FPOR8MMass Reversals of Payment Order
FP31Find Payment
FPP4Maintain Bank Data
FPP1Bussiness Partner
KCLJExternal Master Transfer
FPARBPArchived BPs
INSOARCHArchived IOs
FPARArchived Documents
FPCM1

Tranfer Credit Data

Regards

0 Kudos

actually, I'm focus on BW, but there have not a lots datasource for BW, so I need to more table and table schema reference. but seems SAP for Insurance have no a lot resources!

best regards,

Evans.

hilbergm
Explorer
0 Kudos

Hi Evans,

The datasources for FS-PM can be found under component /PM0/A_FSPM on the source system.

Cheers,

Michael

0 Kudos

Hi Michael,

     thanks for your information, do you have others' information?

best regards,

Evans.

Former Member
0 Kudos

Some more FSCD tables:

FKKVKP                          for the contract account data

DIMAIOB                         Insurance contract general data

DIMAIOBPAR                  Insurance contract prtner specific data

VVKKFAPOS                   Invoice item data

DFKKCOLL                      Table with items transferred to collection agency

DFKKCOH                       Table with correspondence items (to be) printed and send to customer

FKK_INSTPLN_HEAD     Head of installment plan for customer

Hope it helps