Trying to find the Network Activity number from the CATSPS table

[Former Member]

Hi Experts

I am trying to build a report to show unprocessed time on Network Activities. The time is entered via CAT2 and transferred to CATSPS via the CATA job.

Once the data hits the table, an internal system number is given to activity.

I have the following example:

Say I have three Network Activities all linked to the same Network and WBS as follows:

Network Activity #

43000121 0001

43000121 0002

43000121 MTS

When I post time against the 2nd and 3rd NWAu2019s, CATSPS has the following entries:

RNPLNR RAUFPL RAPLZL

000043000121 0000000182 00000002

000043000121 0000000182 00000003

Now the RAPLZL field has no visual link to the NWA.

Does anyone know of the Internal table that holds the link between the RAPLZL field and the Activity that is represents.

I have already looked at PLPO (no entries).

Any other suggestions would be appreciated.

Thank you in advance

[former_member203108 · Accepted solution]

Match the entries RAUFPL, RAPLZL of CATSPS with AUFPL, APLZL of AFVC table, you will get the activity number(VORNR)

[Former Member · Accepted solution]

Thank you Mohammed - sorted my issue