The following Translation Values must be set up in the system for the extraction of financial transactions to be uploaded into SAP Financials.
The value of INP TO SAP AFS must be added to the UDPV object Translation Type.
Translation values for the following Source System and Target system ID’s must be created:
|
Source System ID |
Source System Attribute |
Target System ID |
Target System Attribute |
|
IN.PENSIONS |
ACC/QUAL |
SAP AFS |
ACCOUNT |
|
IN.PENSIONS |
COUNTRY |
SAP AFS |
COMPANY CODE |
|
IN.PENSIONS |
COUNTRY |
SAP AFS |
JOURNAL ID |
|
IN.PENSIONS |
SCHEME |
SAP AFS |
COST CENTRE |
|
IN.PENSIONS |
SCHEME |
SAP AFS |
SEGMENT |
The following table details the Source System Attribute for which translation values must be captured, the fields that need to be read for each attribute and the combination of fields that need to be read on the Business Transaction (BT) for each Attribute:
|
Source System Attribute |
Source |
Details |
|
ACC-QUAL |
Business Transaction |
ACCOUNT CODE - ACCOUNT QUALIFIER (INCOME TYPE, EXPENSE TYPE) |
|
COUNTRY |
Scheme Details |
COUNTRY |
|
SCHEME |
Scheme Details |
SCHEME CODE |
A translation value equal to the SAP Account Number must be captured for each combination of IN.pensions Account Code and Account Qualifier and a translation value equal to the SAP Cost Centre must be captured for all of the Administration Branches (see sample page below).
The following Translation Values must be set up:
|
Source System Attribute |
Source System Value |
Target System Attribute |
Target System Value |
|
ACC-QUAL |
BANK |
ACCOUNT |
100200 |
|
ACC-QUAL |
INVESTMENT |
ACCOUNT |
105500 |
|
ACC-QUAL |
CONTRECVABLE |
ACCOUNT |
575010 |
|
ACC-QUAL |
COMMPAYABLE |
ACCOUNT |
679200 |
|
ACC-QUAL |
VATPAYABLE |
ACCOUNT |
243000 |
|
ACC-QUAL |
FEEPAYABLE-INS |
ACCOUNT |
250200 |
|
ACC-QUAL |
FEEEXPENSE-STPD |
ACCOUNT |
250200 |
|
ACC-QUAL |
FEEEXPENSE-COMP |
ACCOUNT |
250200 |
|
ACC-QUAL |
CONTRIBFUND-PREM |
ACCOUNT |
780010 |
|
ACC-QUAL |
CONTRIBFUND-REC |
ACCOUNT |
780010 |
|
ACC-QUAL |
COMMISSION |
ACCOUNT |
805004 |
|
ACC-QUAL |
FEEEXPENSE-TXW |
ACCOUNT |
260000 |
|
ACC-QUAL |
BENEFITS-DEATH OF MEMBER |
ACCOUNT |
881010 |
|
ACC-QUAL |
BENEFITS-DISABILITY BENEFIT |
ACCOUNT |
881015 |
|
ACC-QUAL |
BENEFITS-PREMIUM AMOUNT |
ACCOUNT |
881040 |
|
ACC-QUAL |
BENEFITS-FINAL MATURITY |
ACCOUNT |
|
|
ACC-QUAL |
BENEFITS-PARTIAL MATURITY |
ACCOUNT |
|
|
ACC-QUAL |
BENEFITS-CANCELLATION |
ACCOUNT |
|
|
ACC-QUAL |
BENEFITS-DEATH BY ACCIDENT / UNNATURAL CAUSES |
ACCOUNT |
881010 |
|
ACC-QUAL |
BENEFITS-DEATH BY NATURAL CAUSESE |
ACCOUNT |
881010 |
|
ACC-QUAL |
BENEFITS-DISABILITY BY ACCIDENT/UNNATURAL CUASES |
ACCOUNT |
881015 |
|
ACC-QUAL |
BENEFITS-DISABILITY BY NATUAL CAUSES |
ACCOUNT |
881015 |
|
ACC-QUAL |
BENEFITS/RETRENCHMENT |
ACCOUNT |
881035 |
|
ACC-QUAL |
FEEEXPENSE/INS |
ACCOUNT |
480001 |
|
ACC-QUAL |
FEEEXPENSE/STPD |
ACCOUNT |
480001 |
|
ACC-QUAL |
FEEEXPENSE/COMP |
ACCOUNT |
480001 |
|
ACC-QUAL |
FEEEXPENSE/TXW |
ACCOUNT |
480320 |
|
ACC-QUAL |
BANKCHARGES |
ACCOUNT |
462250 |
|
ACC-QUAL |
INVESTMNTINC |
ACCOUNT |
785510 |
|
SCHEME |
CREDIT |
COST CENTRE |
416600 |
|
SCHEME |
EDUK |
COST CENTRE |
416200 |
|
SCHEME |
EDUZ |
COST CENTRE |
|
|
COUNTRY |
KENYA |
JOURNAL ID |
XK |
|
COUNTRY |
ZAMBIA |
JOURNAL ID |
XZ |
|
COUNTRY |
BOTSWANA |
JOURNAL ID |
XB |
|
COUNTRY |
KENYA |
COMPANY CODE |
2104 |
|
COUNTRY |
ZAMBIA |
COMPANY CODE |
2102 |
|
COUNTRY |
BOTSWANA |
COMPANY CODE |
1008 |
|
SCHEME |
CREDIT |
SEGMENT |
2104KNL100 |
|
SCHEME |
EDUK |
SEGMENT |
2104KNL500 |
|
SCHEME |
EDUZ |
SEGMENT |
2102ZMD003 |
Note:
Commission reversed in the Benefit Payments Process is offset. For more information refer to
Processes
Benefits (All Products)
Commission Claw Back and Refund of Future Premiums
Note:
This is not a complete list but is based only on the Products currently set up.
Also refer to
System Reports
General
SAP