Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

View: Duplicate Records in View with no join condition


I created a database view with 2 fields each from two table with no join condition. There are duplicate entries in the view as there is no join condition. My requirement is to remove that duplicate entries.

table A

CCode Sales Division

C1 S1 D1

C1 S1 D2

C1 S1 D3

Table B

CCode Plant Status

C1 P1 X

C1 P2 X


Sales Plant

S1 P1

S1 P2

S1 P1

S1 P2

S1 P1

S1 P2

I want to delete these duplicate records.



Not what you were looking for? View more on this topic or Ask a question