Skip to Content
author's profile photo
Former Member

SAP Query: Duplicte records after joining table CSKT

Guru's,

We have created a query in SQ02 for Z table which has fields with KOKRS and KOSTL as well.

Ztable fields:

PLAN_TYPE

PLAN_PROCESS

...

...

KOKRS

KOSTL

...

...

...

We want to display cost center description. So joining this Z table with CSKT(KOKRS,KOSTL). We are getting duplicate records in output because CSKT has duplicate KOSTL.To solve this, we want fetch Latest KOSTL comparing DATBI GE SY-DATUM.

Can anybody help us how to code this logic in Query. or is it possible to edit the code in system generated program(AQL4TAS_CO=====ZPLAN)

I have gone thru most of the SDN threads but could not find the answer.

Please help us.

Thanks in Advace.

Shreyansh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 02:31 PM

    Moderator message - Cross post locked

    Add comment
    10|10000 characters needed characters exceeded