Skip to Content
Author's profile photo Grigoriy Babitskiy

Derivation type: Derivation rule

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)

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mahmoud Elnady
      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

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog Post Author

      Because you use tr. TPM32. But this transaction is used only for Account Assignment Reference.

       

      You have to use tr. TPM_DERIVE_ACCNT as i described here: Re: Interest Expense Different Cost Center and in this article.

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady

      Hi

      I check this T-Code .. but i does not exist in my system.. is this related to specific enhancement package . i use ECC 6.0/wp-content/uploads/2015/11/2_836111.png

       

      Regards

      Mahmoud EL Nady

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog 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

      Author's profile photo Mahmoud Elnady
      Mahmoud Elnady

      Hi

      I couldn't see in our Spro path.. we do not upgrade to EHP 5 so far.. is there any alternative way for assigning cost center ?

      Regards

      Mahmoud EL Nady

      Author's profile photo Grigoriy Babitskiy
      Grigoriy Babitskiy
      Blog Post Author

      I've described all in this answer: Re: Interest Expense Different Cost Center

       

      Try this one:

      • IMG -> Financial Supply Chain Management -> Treasury and Risk Management ->Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Enhancements in the Posting Interface (tr. SE18 -> TPM_ACCIF_TRAC, method ACCIT_KOSTL_EXIT)
      Author's profile photo Former Member
      Former Member

      HI Grigoriy Babitskiy ,

      Many thanks for the information . I have one query .

      How to Add a user defined field say Internal Reference Field in the Source Field in the above.

      So my condition would be like CoCode+AAREF+Internal Reference = Source

      & target would be say Bus Area+ Profit Center = Target .

      Req is to have Cocode + AAREF+ Plant (Internal Reference Field) wise BA+PC .

      Thanks & Best Regards,

      Swaroop Gujarathi

       

      Author's profile photo Angela Kahiga
      Angela Kahiga

      ​Dear Grigoriy

      I'm facing a similar challenge setting up the derivation rule for warehouse concept 3 and so far i'm able to derive the fund center and commitment item in the PO however budget check is not happening. I have included field FLG_INVNTRY_PSTNG = X as per SAP Note 700485 however i'm still not successful. Could you please guide on the source/target fields to use? Will most appreciate you help, thanks.

      Angela.