SAP ECC Source Filter Fields

Some ECC source filter fields are mandatory, others are optional, and some optional fields have default values.

You can also define optional filters.

Mandatory Source Filter Fields

It's mandatory to define values for the following filters:

  • LEDGER:

    The ledger field allows you to determine the source table containing the data you want to import. You must use a two-digit value.

  • FISCALYEAR

  • COMPANYCODE

    If the BAPI and its corresponding destination you use are configured accordingly, you can select more than one company code. For more information, see Create Destination for SAP ECC as Source.

  • PERIOD_AGG

    This field allows you to manage periods. If you select Aggregated, a total for all periods selected is produced. By default, Not Aggregated is selected.

    To map and import multiple periods, select Not Aggregated and define the input and output periods in your mapping file.

    Example for multi-period data mapping:

    The Excel data mapping file contains a 1:1 period mapping for periods 1 through 6.
     

    I

    O

    Level

    PERIOD

    FiscalPeriod

    Alias

    		    

    0

    001

    "001"

    0

    002

    "002"

    0

    003

    "003"

    0

    004

    "004"

    0

    005

    "005"

    0

    006

    "006"
    The data mapping definition does not aggregate periods and does not contain any period source filters.

    Field

    Operator

    Value

    LEDGER

    Include: Equal to

    0L

    FISCALYEAR

    Include: Equal to

    2005

    COMPANYCODE

    Include: Equal to

    1000

    PERIOD_AGG

    Include: Equal to

    		  

Optional Source Filter Fields

The following behavior applies to the optional filter field VERSION:

  • If you don't add a filter for field VERSION, only data for version 1 (actual data) is read by default.

  • If you add a filter for field VERSION and enter a version value, data is read for this version only.

  • If you add a filter for field VERSION and leave it blank, data is read for all versions.

The following behavior applies to the optional filter field RECORDTYPE:

  • If you don't add a filter for field RECORDTYPE, only data for record type 0 is read by default.

  • If you add a filter for field RECORDTYPE and enter a record type value, data is read for this record type only.

  • If you add a filter for field RECORDTYPE and leave it blank, data is read for all record types.

The following behavior applies to the optional filter fields listed below:

  • If you don't add a filter for the field, data is read for all values.

  • If you add a filter for the field and enter a field value, data is read for this value only.

  • If you add a filter for the field and leave it blank, data is read for all values.

Name

Description

BUS_AREA

Business Area

CO_AREA

Controlling Area

COMPANY

Company

COSTCENTER

Cost Center

CURRENCY

Currency Key

FUNC_AREA

Functional Area

FUNC_AREA_LONG

Functional Area

GL_ACCOUNT

Account Number

GRANT_NBR

Grant

PER

Fiscal Period

PROFIT_CTR

Profit Center