ICT59 [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. [SQL] Basics of SQL Cursor [Learning Subject]Basics of SQL Cursor [Objectives]- Understadning concepts of SQL cursor- Learning grammar and commands related to SQLcursor- Being able to manipluate SQL cursor [Core knowledge]SQL cursor is similar to C pointer, indicating memory for data processing.Generally SQL restrives data from a query all at once but SQL cursor can visit each record and manipulate data. Key concepts of S.. 2025. 4. 15. [SQL] Creating a Test Head Blocker [Scenario]A mission given to me killing SQL head blocker automatically by running the process every hour.However, SQL head blocker randomly appears thus hard to test. Test head blocker needs to be created. [Objectives]Creating a test head blocker [Steps]- Go and run SSMS(SQL Server Management Studio) - Create four tabs and run below queries-- 세션 A는 트랜잭션을 시작한 후 커밋하지 않음use YTC_OPERATIONBEGIN TRAN;.. 2025. 4. 8. [D365] Setting up PCF Environment This will guide you how to set up PCF(Power app Component Framework) environment. [Prerequisite]Two applications are required for PCF environement set up1. Visual Studio Code with Power Platform Tools as extension2. Microsoft Power Platform CLIhttps://aka.ms/PowerAppsCLI 1. Run command prompt > create a folder in the c: drive 2. Move to the folder just created then run below command as to crea.. 2025. 1. 22. 이전 1 2 3 4 ··· 15 다음 반응형
