on 05-05-2011 3:21 PM
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
Moderator message - Cross post locked
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.