SAP APO table wíth PO history

[former_member384222]

Hi,

in the external procurement relationship in APO we can find the PO history, eg. material document nr, etc.

The data visible here is stored in the structure

/SAPAPO/SHOW_MMHIPO_MAIN

so I tried to find out where for example is the material doc nr stored:

I tried to find the table for the material doc nr – field BELNR in two ways:

1) Via double click on the data element “/SAPAPO/MBLNR” , followed by “where used” check for table fields:

Result: Data Element /SAPAPO/MBLNR was not found in Table Fields.

2)

Via se84 / ABAP Dictionary / Fields / Table Fields: entered “BELNR” into the field name. Got 23 hits, but all the given tables do not store any data…they all are empty.

I struggle to find the table that stores the material document nr of the PO history in APO (7.3). Someone has any hints?

thank you in advance!

best regards,

Wojciech

[Former Member · Accepted solution]

Hi Wojciech,

Orders cannot be accessed from tables in APO. They are stored in LiveCache and you need to access them with function calls or a BAPI.

I wrote a post about it.

Dude, where’s my table? – The difficulties of accessing data in APO

I never got to write the way to access the orders in the following blog, but I mentioned the way in the comments. From the programming point of view, the best option is to use function /SAPAPO/OM_ORDER_GET_DATA. The drawback is that the selection options are few and you usually need to pull out of the LC a lot of orders you don't need and filter them after. That makes most mass processing slow.

What do you need to access the table for? If it is for a development, use the approach mentioned. If it is only to filter/sort and export - as a regular user - I suggest you treat the result of your report (the one you show in your first screen or transaction /SAPAPO/RRP4) as your table and sort/filter/export from it.

Regards,

Joaquin

[former_member384222 · Accepted solution]

Hi Joaquin,

thanks for responding. I am aware of the fact that orders data is stored in LiveCache but some data you can still get in apo tables. In my case are the scheduling agreement releases and related data of the process. Some data I can see for example in the table /sapapo/tsarh (tsari; tsard) or /sapapo/tpsrc, but there is no data of the goods movements like the mentioned document nr of the goods movements (GR).

I need the data for an idoc extension so the programm can access that data.

kr,

Wojciech