Skip to Content

Derivation type “Derivation rule” works the following way: IF x THEN y.

Scenario: Depending on Product Groups different Profit Centers are assigned.

Header 1 Header 2 Header 3
Security PC80001 Securities TRM department
Loans PC80002 Loans TRM department
OTC Transactions: Money Market, FX, Derivatives PC80003 OTC TRM department
Listed Options / Futures PC80004 Option/Futures TRM department

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Additional Account Assignments -> Define Derivation of Additional Account Assignments (tr. TPM_DERIVE_ACCNT)

/wp-content/uploads/2014/10/1_558415.jpg

In general screen of derivation press “Create step”/wp-content/uploads/2014/10/9_558464.jpg button or F5.

/wp-content/uploads/2014/10/2_558452.jpg

Select “Derivation rule” step.

/wp-content/uploads/2014/10/3_558453.jpg

Enter Source field – PRODUCT_GROUP “product group”.

Target fields – PRCTR “Profit center”

For your purposes you can use other fields

The full list of Source fields:

SOURCES AA_REF Account Assignment Reference of Position Management
SOURCES ACCOUNTING_CODE Accounting Code
SOURCES ACCOUNT_GROUP Securities Account Group
SOURCES ACC_SYMBOL Account Symbol for Account Assignment Reference
SOURCES BP_RLTYP BP Role
SOURCES BUSTRANSCAT Business Transaction Category
SOURCES BUSTRANSID Identifier of the Distributor Business Transaction
SOURCES CHART_OF_ACCOUNTS Chart of Accounts
SOURCES COMPANY_CODE Company Code
SOURCES CURRENCY_CAT Currency Category
SOURCES DEAL_NUMBER Financial Transaction
SOURCES DIS_FLOWTYPE Update Type
SOURCES DOCUMENT_DATE Document Date in Document
SOURCES DOCUMENT_TYPE Document Type
SOURCES FLOW_NUMBER Number of a Distributor Flow
SOURCES FUND Fund
SOURCES GL_ACCOUNT General Ledger Account
SOURCES GRANT_NBR Grant
SOURCES IGT_STATUS IGT: Status of an Intragroup transaction
SOURCES ISSUER Issuer Identity Key
SOURCES KONTRAHENT Business Partner Number
SOURCES LOANS_CONTRACT Contract Number
SOURCES PORTFOLIO Portfolio
SOURCES POSITION_ACCOUNT Futures Account for Listed Options and Futures
SOURCES POSTING_CAT Posting Category
SOURCES POSTING_DATE Posting Date in the Document
SOURCES POSTING_KEY Posting Key
SOURCES POSTING_PERIOD Fiscal Period
SOURCES POSTING_YEAR Fiscal Year
SOURCES PRODUCT_GROUP Product Group
SOURCES PRODUCT_TYPE Product Type
SOURCES RFHAZU Transaction activity
SOURCES SECURITY_ACCOUNT Securities Account
SOURCES SECURITY_ID Security ID Number
SOURCES TRANSACTION_TYPE Financial Transaction Type
SOURCES VALUATION_AREA Valuation Area
SOURCES VALUATION_CLASS Valuation Class
SOURCES VBUND Company ID of Trading Partner

The full list of target fields is

TARGETS GSBER Business Area
TARGETS PARGB Trading Partner’s Business Area
TARGETS PPRCTR Partner Profit Center
TARGETS PRCTR Profit Center
TARGETS PSEGMENT Partner Segment for Segmental Reporting
TARGETS RMVCT Transaction Type
TARGETS SEGMENT Segment for Segmental Reporting
TARGETS VBUND Company ID of Trading Partner
TARGETS XREF3 Reference Key for Line Item

And press “Maintain Rule Values”.

/wp-content/uploads/2014/10/4_558454.jpg

Enter data from scenario table into Derivation rule.

————————————————————————————

One of the usefull things is we can use Source fields intervals – button /wp-content/uploads/2014/10/5_558465.jpg when you create Derivaton rules.

Example: Depending on Amount in Nominal Currency and Nominal Currency we assign Financial Transaction Type to newly created transaction from external systems.

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Transaction Management -> External Link -> Define Mapping for Spot Exchange and Forward Exchange Transactions (tr. FTR_XI_MAP_FXLEG)


/wp-content/uploads/2014/10/6_558466.jpg

/wp-content/uploads/2014/10/7_558477.jpg

————————————————————————————

Let’s get back to our first scenario about Profit centers. We are not using Conditions, so our derivation step will be executed always.

/wp-content/uploads/2014/10/8_558478.jpg

On “Attributes” tab we can define additional parameters: it’s up to you to use this attributes.

  • Issue error message if no value found

You can choose attribute to specify for each derivation step whether an error message should appear if no target values are found. For derivation rules, this option is automatically set as the default setting. If you do not want to maintain derivation rule values for every possible combination of source values, you should deactivate this error message display.

  • It should be possible to maintain rule values using the validity date

If you activate this attribute, you can then make derivation rule entries for rules that have a “valid from” date.

  • Step ID for Direct Call

This attribute is not required in general. It is only useful if you program, for example, a batch input for the data input transaction KEDE and want to directly access maintenance for a specific rule. To activate this attribute, right from general screen of Derivation choose “Goto -> Direct call using step ID”. You can then enter one of the available step IDs.

The derivation step is ready. Save it.

Don’t forget to Test it Derivation: Test your derivation steps.

For other Derivation topics reffer to TRM Derivation (index)

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Mahmoud Elnady

    Hi

    Thanks for your wonderful document..

    I check my system SAP ECC6.0.. i am not able to see the cost or profit center is available in target field . what could be the reason

     

    Regards

    Mahmoud El Nady/wp-content/uploads/2015/11/1_836019.png

    (0) 
        1. Grigoriy Babitskiy Post author

          Can you check SPRO path:

           

          tr. SPRO -> Financial Supply Chain Management -> Treasury and Risk Management ->Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Additional Account Assignments -> Define Derivation of Additional Account Assignments (tr. TPM_DERIVE_ACCNT)


          It is avaiable only in EHP 5: business function FIN_TRM_LR_FI_AN_3

          (0) 

Leave a Reply