Skip to Content
avatar image
Former Member

Pegging Overview - base tables

Hi All,

I have a requirement where in i need to find the tables where data is stored for Pegging Overview :

transaction - /SAPAPO/RRP3 .

i know that there is ome thing called as live cache which helps populate data during run time.

But there has to be some place where the Purchase Requistions / Planned Orders/ Purchase Orders are saved for the function module like

/SAPAPO/OM_ORDER_GET_DATA --- one level of pegging relationship

/SAPAPO/EFPL_ORD_NET_GET --- pegging relationship across the entire strucuture

to get the data at run time.

Could any one please help out ???

Regards,

Vidya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 28, 2008 at 10:59 PM

    Hi Vidya,

    LiveCache not just helps populate data during run time but contains some tables itself for performance reasons. These are called anchor tables. As of SCM 5.0, we have 3 such tables.

    The following are those 3 table.

    /SAPAPO/ORDKEY information about orders in APO

    /SAPAPO/ORDMAP information about orders in APO for the transfer between APO and R/3

    SAPAPO/STOCKANC as of SCM 5.0: table contains stock anchors. Further details can be found in note 837744

    I guess the first 2 tables should contain the data youa are looking for.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Amar,

      I could find the first two tables but there is no data present.

      We are on SCM 4.10; could that be the reason ???

      Thanks.

      Regards,

      Vidya.

  • May 29, 2008 at 03:02 PM

    Hi Vidya,

    I guess it is not about releases (the first 2 tables were in previous version too, only the 3rd is is added to the LIveCache in release 5.0). Please refer to note 389770. There is something like updating the statistics in these tables.

    Add comment
    10|10000 characters needed characters exceeded