topic Re: Get all data from Databasetable in Application Development and Automation Discussions

Get all data from Databasetable

Former Member — Wed, 10 Feb 2016 10:11:40 GMT

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.

Re: Get all data from Databasetable

davis_raja — Wed, 10 Feb 2016 10:17:32 GMT

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.

Re: Get all data from Databasetable

Chintu6august — Wed, 10 Feb 2016 11:32:48 GMT

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!!

Re: Get all data from Databasetable

Former Member — Wed, 10 Feb 2016 11:43:42 GMT

You can use select into table and you can use:

DELETE ADJACENT DUPLICATES FROM it_out COMPARING PKNUM PKPOS.

Re: Get all data from Databasetable

Patrick_vN — Wed, 10 Feb 2016 14:11:42 GMT

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.