project details of network ID in CN23

[Former Member]

hi guys,

i need to create a report, to extract the details for Project PRs. i need to get the network ID, and together with the project details ( project ID, description etc).

but i were unable to find where the project details located in table, which link to the network ID ( NPLNR which found in EBKN).

the transaction code of viewing the project description for a network ID is CN23.

can any one tell me the tables for the linkage? thanks

[Former Member · Accepted solution]

Hi,

I am not very cler with ur req...do u need the project details for the given network??if so then try Aufk table...

[Former Member · Accepted solution]

hi all,

i am not very sure... what i know is that, there will be a field "Network" in a PR if it is a project PR, under item --> account assignment tab. double click on the network field, it bring me to transaction code CN23 -network display screen, under assignments tab, i want to get the field for "Project def."

so i wonder what table it is used, so that i can retrieve it base on the PR network ID. thanks

[Former Member]

Hi

base tables are PROJ and PRPS

from this take WBS element number and

The linking between the tables of network orders and the Purchase related tables are

afko-pronr = prps-psphi

afvc-projn = prps-pspnr

and

aufk-pspel = prps-pspnr

ebkn-nplnr = afko-aufnr for PR link

ekkn-nplnr = afko-aufnr for PO link

mseg-nplnr = afko-aufnr for GR/GI link

Regards

Anji