{"id":87,"date":"2014-12-19T11:54:28","date_gmt":"2014-12-19T10:54:28","guid":{"rendered":"http:\/\/www.pierre-vincent.com\/memosap\/?p=87"},"modified":"2014-12-19T11:54:28","modified_gmt":"2014-12-19T10:54:28","slug":"how-to-read-order-details-from-the-livecache-with-fm-sapapoom_order_get_data","status":"publish","type":"post","link":"http:\/\/www.pierre-vincent.com\/memosap\/2014\/12\/19\/how-to-read-order-details-from-the-livecache-with-fm-sapapoom_order_get_data\/","title":{"rendered":"How to read order details from the liveCache with FM \/SAPAPO\/OM_ORDER_GET_DATA"},"content":{"rendered":"<p><del><\/del>http:\/\/scn.sap.com\/docs\/DOC-54254<\/p>\n<header>\n<h1>How to read order details from the liveCache with FM \/SAPAPO\/OM_ORDER_GET_DATA<\/h1>\n<div class=\"j-byline font-color-meta\">created by <a id=\"jive-183528913104548571795\" class=\"jiveTT-hover-user jive-username-link\" href=\"http:\/\/scn.sap.com\/people\/tiago.furlanetto\" data-externalid=\"\" data-username=\"tiago.furlanetto\" data-avatarid=\"1098\" data-userid=\"18352\" data-presence=\"null\">Tiago Furlanetto<\/a> on Apr 12, 2014 11:54 PM, last modified by <a id=\"jive-183528913104549349357\" class=\"jiveTT-hover-user jive-username-link\" href=\"http:\/\/scn.sap.com\/people\/tiago.furlanetto\" data-externalid=\"\" data-username=\"tiago.furlanetto\" data-avatarid=\"1098\" data-userid=\"18352\" data-presence=\"null\">Tiago Furlanetto<\/a> on Apr 13, 2014 1:01 AM<\/p>\n<div class=\"j-version j-rc4\">Version 3<\/div>\n<\/div>\n<div class=\"social-wrap\">\n<div class=\"social-btn linkedin\"><span class=\"IN-widget\"><span id=\"li_ui_li_gen_1418986307999_0\"><a id=\"li_ui_li_gen_1418986307999_0-link\"><\/a><span id=\"li_ui_li_gen_1418986307999_0-logo\">in<\/span><span id=\"li_ui_li_gen_1418986307999_0-title\"><span id=\"li_ui_li_gen_1418986307999_0-mark\"><\/span><span id=\"li_ui_li_gen_1418986307999_0-title-text\">Share<\/span><\/span><\/span><span id=\"li_ui_li_gen_1418986308013_1-container\" class=\"IN-right\"><span id=\"li_ui_li_gen_1418986308013_1\" class=\"IN-right\"><span id=\"li_ui_li_gen_1418986308013_1-inner\" class=\"IN-right\"><span id=\"li_ui_li_gen_1418986308013_1-content\" class=\"IN-right\">14<\/span><\/span><\/span><\/span><\/span><\/div>\n<div class=\"social-btn googleplus\">\n<div id=\"___plusone_0\"><iframe loading=\"lazy\" id=\"I0_1418986307648\" tabindex=\"0\" title=\"+1\" src=\"https:\/\/apis.google.com\/u\/0\/se\/0\/_\/+1\/fastbutton?usegapi=1&amp;size=medium&amp;origin=http%3A%2F%2Fscn.sap.com&amp;url=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-54254&amp;gsrc=3p&amp;jsh=m%3B%2F_%2Fscs%2Fapps-static%2F_%2Fjs%2Fk%3Doz.gapi.fr.0xLoJdcaDnc.O%2Fm%3D__features__%2Fam%3DAQ%2Frt%3Dj%2Fd%3D1%2Ft%3Dzcms%2Frs%3DAGLTcCPyoETQUrQM_PJkVB7N3U_4uoMmKw#_methods=onPlusOne%2C_ready%2C_close%2C_open%2C_resizeMe%2C_renderstart%2Concircled%2Cdrefresh%2Cerefresh&amp;id=I0_1418986307648&amp;parent=http%3A%2F%2Fscn.sap.com&amp;pfname=&amp;rpctoken=30107519\" name=\"I0_1418986307648\" width=\"100%\" height=\"150\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" data-gapiattached=\"true\"><\/iframe><\/div>\n<\/div>\n<div class=\"social-btn twitter\"><a class=\"twitter-share-button\" href=\"https:\/\/twitter.com\/share\" data-text=\"How to read order details from the liveCache with FM \/SAPAPO\/OM_ORD...\" data-hashtags=\"scn\" data-via=\"SAPCommNet\" data-related=\"\">Tweet<\/a><\/div>\n<div class=\"social-btn facebook\"><\/div>\n<\/div>\n<\/header>\n<section class=\"jive-content-body\">\n<div class=\"jive-rendered-content\">\n<p>Very often when analyzing issues in APO I find it useful to read order details from the liveCache.<\/p>\n<p>We can see from the order data stored in the liveCache when it was created, whether it was already transferred to ECC, what is the net processing times (in seconds) of the modes of the activities and, of course, compare all that information to the interactive screens we use all the time, be it Master Data (like PDS display) or application-specific (like Product View or a Planning Book).<\/p>\n<p>One way to do this is by executing Function Module \/SAPAPO\/OM_ORDER_GET_DATA, as described below:<\/p>\n<p><strong>1) Get the OrderID number of the order.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>At the Product View, execute ok-code GT_IO and then copy the value of the field Internal Order corresponding to the order you want to get the details on:<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431295\/1_orderid.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431295\/372-294\/1_orderid.jpg\" alt=\"1_orderid.jpg\" width=\"372\" height=\"294\" \/><\/a><\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431296\/2_orderid.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431296\/2_orderid.jpg\" alt=\"2_orderid.jpg\" width=\"495\" height=\"152\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Another way would be to open the Order View (\/SAPAPO\/RRP2) for the order, then enable the debugger with ok-code \/h and press enter twice to open the debugger. Then, copy the orderid from field GT_ORDERS[1]-ORDERID<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431312\/3_orderid.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431312\/451-251\/3_orderid.jpg\" alt=\"3_orderid.jpg\" width=\"451\" height=\"251\" \/><\/a><\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431313\/4_orderid.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431313\/4_orderid.jpg\" alt=\"4_orderid.jpg\" width=\"418\" height=\"305\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>2) Get the GUID of the Planning Version<br \/>\n(you can skip this step if you are reading order data from the Active Version \/ Planning Version 000).\u00a0\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>This can be done in transaction \/SAPAPO\/OM16. There, specify the name of the Model and the name of the Planning Version and execute. Then, copy the value of field Guid of Planning Vers.<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431314\/5_plngversionguid.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431314\/331-187\/5_plngversionguid.jpg\" alt=\"5_plngversionguid.jpg\" width=\"331\" height=\"187\" \/><\/a><\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431315\/6_guidofplanningversion.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431315\/370-155\/6_guidofplanningversion.jpg\" alt=\"6_guidofplanningversion.jpg\" width=\"370\" height=\"155\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>3) Execute in transaction SE37 the Function Module \/SAPAPO\/OM_ORDER_GET_DATA.<\/strong><\/p>\n<p>At the selection screen of the transaction, specify the Function Module and click in Test\/Execute button (F8)<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431316\/7_functionmodule.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431316\/310-106\/7_functionmodule.jpg\" alt=\"7_functionmodule.jpg\" width=\"310\" height=\"106\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>On Test Function Module screen, set the indicator Uppercase\/Lowercase<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431317\/8_uppercaselowercase.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431317\/328-107\/8_uppercaselowercase.jpg\" alt=\"8_uppercaselowercase.jpg\" width=\"328\" height=\"107\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>In the Details View of Import Parameter IS_GEN_PARAMS, specify the GUID of the Planning Version (always 000 for the Active version)<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431321\/9_is_gen_params.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431321\/368-237\/9_is_gen_params.jpg\" alt=\"9_is_gen_params.jpg\" width=\"368\" height=\"237\" \/><\/a><\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431322\/10_simversion.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431322\/381-116\/10_simversion.jpg\" alt=\"10_simversion.jpg\" width=\"381\" height=\"116\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Press Back button. Then, in the Details View of IT_ORDER, specify the OrderID<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431323\/11_it_orders.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431323\/362-238\/11_it_orders.jpg\" alt=\"11_it_orders.jpg\" width=\"362\" height=\"238\" \/><\/a><\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431324\/12_it_orders.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431324\/418-170\/12_it_orders.jpg\" alt=\"12_it_orders.jpg\" width=\"418\" height=\"170\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Press back button and then execute the Function Module. Then, click on Save button in the popup and check the results:<\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431326\/13_execute.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431326\/13_execute.jpg\" alt=\"13_execute.jpg\" width=\"393\" height=\"298\" \/><\/a><\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431327\/14_save.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431327\/14_save.jpg\" alt=\"14_save.jpg\" width=\"385\" height=\"225\" \/><\/a><\/p>\n<p><a href=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/showImage\/102-54254-3-431331\/15_results.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"http:\/\/scn.sap.com\/servlet\/JiveServlet\/downloadImage\/102-54254-3-431331\/250-400\/15_results.jpg\" alt=\"15_results.jpg\" width=\"250\" height=\"400\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>4) Analyze the data<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>You can check, for example, the date and time this order was created in APO, in export parameter ET_ORDERS, field CREATION_TIME (all dates are displayed in UTC, exactly as stored in the liveCache).<\/li>\n<li>If you are in a scenario with alternative sequences, you can see in ET_MODES, field PROC_TIME, what is the net processing time of that mode, in seconds.<\/li>\n<li>You can see the time-continuous and the bucket capacity requirement for each of the modes in ET_CAP_REQS.<\/li>\n<li>In the example above, you can see this order was not sent over to ECC yet as ET_ORDMAPS is empty.<\/li>\n<li>If there are activity relationships in the order, they will be shown in ET_INTERN_CONSTRAINTS.<\/li>\n<li>Many other informations can be checked, if required, and then compared to the values displayed in interactive transaction (like the \/SAPAPO\/RRP3 or \/SAPAPO\/SDP94).<\/li>\n<\/ul>\n<\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/scn.sap.com\/docs\/DOC-54254 How to read order details from the liveCache with FM \/SAPAPO\/OM_ORDER_GET_DATA created by Tiago Furlanetto on Apr 12, 2014 11:54 PM, last modified by Tiago Furlanetto on Apr 13, 2014 1:01 AM Version 3 inShare14 Tweet Very often when &hellip; <a href=\"http:\/\/www.pierre-vincent.com\/memosap\/2014\/12\/19\/how-to-read-order-details-from-the-livecache-with-fm-sapapoom_order_get_data\/\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-87","post","type-post","status-publish","format-standard","hentry","category-apo"],"_links":{"self":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/87","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/comments?post=87"}],"version-history":[{"count":0,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/87\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/media?parent=87"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/categories?post=87"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/tags?post=87"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}