Skip to content

Instantly share code, notes, and snippets.

View akshayrajkumar's full-sized avatar

Akshay Rajkumar akshayrajkumar

View GitHub Profile
@akshayrajkumar
akshayrajkumar / ZRANGES.abap
Created June 12, 2018 07:00
to add selected fields from internal table using RANGES
* prog 27
TABLES: kna1.
TYPES: BEGIN OF t_kna1,
v_name1 LIKE kna1-name1,
v_name2 LIKE kna1-name2,
v_land1 LIKE kna1-land1,
END OF t_kna1.
SKIP 2.
@akshayrajkumar
akshayrajkumar / ZSUBQUERY.abap
Last active April 19, 2021 05:40
Select the carrier Id from SFLIGHT as the subquery (inner query) and compare the carrier id with SPFLI. Pass the information up to the outer select which according to the carrier finds the matching connection id (CONNID) from SFLIGHT.
TABLES: spfli, sflight.
TYPES: BEGIN OF t_table,
v_carrid LIKE sflight-carrid,
v_connid LIKE spfli-connid,
END OF t_table.
DATA: int_table TYPE STANDARD TABLE OF t_table, wa_table TYPE t_table.
@akshayrajkumar
akshayrajkumar / ZINNERJOIN.abap
Created June 12, 2018 07:37
using inner joins in abap
REPORT ZINNERJOIN.
TABLES: spfli, sflight.
*
TYPES: BEGIN OF t_table,
v_carrid LIKE spfli-carrid,
v_connid LIKE spfli-connid,
v_cityfrom LIKE spfli-cityfrom,
v_cityto LIKE spfLi-cityto,
@akshayrajkumar
akshayrajkumar / ZEXPORT.abap
Created June 12, 2018 10:08
exporting fields from internal table to a database using EXPORT keyword
report ZEXPORT.
TYPES: BEGIN OF st_table,
carrid LIKE sflight-carrid,
connid LIKE spfli-connid,
fldate LIKE sflight-fldate,
planety LIKE sflight-planetype,
seatmax LIKE sflight-seatsmax_b,
seatsocc LIKE sflight-seatsocc_b,
END OF st_table.
@akshayrajkumar
akshayrajkumar / gist:68cbf12c1bed1f92c566e3d15cbab453
Last active June 15, 2018 04:17
to download data from db in abap
data: lt_data type standard table of sflight,
lw_data type sflight.
SELECT * FROM SFLIGHT INTO TABLE LT_DATA.
CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
filename = 'C:\Users\A07208trng_B4B.04.25\Desktop\akk.txt'
tables
data_tab = lt_data.
@akshayrajkumar
akshayrajkumar / ZCLASS.abap
Created June 15, 2018 09:56
IMPLEMENTATION OF CLASS IN ABAP. CREATION OF METHODS IN CLASS AND OBJECT TO GET ELEMENTS AND DISPLAY FROM TABLE.
REPORT ZCLASS.
CLASS lc_class DEFINITION.
PUBLIC SECTION.
DATA:lt_sflight TYPE STANDARD TABLE OF sflight.
METHODS: select_data IMPORTING im_carrid TYPE s_carr_id,
display_data.
ENDCLASS.
CLASS lc_class IMPLEMENTATION.
METHOD select_data.
@akshayrajkumar
akshayrajkumar / ZXCN1U01.abap
Last active August 8, 2019 09:56
Code to loop a SAP_USER field and validate the fields with respect to the data available in the custom table
IF sy-uname EQ 'XXXXXX' OR sy-uname EQ 'XXXXXX'.
*//Work Area Declarations...............................................
DATA:
lw_ops_usrfld TYPE zops_t_usfld_val,
lw_components TYPE abap_compdescr,
lw_sap_usr TYPE afvui.
*//Variable Declarations................................................
DATA:
@akshayrajkumar
akshayrajkumar / conc.abap
Created October 7, 2019 10:17
concatenate two variables in abap using 7.4 syntax
data : lv_sam type String.
lv_sam = text-002.
data(lv_sam2) = 'currency'.
data(lv_out) = | { lv_sam } { lv_sam2 } | .
WRITE :/ lv_out.
@akshayrajkumar
akshayrajkumar / alv-abap
Created October 15, 2019 14:06
Snippet to Display Internal Table in ALV
tables: mara.
data:
lt_mara type STANDARD TABLE OF mara,
displayalv type REF TO cl_salv_table.
select * from mara into table lt_mara.
* TRY.
@akshayrajkumar
akshayrajkumar / readme.txt
Created April 26, 2021 07:54
Driver Program for Adobe Forms in SAP ABAP.
create an header structure(zadobefheader) in SE11 with required fields.
create a item table(ztt_adobef_lines) in SE11 with required fields.
in the relevant output type, maintain the form routine as ENTRY so that the initial call for from processing will be PERFROM ENTRY.
use the FM NAST_UPDATE_PROTOCOL to update the errors and success messages.
in the form processing, create a custom FM ZADOBEFORM_OUTPUT by exporting nast and importing the header and line item table, so that you have flexibility to use same program fro multiple requirement.
get the fm_name from SFP and call fm and pass the values in the fields.
for further details please comment!