Skip to content

Imports one SAP S/4HANA Cloud entity over your S/4HANA Cloud connection into a project table. Pick the connection, the entity type, and any filters; the step pulls matching records and writes them, with no OData query to author.

This is a generic canned step — one step type covers two entities: an aggregated trial_balance cube for period-end reporting, and line-item-level journal_entry_items for detailed posted transactions.

Field Required Notes
S/4HANA Connection Yes The S/4HANA Cloud connection to read through.
Target Table Yes The project table the results are written to. It is overwritten in full on every run.
Entity Type Yes Which entity to pull. Default trial_balance. One of trial_balance, journal_entry_items.
Filters No Range and equality filters translated into the request’s OData $filter. Each entity restricts filters to the fields S/4HANA can actually evaluate server side — an unsupported field is rejected, not silently dropped.
Entity Type What it pulls OData Service Filterable fields
trial_balance Aggregated period-end GL account balances API_OPLACCTGDOCITEMCUBE_SRV CompanyCode, GLAccount, CostCenter, ProfitCenter, FiscalYear (range), FiscalPeriod (range), Ledger
journal_entry_items Posted journal entry line items API_JOURNALENTRYITEMBASIC_SRV CompanyCode, GLAccount, CostCenter, ProfitCenter, PostingDate (range), FiscalYear (range), FiscalPeriod (range), Ledger