Skip to Content

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

View: Duplicate Records in View with no join condition

Hi,

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

View

Sales Plant

S1 P1

S1 P2

S1 P1

S1 P2

S1 P1

S1 P2

I want to delete these duplicate records.

Regards

Suresh

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