Select records from SAP MDG?

Question

I am new to SAP-MDG and I have added few customers using the standard SAP screens, I am interested in knowing if we can directly connect to MDG tables using Hana Studio.

Tables like MARA or KNA1, can I directly fire select queries on these tables?

select * from KNA1 fetch first 3 rows only;

something like this?

Thank you,

Divyesh Kalbhor

Sergio Prats · Accepted Answer · 2017-07-04T07:51:22.660

2

You can do this to store any three records from KNA1 into an internal table:

DATA: lt_KNA1 LIKE TABLE OF KNA1.

select * from KNA1 INTO lt_KNA1 up to 3 rows.

edited Jul 04 '17 at 07:51

answered Jul 03 '17 at 12:24

Sergio Prats

1,043
1
14
19

`OCCURS` and `WITH HEADER LINE` are deprecated statements, and shouldn't be used longer. – Suncatcher Jul 03 '17 at 18:09
So where do I fire this query? Like for DB2 we have TOAD or AQT, do we have some tool for MDG tables? – Divyesh Kalbhor Jul 04 '17 at 06:03
@Suncatcher, true, that comes from my time as ABAP programmer, changed. – Sergio Prats Jul 04 '17 at 07:52
2

@DivyeshKalbhor, you can run this query in any ABAP-program, but also you can run queries in native SQL [like this](http://www.sap-perf.ca/execute-sql-statement-directly-in-sap/). – Suncatcher Jul 04 '17 at 19:20
@Suncatcher : Did that! It worked. Thank you for your help. – Divyesh Kalbhor Jul 05 '17 at 04:03

Select records from SAP MDG?

1 Answers1