Get all data from Databasetable

[Former Member]

Hi Everyone,
i need to check all the data from table PKPS where the same PKNUM contains the same PKPOS.
Is there an opportunity to get this data via a view? Or should we write a report for showing this data?

Example:
PKNUM: 1 PKPOS 1 => Relevant
PKNUM: 1 PKPOS 1

PKNUM: 2 PKPOS 1 => not Relevant
PKNUM: 2 PKPOS 2

Thanks in Advance.

[davis_raja]

There is no need to write a report for this.

Goto T code SE16

Type PKPS and ENTER

Enter PKNUM and PKPOS in to the fields

It will display all PKNUM and PKPOS from the table

Identify the data.

[Chintu6august]

Hi,

go to SE16N, give table name PKPS and hit enter.
remove the no. of hit, if you don't have PKNUM and PKPOS.

alv list will appear, make use of FLITERS and compare the records.

thanks!!

[Former Member]

You can use select into table and  you can use:

  DELETE ADJACENT DUPLICATES FROM it_out COMPARING PKNUM PKPOS.

[Patrick_vN]

Not sure if there is a direct way to only show the records that have "doubles". Maybe export the data from PKPS (via SE16N) into excel and check for records with the same PKNUM/PKPOS combo there.