09-09-2014 2:50 AM
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.
09-16-2014 1:05 PM
09-16-2014 1:05 PM
09-16-2014 1:21 PM
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..
FPL9 | Account Display |
FPMA | Automatic Clearing |
INSODISP | Insurance Object |
INSOCREATE | Create Insurance Object |
INSOCHANGE | Change Insurance Object |
FPY1 | Payment Run |
FPE1 | Post Document |
CAA1 | Contract Account Creation |
CAA2 | Contract Account change |
CAA3 | Contact Account Display |
FP05 | Payment Lot |
VYSPA | Pay Plan Posting |
VPVA | Dunning Run |
VPVB | Dunning Activity Run |
VPVC | End Dunning Activity Run |
FP08 | Reverse Document |
FP09 | Returns Request |
ACB1 | Account Balance Display |
FPM3 | Dunning History |
FP06 | Accounts Maintenance |
FPU5 | Carry Forward Transfer |
FP40 | Transfer Items |
FPVZ | Agree Payment Amounts |
FP25 | Check Lot |
FPCHR | Check management |
FPOR8M | Mass Reversals of Payment Order |
FP31 | Find Payment |
FPP4 | Maintain Bank Data |
FPP1 | Bussiness Partner |
KCLJ | External Master Transfer |
FPARBP | Archived BPs |
INSOARCH | Archived IOs |
FPAR | Archived Documents |
FPCM1 | Tranfer Credit Data Regards |
09-17-2014 10:44 AM
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.
09-18-2014 5:16 PM
Hi Evans,
The datasources for FS-PM can be found under component /PM0/A_FSPM on the source system.
Cheers,
Michael
09-19-2014 2:15 AM
Hi Michael,
thanks for your information, do you have others' information?
best regards,
Evans.
10-16-2014 3:44 PM
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