Source and Target Fields (SAP Library

Source and Target Fields

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 (data base structure FMDERIVE) as source and target fields. In general the fields are used as source and target fields in the following way:

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

Note

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 Data ® Assignments to Account Assignments from Other Components ® Choose Derivation Steps.

Recommendation

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

Note

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 later 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

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

Note

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.

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

Additional target fields

Number of G/L account ACCOUNT_NUMBER

Note

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.

Note

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.