how to read fields of structures

[mark_fryu]

Hi everyone,

inside a custom report, I need to read some fields that are present in these structures:

AFVGD

AFRUD

CAUFVD

VIQMFE

RIWO00

VIQMUR

since they are structures, I can't do a Select, are there tables that I can use that are connected to these structures? Or are there Function Modules?

Thank you!

[Sandra_Rossi]

I guess you are talking about screen fields which reference components of the structures you have listed. These screen fields are initialized from tables. Now the question is to know from which screen these fields were taken, and you'll need to display that screen and use a SQL trace to know from which tables they come.

[Nilesh_Bhasare · Accepted solution]

Hello @mark_fryu ,

As per my understanding, your question is related to tables for Prod./ Process Orders along with Operations and Quality Notifications.

Go to Tcode SE16N to get following tables:

So, you can use Table CAUFV for Prod. Orders / Process Orders

AFVC for Order Operations (Pass AUFPL from CAUFV table into AFVC to get operations details)

AFRU for Prod. Order Confirmation Details

QMEL - Main Table for Notifications

QMFE for Quality Notification Items 

QMUR for Quality Notification - Causes 

Your Response is appreciated.

MAN (Manufacturing) 

[Daphne_Mengwein]

Hello @mark_fryu , it looks like you got some help. If your question was answered, please accept. Thank you and have a great day!