Skip to content
FAST SAP SOLUTIONS®Discuss a project

START HERE · NO PRIOR TOPIC KNOWLEDGE NEEDED

What it is. Why it matters.

Federation reads data where it already lives; replication copies it to another location. SAP Datasphere supports such approaches so designers can balance freshness, availability and processing needs.

Completely new to SAP?

Manufacturers use SAP to connect work such as buying components, recording inventory, planning production, shipping equipment and accounting for costs. SAP S/4HANA is an enterprise resource planning system: it connects these activities through shared business data.

SAP HANA is a database platform. Data models describe how records relate; queries ask for results. Start with the intended result before looking at storage or performance.

A transaction code, or t-code, is a shortcut to a task in classic SAP GUI. Fiori apps provide another way to work. Names and screens depend on the product and release; you do not need a live system to learn the concepts in this guide.

Original editorial vector illustration for SAP Datasphere federation versus replication: Choose where the query runs
Original FSS editorial vector illustration. Conceptual artwork, not an SAP interface or customer-system evidence.
Scope and source-review notes

Scope and evidence

Source review by FAST SAP SOLUTIONS® editorial. This badge describes our editorial review; it does not represent SAP certification or independent endorsement.

SAP Datasphere remote-table federation and replication concepts. Real-time support depends on connection type, source object and change-capture prerequisites.

Documentation review on 14 November 2026 using official SAP sources and indexed official excerpts where full Help text was unavailable. Scope and service or release differences are explained in the lesson. All datasets, requests and checks are illustrative; no customer SAP runtime execution or measured results are claimed.

A MANUFACTURING EXAMPLE

Explain two plant-reporting totals at different times

Where is the data being read?

Federated query: Reads the remote source. Replicated dataset: Reads a local copy. Latest source change: After last copy. Freshness check: Connection and refresh time
What to notice: A copied dataset can lag behind a live source even when both reports are operating correctly.Original annotated example with illustrative values. This is not an SAP screen or a result from a customer system.
Read the example values
Federated query
Reads the remote source
Replicated dataset
Reads a local copy
Latest source change
After last copy
Freshness check
Connection and refresh time
Words you’ll meet in this guide
Query
A request to retrieve or calculate data.
Table
Data organized into rows and columns.
Persistence
Keeping data in storage so it survives beyond memory.
CDS
Core Data Services: reusable definitions of business data and relationships.
HANA
SAP’s database platform.
Preview the practical steps

SEE THE CONNECTION

See it in a simple example.

A small example to make the idea concrete.

Source records → Live query or copy → Reporting dataset. Conceptual diagram for SAP Datasphere federation versus replication: Choose where the query runs.
Apply the idea: A manufacturer compares a federated result with replicated operational data refreshed earlier.An illustrative example, not a live SAP screen. The connections show how to think about the topic; they are not instructions to change a system.
  1. Explain two plant-reporting totals at different times

    A manufacturer compares a federated result with replicated operational data refreshed earlier.

  2. Choose the data path from freshness and workload requirements

    Federation reads a remote source through the supported connection when the query needs its data.

  3. Understand what the consumer actually reads

    In remote access, Datasphere reads through the virtual table and its adapter to the source.

  4. Worked case: two correct totals at different freshness points

    Imagine a source sales fixture with order A=100 EUR and B=50 EUR at 10:00.

Reading map · FSS editorial. The sections below explain each part in detail.

Found this useful?

Share this guide with your network, or leave a like.

LinkedIn WhatsApp

Your like is saved in this browser.

Explore Knowledge Hub

Discuss Your SAP Project

Your enquiry is sent through this website and used only to respond to your request.