Import Actuals (posted line items) from SAP to EcoSys as transactions.
SAP Actuals are imported incrementally for each project based on the last runtime of the job. The last runtime value is stored on the EcoSys project in the field SAP Actuals Last Runtime. See the Maintaining Actuals and Commitments section for details.
There are no updates of Actuals transactions – only new records are imported based
on the last runtime logic described above.
By default, only Actuals at the WBS level are imported. Set the IncludeAdditionalStructures parameter to True in order to import Actuals at the Network, Activity or Orders level.
Purchase Orders are also imported as part of the Actuals import. A Purchase Order record will be created in EcoSys where the Purchasing Document Number (COVP-EBELN) is assigned.
For more information, see WBS to CBS Data Mapping to know how the EcoSys mapping
rules impacts the Commitments import.
Job Details:
-
Connect Job Name: SAP Actuals Import
-
Connect Job Action: ITG SAPC Actuals Import
Job Parameters:
The parameters are specified in the EcoSys Connect Settings Maintenance screen under the "Default" SAP Import Group:
|
Parameter |
Default Value |
Description |
|---|---|---|
|
CostElementCategoryRangeStart |
Cost Element range starts. |
|
|
CostElementCategoryRangeEnd |
Cost Element range ends. |
|
|
CostElementRangeStart |
Cost Element Category range starts. |
|
|
CostElementRangeEnd |
Cost Element Category range ends. |
|
|
CostElementGroup |
Cost Element Group |
|
|
CostElementRangeMatch |
Cost Element range matches (either INCLUDE or EXCLUDE), which determines the behavior for cost elements in the specified range. |
|
|
IncludeAdditionalStructures |
False |
If true, lookup up Actuals for WBS, Networks, Activities and Orders. If false, then only WBS. |
|
SAPLedgerNumber |
SAP ledger number, usually 00 for Actuals. This needs to be provided for performance gain as this field is part of database index. |
|
|
IsUseControllingAreaForLineItemFilter |
False |
If true, uses Controlling Area from SAP Project as filter |
|
SAPVersion |
The VERSION value in SAP filters (the default is to include all). |
|
|
IgnoreCOBusinessTransactions |
List of CO Business Transactions (ORGVG) to ignore during import of actuals |
|
|
IgnoreDebitCreditIndicator |
Ignores debit credit indicator (BEKNZ): a value to ignore for filtering out settlement records. |
Deprecated Parameters from SAP Adapter
|
Job Parameter |
Description |
|
version |
Now specified in the EcoSys import spreadsheet API |
|
startDate |
Use project level SAP Actuals Last Runtime instead |
|
endDate |
Use project level Actuals End Timestamp instead |
|
costObjectExternalIds |
Use SAP Import or SAP Import Group instead |
|
costObjectCategories |
Use SAP Import or SAP Import Group instead |