SAP ABAP General Archives

How to sort Table Maintenance

Sometimes you need to sort table maintenance before display, this is simple method to do that. 1.Go to SE11 Open your table, go to menu Utilities-> Table Maintenance Generator. 2. Go to Environment -> Modification -> Maintenance Screens 3.Create one module in PBO.

PROCESS BEFORE OUTPUT.
  MODULE liste_initialisieren.
  MODULE sort_extract. "Create one module for example sort_extract
  LOOP AT extract WITH CONTROL
   tctrl_ztbmm007 CURSOR nextline.
    MODULE liste_show_liste.
  ENDLOOP.
*
PROCESS AFTER INPUT.
[...]

PROCESS BEFORE OUTPUT.

MODULE liste_initialisieren.

MODULE sort_extract. "Create one module for example sort_extract

LOOP AT extract WITH CONTROL

tctrl_ztbmm007 CURSOR nextline.

MODULE liste_show_liste.

ENDLOOP.

PROCESS AFTER INPUT.

[...]

4. Write this ABAP Code in module sort_extract.

  DATA : it_ztbmm007 LIKE ztbmm007 OCCURS 1 WITH HEADER LINE .

  IF NOT sy-ucomm = 'NEWL'.
    it_ztbmm007[] = extract[].

    SORT it_ztbmm007 BY werks ekgrp.

    extract[] = it_ztbmm007[].

  ENDIF.

DATA : it_ztbmm007 LIKE ztbmm007 OCCURS 1 WITH HEADER LINE .

IF NOT sy-ucomm = 'NEWL'.

it_ztbmm007[] = extract[].

SORT it_ztbmm007 BY werks ekgrp.

extract[] = it_ztbmm007[].

ENDIF.

ABAP Program to Upload Routing

How to use BAPI_ROUTING_CREATE We would to share Full ABAP Program to upload Routing using BAPI_ROUTING_CREATE . Routing data is located in Excel file. Below is the template from excel file. and you can modify it according to your needs

perform fill_cell using 1 1  'X' 'Material No' 'L' 'C'.
  perform fill_cell using 1 2  'X' 'Task List Description' 'L' 'C'.
  perform fill_cell using 1 3  'X' 'Plant' 'L' 'C'.
  perform fill_cell using 1 4  'X' 'Task List Usage' 'L' 'C'.
  perform fill_cell using 1 5  'X' 'Status' 'L' 'C'.
  perform fill_cell using 1 6  'X' 'From Lot Size' 'L' 'C'.
  perform fill_cell using 1 7  'X' 'UoM Task List' 'L' 'C'.
  perform fill_cell using 1 8 'X' 'Work Center' 'L' 'C'.
  perform fill_cell using 1 9 'X' 'Control Key' 'L' 'C'.
  perform fill_cell using 1 10  'X' 'Operation Short Text' 'L' 'C'.
  perform fill_cell using 1 11 'X' 'Base Qty' 'L' 'C'.
  perform fill_cell using 1 12 'X' 'Valid From(YYYYMMDD)' 'L' 'C'.
  perform fill_cell using 1 13 'X' 'Machine' 'L' 'C'.
  perform fill_cell using 1 14 'X' 'FOH' 'L' 'C'.
  perform fill_cell using 1 15 'X' 'Labor' 'L' 'C'.
  perform fill_cell using 1 16 'X' 'Carrier' 'L' 'C'.
  perform fill_cell using 1 17 'X' 'Qty per Jig' 'L' 'C'.
  perform fill_cell using 1 18 'X' 'Jig Available' 'L' 'C'.

perform fill_cell using 1 1 'X' 'Material No' 'L' 'C'.

perform fill_cell using 1 2 'X' 'Task List Description' 'L' 'C'.

perform fill_cell using 1 3 'X' 'Plant' 'L' 'C'.

perform fill_cell using 1 4 'X' 'Task List Usage' 'L' 'C'.

perform fill_cell using 1 5 'X' 'Status' 'L' 'C'.

perform fill_cell using 1 6 'X' 'From Lot Size' 'L' 'C'.

perform fill_cell using 1 7 'X' 'UoM Task List' 'L' 'C'.

perform fill_cell using 1 8 'X' 'Work Center' 'L' 'C'.

perform fill_cell using 1 9 'X' 'Control Key' 'L' 'C'.

perform fill_cell using 1 10 'X' 'Operation Short Text' 'L' 'C'.

perform fill_cell using 1 11 'X' 'Base Qty' 'L' 'C'.

perform fill_cell using 1 12 'X' 'Valid From(YYYYMMDD)' 'L' 'C'.

perform fill_cell using 1 13 'X' 'Machine' 'L' 'C'.

perform fill_cell using 1 14 'X' 'FOH' 'L' 'C'.

perform fill_cell using 1 15 'X' 'Labor' 'L' 'C'.

perform fill_cell using 1 16 'X' 'Carrier' 'L' 'C'.

perform fill_cell using 1 17 'X' 'Qty per Jig' 'L' 'C'.

perform fill_cell using 1 18 'X' 'Jig Available' 'L' 'C'.

You can download ABAP Program to upload or download Routing here – > Upload SAP Routing […]

How to manipulating Search Help using Search Help Exit

In this article we will focus on discussing how to use search help exit and we hope you understand how to make search help. For example we will create search help ZSH_AFNAM, this search help will select data from table let’s say ZTBMM007. this table contain two fields AFNAM ( Requitioner ) and name of requisitioner. […]

Enhancing Your ABAP Code – Part 1

There are various reason why ABAP Developments don’t always run correctly, the first category is the errors are caused by the developer’s basic lack of ABAP skills. In this article allowed me to explain some of errors that may be occured. The second category of errors can be characterized that wrong assumptions about the data […]

Business Partner Relationship Report using RS_TREE_LIST_DISPLAY and RS_TREE_CONSTRUCT

SAP ABAP Tutorial – You can create Tree Report simple using RS_TREE_LIST_DISPLAY. In this sample ABAP Code we have to create Business Partner Relationship Report. This report must build with Tree layout report, let’s start from getting data and put into an internal table, then build tree node by populating internal table which it have […]