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)
In general screen of derivation press “Create step” button or F5.
Select “Derivation rule” step.
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”.
Enter data from scenario table into Derivation rule.
————————————————————————————
One of the usefull things is we can use Source fields intervals – button 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)
————————————————————————————
Let’s get back to our first scenario about Profit centers. We are not using Conditions, so our derivation step will be executed always.
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)
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
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: and in this article.
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
Regards
Mahmoud EL Nady
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
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
I've described all in this answer:
Try this one:
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
​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.