Skip to Content
1
Sep 15, 2020 at 06:29 AM

Query data from SAP; no access to Dictionary Tcodes

57 Views

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.