How To...Use SQL-Script for Planning Functions in PAK Applicable Releases: SAP NetWeaver BW 7.30, SP10; BW 7.31, SP 9; BW 7.40 SP5 and higher SAP HANA 1.0 Topic Area: Business Information Management Version 1.4 September 2015© Copyright 2015 SAP AG. All rights reserved, ‘No part ofthis publication may be reproduced or ‘transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft, Windows, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation. IBM, DB2, DB2 Universal Database, 08/2, Parallel Sysplex, MVS/ESA, AIX, 8/390, AS/400, 08/300, 08/400, iSeries, Series, xSeries, Series, 2/08, AFP, Intelligent Miner, WebSphere, Netfinity, Tivoli, nformix, 15/08, POWER, POWERS, OpenPower and PowerPC are ‘trademarks or registered trademarks of IBM Corporation. Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries. Oracle is a registered trademark of Oracle Corporation. UNIX, X/Open, OSF/, and Motif are registered trademarks ofthe Open Group. Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MuitiWin are trademarks or registered trademarks of Citrix Systems, Inc. HTML, XML, XHTML and WC are trademarks or registered trademarks of WgC®, World Wide Web Consortium, Massachusetts Institute of Technology. Java isa repistered trademark of Sun Microsystems, Ine. JavaScript is a registered trademark of Sun Microsystems, Inc, used under license for technology invented and implemented by Netscape. ‘MaxDB is trademark of MySQL AB, Sweden. SAP, B/3, mySAP, mySAP.com, xApps,xApp, SAP ‘NetWeaver, and other SAP products and services ‘mentioned herein as wel as their respective logos are ‘trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the ‘trademarks oftheir respective companies. Data contained in this document serves informational purposes only ‘ational product specifications may vary. ‘These materials are subject to change without notice. ‘These materials ae provided by SAP AG ands affliated companies (‘SAP Group") for informational purposes only, ‘without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect tothe materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, ifany. Nothing herein should be construed as constituting an additional warranty. These materials are provided “as is” without a warranty of any kind, ether express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP shall not be liable for damages of any kind including ‘without limitation direct, special, indirect, or consequential damages that may result from the use ofthese materials SAP does not warrant the accuracy or completeness of the information text, graphics, links or other items contained ‘within these materials. SAP has no control over the information that you may access through the use of hot Tinks contained in these materials and does not endorse ‘your use of third party web pages nor provide any warranty ‘whatsoever relating to third party web pages. SAP NetWeaver “How-to” Guides are intended to simplify ‘the product implementation. While specifi product features and procedures typically are explained in a practical business context, it is not implied that those features and procedures are the only approach in solving a specific business problem using SAP NetWeaver. Should you wish to receive additional information, clarification or support, please refer to SAP Consulting. Any software coding and/or code lines / strings (“Cade”) included in this documentation are only examples and are not intended tobe used ina productive system environment. The Code is only intended better explain and visualize the syntax and phrasing rules of certain coding SAP does not warrant the correctness and completeness of ‘the Code given herein, and SAP shall not be liable for errors or damages caused by the usage ofthe Code, except if'such damages were caused by SAP intentionally or grossly negligent. Disclaimer Some components ofthis product are based on Java™. Any code change in these components may cause unpredictable and severe malfunctions and is therefore expressively prohibited, ais any decompilation of these components. Any Java™ Source Code delivered with this product is only tobe used by SAP's Support Services and may not be modified or altered in any way. THE BEST-RUN BUSINESSES RUN SAP“ ISAPADocument History Document Version Description 4.00 First official release of this guide 4.40 Remark regarding message table added (chapter 3.9) 1.20 New note mentioned necessary for displaying messages (chapter 9.9) 1.30 Note added regarding side-effect free SQL-Script (chapter 3.2) 1.40 ‘Small corrections in chapter SQL-Script Debugging (chapter 3.8)