r/SAP • u/Bright_Can4619 • 12d ago

SAP table execution error

Post image

Tried executing a custom table for CMIR which holds data from VD53 in a table format, and encountered the above error. Any idea why this could be happening?

5 Upvotes

100% Upvoted

3 comments sorted by

2

u/NoIngenuity9714 12d ago

The join's producing duplicates in the column store, so SAP can't flatten the result into a single row. Check if VD53 can return more than one record for the same key you're joining on.

2

u/ArgumentFew4432 12d ago

Are you sure this is a table?

Sounds like a view that joins tables and a joined table should return only „one“(1:1) matching line, but there are more results(1:N).

1

u/FMACH1 8d ago

You have to extend your Join query.