link between Project and Customer

[Former Member]

Hi Experts,

I want to generate report which fields-g/l account,amount,cost center,profit center,customer,project

I am using tables FAGLFLEXA to get GL details

SKA1-GL text

KNA1-Customer text

Please correct me if i am wrong.

But i am unable to link Project with any one of the above fields.In table PROJ i can see Profit center and cost center but no value exists where with G/L account both gets populating.

Is it possible to generate report with above fields??

Please tell me tables which links Customer with Project

I seen in sdn forum where it can interlinked only through sales order.If so how can i get interlink through tables??

Thanks&Regards,

narasimha.

[Former Member]

Hi,

If you have the sales order no and item you can pass it to (VBAP) and get the wbs element (PS_PSP_PNR). You can pass this field to table (PRPS - POSID) and get the project number (PSPHI)

Hope this will help you.

BR

Anjali

[Former Member]

Hi,

you can try by linking the customer by assigning the partner determination to the project, by which can track the reporting.

Regards,