Hello everyone,
Is there any way to see the way a Structure retrieves data? I do not have access to Tcode se11 or sqvi.
What I want to do is query information from an SAP replicated database with SQL queries.
What I can use Tcodes: se16; se16n and table dd08l to view tables and fields relationships between them.
For example: I want to know how tcode MD04 displays the correct SchLn quantities.
I take the Purch orders(field EBELN) & Item(field EBELP) from EKPO table and input them in EKET, now I filter as follows:
EKPO field LOEKZ != 'L'--DELETION INDICATOR
EKPO field BSTYP = 'L' -- purch doc category = L - scheduling agreement
EKET field WEMNG = 0 --QTY DELIVERED
I managed to find the for SchLn from MD04 this way but the filtering is not enough. Because the info in Tcode MD04 is displayed as a Structure, i cannot find the correct way to show up all the values for SchLn (Schedule Line) column.
I hope someone can help me with a method to find the relationships between tables used in a structure.