SAP ABAP SQL -Upper function

access_time 2025-12-30T11:35:42.122Z face LearnABAP.IO
SAP ABAP SQL -Upper function Using UPPER in SQL Requirement I need to fetch MATNR based on CCNGN 🔲 In the above data set we need to fetch MATNR 2 with CCNGN b.2.Ba , b.2.BA , B.2.Ba , b.2.bA ,B.2.aA,B.2.BA orb.2.ba below is the code for that DATA(lv_ccngn) = 'B.2.BA'. TRANSLATE lv_ccngn TO UPPER C...

SQL -Max function

access_time 2025-12-21T14:47:27.862Z face LearnABAP.IO
SQL -Max function Lets understand MAX function in SQL SQL requirement Open VBEP table which contains schedule line details for each sales order Now check which ETENR has value more than 1 or 2 or 3 . its your choice The expected result is SELECT vbeln , MAX( etenr ) AS maxetenr FROM vbep INTO TABLE...

AMDP example

access_time 2025-09-28T07:38:27.001Z face LearnABAP.IO
SAP AMDP AMDP Example Create a class in ECLIPSE ( AMDP Class ) Note -You need to have HAND DB to use AMDP CLASS zamdp5 DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES: if_amdp_marker_hdb. TYPES:BEGIN OF lty_vbak, vbeln TYPE vbeln, auart TYPE auart, netwr TYPE netwr_ap, END OF lty...

SAP SD and SAP MM flow

access_time 2025-09-14T18:43:44.261Z face LearnABAP.IO
SAP SD and SAP MM flow SAP SD and MM Flow for ABAP Consultants Below is a illustration of SAP SD flow Customer enquires about the products services that were sold by company Company Gives a Quotation for the products and services to a customer Based on purchase order sales order will be created Onc...

TICTACTOE

access_time 2025-08-03T09:39:40.44Z face LearnABAP.IO
TICTACTOE lets play a game this Sunday. Copy the below Code REPORT zac_tictacto. tictactoe TYPES:BEGIN OF lty_table, var1 TYPE c, var2 TYPE c, var3 TYPE c, END OF lty_table. DATA lv_counter1 TYPE i. DATA lv_counter2 TYPE i. DATA lv_helper TYPE c. DATA lv_flag TYPE c. DATA lv_final TYPE i VALUE 9. D...