Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
5,559

This is the first part is available here


Assign Update Types for Valuation

FSCM-TRM-TM-General Settings-Accounting-Key Date Valuation-Update Types-Assign Update Types for Valuation



Derived Business Transactions Update Types and Usages

FSCM-TRM-TM-General Settings-Accounting-Derived Business Transactions-Update Types-Define Update Types and Assign Usages



Assigned Update Types for Derived Business Transactions

FSCM-TRM-TM-General Settings-Accounting-Derived Business Transactions-Assigned Update Types for Derived Business Transactions



Define Account Assignment References

FSCM-TRM-TM-General Settings-Accounting-Link to Other Accounting Components-Define Account Assignment References

Because we have a difference in accounting treatment for the price gains between our 2 security classifications, we need 2 account assignment references.



Define Account Assignment Reference Determination

FSCM-TRM-TM-General Settings-Accounting-Link to Other Accounting Components-Define Account Assignment Reference Determination (Securities/Listed Derivatives)



Indicate Update Types as Relevant to Posting

FSCM-TRM-TM-General Settings-Accounting-Link to Other Accounting Components-Indicate Update Types as Relevant to Posting

All of the update types created should be made relevant to posting except for DBN_E001 and DBN_E002 which TRM uses internally when calculating gains and losses.


Define Account Determination

FSCM-TRM-TM-General Settings-Accounting-Link to Other Accounting Components-Define Account Determination


Account Symbols

Business DefinitionNumberSAP Definition
Equity Investment1Position
Cash3Bank Clearing
Dividend Income4.1.4Dividend Income
Unrealized FX Gain4.9.4.2Increase FX
Unrealized FX Loss4.9.3.2Decrease FX
Realized FX Gain4.9.2.1Realized Gain FX
Realized FX Loss4.9.1.1Realized Loss FX
Unrealized Price Gain4.9.4.4Increase Titel
Unrealized Price Loss4.9.3.4Decrease Titel
Realized Price Gain4.9.2.2Realized Gain Titel
Realized Price Loss4.9.1.2Realized Loss Titel
Technical Clearing9.1.3Technical Clearing
OCI – Unrealized Price Gain6.1.2.1Valuation Titel (positive)
OCI – Unrealized Price Loss6.1.2.2Valuation Titel (negative)
Commission Fee4.2.2Provision/Fee


Posting Specifications


Posting SpecDescriptionDebit SymbolCredit Symbol
11100Share Purchase13
11200Share Sale31
11300Position to Tech Clearing19.1.3
11400Tech Clearing to Position9.1.31
11500Tech Clearing to Bank Clearing9.1.33
11600Bank Clearing to Tech Clearing39.1.3
12100Realized Price Gain14.9.2.2
12200Realized Price Loss4.9.1.21
12230Price loss from unrealized to realized4.9.1.24.9.3.4
12300Realized FX Gain14.9.2.1
12400Realized FX Loss4.9.1.11
13200Dividend Received34.1.4
13500Tech Clearing to Dividend Income9.1.34.1.4
14300Fee Payment4.2.23
15100Price Gain (P/L)14.9.4.4
15200Reset Price Gain (P/L)4.9.4.41
15230Price gain from unrealized to realized4.9.4.44.9.2.2
15300Balance Sheet Revaluation (gain)14.9.4.2
15400Reset FX Gain4.9.4.21
15430Move FX gain from unrealized to realized4.9.4.24.9.2.1
15500Price Loss (P/L)4.9.3.41
15600Reset Price Loss (P/L)14.9.3.4
15700Balance Sheet Revaluation (loss)4.9.3.21
15730Move FX loss from unrealized to realized4.9.1.14.9.3.2
15800Reset FX Loss14.9.3.2
22310Move Realized Security Gain from OCI to P/L6.1.2.14.9.2.2
33610Move Realized Security Loss from P/L to OCI4.9.1.26.1.2.2
23100Price Gain (OCI)16.1.2.1
23150Reset Price Gain (OCI)6.1.2.11
23200Price Loss (OCI)6.1.2.21
23250Reset Price Loss (OCI)16.1.2.2


Assignment of Update Types to Posting Specs


