Showing results for 
Search instead for 
Did you mean: 

Need relation between coas table and customer master data.

0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

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.