We learned from previous articles how we can manage such account assignments as Fund, Grant and Functional area inside Treasury transactions.
But Public Sector Management has other account assignment master data:
- Commitment Item
- Funds Center
- Funded Program
This master data is not represented in the Treasury module. But there is an opportunity to derive these account assignments from TRM master data into PSM.
You can find Derivation instrument following this SPRO path:
IMG -> Public Sector Management -> Funds Management Government -> Master Data -> Allocations to Account Assignments from Other Components -> Define Account Assignment Derivation (tr. FMDERIVE)
First we need to define Derivation strategy:
Double click on derivation strategy line and in edit mode create derivation step :
We can derive PSM account assignment depending on the following TRM master data:
- Product type
- Update type
- Portfolio
- Business transaction category
Also we can choose other source fields: source fields is almost identical, the difference is COST_CENTER_GRP, COST_ELEMENT_GRP, ORDER_GRP.
| ACCOUNT_NUMBER | G/L Account Number |
| ACCT_KEY | Transaction Key |
| ACCT_TYPE | Account Type |
| ASSET | Main Asset Number |
| ASSETTRTYP | Asset Transaction Type |
| BUILDING_NUMBER | Building Number |
| BUS_AREA | Business Area |
| BUS_TRANS_CAT | Business Transaction Category |
| BUSINESS_ENTITY | Business Entity Number |
| CO_AREA | Controlling Area |
| CO_BUSPROC | Business Process |
| COMMIT_ITEM | Commitment Item |
| COMPANY_CODE | Company Code |
| CONTRACT_NUMBER | Real Estate Contract Number |
| COST_CENTER | Cost Center |
| COST_CENTER_GRP | Cost Center Group |
| COST_ELEMENT | Cost Element |
| COST_ELEMENT_GRP | Cost Element Group |
| COSTOBJECT | Cost Object |
| CRM_EXPENSE_TYPE | Expense Type for Grantor |
| CRM_PAYMENT_TYPE | Payment Type for Grantor |
| DIST_FLOWTYPE | Update Type |
| DISTR_CHAN | Distribution Channel |
| DIVISION | Division |
| DOC_TYPE | Document Type |
| DOCUMENT_DATE | Document Date in Document |
| DR_CR_IND | Debit/Credit Indicator |
| EE_GROUPING_FOR_FIXED_ACCT | Employee Grouping Fixed Account Assignment FM/GM |
| FIVOR | Financial transaction |
| FLG_COMMIT_ITEM_NOT_VALID | Commitment Item for Posting date Not Valid |
| FLG_FUNCTION_NOT_VALID | Functional Area Not Valid for Key Date |
| FLG_FUND_CENTER_NOT_VALID | Funds Center for Posting Date Not Valid |
| FLG_FUND_NOT_VALID | Fund for Posting Date Not Valid |
| FLG_GRANT_NOT_VALID | Grant for Posting Date Not valid |
| FLG_INVNTRY_PSTNG | Indicates that current posting is an inventory posting |
| FLG_MEASURE_NOT_VALID | Funded Program for Posting Date Not Valid |
| FM_AREA | Financial Management Area |
| FM_SPLIT | Line is Result of Account Assignment Distribution |
| FMXDOCLN | FM Reference Line Item |
| FMXDOCNR | FM Reference Document Number |
| FMXYEAR | FM Reference Year |
| FMXZEKKN | FM Reference Sequence Account Assignment |
| FUNCTION_AREA | Functional Area |
| FUND | Fund |
| FUND_CENTER | Funds Center |
| FUND_TYP | FM Fund Type |
| GRANT_NBR | Grant |
| LEASE_NUMBER | Lease-Out Number |
| LOGSYSTEM | Logical System |
| MATERIAL_NUMBER | Material Number |
| MEASURE | Funded Program |
| MOVE_TYPE | Movement Type (Inventory Management) |
| ORDER_GRP | Order Group |
| ORDER_NUMBER | Order Number |
| ORDER_NUMBER_NP | Network Number for Account Assignment |
| ORDER_NUMBER_NV | Routing number of operations in the order |
| ORDER_NUMBER_PM | Order Number of a Maintenance Order |
| ORDER_NUMBER_SD | Sales and Distribution Document Number |
| ORDER_POSNR_NV | General counter for order |
| ORDER_POSNR_SD | Sales Document Item |
| PART_PRCTR | Partner Profit Center |
| PARTNER_FUND | Partner Fund |
| PARTNER_FUND_TYP | FM Fund Type |
| PLANT | Plant |
| PO_LINE_ITEM | Item Number of Purchasing Document |
| PO_LINE_ITEM_SES | FM Reference Line Item |
| PO_NUMBER | Purchasing Document Number |
| PO_NUMBER_SES | Entry Sheet Number |
| PO_PRED_ORG | Predecessor document organization |
| PO_SEQ_AA | Sequential Number of Account Assignment |
| PO_SEQ_AA_SES | FM Reference Sequence Account Assignment |
| PORTFOLIO | Portfolio |
| POSTING_DATE | Posting Date in the Document |
| PROCESS_INFO | Process info status (FMDERIVE) |
| PRODUCT_TYPE | Product Type |
| PROFIT_CENTER | Profit Center |
| PROG_PROFILE | Program Profile |
| PROPERTY_NUMBER | Land Number for BE |
| REF_TRANS | Reference Transaction |
| RENTAL_UNIT | Number of Rental Unit |
| RES_DOC | Document Number for Earmarked Funds |
| RES_ITEM | Earmarked Funds: Document Item |
| REVERSEDOC | Identifier for reversal document |
| SALESORG | Sales Organization |
| SERVICE_CHARGE_KEY | Service Charge Key |
| SETTLEMENT_UNIT | Settlement Unit |
| SPEC_STOCK | Special Stock Indicator |
| SUB_ASSET | Asset Subnumber |
| TR_PART_BA | Trading Partner's Business Area |
| TRANSAC | Business Transaction |
| TRANSAC_TYPE | Transaction Type |
| USER_NAME | User Name |
| USERTEMP1 | Temporary field 1 (user-defined) |
| USERTEMP2 | Temporary field 2 (user-defined) |
| USERTEMP3 | Temporary field 3 (user-defined) |
| USERTEMP4 | Temporary field 4 (user-defined) |
| VAL_AREA | Valuation Area |
| VAL_CLASS | Valuation Class |
| VAL_TYPE | Valuation Type |
| WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) |
| WBS_ELEMENT_GRP | WBS element group |
If you need you can define Conditions and Derivation step attributes.
Press "Rule values" button (F9) and in edit mode append a row of parameters. Enter parameters in source fields and parameters in target fields.
You can enter source fields' parameters as a single parameter or as a range of parameters - from ... to.
Now let's test new derivation step.
Return back to the list of steps and press "Test" button (F8).
Enter Treasury and Risk Management paramters at "Additional fields" tab.
Open "Organizational fields" tab. Press "Derive" button and check if "FM/GM account assignment" parameters are derived.
Save derivation step!
Return back to "Account assignment derivation definition" screen, open "Company code assignment" config and assign newly created Derivation strategy to Company code.
TRM-PSM Derivation is ready.
Example:
We have configured the same Derivation step, but without Portfolio source field.
We have Interest rate instrument with the following cash flow
We will post the first flow - borrowing.
Following the Reference Key in the Posting log we will find Fund management document.
Fund management document with the PSM account assignment defined in derivation step.
TIP: if you start derivation trace (button at the main screen of Derivation strategy definition - 
) then at TBB1 production run you'll get screen similar to Derivatin test step. It is very usefull during production run to see what parameters you can get from TRM.
Example of trace screens:
That's it!
More about PSM account assignment Derivation read help.sap.com
More about TRM-PSM integration read other articles.
- SAP Managed Tags:
