filter COEP line items to get CJ74 report

[albertino87]

Hi

my customer wants me to use the recreate CJ74 reports from COVP/COEP tables for backwards compatibility for the CJ74 reports. However by querying the COEP/COVP table using the OBJNR and LEDNR='00' and WRTTP=4, I get more results than the CJ74 report. I noticed that the additional line items I get (non cj74 line items) are booked against cost element 730930 or others 7* Cost elements. Is this the actual filter I require, filter out all 7* Cost elements? are there other cost elements that should be filtered out or is there a more generic filter?

Non-cj74 line items have:

BEKNZ = A,S

VRGNG=KOAL or KOAO.

while valid line items from cj74 include items with

BEKNZ = A,S,H

VRGNG=KOAO, COIN, RKL

so i don't think i can use these two fields to filter.

[FredericGirod]

did you try an SQL trace to get all the filter apply to the SELECT statement ?

[albertino87]

Hi Frederic,
unfortunately i am not a sap system admin and don't have access to many features on SAP