Need relation between coas table and customer master data.

[vidyasagarc]

HI gurus,

             I am developing a Internal order Report IN FI Module

using table COAS, I need to display the names of the numbers Assigned to  Applicant(COAS-USER0) and Telephone Number(COAS-USER1). In these there are Only Applicant Number.I didn't find any of these table fields in customer master data (KNA1) table, Where can i find these fields related to Order number (AUFNR) in COAS table.

with regards,

C VidyaSagar Yadav.

[Former Member]

HI ,

just do the following table hav relationship and refer the screen shorts,,blow..

Screen short 1

from coas -- PLANT

from kna1 -- PLANT

the you can get AUFNR from coas and AUFNR from kna1 , then you can get USER detail and Telephone details from COAS

go ahead....

[Former Member]

I don't think there is a relationship defined by SAP (USER0 is a text field that can take any value). So the relationship is likely defined by your business.

So talk to your business analyst.

Rob