Skip to content
FAST SAP SOLUTIONS®Discuss a project

START HERE · NO PRIOR TOPIC KNOWLEDGE NEEDED

What it is. Why it matters.

A CDS association describes a relationship between data objects. Cardinality states the expected number of related records; it does not remove duplicates from an incorrect relationship.

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.

ABAP is SAP’s programming language for business applications. A program reads data, applies rules and produces a result. Start with the objects involved before investigating code.

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 CDS association duplicates rows? Check the real relationship and cardinality
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.

ABAP CDS associations and cardinality in supported view types; source/target wording and optimizer capabilities depend on backend release.

Primary documentation reviewed on 14 November 2026 using official indexed excerpts. Documentation review only; authored examples were not compiled or executed in an SAP system.

A MANUFACTURING EXAMPLE

Explain duplicated component-report rows

Count the related matches

Source order: 1001. Matching items: 3. Joined result: Can contain 3 rows. Expected total: Must respect row meaning
What to notice: Declaring a relationship does not remove extra matches or repair an incorrectly modeled total.Original annotated example with illustrative values. This is not an SAP screen or a result from a customer system.
Read the example values
Source order
1001
Matching items
3
Joined result
Can contain 3 rows
Expected total
Must respect row meaning
Words you’ll meet in this guide
Program
A set of instructions executed by a computer.
Class
A reusable unit that groups data with operations called methods.
Database
Organized information kept beyond one program execution.
Internal table
A list of rows held temporarily in an ABAP program’s memory.
Key
One or more fields used to identify or find a record.
ABAP
SAP’s programming language for business applications.
CDS
Core Data Services: reusable definitions of business data and relationships.
API
A defined interface through which programs exchange data or request actions.
SQL
A language used to read and work with database data.
Preview the practical steps

SEE THE CONNECTION

See it in a simple example.

A small example to make the idea concrete.

Source row → Related matches → Result row count. Conceptual diagram for CDS association duplicates rows? Check the real relationship and cardinality.
Apply the idea: A manufacturer's component report unexpectedly multiplies rows when related language texts or other non-unique details are included.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 duplicated component-report rows

    A manufacturer's component report unexpectedly multiplies rows when related language texts or other non-unique details are included.

  2. Count actual target matches before changing cardinality

    When adding an association target field increases a CDS result's row count, inspect how many target rows match each source under the actual ON condition.

  3. Scope and prerequisites

    This guide covers ABAP CDS association/cardinality concepts and path-field consumption.

  4. Association definition and consumption are separate observations

    An association describes a relationship that can be exposed for consumers to navigate.

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.