Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

filter COEP line items to get CJ74 report

albertino87
Explorer
0 Kudos

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.

2 REPLIES 2

FredericGirod
Active Contributor
0 Kudos

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

albertino87
Explorer
0 Kudos

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