Show TOC

 Source and Target Fields Locate this document in the navigation structure

Use

When defining a derivation step, you specify source and target fields for the derivation.

You can use all fields available in the Funds Management derivation structure (database structure FMDERIVE) as source and target fields. In general, the fields are used as source and target fields as described below.

Structure

Source fields

You can use the following basic data as source fields:

Organizational units

Company code COMPANY_CODE

FM area FM_AREA

Controlling area CO_AREA

FM Account Assignment Elements

Fund FUND

This graphic is explained in the accompanying text.

If you have defined funds centers in the commitment item master records or funds in the funds center master records, the commitment item (COMMT_ITEM) and funds center (FUND_CENTER) fields are also used as source fields in the derivation steps provided by SAP (function calls). If you have made this association in your system, you must make sure that you also activate the relevant derivation steps (that is, Funds center from commitment item master record and Fund from funds center master record ) in Customizing and copy them to your derivation strategy. Otherwise, this association will not be made during derivation.

To copy the standard derivation steps provided by SAP to your derivation strategy, go to the Customizing of Funds Management Government and choose Master DataAssignments to Account Assignments from Other ComponentsChoose Derivation Steps

This graphic is explained in the accompanying text.

SAP recommends that you do not use these master data associations in master data maintenance, instead you should create them using a derivation rule. In the same way, you should use a derivation rule or an allocation to assign commitment items to a G/L account.

Cost element and Controlling objects

Cost element COST_ELEMENT

Cost center COST_CENTER

Profit center PROFIT_CENTER

Internal order ORDER_NUMBER

Work breakdown structure element (WBS element) WBS_ELEMENT

Financial Accounting basic data

Number of G/L account ACCOUNT_NUMBER

Asset general prefix ASSET

This graphic is explained in the accompanying text.

If you have defined Controlling objects (cost element, order, WBS element) in the asset master record, you can use the standard derivation steps provided by SAP (function calls) to derive a temporary CO object from which the funds center is derived in a subsequent derivation step. In this derivation step, you must define a derivation rule in which the funds center is derived from the CO object. SAP provides the following derivation steps for you to copy to your derivation strategy in Customizing:

Responsible cost center from asset master data

Internal order from asset master data

WBS element from asset master data

To copy the standard derivation steps provided by SAP to your derivation strategy, go to Customizing for Funds Management Government and choose Master DataAssignments to Account Assignments from Other ComponentsChoose Derivation Steps .

Asset subnumber SUB_ASSET

Real Estate objects

Building number BUILDING_NUMBER

Number of business entity BUSINESS_ENTITY

Property number to goods receipt PROPERTY_NUMBER

Additional fields for CO activity allocation

Debit/Credit indicator DR_CR_IND

Partner fund PARTNER_FUND

FM fund type (for partner fund) PARTNER_FUND_TYP

Valid from date POSTING_DATE

Business transaction TRANSAC

FM fund type FUND_TYP

CO reconciliation object FLG_CO_RECON

This graphic is explained in the accompanying text.

This field is only relevant if you have defined that only real CO objects should be considered for the account assignment derivation (flag Only use real CO objects ) under step Make other Settings in Customizing . In the case of cost center revenue postings with cost element type “11”, this indicator is set in the background for the CO reconciliation object in the database structure FMDERIVE. If you refer to this indicator in another derivation step you can then use the statistical cost center account assignment for account assignment derivation too.

Treasury and Risk Management Objects

Product type PRODUCT_TYPE

Portfolio PORTFOLIO

Business transaction category BUS_TRANS_CAT

Update type DIST_FLOWTYPE

Target fields

You can use the following fields as target fields for derivations:

FM account assignment elements

Commitment item COMMIT_ITEM

Funds center FUND_CENTER

Fund FUND

Function area FUNCTION_AREA

Grant GRANT

Additional target fields

Number of G/L account ACCOUNT_NUMBER

This graphic is explained in the accompanying text.

This target field is only relevant, if you use the source fields listed above for CO activity allocation. The G/L account is required as an interim step for deriving a commitment item.

Auxiliary field 1 (user-defined)

You can use this field to calculate and hold interim results for the derivation.

 ( )

If you need additional help fields for your account assignment, you can extend the database structure FMDERIVE by adding your own fields in the include CI_FMDERIVE .