CJI3 - Copy to a ZReport

[Former Member]

Hi,

Have copied the report CJI3 into a Zprogram.

Need to have some additional fields available for creating new display variant,thru change layout.

Thank you

Lalitha

Message was edited by:

Lalitha Sankaran

[mallikarjun_vaja]

hi Lalitha,

i got the same requrement reg Report CJI3??

Is ur query solved,,,if yes...plz let me know how ue query is solved.

Regards

vaja

[Former Member]

Hi Mallikarjun,

Not sure if you already found the solution.

But here is what we did - copied the std program to a custom program.

RKPEP003 --> copied to Z program

FM PS05_PROJECT_LINE_ITEM --> ZPS05_PROJECT_LINE_ITEM

FM K_LINE_ITEMS_SELECT_AND_LIST within the above FM - ZK_LINE_ITEMS_SELECT_AND_LIST

In the Subroutine - FORM select_covp (in include LZKAEPFSL (custom include))

we can add the selection for the new added fields within the LOOP AT lt_cossa.

example:

• Get Network assignment

SELECT SINGLE astna astnr werks

INTO (gs_covp_ext-p_astna , gs_covp_ext-p_astnr ,

gs_covp_ext-p_werks)

FROM proj

WHERE pspnr = gs_covp_ext-psphi.

defined the new fields in the Type Group -again a custom group ZKAEP

example

PENDE LIKE PRTE-PENDE, " WBS basic end date

ZUORD LIKE PROJ-ZUORD, " Network assignment

SMEBTR LIKE COEPR-SMEBTR, " Statistical quantity

after this to add the fields to the field catalog include LZKAEPFLI

again a custom one for LKAEPFLI

Hope this helps,

Thank you

Lalitha

[Former Member]

Hi ,

I am facing problem with CJI3 transaction... It takes more than 15 minutes to produce an output... i feel it is spending more time in call function 'PS05_PROJECT_LINE_ITEM' .. did u make any changes to ur Z program to improve the performanance

Regards,

Raj

[Former Member]

Hi Subramani,

The FM also is copied into a Z FM, but I do not see any code for improving performance, Just few more new fields are added that was required.

Hope you have found your solution by now.

Thanks and regards

Lalitha

[Former Member]

Hi Lalitha,

Yes, I found a user exit "EXIT_SAPLKAEP_001 " where in which we used to get Work Order details, had many select statements and it was running within a loop.

But the loop was running in the standard code. So now that the ouput had many line item having same work order, only the first time for every work order the select statement is executed, and the results are put into a memory and when it runs for the second time select statements are not executed but fetched the details from the memory.

I have made the code changes but didnt test it as my development server is down.. i ll update it to u if the performance is improved,

Thanks,

Kandaraj subramani

[Former Member]

Hi Lalitha,

Did you modify the standard structures PROJ, PRTE and COEPR to add new fields to CJI3 report. Even I am working on the similar requirement. Appreciate your response on this.

Thanks in Advance,

Meenu.