Thursday, February 2, 2023
Latest:
  • ABAP 7.5 declare a new field in SELECT statement by CAST
  • tmp
  • CUSTOM BUTTON, SELECT ALL, DESELECT ALL & FILTER OPTION IN OOPS ALV – USING CL_GUI_ALV_GRID
  • Call a transaction in BDC way
  • Disabling the Modification Assistant
henrydaiit

henrydaiit

SAP Senior Technical Consultant

  • SAP
    • SAP ABAP
    • SAP Basis
    • SAP CO
    • SAP FI
    • SAP MM
    • SAP PM
    • SAP PP
    • SAP QM
    • SAP SD
    • SAP WM
  • Contact Me

Excel

Excel

Excel 

Find out the last position of a character in string from right to left

May 30, 2019May 30, 2019 admin 0 Comments Excel, Find, LEN, position of a character in string, SUBSTITUTE

EG: find out the last position of character ‘_’ in text in cell A1 =FIND(“|”,SUBSTITUTE(A1,”_”,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,”_”,””))))

Read more

Categories

  • C# (1)
  • cPanel (1)
  • Excel (1)
  • IIS (2)
  • JVZoo (2)
  • MU Legend (1)
  • News (1)
  • Những phần mềm hữu ích nhất (2)
  • SAP (70)
    • SAP ABAP (65)
      • Adobe Form (PDF Form) (4)
      • ALV (3)
      • Message Class (1)
      • Performance Improvement (1)
      • Smartform (1)
      • Work with Excel (1)
    • SAP ERP (1)
    • SAP SD (1)
  • Uncategorized (1)
  • Windows 7 (1)
  • Wordpress (1)
  • Wordpress Themes (1)

NEWS

SAP ABAP 

ABAP 7.5 declare a new field in SELECT statement by CAST

December 24, 2022 admin 0

Sample: SELECT vbak~vbeln, vbak~kunnr, vbak~vdatu, vbap~matnr, vbap~wrf_charstc1, vbap~vstel, vbap~werks, vbap~kwmeng, mara~satnr, CAST( ‘ ‘ AS CHAR( 70 ) ) AS atwrt INTO TABLE @DATA(lt_so) FROM vbap INNER JOIN vbak ON vbap~vbeln = vbak~vbeln INNER JOIN mara ON vbap~matnr = mara~matnr WHERE vbak~auart IN ( ‘ZGW1’,‘ZGW2’ ) AND vbak~autlf = ” AND vbap~werks IN @lt_r_werks AND vbap~matnr IN @lt_r_matnr

Uncategorized 

tmp

November 30, 2022 admin 0

RSS Số hóa

  • Galaxy S23 Ultra giảm 5 triệu đồng sau mở bán February 1, 2023
  • Samsung ra laptop Galaxy Book3 Ultra cao cấp February 1, 2023
  • Ảnh thực tế Galaxy S23 và S23+ February 1, 2023
  • Galaxy S23 series ra mắt February 1, 2023
  • Galaxy S23 Ultra trình làng với camera 200 'chấm' February 1, 2023
  • Những tỷ phú công nghệ mơ sống lâu February 1, 2023
  • Giới công nghệ mong chờ gì ở Galaxy mới? February 1, 2023
  • ChatGPT khác biệt gì so với tìm kiếm Google February 1, 2023
  • Nhân viên Facebook chờ đợt sa thải tiếp theo February 1, 2023
  • OpenAI ra công cụ chống đạo văn bằng ChatGPT February 1, 2023

TG: 125x125 Ads

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Dec    

About Me

Full name: Dai Nguyen Quang

Nick name: henrydaiit

Current job title: Senior SAP ABAP Consultant

Knowlegdes: SAP ECC6, SAP ABAP, SAP BI, C#, VB.NET, ASP.NET MVC3, HTML, CSS, Javascript, jQuery, SQL Server, Wordpress

Useful Links

Comming Soon

Statistics

  • 0
  • 1
  • 1
  • 1
  • 1
  • 82
  • 587
  • 8,109
  • 4,036
  • 0

Ads