Posts

Showing posts from November, 2019

Using BAPI upload excel file for t-code AS02 in SAP

Using BAPI " BAPI_FIXEDASSET_CHANGE " create a zprogram to upload excel file for mass change fixed asset in SAP. REPORT  ZAS02_ASSET_CHANGE_UPLOAD . TYPE-POOLS :  truxs . " Structure for Excel data TYPES :  BEGIN  OF  ty_excel ,          anln1  TYPE  anln1 ,          bukrs  TYPE  bukrs ,          kostl  TYPE  kostl ,          werks  TYPE  werks ,          prctr  TYPE  prctr ,         END  OF  ty_excel . DATA :  lt_excel     TYPE  TABLE  OF  ty_excel ,       ls_excel     TYPE  ty_excel ,     ...

Control Break Statement in SAP ABAP

Control Break Statement : Events 1.AT NEW 2.AT FIRST 3.AT LAST 4.AT END OF 5.ON CHANGE OF Using these statements we can control the flow of ABAP programming statement within the LOOP........ ENDLOOP statement AT NEW: It triggers for a group of similar contents in an internal table.It triggers whenever there is a change in field values in an internal based on character value. Syntax:  AT NEW <field-name>.  ....................... statenments  ......................... ENDAT. AT FIRST:  It triggers during first loop iteration . Syntax:  AT FIRST. .................... STATEMENTS ........................... ENDAT.   AT LAST: It triggers for last line of an Internal Table or last loop iteration.Most of the time AT LAST used to do for GRAND Total. Syntax: AT LAST. ................................ ................................ ENDAT. AT END OF: It will triggers the end of group of similar values in an internal ta...

Internal Table & Structure concept in SAP ABAP

Today I am going to discuss about Internal Table concept in sap ABAP. Internal table is a temporary table created in RAM. It is created during run time and store data temporarily. Using "Table of"  key word we can create internal table.Internal table can store multiple value in run time. Syntax of internal table: Data: Itab TYPE TABLE OF  MARC (TYPE TABLE). Even we can create internal table as we need. At the very first time we need to create a structure. Using Type keyword we create structure in ABAP program. Structure never holds any data, based on structure we can create number of object in sap. Syntax: Types: Begin of st ,             matnr  type  marc-matnr,            werks   type  marc-werks,            sobsk    type marc-sobsk,           ...

AMDP in SAP HANA

Database procedure are stored and execute in the Database. On HANA database through ABAP using AMDP class and AMDP method called  ABAP managed Database Procedure. SQL script is the language for creating stored procedure in HANA. Benefit of SQL script allows complex calculation inside HANA Database. Language varies from one database system to others. The ABAP Managed Database Procedure should be created using ABAP developments tools Eclipse or HANA studio. If we consider students as a Class and that Class has a Marker Interface "IF_AMDP_MARKER_HDB"  then it is an AMDP Class.If one or more method of AMDP class has then keyword is "BY DATABASE PROCEDURE". The AMDP class must contain the appropriate tag interface. In Class definition provide interface IF_AMDP_MARKER_HDB . Define Table Type as TT_name and structure as TY_name. Define the method GET_name_data