Basic Treasury FD And Loans Configuration Setup
July 20, 2005
*Caution: article based on SAP ver. 4.0 is and to be used as guide only.
This article presents a very basic bare-bones asset accounting setup. It assumes familiarity with SAP configuration terms and concepts. Do note also that changes in configuration have occurred with SAP’s latest solution for treasury called CFM (Corporate Finance Management).
The business scenario is a basic setup to run treasury fixed deposits given/taken in a company. It assumes familarity with basic SAP configuration concepts already. The scenario is a given company which needs to track it’s portfolio of fixed deposits placed (FD) and loans taken (LTL).
Preconditions: Setup company codes beforehand.
1. Setup product types Setup planning levels for product types per company code (maintain view [V_T036VN])
FD 10 TD TD
FD 11 TD TD
FD 12 TD TD
FD 20 TD TD
FD 21 TD TD
LTL 10 TL TL
LTL 11 TL TL
LTL 12 TL TL
LTL 20 TL TL
LTL 21 TL TL
2. Setup transaction types for each of the product types above.
3. Link flow types to transaction types
4. Assign condition types to transaction types
5. Define master agreement types (master agreements are optional).
6. Setup business partners:
Use standard treasury partner grouping TR02: Treasury partner (external) with or without link to customer master grouping. A link to a customer master is required if payments are to be effected through an open item receivable/payable, rather than directly through the bank account. 7. Remove all unnecessary role-view assignments for the role category treasury partner (1000)
8. Maintain role activities (create/change/display) for creation of business partner
9. Maintain role category field modifications for treasury partner (1000)
10. Configure global transaction variant for business partner creation [BPC1] – optional
11. Setup account assignment refs. for loan & FD accounts Program:
Maintain view [V_KONTREF5] SAPLOGH2, [TBK5]
3 + SGD ++++++++++ Bank clearing
4.1.1 + SGD 111111 Interest received (FD)
4.1.3 + SGD 222222 Interest expense (Loans)
5.3.0 + SGD 333333 Deferred interest receivable (FD)
5.3.1 + SGD 444444 Accrued interest payable (Loans)
12. Setup user exit ZTR01 to default account assignment name in assignment field of posted treasury documents. – optional
13. Setup account postings for treasury transactions [TBCY]
Treasury posting document types
(examples suggested):
TA – treasury posting
TX – reversal
BR – bank recon.
14. Setup number ranges for treasury transaction types - suggested ranges
No. From To
FD 01 0000000000001 0000002000000
Loans 02 0000002000001 0000003000000
15. Check that financial assets management set for all company codes (Maintain view [VTIPZBFI])
16. Setup document no. ranges for TR posting documents (TA, TI & TX) - setup FI doc. no. ranges for TR documents setup in 13 above.
