C_CPI Integration Suite Development Practice Question
An integration developer is configuring a Message Mapping in SAP Cloud Integration. The source XML contains a repeating element <Order> with a nested <Item> element that also repeats. The target structure requires one flat record per item, repeating the parent Order ID on each record. Which mapping construct should the developer use to produce the required target structure?
⚠ Common exam trap
The trap here is assuming the outer repeating node must be the one-to-many node, when the target granularity is actually defined by the innermost repeating element.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
A one-to-one mapping on the Order node combined with a one-to-many mapping on the Item node
Flat target records with a repeated parent identifier require the repetition to be generated from the deepest repeating node that defines the record granularity. Mapping the repeating Item node as one-to-many emits one target node per item, and keeping the Order node as one-to-one preserves access to the parent Order ID so it can be copied into each emitted record.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A user-defined function that calls the removeContexts API on the Order node
Why it's wrong here
removeContexts strips queue context and is intended for collapsing repeated contexts before an aggregation or value comparison, not for expanding nested repetitions into flat records. Using it here would eliminate the order context needed to repeat the Order ID, so the parent identifier could not be copied onto each item record.
- ✗
A one-to-many mapping on the Order node combined with a one-to-one mapping on the Item node
Why it's wrong here
One-to-many on Order would duplicate the order-level context, but pairing it with a one-to-one Item mapping keeps only a single item per generated order, so nested items beyond the first are dropped. The target needs every Item emitted while the parent Order ID is repeated, which requires the child to drive the repetition, not the parent.
- ✓
A one-to-one mapping on the Order node combined with a one-to-many mapping on the Item node
Why this is correct
The repetition must be driven from the Item node, because one flat target record is required per item. A one-to-many mapping on Item emits one target node for each source Item, while the surrounding one-to-one context of Order makes the parent Order ID available to be copied into every generated record, producing the flat output.
- ✗
A one-to-many mapping on both the Order and Item nodes
Why it's wrong here
Applying one-to-many on both levels multiplies the cardinality, so each Order context is expanded and then each Item is expanded again. This produces duplicated or cross-multiplied target records rather than exactly one flat record per source item, so the resulting structure does not match the target definition.
About these practice questions
This C_CPI question is part of Courseiva's 218-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official SAP exam blueprint
This C_CPI practice question is part of Courseiva's free SAP certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the C_CPI exam.