How to check SAP system running on HANA database or not?

June 09, 2023

There are several ways to check database running on SAP.

1. When you logged in to SAP system through SAP GUI , you can check the database from SYSTEM > STATUS.

2. Another way to check database, go to SE24 tcode and then put the class name CL_DB_SYS and run the class.

If HANA database is exist then in IS_IN_MEMORY_DB attribute will be 'X' and DBSYA_TYPE attribute will be DHB.

If HANA database is not exist then IS_IN_MEMORY_DB attribute will be blank and DBSYA_TYPE attribute will be showing the existing oracle database.

If you have any Question you can contact us or mail us.We will reply you as soon as possible.
No comments:
Labels:

How to enable or disable MS Word as Editor in SAPscript and Smart Forms

February 07, 2023

Step 1. Go to SE38 and type program name  - RSCPSETEDITOR and then execute it.
Step 2. Tick or Untick SAPscript / Smart Forms to enable or disable MS Word as Editor.
Step 3. After that activate the changes.


IDE Used To Test This Code : SAP ABAP Editor.

Try this code in your computer for better understanding. Enjoy the code. If you have any Question you can contact us or mail us. We will reply you as soon as possible.
No comments:
Labels:

How to read AL11 files using ZSUBST_GET_FILE_LIST function module in ABAP program

January 31, 2023

Code :
REPORT zvp_read_all_files.

DATA : r3_filepath(100) TYPE c,
       it_filelists     TYPE TABLE OF rsfillst.

DATA: path      TYPE rsmrgstr-path,
      filename  TYPE rsmrgstr-name,
      open_file TYPE rlgrap-filename.

r3_filepath = 'Your Folder Path'.
path = r3_filepath.

CALL FUNCTION 'ZSUBST_GET_FILE_LIST'
  EXPORTING
    dirname      = path
    filenm       = filename
    pattern      = 'HOLD_*.CSV'
  TABLES
    file_list    = it_filelists
  EXCEPTIONS
    access_error = 1
    OTHERS       = 2.

IF it_filelists[] IS INITIAL.
  MESSAGE 'No File in Application Layer Folder' TYPE 'I'.
  LEAVE LIST-PROCESSING.
ELSE.
  LOOP AT it_filelists INTO DATA(wa_filelists).
    CONCATENATE wa_filelists-dirname wa_filelists-name INTO open_file SEPARATED BY '/'.
    WRITE: open_file.
  ENDLOOP.
ENDIF.

Output :



IDE Used To Test This Code : ABAP Editor.

Try this code in your computer for better understanding. Enjoy the code. If you have any Question you can contact us or mail us. We will reply you as soon as possible.
No comments:
Labels: ,

ABAP program to display table output using cl_demo_output class

January 30, 2023

Custom Table -  ZVP_TEST
Above table have following fields and their data types.

CLIENT         MANDT
ID                 INT4
NAME         CHAR50
COUNTRY CHAR30
PHONE         CHAR10
SALARY CHAR40

Code -
SELECT * FROM zvp_test INTO TABLE @data(it).
cl_demo_output=>display( it ).

Output -



IDE Used To Test This Code : ABAP Editor.

Try this code in your computer for better understanding. Enjoy the code. If you have any Question you can contact us or mail us. We will reply you as soon as possible.
No comments:
Labels: ,

SAP ABAP Editor Lists of Shortcut Key

January 10, 2023

Copy a line of code - Ctrl + Shift + T
Comment a line - Ctrl + <
Comment out a line - Ctrl + >
No comments:
Labels:

How to show Internal Table last record using inline in SAP ABAP

February 08, 2022

Code :
REPORT ZSOUMYO_DEMO.

types: BEGIN OF ty_str,
        id  TYPE i,
        name TYPE char20,
        address TYPE char100,
       END OF ty_str.

DATA: it_str TYPE STANDARD TABLE OF ty_str,
      wa_str TYPE ty_str.

wa_str-id = '1'.
wa_str-name = 'prasun'.
wa_str-address = 'kolkata'.
APPEND wa_str to it_str.

wa_str-id = '2'.
wa_str-name = 'kalyan'.
wa_str-address = 'delhi'.
APPEND wa_str to it_str.

wa_str-id = '3'.
wa_str-name = 'rita'.
wa_str-address = 'Mumbai'.
APPEND wa_str to it_str.

