Query SAP APO Tables

[Former Member]

Hi,

Can some one clarify the syntax for quering SAP APO tables in Backend Oracle Database.The doubt is about calling the table name : should it be

/sapapo/matkey or just 'matkey' or some thing else.Actually first 2 options did not work.

SELECT *

FROM /sapapo/MATKEY

Regards,

Manish

[hkmaradana · Accepted solution]

Hello,

TRy like this:

data: it_matkey type table of /sapapo/matkey with header line.

select * from /sapapo/matkey into table it_matkey.

let me know if any issues.

Regards

Cris