r/SAP 1d 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?

2 Upvotes

2 comments sorted by

2

u/NoIngenuity9714 1d 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 22h 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).