cancel
Showing results for 
Search instead for 
Did you mean: 

Query / reporting: production order - sales order

Former Member
0 Kudos

Hi,

I need a query with the following fields connected:

structure CAUFVD

MATNR

GAMNG

structure AFPOD

KDAUF

structure AFVGD

MGVRG

structure KUAGV

KUNNR

In my eyes there is no possibility to connect structures =>How can I find out which tables are 'behind' the mentioned structures ???(without SE16...)

Thanks for all ideas

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

EG,

A single structure can contain fields from one or more table. It can also contain results of calculations or other ABAP processes.

Bottom line, there is not always a 1-to-1 relationship between a collection of structures and specific table fields.

Now I could give you some tables to look at, but this would be speculative on my part. I suggest you determine exactly what you want in your report, and then hand it off to a developer. Or, execute a standard SAP report.

Best Regards & Good Luck,

DB49

Answers (2)

Answers (2)

Former Member
0 Kudos

@Hallo DB49:

thank you for the backround informations:I hoped there is a 1 to 1 relation between structure and specific table.

Because of lack of time I want to find a solution without involving the development...

I will try if there is a chance to get the needed information with standard reports

@hallo Antul Katti:

I will check the tables tomorrow

kind regards

earlgrey

Former Member
0 Kudos

you can find tables AFPO and AFVG