PS Network activities work hours in BW

[nicolas_boizar]

Hello,

I'm looking for a standard datasource to extract the working hours posted to the Network activities...

I know that the source table is AFVV and I can already extract the PP hours using the datasource 2LIS_04_P_ARBPL.

But I can't find any datasource to get the Network activity hours...

I already use the datasource 0CO_OM_NWA_2 to get the Network activity actual costs but unfortunately it doesn't help me because I also need the hours with no costs...

Does someone have an idea ?

any help would be great !

Thank you very much

[kenmelching]

What transaction(s) are you using to confirm Network Activities?

To see a list of NWA confirmations use CN48N. CATS Transfer generates confirmations.

If you are manually entering confirmations then you are correct, use AFRU. Without costs there will not be a CO document.

[nicolas_boizar]

Thanks Ken for your reply.

The CO tables give only activites with costs...

And looks like the CATS tables don't provide the activites with no costs..

In CN47N, there are Network activity actual works (with costs = 0) that I can't find in the CO tables and in the CATS tables.. The only tables that store this kind of work are AFRU and AFVV...

But the standard datasources available don't seem to provide them...

[kenmelching]

For data summarized by accounting period use table COSS. For daily postings use table COEP.

It also depends how you are entering time against the NWA. If you are using CATS you will need to access table CATSDB. That is the table that contains the actual day time was charged.

[nicolas_boizar]

any idea please ?