Automate

 View Only

  • 1.  Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Posted 12-17-2020 04:15

    ​

    ​



    ------------------------------
    perraud bruno | Appli support Ing.
    Teledyne e2v - UK | 0476583157
    ------------------------------


  • 2.  RE: Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Employee
    Posted 12-22-2020 10:12

    Hi Perraud 

    Can you please be more specific?  APO is not my specialty - perhaps share screen shots?

    In the meantime, have you looked at tables /SAPAPO/RES_HEAD and trying to guess what you're after perhaps /SAPAPO/RESDIM and search for tables /SAPAPO/TIME* .

    Also did a google search and got this article:  https://answers.sap.com/questions/8098795/apo---capacity-profile-time-capacity-for-resources.html which lists many of the tables related to capacity.

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 3.  RE: Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Posted 12-23-2020 04:10
      |   view attached

    Hi Sigrid,

    Please find attached the SAPAPO/RES01 screenshots with the data I have to extract from SAP HANA (screen nbr 3).

    In fact I need to extract these data for all of our resources. In this example the times capacity are showed for the resource 765268_3061_ZPR

    Thanks for your support

    Regards

    Bruno PERRAUD

    ​



    ------------------------------
    perraud bruno | Appli support Ing.
    Teledyne e2v - UK | 0476583157
    ------------------------------

    Attachment(s)

    docx
    SAPAPO-RES01.docx   437 KB 1 version
    Original Message


  • 4.  RE: Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Employee
    Posted 01-04-2021 13:10
    Thanks Perraud , but I'm still not sure what you're after.   Is it just the Header General data, as in your screen shot?  Details are key - and just show it for 1 resource.  The search criteria will allow for masking (LIKE operator or ranges, etc) to pull multiple resources.  

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 5.  RE: Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Posted 01-05-2021 03:20
      |   view attached
    Hi Sigrid,

    Thanks for your answer,
    In fact the goal is to extract the Capacity detail for one or several resources available (Screenshot in attachment).

    　

    In a second step, the goal could be to download and upload this kind of data

    Best Regards

    Bruno

      ​

    ------------------------------
    perraud bruno | Appli support Ing.
    Teledyne e2v - UK | 0476583157
    ------------------------------

    Attachment(s)

    pdf
    res01-detail.pdf   85 KB 1 version
    Original Message


  • 6.  RE: Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Employee
    Posted 01-05-2021 11:40
    OK Perraud - so I don't use APO, and our system is NOT setup with all of this data.  I'm assuming you are going into /SAPAPO/RES01 and then clicking capacity profile on top, right? 
    I do see data there, but I'm not familiar with the tables.  I did some google searching and found
    /SAPAPO/RES_HEAD for the resource header
    /SAPAPO/LOC for the location
    Then this post for suggestions on data that may contain your capacity data - Since we don't really have much of anything configured, I wasn't able to find the right data.  But you might.:  https://answers.sap.com/questions/8098795/apo---capacity-profile-time-capacity-for-resources.html  

    For updating, it looks you like *might* be able to click on the binoculars to find a date to update a line. 

    But there are also BAPIs, which may be easier.  A single google search may help.   Here's one: https://answers.sap.com/questions/4147966/bapi-ti-change-work-center-master-data-in-apo.html 

    Hope that gets you started.

    Best Regards,
    Sigrid


    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 7.  RE: Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Posted 01-15-2021 03:33
    Hello Mr Perraud. 
    I see you seem t have a french phone number. I'm a french solutions engineer and if necessary we can exchange in french. I will take this opportunity to explain you more on how you could use BAPIs to extract data.

    Best regards,

    David Coerchon


    ------------------------------
    David Coerchon | Senior SE
    Winshuttle North America | +33698797172
    ------------------------------

    Original Message


  • 8.  RE: Who has already tried to create a query with the /SAPAPO/RES01 transaction in SAP HANA to extract 'Capacity Profile Time Capacity' data?

    Posted 01-18-2021 04:30
    Bonjour Mr Coerchon,

    Parfait si nous pouvons communiquer sur ce sujet .. In french.
    En l'état ma principale préoccupation étant de pouvoir manipuler vi Winshuttle les données PPDS (APO) SAO HANA.
    En particulier, les données Capacity Profile pour un ensemble de ressources.

    A votre disposition

    Bien cordialement

    Bruno PERRAUD      ​

    ------------------------------
    perraud bruno | Appli support Ing.
    Teledyne e2v - UK | 0476583157
    ------------------------------

    Original Message