Search code examples
abapmaster-data-management

Select records from SAP MDG?

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

Solution

  • 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.