Update TypePosting Specification
SE111011100
SE221011200
SE330311100
SE331314300
SAM511313200
SAM811413500
SAM811511300
RHT000311300
RHT000411400
RHT000511600
RHT000611500
CA0001No Posting Spec Required
CA0002No Posting Spec Required
CA0003No Posting Spec Required
DBN_B00112100
DBN_B00212100
DBN_B00312200
DBN_B00412200
DBN_B00512300
DBN_B00612300
DBN_B00712400
DBN_B00812400
DBN_E001Not relevant to posting
DBN_E002Not relevant to posting
DBN_E00315230
DBN_E00412230
DBN_E00515430
DBN_E00615730
DBNOE00322310
DBNOE00422610
NV20015100
NV20115500
NV20215300
NV20315700
NV25015200
NV25115600
NV25215400
NV25315800
NV200OCI23100
NV201OCI23200
NV250OCI23150
NV251OCI23250


Assignment of GL account to Account Symbol


NumberAARGL Account
1STOUSGHFT11310100
3STOUSGHFT+++++++++5
4.2.2STOUSGHFT73410200
4.1.4STOUSGHFT73410100
4.9.1.1STOUSGHFT73310603
4.9.2.1STOUSGHFT73310603
4.9.1.2STOUSGHFT73210201
4.9.2.2STOUSGHFT73210201
4.9.3.2STOUSGHFT73310503
4.9.4.2STOUSGHFT73310503
4.9.3.4STOUSGHFT73210101
4.9.4.4STOUSGHFT73210101
9.1.3STOUSGHFT11119905
1STOUSGAFS11310100
3STOUSGAFS+++++++++5
4.2.2STOUSGAFS73410200
4.1.4STOUSGAFS73410100
4.9.1.1STOUSGAFS73310603
4.9.2.1STOUSGAFS73310603
4.9.1.2STOUSGAFS73210201
4.9.2.2STOUSGAFS73210201
4.9.3.2STOUSGAFS73310503
4.9.4.2STOUSGAFS73310503
9.1.3STOUSGAFS11119905
6.1.2.1STOUSGAFS32320100
6.1.2.2STOUSGAFS32320100

Trying it out

For our demonstration, we will use IBM as the issuer and Bank of Montreal as our counterparty and depository bank. Use transaction code BP to enable them in these roles with your company code. The next step is to create a security account. Use transaction TRS_SEC_ACC to create the account.


We also need to create the security we will be trading using FWZZ


At this point, we are ready to enter our first transaction in FTR_CREATE. In the initial screen, we have to specify our company code (1001), transaction type (100-purchase), our counterparty (BMO) and the ID number (IBM_CS).

It is possible to add the commission (expensed or capitalized) directly in the deal by using the “other flows” tab. After saving the deal, we have to settle it in FTR_EDIT as the processing category we selected requires settlement. Once the deal is settled, use TBB1 to post the purchase transaction. Let’s add a manual fee with FWBS.


To be able to fair value our position at month end, we need a closing price. You can use FW17 to enter a price for the security class. Remember that our valuation step requires a closing price. Because we did not configure reset flows for valuation, we need to use the “Mid-Year Valuation with Reset” option in TPM1. Next, let’s pretend IBM declares a dividend of 25 cents per share. We first need to enter a dividend condition on the security class using FWZZ.


Let’s also pretend that we participate in IBM’s DRIP but that they don’t support fractional share ownership. In order to capitalize the dividend, we have to use FWZE and enter the amount and number of shares to capitalize.


Whatever amount is left (3$ in our example) will be expected in the bank sub account. The next business process we will cover is Corporate Actions. Let’s assume IBM announces a 2 for 1 split effective Feb 12th. We must first enter the action using FWK0. We must also activate the action before we can post.


To make the split effective in the sub-ledger, we must post it with FWKB. If you look at our position in TPM12 after posting, the number of units has doubled but the purchase value has not changed.


To finalize this example, let’s sell all of our shares for a big profit. Once the deal is settled and posted with TBB1, we end up with the following entries in the posting journal (TPM20)


Thanks for reading. I hope you have enjoyed this post and that you learned a thing or two in the process.

8 Comments
Labels in this area