sap3 [HANA DB] Searching Contents of Procedure [Scenario]Newly developed addon function fasely print out document number, all document number is printed as "1".Since it takes long to get the issue fixed, the customer requested me to modify the related query. However, there is no given procedure list. The first step should be finding out related procedure in HANA DB. [Objectives]Searching HANA DB procedure which is related to the problematic .. 2026. 3. 11. [Automation] SAP Pending Approval Notification [Requirements]- A customer want to check if there is any pending approval in SAP system and receive a notification** SAP Business One has an email notification funtion but not activated in the customer environment [OS] Windows 10 [Development Language]Python / SQL [IDE]SAP HANA DB / PYCharm [Setting]- Figure out table structure in terms of approval document and create a procedure printing out pe.. 2025. 10. 7. [VBA] Extracting Data from SQL with a Button in Excel [Requirements] Business transport team asks a Excel sheet to fetch all purchase order data in ERP system - Create Excel file with VBA embedded which fetchs data - Create SQL procedure calling ERP data from SQL database [OS] Windows 10 [Development Language] VBA, SQL [IDE] SSMS(SQL Server Management Studio), Microsoft Visual Basic For Applications [Code] VBA script: GetData_from_SQLServerDatabase.. 2023. 6. 27. 이전 1 다음 반응형