How to find order no. from project no.

[Former Member]

Hi,

We are trying to create a custom report like CN47N. Now I want to find out order no. for any project no. entered. Can you suggest what tables to use to find order nos for any project?

[Former Member · Accepted solution]

Hi ,

U can use table VBAK for header item & VBAP for sales document items with account assignment of WBS.

Rgds

Edited by: Shrikrishna Rasam on Oct 3, 2008 7:38 AM

[Former Member]

Hi,

There is no sales order number in CN47N. It's network number , or Production order number.

Murali

[virendra_pal]

I assume that you are searching for order number meaning networks for any any WBS

from Table AUFK, for AUTYP = 20

get AUFNR

where PSPEL = WBS Number

[Former Member]

Actually I'm trying to find the table-field for the sales order no. So if you look in the CN47N report, the first column is for sales order no. and thats the one I'm trying to find out. I'm thinking it might be the VBUK table but don't know how to find the sales order nos. related to the project no. Any suggestions?