Tables in APO

[Former Member]

Hi all,

I am trying to derive data(Line, source item, target item, set up time & cost etc) related to production in APO using SQVI. The table names I get using conventional methods when tried in SE17 says structure or data cannot be read directly. Can someone tell me how to get the correct table names in APO?

Thanks in advance

Mano

[Former Member · Accepted solution]

you can go in SE16 and give /SAPAPO/* and press F4 for all APO releted tables.

[Former Member · Accepted solution]

Hi,

It works. But I am not sure they are the ones I am looking for. I look to extract information from APO using SQVI. From erp tables like MARA,MARC etc I can retrive info using SQVI. Similarly I try to do with APO.

I look to retrieve informations like,

product/production resource/process time/production quantity etc. Which tables should I use in APO?

I can view recipe in ERP but one at a time, how to view consolidated information at a location?

Thanks

Mano

[Former Member · Accepted solution]

Hi Mano.

Yes you can use SQVI to create view in APO .

Below are the some imp table in APO.

/SAPAPO/ATP01

/SAPAPO/TL

/SAPAPO/LOC

/SAPAPO/MATKEY

/SAPAPO/MATLOTSZ

/SAPAPO/MATRQ

/SAPAPO/RES_HEAD

/SAPAPO/RRPCUST2

/SAPAPO/SNP01

/SAPAPO/SNP02

/SAPAPO/SNP11

/SAPAPO/V_MATLOCT: very important view created in APO for material location related info.

Best you can use table DD02t for the table you are looking for.

Manish

[Former Member · Accepted solution]

That is remarkable.

Regards

Mano