wa_str-id = '4'.
wa_str-name = 'suman'.
wa_str-address = 'pune'.
APPEND wa_str to it_str.

wa_str = it_str[ lines( it_str ) ].
write:/ wa_str-id,
        wa_str-name,
        wa_str-address.

Output :


IDE Used To Test This Code : SAP GUI.

Try this code in your computer for better understanding. Enjoy the code. If you have any Question you can contact us or mail us.We will reply you as soon as possible.
No comments:
Labels: ,

How to insert values in a table in Oracle 10g

April 26, 2021

Code :
INSERT INTO student ( id, first_name, last_name )
VALUES( '1', 'subhajit', 'naskar' );


Output :
1 row(s) inserted.

IDE Used To Test This Code : Oracle 10g.

Try this code in your computer for better understanding. Enjoy the code. If you have any Question you can contact us or mail us. We will reply you as soon as possible.
No comments:
Labels:

How to create a table in Oracle 10g

April 26, 2021

Code :
CREATE TABLE student(
id NUMBER (10),
first_name VARCHAR2(50),
last_name VARCHAR2(50),
phone NUMBER (10)
);

Output :
Table created.

IDE Used To Test This Code : Oracle 10g.

Try this code in your computer for better understanding. Enjoy the code. If you have any Question you can contact us or mail us. We will reply you as soon as possible.
No comments:
Labels:

What is Process Memory in Operating System

October 03, 2020

Process memory divided in to 4 main section - 
1. Stack Section.
2. Heap Section.
3. Data Section.
4. Text Section.

Stack - Stack section is basically used for local variables.

Heap - Heap section used for dynamic memory allocation. Heap section managed via call of free, malloc, delete, new function.

Data - This section used for static and global variables.

Text - This section hold compiled code from non volatile memory when program launched.

If you have any Question you can contact us or mail us. We will reply you as soon as possible.
No comments:
Labels:

How to find all implementation for a particular BAdi name?

May 09, 2020

Step 1 : Go to SE18. Choose BAdi Name and put the BAdi Name and click Display button, we will find out list of all implementation for BAdi Name VENDOR_ADD_DATA.

Step  2 : Then click on Implementation and click on Display.

Step 3 : You will get a popup menu where you can see the all implementation.


If you have any Question you can contact us or mail us.We will reply you as soon as possible.
No comments:
Labels: ,

What is process state in OS

May 09, 2020

When process executes it changes states. Process states are - 

New - The process is being created.

Ready - Process is waiting to be assigned by another processor.

Running - Instructions are being executed.

Waiting - Process is waiting for some event to occur (I/O completion).

Terminated - Process has finished execution.

If you have any Question you can contact us or mail us.We will reply you as soon as possible.
No comments:
Labels:

Swapping of two numbers in SAP ABAP

May 09, 2020

Code :
REPORT ZVP_SWAPPING_PROGRAM.

DATA: TEMP TYPE CHAR10.

PARAMETERS: P_FIRST TYPE CHAR10,
            P_SECOND TYPE CHAR10.

TEMP = P_FIRST.
P_FIRST = P_SECOND.
P_SECOND = TEMP.

WRITE:/ 'FIRST', P_FIRST.
WRITE:/ 'SECOND', P_SECOND.

Output :
Selection Screen Input

Output Result


IDE Used To Test This Code : SAP ABAP Editor.

Try this code in your computer for better understanding. Enjoy the code. If you have any Question you can contact us or mail us.We will reply you as soon as possible.
No comments:
Labels: ,

What is Bootstrap Program in Operating System

May 08, 2020


A small initial program is needed to powered up the system or rebooted the system. This initial program known as Bootstrap Program. This program stored in ROM or EEPROM , in general terms it is known as Firmware.

If you have any Question you can contact us or mail us.We will reply you as soon as possible.
No comments:
Labels:

PRODUCTS

LISTS OF PRODUCTS
StockPOS
CTQRScan

SERVICES

SKILLS
SOFTWARE DEVELOPMENT
WEBSITE DEVELOPMENT
WEB HOSTING
BULK SMS SERVICE
SEO SERVICE
ANDROID APPS
QR CODE / BARCODE
HARDWARE SERVICE
OUR WORK AREA
CONTACT