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:

/wp-content/uploads/2015/11/1_840043.jpg

Double click on derivation strategy line and in edit mode create derivation step :

/wp-content/uploads/2015/11/2_840128.jpg

We can derive PSM account assignment depending on the following TRM master data:

  • Product type
  • Update type
  • Portfolio
  • Business transaction category

/wp-content/uploads/2015/11/3_840129.jpg

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.

/wp-content/uploads/2015/11/4_840145.jpg

Now let’s test new derivation step.

Return back to the list of steps and press “Test” button (F8).

/wp-content/uploads/2015/11/5_840146.jpg


Enter Treasury and Risk Management paramters at “Additional fields” tab.

/wp-content/uploads/2015/11/6_840147.jpg

Open “Organizational fields” tab. Press “Derive” button and check if “FM/GM account assignment” parameters are derived.

/wp-content/uploads/2015/11/7_840148.jpg

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.

/wp-content/uploads/2015/11/9_840130.jpg

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

/wp-content/uploads/2015/11/8_840156.jpg

We will post the first flow – borrowing.

/wp-content/uploads/2015/11/10_840157.jpg

Following the Reference Key in the Posting log we will find Fund management document.

/wp-content/uploads/2015/11/11_840161.jpg

Fund management document with the PSM account assignment defined in derivation step.

/wp-content/uploads/2015/11/12_840162.jpg

TIP: if you start derivation trace (button at the main screen of Derivation strategy definition – /wp-content/uploads/2015/11/13_840163.jpg) 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:

/wp-content/uploads/2015/11/14_840168.jpg

/wp-content/uploads/2015/11/15_840169.jpg

That’s it!

More about PSM account assignment Derivation read help.sap.com

More about TRM-PSM integration read other articles.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply