Use Predefined Keywords in Source Filters

You can use predefined keywords to define source filter values instead of fixed values. This makes your data mapping definitions more flexible.

You can use predefined keywords for the following source filters:

  • Fiscal Year

  • Fiscal Period

  • Consolidation Unit

  • Consolidation Group

  • Consolidation Version

  • Consolidation Chart Of Accounts

These predefined keywords are available for table-based data sources. They automatically select the appropriate values from the default values defined in:

  • The Set Global Parameters app, for data mapping jobs run manually from data mapping apps.

  • The Global Parameters values defined in the Schedule section of the job, for data mapping jobs run automatically.

  • The package context, for data mapping jobs run from packages. For more information, see Run a Job from Within a Package.

  • The API settings, for data mapping jobs run from the Group Journal Entries - Import API. For more information, see Group Journal Entries - Import API.

These keywords are specific to each data source. You use them to define source filter values for all table-based source types, as listed below:

Keywords

Explanation

Availability by Data Source Type
   

ACDOCA

ACDOCU

ECC

Datasphere

OData

[Current Period]

Uses the current month from the system date.

X

X

X

X

X

[Current Year]

Uses the current year from the system date.

X

X

X

X

X

[Default Fiscal Period]

Uses the default fiscal period.

X

X

X

X

X

[Default Fiscal Year]

Uses the default fiscal year.

X

X

X

X

X

[Previous Period]

Uses the month immediately before the current one from the system date.

X

X

X

X

X

[Previous Year]

Uses the year immediately before the current one from the system date.

X

  

X

X

X

[Fiscal Period Prior to Default]

Uses the fiscal period immediately before the default one.

X

X

X

X

X

[Fiscal Year Prior to Default]

Uses the fiscal year immediately before the default one.

X

X

X

X

X

[Default Consolidation Version]

Uses the default consolidation version.

  

X

  

X

X

[Default Consolidation CoA]

Uses the default chart of accounts.

X

X

  

X

X

[Default Consolidation Unit]

Uses the default consolidation unit.

X

X

  

X

X

[Default Consolidation Group]

Uses the default consolidation group.

  

X

  

X

X
Depending on the field, you can select a keyword from the value help dialog box or enter it manually.

  • For fields with selectable values, select the keyword directly from the dialog box.

  • For fields without selectable values, type an opening bracket ( [ ) and select the keyword from the dropdown list.