SAP Help

ABAP : Dynamic ITAB for Ranges

noreply@blogger.com (Oka) — Wed, 15 May 2013 20:45:00 -0700

Example of ABAP Code Dynamic Internal Table - Ranges
*---------------------------------------------------------------------*
* Form f_ranges_str
* By Oka Wirasatha
*---------------------------------------------------------------------*

form F_RANGES_STR
using FV_FIELD
FV_SIGN FV_OPTION FV_LOW FV_HIGH.
type-pools:
ABAP.

data:
GR_STRUCTDESCR type ref to CL_ABAP_STRUCTDESCR,
GR_TABLEDESCR type ref to CL_ABAP_TABLEDESCR,
GR_DATADESCR type ref to CL_ABAP_DATADESCR,
GR_TYPEDESCR type ref to CL_ABAP_TYPEDESCR,
GT_COMPONENTS type ABAP_COMPONENT_TAB,
GW_COMPONENT type line of ABAP_COMPONENT_TAB,
GR_WA type ref to DATA,
GR_TAB type ref to DATA,
LV_TEXT(20).

field-symbols: <fs_wa> type any,
<fs_val> type any,
<fs_tab> type TABLE.
* determine components of structure -> GT_COMPONENTS
move 'SIGN' to GW_COMPONENT-NAME.
GW_COMPONENT-TYPE ?= CL_ABAP_ELEMDESCR=>GET_C( P_LENGTH = 1 ).
insert GW_COMPONENT into table GT_COMPONENTS.

move 'OPTION' to GW_COMPONENT-NAME.
GW_COMPONENT-TYPE ?= CL_ABAP_ELEMDESCR=>GET_C( P_LENGTH = 2 ).
insert GW_COMPONENT into table GT_COMPONENTS.

move 'LOW' to GW_COMPONENT-NAME.
GW_COMPONENT-TYPE ?= CL_ABAP_ELEMDESCR=>DESCRIBE_BY_NAME( FV_FIELD ).
insert GW_COMPONENT into table GT_COMPONENTS.

move 'HIGH' to GW_COMPONENT-NAME.
GW_COMPONENT-TYPE ?= CL_ABAP_ELEMDESCR=>DESCRIBE_BY_NAME( FV_FIELD ).
insert GW_COMPONENT into table GT_COMPONENTS.

* get structure descriptor -> GR_STRUCTDESCR
GR_STRUCTDESCR ?= CL_ABAP_STRUCTDESCR=>CREATE( GT_COMPONENTS ).

* create work area of structure GR_STRUCTDESCR -> GR_WA
create data GR_WA type handle GR_STRUCTDESCR.
assign GR_WA->* to <fs_wa>.

GR_DATADESCR ?= GR_STRUCTDESCR.
GR_TABLEDESCR ?= CL_ABAP_TABLEDESCR=>CREATE( GR_DATADESCR ).

* Create dynmaic internal table
create data GR_TAB type handle GR_TABLEDESCR.
assign GR_TAB->* to <fs_tab>.

assign component 'SIGN' of structure <fs_wa> to <fs_val>.
= FV_SIGN.
assign component 'OPTION' of structure <fs_wa> to <fs_val>.
= FV_OPTION.
assign component 'LOW' of structure <fs_wa> to <fs_val>.
= FV_LOW.
assign component 'HIGH' of structure <fs_wa> to <fs_val>.
= FV_HIGH.

insert <fs_wa> into table <fs_tab>.

loop at T_ITEM.
concatenate 'T_ITEM-' FV_FIELD into LV_TEXT.
assign (LV_TEXT) to <fs_val>.
if not <fs_val> in <fs_tab>.
delete T_ITEM.
endif.
endloop.
endform. "f_ranges_str

ABAP Dialog Programming : Set Filter data of Table Control

noreply@blogger.com (Oka) — Wed, 15 May 2013 20:23:00 -0700

Example ABAP code for Filter data of table control

*---------------------------------------------------------------------*
* Form F_filter_data
*---------------------------------------------------------------------*
* By Oka Wirasatha
*---------------------------------------------------------------------*
form F_FILTER_DATA .
field-symbols :
<selected_col> type CXTAB_COLUMN.
data : LW_COLS like TC_ITEM-COLS.
data : GT_FIELDCAT type LVC_T_FCAT.
data LAYO type LVC_S_LAYO.
data : GT_FILTER_INDEX type LVC_T_FIDX,
LT_SELCOL type table of LVC_S_COL with header line.
data : LT_FILT type LVC_T_FILT,
LW_FILT type LVC_S_FILT,
LT_LAYOUT type LVC_S_LAYO.

* find out if a column is selected.
loop at TC_ITEM-COLS assigning <selected_col>.
if <selected_col>-SELECTED = 'X'.
LT_SELCOL-FIELDNAME = <selected_col>-SCREEN-NAME+7(10).
append LT_SELCOL.
endif.
endloop.

call function 'LVC_FIELDCATALOG_MERGE'
exporting
I_STRUCTURE_NAME = 'ZSMM_GRDM'
changing
CT_FIELDCAT = GT_FIELDCAT
exceptions
INCONSISTENT_INTERFACE = 1
PROGRAM_ERROR = 2
others = 99.

if SY-SUBRC = 0 and not LT_SELCOL[] is initial.
call function 'LVC_FILTER'
exporting
IT_FIELDCAT = GT_FIELDCAT
IT_SELECTED_COLS = LT_SELCOL[]
IS_LAYOUT = LT_LAYOUT
importing
ET_FILTER_INDEX = GT_FILTER_INDEX
tables
IT_DATA = T_ITEM "gt_subitems
changing
CT_FILTER = LT_FILT
exceptions
others = 0.
if SY-SUBRC = 0.
loop at LT_FILT into LW_FILT.
* Filter data with dynamic Selected col
perform F_RANGES_STR
using LW_FILT-FIELDNAME
LW_FILT-SIGN
LW_FILT-OPTION
LW_FILT-LOW
LW_FILT-HIGH.
endloop.
if SY-SUBRC ne 0.
* Fill default data to list
endif.
endif.
endif.

endform. " F_filter_data

ABAP Dialog Programming : Sorting selected column in Table Control

noreply@blogger.com (Oka) — Wed, 15 May 2013 20:02:00 -0700

This is example of abap code for sorting selected table control.

*---------------------------------------------------------------------*
* Form F_SORT_TABLE
*---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* By Oka Wirasatha
*----------------------------------------------------------------------*
form F_SORT_TABLE using FV_CODE.
field-symbols :
<lfs1>,
<selected_col> type CXTAB_COLUMN.

data : LW_COLS like TC_ITEM-COLS.
data : LV_TXT1(20),
LV_INDEX(2) type N.
data : begin of W_SORT,
SORT01(20),
SORT02(20),
SORT03(20),
SORT04(20),
SORT05(20),
SORT06(20),
SORT07(20),
end of W_SORT.

* find out if a column is selected.
LV_INDEX = 0.
clear W_SORT.
loop at TC_ITEM-COLS assigning <selected_col>.
if <selected_col>-SELECTED = 'X'.
LV_INDEX = LV_INDEX + 1.
concatenate 'w_sort-sort' LV_INDEX into LV_TXT1.
assign (LV_TXT1) to <lfs1>.
<lfs1> = <selected_col>-SCREEN-NAME+7(10).
endif.
endloop.

if not W_SORT is initial.
if FV_CODE = 'ASC'.
sort T_ITEM by (W_SORT-SORT01).
else.
sort T_ITEM descending by (W_SORT-SORT01).
endif.
else.
message S000(ZMM) with 'No column is selected'.
endif.

endform. " sort_table

Problem SAP-SCRIPT line command too long

noreply@blogger.com (Oka) — Thu, 15 Nov 2012 20:43:00 -0800

Sometimes your sap scripts command too long, how to covered this ?

Easy way is press shift+F8.

Dynamic Selection Screen Base on TCODE

noreply@blogger.com (Oka) — Wed, 25 Apr 2012 23:12:00 -0700

SELECTION-SCREEN BEGIN OF BLOCK SO WITH FRAME TITLE TEXT-001.

SELECT-OPTIONS: S_VBELN FOR VBAK-VBELN,"Sales order number

S_VBELND FOR LIKP-VBELN,"Delivery number

S_VBELNI FOR VBRK-VBELN,"Invoice number

S_VBELNP FOR VBKD-BSTKD."PO number

SELECTION-SCREEN END OF BLOCK SO.

*--- EVENT AT SCREEN OUTPUT -------------------------------

AT SELECTION-SCREEN OUTPUT.

CASE SY-TCODE.

WHEN 'ZEDI6'.

LOOP AT SCREEN.

CASE SCREEN-GROUP4.

WHEN '001'. "Sales order select

SCREEN-ACTIVE = '1'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '002'. "Delivery select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '003'. "Invoice select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '004'. "PO Select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

ENDCASE.

ENDLOOP.

WHEN 'ZEDI6D'. "Delivery select

LOOP AT SCREEN.

CASE SCREEN-GROUP4.

WHEN '001'. "Sales order select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '002'. "Delivery select

SCREEN-ACTIVE = '1'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '003'. "Invoice select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '004'. "PO Select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

ENDCASE.

ENDLOOP.

WHEN 'ZEDI6I'. "Invoice select

LOOP AT SCREEN.

CASE SCREEN-GROUP4.

WHEN '001'. "Sales order select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '002'. "Delivery select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '003'. "Invoice select

SCREEN-ACTIVE = '1'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '004'. "PO Select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

ENDCASE.

ENDLOOP.

WHEN 'ZEDI6P'. "PO select

LOOP AT SCREEN.

CASE SCREEN-GROUP4.

WHEN '001'. "Sales order select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '002'. "Delivery select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '003'. "Invoice select

SCREEN-ACTIVE = '0'. "1=Active, 0=Don't display

MODIFY SCREEN.

WHEN '004'. "PO Select

SCREEN-ACTIVE = '1'. "1=Active, 0=Don't display

MODIFY SCREEN.

ENDCASE.

ENDLOOP.

ENDCASE.

Dynamic selection screens based on user input parameters

noreply@blogger.com (Oka) — Wed, 25 Apr 2012 23:10:00 -0700

Dynamic selection screens based on user input parameters with dropdowns and execute button disabled.
The selection screen push button does the functionality of the disabled execute button
REPORT zsscr.

*TYPE POOLS DECLARATIONS FOR VALUE REQUEST MANAGER AND ICONS

TYPE-POOLS : vrm,
icon.

*SELECTION SCREEN FIELDS
TABLES : sscrfields.

*GLOBAL DECLARATIONS

DATA : flag TYPE c,
tablename(10),
mmtable LIKE dd02l-tabname,
sdtable LIKE dd02l-tabname,
hrtable LIKE dd02l-tabname.

*DECLARATIONS FOR SELECTION SCREEN STATUS

DATA it_ucomm TYPE TABLE OF sy-ucomm.

**********SELECTION-SCREENS*********************

SELECTION-SCREEN BEGIN OF BLOCK blk1 WITH FRAME.

*FOR DYNAMIC DISPLAY OF MODULES
PARAMETERS : pa RADIOBUTTON GROUP rad USER-COMMAND com MODIF ID mod,
pb RADIOBUTTON GROUP rad MODIF ID rad,
pc RADIOBUTTON GROUP rad MODIF ID cad.
SELECTION-SCREEN SKIP.

**TO INCLUDE DYNAMIC ICONS

SELECTION-SCREEN COMMENT 2(6) text_001.

*DYNAMIC LIST BOX BASED ON USER SELECTIONS

PARAMETERS one AS LISTBOX VISIBLE LENGTH 20 MODIF ID mod.
PARAMETERS two AS LISTBOX VISIBLE LENGTH 20 MODIF ID rad.
PARAMETERS three AS LISTBOX VISIBLE LENGTH 20 MODIF ID cad.
SELECTION-SCREEN END OF BLOCK blk1.

*DISPLAY DYNAMIC PUSHBUTTON ON APP TOOLBAR ON USER CLICKS

SELECTION-SCREEN: FUNCTION KEY 1,
FUNCTION KEY 2,
FUNCTION KEY 3.

**EVENT ON SELECTION SCREEN FOR OUTPUT DISPLAY

AT SELECTION-SCREEN OUTPUT.

*CLICK OF FIRST RADIO BUTTON
IF pa = 'X'.
sscrfields-functxt_01 = 'Materials Management'.
WRITE icon_plant AS ICON TO text_001.

*CODE TO GET DYNAMICS BASED ON THE SELECTED RADIO
LOOP AT SCREEN.
IF screen-group1 = 'MOD'.
screen-intensified = '1'.
screen-active = 1.
screen-display_3d = '1'.
MODIFY SCREEN.
ENDIF.
IF screen-group1 = 'RAD'.
screen-intensified = '0'.
screen-active = 0.
screen-display_3d = '0'.
MODIFY SCREEN.
ENDIF.
IF screen-group1 = 'CAD'.
screen-intensified = '0'.
screen-active = 0.
screen-display_3d = '0'.
MODIFY SCREEN.
ENDIF.
ENDLOOP.
ENDIF.

*CLICK OF SECOND RADIO
IF pb = 'X'.
sscrfields-functxt_02 = 'Sales And Distribution'.
WRITE icon_ws_ship AS ICON TO text_001.
LOOP AT SCREEN.
IF screen-group1 = 'RAD'.
screen-intensified = '1'.
screen-active = 1.
screen-display_3d = '1'.
MODIFY SCREEN.
ENDIF.
IF screen-group1 = 'MOD'.
screen-intensified = '0'.
screen-active = 0.
screen-display_3d = '0'.
MODIFY SCREEN.
ENDIF.
IF screen-group1 = 'CAD'.
screen-intensified = '0'.
screen-active = 0.
screen-display_3d = '0'.
MODIFY SCREEN.
ENDIF.
ENDLOOP.
ENDIF.

*CLICK OF THIRD RADIO BUTTON
IF pc = 'X'.
sscrfields-functxt_03 = 'Human Resources'.
WRITE icon_new_employee AS ICON TO text_001.
LOOP AT SCREEN.
IF screen-group1 = 'RAD'.
screen-intensified = '0'.
screen-active = 0.
screen-display_3d = '0'.
MODIFY SCREEN.
ENDIF.
IF screen-group1 = 'MOD'.
screen-intensified = '0'.
screen-active = 0.
screen-display_3d = '0'.
MODIFY SCREEN.
ENDIF.
IF screen-group1 = 'CAD'.
screen-intensified = '1'.
screen-active = 1.
screen-display_3d = '1'.
MODIFY SCREEN.
ENDIF.
ENDLOOP.
ENDIF.

*CUSTOMISING THE TOOLBARS OF THE SELECTION SCREEN
*WITH F8 BUTTON DISABLED

APPEND : 'PRIN' TO it_ucomm,
'SPOS' TO it_ucomm,
'ONLI' TO it_ucomm.

CALL FUNCTION 'RS_SET_SELSCREEN_STATUS'
EXPORTING
p_status = sy-pfkey
TABLES
p_exclude = it_ucomm.

**EVENT ON THE SELECTION
AT SELECTION-SCREEN.

*LIST BOX ONE VALUES
CASE one.
WHEN '1'.
mmtable = 'MARC'.
WHEN '2'.
mmtable = 'MARA'.
WHEN '3'.
mmtable = 'MARD'.
WHEN '4'.
mmtable = 'MARM'.
ENDCASE.
*LIST BOX TWO VALUES
CASE two.
WHEN '1'.
sdtable = 'VBAK'.
WHEN '2'.
sdtable = 'VBAP'.
WHEN '3'.
sdtable = 'VBUK'.
WHEN '4'.
sdtable = 'VBUP'.
ENDCASE.
*LIST BOX THREE VALUES
CASE three.
WHEN '1'.
hrtable = 'PA0001'.
WHEN '2'.
hrtable = 'PA0006'.
WHEN '3'.
hrtable = 'PA0022'.
WHEN '4'.
hrtable = 'PA0008'.
ENDCASE.

*VALUES FOR CLICK OF THE PUSHBUTTON ON APP TOOLBAR
*AND ENABLING THE BUTTONS TO PERFORM F8

CASE sscrfields-ucomm.
WHEN 'FC01'.
tablename = mmtable.
sscrfields-ucomm = 'ONLI'.
WHEN 'FC02'.
tablename = sdtable.
sscrfields-ucomm = 'ONLI'.
WHEN 'FC03'.
tablename = hrtable.
sscrfields-ucomm = 'ONLI'.
ENDCASE.

*INITIALIZATION EVENT
INITIALIZATION.

*VALUES ASSIGNED TO DROPDOWNLISTS IN THE SUBROUTINES
PERFORM f4_value_request_pa.
PERFORM f4_value_request_pb.
PERFORM f4_value_request_pc.

*START OF SELECTION EVENT
START-OF-SELECTION.

*SUBROUTINE TO PROVIDE DROPDOWN VALUES TO LIST1
FORM f4_value_request_pa.
DATA: l_name TYPE vrm_id,
li_list TYPE vrm_values,
l_value LIKE LINE OF li_list.

l_value-key = '1'.
l_value-text = 'Plant Data for Material'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '2'.
l_value-text = 'General Material Data'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '3'.
l_value-text = 'Storage Location Data for Material'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '4'.
l_value-text = 'Units of Measure for Material'.
APPEND l_value TO li_list.
CLEAR l_value.

l_name = 'ONE'.

CALL FUNCTION 'VRM_SET_VALUES'
EXPORTING
id = l_name
values = li_list
EXCEPTIONS
id_illegal_name = 1
OTHERS = 2.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

ENDFORM. " f4_value_request_tabname

*SUBROUTINE TO PROVIDE DROPDOWN VALUES TO LIST2
FORM f4_value_request_pb.

DATA: l_name TYPE vrm_id,
li_list TYPE vrm_values,
l_value LIKE LINE OF li_list.

l_value-key = '1'.
l_value-text = 'Sales Document: Header Data'.
APPEND l_value TO li_list.
CLEAR l_value.
l_value-key = '2'.
l_value-text = 'Sales Document: Item Data'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '3'.
l_value-text = 'Sales Document:Header Status'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '4'.
l_value-text = 'Sales Document: Item Status'.
APPEND l_value TO li_list.
CLEAR l_value.
l_name = 'TWO'.

CALL FUNCTION 'VRM_SET_VALUES'
EXPORTING
id = l_name
values = li_list
EXCEPTIONS
id_illegal_name = 1
OTHERS = 2.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

ENDFORM. " f4_value_request_PB

*SUBROUTINE TO PROVIDE DROPDOWN VALUES TO LIST3

FORM f4_value_request_pc.
DATA: l_name TYPE vrm_id,
li_list TYPE vrm_values,
l_value LIKE LINE OF li_list.
l_value-key = '1'.
l_value-text = 'HR Master :Infotype 0001 (Org. Assignment)'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '2'.
l_value-text = 'Address Infotype 0006'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '3'.
l_value-text = 'Education Infotype 0022'.
APPEND l_value TO li_list.
CLEAR l_value.

l_value-key = '4'.
l_value-text = 'Basic Pay Infotype 0008'.
APPEND l_value TO li_list.
CLEAR l_value.

l_name = 'THREE'.

CALL FUNCTION 'VRM_SET_VALUES'
EXPORTING
id = l_name
values = li_list
EXCEPTIONS
id_illegal_name = 1
OTHERS = 2.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

ENDFORM. " f4_value_request_PC

FORM output.

DATA p_table(10).
p_table = tablename.

*popup to display the selected table and
*Continue button is clicked
CALL FUNCTION 'POPUP_TO_DISPLAY_TEXT'
EXPORTING
titel = 'User Selections '
textline1 = p_table
textline2 = 'is the Selected table'
start_column = 25
start_row = 6.

*assigning the table value in p_table to the
*Table in SE16 transaction by explicitly calling

SET PARAMETER ID 'DTB' FIELD p_table.
CALL TRANSACTION 'SE16'.

ENDFORM. "OUTPUT

Dynamic Table Selection

noreply@blogger.com (Oka) — Wed, 25 Apr 2012 23:00:00 -0700

REPORT zdany_dynamic_select.

* We use some parameters to dynamically control the select, this is not very
* clever but this is just a test program !!
PARAMETER : p_tabnam TYPE tabname DEFAULT 'SFLIGHT',
p_selfl1 TYPE edpline DEFAULT 'CARRID',
p_selfl2 TYPE edpline DEFAULT 'CONNID',
p_selfl3 TYPE edpline DEFAULT 'FLDATE',
p_selfl4 TYPE edpline DEFAULT 'PRICE',
p_selfl5 TYPE edpline DEFAULT 'CURRENCY',
p_where1 TYPE edpline DEFAULT 'PRICE > 300',
p_where2 TYPE edpline DEFAULT 'AND CURRENCY = ''EUR'''.

FIELD-SYMBOLS : TYPE ANY TABLE,
TYPE ANY,
TYPE ANY.

DATA: lt_where TYPE TABLE OF edpline,
lt_sel_list TYPE TABLE OF edpline,
lt_group TYPE TABLE OF edpline,
l_having TYPE string,
l_wa_name TYPE string,
l_sel_list TYPE edpline,
dref TYPE REF TO data,
itab_type TYPE REF TO cl_abap_tabledescr,
struct_type TYPE REF TO cl_abap_structdescr,
elem_type TYPE REF TO cl_abap_elemdescr,
comp_tab TYPE cl_abap_structdescr=>component_table,
comp_fld TYPE cl_abap_structdescr=>component.

TYPES: f_count TYPE i.

* Creation of the output table including a non standard field, f_count
* see ABAP FAQ #14 for more information on this topic
struct_type ?= cl_abap_typedescr=>describe_by_name( p_tabnam ).
elem_type ?= cl_abap_elemdescr=>describe_by_name( 'F_COUNT' ).
comp_tab = struct_type->get_components( ).

* We remove the unnecessary fields
LOOP AT comp_tab INTO comp_fld.
IF comp_fld-name <> p_selfl1 AND
comp_fld-name <> p_selfl2 AND
comp_fld-name <> p_selfl3 AND
comp_fld-name <> p_selfl4 AND
comp_fld-name <> p_selfl5.
DELETE TABLE comp_tab WITH TABLE KEY name = comp_fld-name.
ENDIF.
ENDLOOP.

comp_fld-name = 'F_COUNT'.
comp_fld-type = elem_type.
APPEND comp_fld TO comp_tab.

struct_type = cl_abap_structdescr=>create( comp_tab ).
itab_type = cl_abap_tabledescr=>create( struct_type ).

l_wa_name = 'l_WA'.
CREATE DATA dref TYPE HANDLE itab_type.
ASSIGN dref->* TO .
CREATE DATA dref TYPE HANDLE struct_type.
ASSIGN dref->* TO .

* Creation of the selection fields and the "group by" clause
APPEND p_selfl1 TO lt_sel_list.
APPEND p_selfl1 TO lt_group.
APPEND p_selfl2 TO lt_sel_list.
APPEND p_selfl2 TO lt_group.
APPEND p_selfl3 TO lt_sel_list.
APPEND p_selfl3 TO lt_group.
APPEND p_selfl4 TO lt_sel_list.
APPEND p_selfl4 TO lt_group.
APPEND p_selfl5 TO lt_sel_list.
APPEND p_selfl5 TO lt_group.
APPEND 'COUNT(*) AS F_COUNT' TO lt_sel_list.

* creation of the "where" clause
APPEND p_where1 TO lt_where.
APPEND p_where2 TO lt_where.

* Creation of the "having" clause
l_having = 'count(*) >= 1'.

* THE dynamic select
SELECT (lt_sel_list)
FROM (p_tabnam)
INTO CORRESPONDING FIELDS OF TABLE
WHERE (lt_where)
GROUP BY (lt_group)
HAVING (l_having)
ORDER BY (lt_group).

* display of the results
LOOP AT ASSIGNING .
LOOP AT comp_tab INTO comp_fld.
ASSIGN COMPONENT comp_fld-name OF STRUCTURE TO .
WRITE: .
ENDLOOP.
SKIP.
ENDLOOP.

Field Catalog Options In ALV

noreply@blogger.com (Oka) — Thu, 15 Mar 2012 00:51:00 -0700

Added by Hareesh Menon, last edited by kishan P on Jan 13, 2012 (view change)

Field catalog options :

FIELDNAME:

You use this field to assign a field name of your output table to a row of the field catalog. All settings that you make in this row refer to the corresponding column of the output table.

REF_FIELD:

You must fill this field if:

• the output table field described by the current entry in the field catalog has a corresponding field in the Data Dictionary and

• the field name in the output table is not identical to the field name of the field in the Data Dictionary.

If the field names are identical, it is sufficient to specify the DDIC structure or table in field REF_TABLE of the field catalog.

REF_TABLE:

You must fill this field only if the output table field described by the current entry in the field catalog has a corresponding entry in the Data Dictionary. Using this assignment, the ALV Grid Control can copy the text for the column header from the Dictionary.

CHECKBOX:

Outputting a checkbox. The checkbox cannot be modified by the user.

COL_POS:

Relevant only if the relative column positions should not be identical to the sequence of fields in the field catalog when the list is displayed for the first time. The parameter determines the relative column position of the field for list output. The user can interactively modify the order of the columns. If this parameter is initial for each field catalog entry, the order of the columns corresponds to the sequence of fields in the field catalog.

DO_SUM:

If this field is set, the ALV uses this field to calculate the total (this corresponds to the generic totals function in the toolbar.)

EMPHASIZE:

If the field is set to 'X', the ALV uses a pre-defined color for highlighting the column. If it is set to 'Cxyz' (color code), the remaining numbers have the following meaning:

• x: color number

• y: intensified display on/off

• z: inverse display on/off

HOTSPOT:

If this field is set, all cells of this column are hotspot-sensitive.

HREF_HNDL:

Handle to which an URL is assigned. The ALV Grid Control displays all cells of the column as hyperlinks. You must maintain the target address of the hyperlink in a table of type LVC_T_HYPE and pass it using set_table_for_first_display.

KEY:

If this field is set, the ALV Grid Control color-codes the column as a

key field and fixes this column during horizontal scrolling. The order of the key columns in the ALV Grid Control can be modified interactively. In contrast to the SAP List Viewer, the ALV Grid Control allows you to directly hide key columns with NO_OUT

LOWERCASE:

If this field is set, the ALV Grid Control recognizes upper/lower case in the output table. This affects the sorting of fields, for example.

NO_OUT:

If you set this field, you hide the relevant column in the list. Nevertheless, the column is available in the field selection and can be interactively selected by the user as a display field. The ALV displays the contents of hidden fields on the detail screen for a row in the grid control.

NO_MERGING:

If this field is set, cells with the same value are not merged into a single cell when this column is sorted.

NO_SUM:

If you set this field, you lock totals calculation for the relevant field.

OUTPUTLEN:

Determines the column width of the field:

• If the field has a reference to the Data Dictionary, you can leave the field set to its initial value. In this case, the ALV adopts the output length of the relevant domain.

• For fields without reference to the DDIC, you must specify the desired field output length.

STYLE:

Displays all cells of this column with a style e.g. as pushbuttons. Constants "MC_STYLE..." of the class "cl_gui_alv_grid" can be passed to this field.

TECH:

If this field is set, the relevant field is not displayed on the list and cannot be shown interactively. The field is only known in the field catalog. (For example, it must not be specified as a sorting criterion).

DECIMALS_O:

If a field has no currency, then you can use this field to determine the number of decimal places to be displayed. This setting is kept even if you afterwards assign a currency field to this field or assign a currency to the CURRENCY field of the field catalog.

DECMFIELD:

Defining the digits after the comma on a row-by-row basis. You can use an additional field in the output table to determine how many digits are to be displayed after the comma in each row.

EDIT_MASK:

If you set a conversion exit (for example, conv = ' ==ALPHA ' for function module CONVERSION_EXIT_ALPHA_OUTPUT ), you enforce output conversion for the associated output field.

ICON:

If this field is set, the column contents of the output table are output as an icon. The column contents must consist of valid icon strings ( (xx) or @xx\Q @ ). You should consider the problem of printing icons.

JUST:

Relevant only to fields of data type CHAR or NUMC. Justifications:

• 'R': right justified

• 'L': left justified

• 'C': centered

How the column header is justified, depends on how the column contents are justified. You cannot justify the column header separately.

LZERO:

Relevant only to fields of data type NUMC. In the default setting, the

ALV Grid Control displays these fields right justified without leading zeros. If you set LZERO, leading zeros are displayed.

NO_SIGN:

Relevant only to value fields. If you set NO-SIGN, values are displayed without signs.

NO_ZERO:

If NO_ZERO is set, no zeros are displayed for initial value fields. The cell remains empty.

COLDDICTXT:

Relevant only to fields with reference to the Data Dictionary. You use values 'L', 'M', 'S' or 'R' to determine if SCRTEXT_L, SCRTEXT_M, SCRTEXT_S or REPTEXT is used as the column header.

COLTEXT:

Determines the column header of the column. You should assign a value to this field if it does not have a Data Dictionary reference.

REPTEXT:

Relevant only to fields with reference to the Data Dictionary. For such fields, the ALV Grid Control copies the field label for the header of the corresponding data element into this field.

SCRTEXT_L:

Relevant only to fields with reference to the Data Dictionary. For such fields, the ALV Grid Control copies the long field label of the corresponding data element into this field.

SCRTEXT_M:

Relevant only to fields with reference to the Data Dictionary. For such fields, the ALV Grid Control copies the medium field label of the corresponding data element into this field.

SCRTEXT_S:

Relevant only to fields with reference to the Data Dictionary. For such fields, the ALV Grid Control copies the short field label of the corresponding data element into this field.

SELDDICTXT:

Relevant only to fields with reference to the Data Dictionary. You use values 'L', 'M', 'S' or 'R' to determine if SCRTEXT_L, SCRTEXT_M, SCRTEXT_S or REPTEXT is used as the text for column selection.

SELTEXT:

Determines the text to be used in the column selection for the column. You should assign a value to this field if it does not have a Data Dictionary reference.

TIPDDICTXT:

Relevant only to fields with reference to the Data Dictionary. You use values 'L', 'M', 'S' or 'R' to determine if SCRTEXT_L, SCRTEXT_M, SCRTEXT_S or REPTEXT is used as the tool tip.

TOOLTIP:

Determines the text to be used as the tool tip for the column. You should assign a value to this field if it does not have a Data Dictionary reference.

Maintain Message Class Validation and Substitution

noreply@blogger.com (Oka) — Wed, 10 Aug 2011 23:35:00 -0700

Table GB02C is table for Link Message Class and Validation or Substitution. For Modify this table use program RGUGBR28 and generate coding with program RGUGBR00 after change message class.

SAP Error : System error (termination point Document Number Replacement)

noreply@blogger.com (Oka) — Tue, 26 Jul 2011 18:57:00 -0700

In my SAP System implement splitting document, when try upload journal occurs error below :
Error analysis
    Short text of error message:
    System error (termination point Document Number Replacement)

    Long text of error message:
     Diagnosis
         An internal error has occurred.
     System Response
         You cannot continue with processing.
     Procedure
         Contact SAP to establish whether the error can only be rectified by
         a program correction, or whether it can also be rectified by
         changes to the settings. There may also be an error in the updating
         of the data which must be resolved.
         Specify the following parameters when reporting the error:
         o   Message           : GLT0/000
         o   Program           :
         o   Termination point : Document Number Replacement

    Technical information about the message:
    Message class....... "GLT0"
    Number.............. 000
**********************************
After debug why this happen, I found that there are summarization procedure for not unique item journal.
My solution is make unique line item journal in field assignment.

How to import SAP Script to Text File

noreply@blogger.com (Oka) — Sun, 24 Jul 2011 20:00:00 -0700

To IMPORT/EXPORT SAP Script we can used standard sap program RSTXSCRP.

Fill object name with name of sap script form and Execute (F8)

oka

User Exit for Validation (GGB0)

noreply@blogger.com (Oka) — Wed, 22 Jun 2011 21:19:00 -0700

For create complex validation role you can copy program RGGBR000 into ZRGGBR000 and then maintain table for assign new program ZRGGBR000 in tcode GCX2.After define role and activate, user exit will be available on validation.

BOM not loading in CK11N

noreply@blogger.com (Oka) — Wed, 22 Jun 2011 18:55:00 -0700

I Have experience when running tcode CK11N, in tab Qty Struc. BOM data is empty. Why ?
I'm try find the solution in Uncle Google, but not found the right answer.

After asking my PP friend the solution is check setting in Material Master Tab MRP 2 for Procurement type should be "E" In-house production.

Set this field to "E" and CK11N will be running well.

~Oka~

Add fields for Substitutions In Accounting Document (OBBH)

noreply@blogger.com (Oka) — Thu, 28 Apr 2011 01:19:00 -0700

How to add new fields Cost Center (KOSTL) for substitutions in accounting transaction ?

Modify view VWTYGB01 in SM30 where boolclass = '009' and classtype = 'S' and bcltab = 'BSEG' and bclfield = 'KTOSL' untick fields BEXCLUDE
Running Report RGUGBR00 and fill Application area with 'FI' and tick item that you want to generate.

Now fields KOSTL will be turn up in Substitution.

hope it's helpful

Why in New GL Receive Asset From PO posted to Dummy PC

noreply@blogger.com (Oka) — Wed, 6 Apr 2011 19:48:00 -0700

I have experience when try to receive asset from PO (MIGO/MB01) FI posted for line item asset fill profit center Dummy. I'm check setting in material master and asset master data to find is profit center / cost center right value and noting wrong.
Finally I'm try to debug the program and I'm found even in substitution we change profit center to right value but after step substitution the profit center value change again to Dummy PC, this step read from table V_T8A30 (3KEH). Correction this problem just setting derivation role for profit center in tcode 3KEI.
After setting this derivation role, my FI document fill right profit center.
Summary : Even in new GL this classic setting have to customizing.

Cheers
Oka

SAP Note 325546 - CO line item reports : Creating a user-defined field

noreply@blogger.com (Oka) — Wed, 30 Mar 2011 23:05:00 -0700

Base on sap note 325546, I will give example for add new fields Order type to report KOB1.

Go to tcode SM34 and maintain view table V_TKALV add new fields ZZAUART in structure KAEP_COAC, field group "K".
Go to sap enhancement SMOD and entry Enhancement project COOMEP01 and click button test run. double click include table CI_RKPOS and add new component ZZAUART component type AUFART. Then activated structure CI_RKPOS.
Double click FM EXIT_SAPLKAEP_001. In area Function module double click ZXKAEPU01 to create include file. Add this code
CHECK i_rep_object = 'OR'.

SELECT SINGLE auart INTO cs_record-zzauart
FROM aufk
WHERE aufnr = cs_record-aufnr.
Activated ZXKAEPU01 and then actived COOMEP01.

Now you can see in KOB1 fields order type in line item data.

(Oka)

RFCEXEC

noreply@blogger.com (Oka) — Mon, 7 Mar 2011 06:10:00 -0800

You can see it in SM59 -> TCP/IP Connection -> SERVER_EXEC -> System Information -> Function list.

RFC_RAISE_ERROR !!! FOR INTERNAL USE ONLY !!!

RFC_REMOTE_EXEC allows to start programs and to pipe an internal table into
stdin without waiting for the program to end.

IMPORTING
   COMMAND        C(256)
     program name.
TABLES
   PIPEDATA       C(80)
     internal table serves as input to the started program.

RFC_REMOTE_FILE allows to read or write text files.

IMPORTING
   FILE           C(256)
     file name
   WRITE          C(1)                 (Default SPACE)
     if WRITE is 'X' the internal table is written to the file,
     else it is filled from the file.
TABLES
   FILEDATA       C(80)
     internal table serves as input to the file, if WRITE is 'X'
     else it is filled from the file.

RFC_REMOTE_PIPE allows to start programs and to pipe an internal table into
stdin. The caller waits until the program ends.

IMPORTING
   COMMAND        C(256)
     program name
   READ           C(1)                 (Default SPACE)
     if READ is 'X' the internal table is filled from stdout
     instead of being piped into stdin.
TABLES
   PIPEDATA       C(80)
     internal table serves as input to the started program, if
     READ is 'X' it is filled by the started program instead.

Example
CALL FUNCTION 'RFC_REMOTE_PIPE'
   DESTINATION i_dest
   EXPORTING
    command               = l_command
     read                  = 'X'
   TABLES
     pipedata              = t_flist
   EXCEPTIONS
    system_failure        = 1 MESSAGE errmsg
      communication_failure = 2 MESSAGE errmsg.
   IF sy-subrc NE 0.
     IF sy-subrc = 1.
       MESSAGE errmsg TYPE 'I' RAISING system_failure.
     ELSE.
       MESSAGE errmsg TYPE 'I' RAISING rfc_connection.
     ENDIF.
     EXIT.
   ENDIF.

RFC_MAIL
allows to send mail via e-mail (example only).

IMPORTING
   USER           C(256)
     user name (e-mail address).
TABLES
   MAIL           C(80)
     internal table containing mail.

RFC_START_PROGRAM allows to start programs without waiting for the program to end
Only available via explizit call of RfcAllowStartProgram

IMPORTING
   COMMAND        C(512)
     program name.

EXPORTING
   ERROR          C(255)
     Error text.

RFC_SET_REG_SERVER_PROPERTY Set different properties for an registered server

IMPORTING
   EXCLUSIV(1): 'Y': Start exclusiv use of this reg. server
                'N': Stop exclusiv use of this reg. server
                'E': Disconnect

API_CREATE_TID creates a transaction-ID for transactional RFC
ONLY FOR tRFC BETWEEN EXTERNAL PROGRAMS

EXPORTING
   TID(24)

RFC_START_GUI starts SAPGUI on FrontEnd system for working
with Function Module needed Input/Output on SAPGUI

IMPORTING
   STGUICMD(255)

API_CLEAR_TID calls function noted by RfcGetTransID()
INTERNAL USE: CONFIRMATION OF EXECUTED LUW

IMPORTING
   CALLID(64)

ARFC_DEST_CONFIRM calls function noted by RfcGetTransID()
INTERNAL USE: CONFIRMATION OF EXECUTED LUW

IMPORTING
   CALLID(64)

ARFC_DEST_SHIP
INTERNAL USE: PLAYBACK OF RECORDED RFC DATA
TABLES
    DATA LIKE ARFCSDATA
   STATE LIKE ARFCSSTATE

RFC_DOCU returns this text.

TABLES
   DOCU           C(80)
     contains documentation text.

RFC_PING2 connection test.
#+ load test

RFC_PING connection test.

RFC_SYSTEM_INFO gives some informations about the execution environment.

EXPORTING
   RFCSI_EXPORT   LIKE RFCSI

SAP Online Help PDFs

noreply@blogger.com (Oka) — Thu, 3 Mar 2011 20:46:00 -0800

SAP Online Help PDFs

http://www.consolut.com/
The following PDF files contain the 4.6C descriptions of the SAP R/3 environment. With an installed SAP system, you can teach yourself in SAP. This SAP Online Help is really complete especially concerning the business processes and can be printed very easy.

PDF Files

ABAP/4 OLE Automation Controller

ABAP Programming (BC-ABA)

Activity-Based Costing

Activity-Based Costing (CO-OM-ABC)

Actual Costing / Material Ledger

Advance Payments

ALE in Profit Center Accounting (EC-PCA-TL)

ALE Introduction and Administration

ALE Programming Guide

ALE Quick Start

ALE QuickStart for Distributed HR

ALE Scenarios in Asset Accounting

ALE Scenarios in Personnel Cost Planning

ALV Gird Control (BC-SRV-ALE)

APIs for Logistics

Archiving Application Data (CA-ARC)

Archiving Application Data (FI)

Argentina

Arrears Processing for Deductions

Assembly-to-order (LO-ASM)

Asset Accounting (FI-AA)

Asset Information for Intranets (FI-AA)

Availability Check and Requirements in Sales and Distribution

Balance Sheet Valuation (MM-IM-VP)

Bank Accounting (FI-BL)

Banks (PA-PA)

BAPI ActiveX Control

BAPI Programming Guide (CA-BFA)

BAPI User Guide (CA-BFA)

Basic Data (QM-PT-BD)

Basic Functions (SD-FT-PRO)

Basic Functions

Basic Functions and Master Data in SD Processing (SD-BF)

Basis (BC)

Basis

Batch Management (LO-BM)

BC - ABAP Dictionary

BC ABAP Workbench Tools

BC ABAP Workbench Tutorial

BC Basis Programming Interfaces

BC - Business Workplace

BC - Central Maintenance and Transport Objects

BC Data Modeler

BC Documentation of System Objects

BC Extended Applications Function Library

BC - Namespaces and Naming Conventions (BC-CTS-NAM)

BC R/3 Database Guide:DB2/400

BC R/3 Database Guide: DB2 Universal Database for UNIX & Windows

BC R/3 Database Guide: Informix

BC SAPconnect

BC SAP Graphics: Programming Interfaces

BC SAP Graphics: User's Guide

BC - SAP Printing Guide

BC SAPscript Raw Data Interface

BC SAPscript: Printing with Forms

BC - SAP Style Guide

BC Style and Form Maintenance

BC System Services

BC The SAP Communications Server

BC - Word-Processing in the SAPscript Editor

Benefits (PA-BN)

Billing (SD-BIL)

Billing Plan (SD-BIL-IV)

Brazil

Business Area (FI)

Business Configuration Sets (BC-CUS)

Business Document Service (BC-SRV-BDS)

Business Partner Master Data (LO-MD-BP)

CA - Cross-Application Components: Workflow Scenarios

CA - Cross-Application Functions

CAD Interface (CA-CAD)

CA - Drilldown Reporting

CA Extended Table Maintenance

CA - Message Control (CA-GTF-BS)

Capacity Evaluation (PP-CRP-ALY)

Capacity Leveling (PP-CRP-LVL)

Capacity Leveling in PP-SOP and LO-LIS-PLN

Capacity Planning in Customer Service and Plant Maintenance

Capacity Planning in Long-term Planning

Capacity Planning in MPS and MRP

Capacity Planning in Process Industries

Capacity Planning in Repetitive Manufacturing

Capacity Planning in Sales and Distribution

Capacity Planning in Shop Floor Control (PP-SFC)

Capacity Planning in the Project System

Cash Management (TR)

CATT: Computer Aided Test Tool (BC-CAT-TOL)

CATT: Enhanced Mode (BC-CAT-TOL)

CBI Question & Answer Database

Central Adress Management (BC-SRV-ADR)

Change and Transport System - Overview (BC-CST)

Changing the SAP Standard (BC)

Characteristics (CA-CL-CHR)

Classification System (CA-CL)

Client Copy and Support

Closing and Reporting (FI)

Collaborative Engineering & Project Management

Computing Center Management System (BC-CCM)

Concept Check Tool

Coding Block

CO External Data Transfer

Colombia

Commitments Management (CO)

Communication / Printing (SD-FT-COM)

Compensation Management (PA-CM)

Components of the Logistics Information System (LIS)

Consolidation (EC-CS)

Controlling (CO)

Controls Tutorial (BC-CI)

Country Versions

Consolidation (FI-LC)

Configuration Management (LO-CM)

Confirmation

Connecting to External Time Management Systems

Connecting to SAP CAMPBELL Personnel Administration

Connection with External Time Recording Systems

Consumption-Based Planning (MM-CBP)

Controlling (CO)

Conversion to the Euro in Human Resources

Cost Center Accounting (CO-OM-CCA)

Costs

Country Versions

Credit and Risk Management (SD-BF-CM)

Cross-Application Components (CA)

Cross-Application Mass Maintenance (CA-GTF-MS)

Cross-System Planning Situation (CA-BFA)

Customer Service (CS)

Customer Service Processing (BC-SLS-OA)

Customizing (BC-CUS)

Customizing System Settings (BC-CUS)

Customizing Cross-System Tools

Cross-Application Time Sheet (CA-TS)

Dangerous Goods Management (EHS-DGP)

Data Retention Tool (DART)(CA-GTF-DRT)

Database Administration (Oracle) with SAPDBA

Dates

DCOM Connector Logon Component

Decentralized Warehouse Management (LE-IDW)

Defects Recording (QM-IM-RR-DEM)

Demand Management (PP-MP-DEM)

Derivatives

Desktop Office Integration (BC-CI)

Developing an Infotype (Planning)

Developing an Infotype in Personnel Administration

Direct and Indirect Quotation for Exchange Rates

Distributed Contracts (MM-PUR, MM-SRV)

Distributed Profitability Analysis (CO-PA)

Distribution Resource Planning (PP-SOP-DRP)

Documents

Document Management

Documentary Payments (SD-FT-LOC)

Documentation Maintenance

Dynamic Modification of the Inspection Scope

Early Warning System: Overview

Editor for Functions and Operations (PY-XX-TL)

Editor for Personnel Calculation Rules (PY-XX-TL)

Editor for Personnel Calculation Schemas (PY-XX-TL)

EH&S Environment, Health & Safety

Electronic Account Statement (FI-BL)

Electronic Data Interchange / IDoc Interface (SD-EDI)

Employee Self-Service

Employment and Salary Verification in the Internet (PA-PA-US)

Enhancements, Modifications... (CA-BFA)

Engineering Change Management

Engineering Workbench (PP-BD)

Entering Measurement and Counter Readings in the Internet

Entering Planning Data in the Workflow (CO-PA)

Enterprise Controlling (EC)

Enterprise Organization (CO)

Enterprise Modelling - Consultant's Handbook

Environment, Health & Safety

European Monetary Union: Euro (CA-EUR)

Evaluating the Payroll Results using Infotypes or the Logical Database

Executive Information System and Business Planning

Expert Mode

External Data Transfer

External Services Management (MM-SRV)

External Supply of the Time Sheet

Features Editor

FI Accounts Receivable and Accounts Payable

Financial Accounting (FI)

Financial Accounting - General Topics

FI Financial Accounting: Data Transfer Workbench

Financial Information System (FI)

FI/SD - Credit Management/Risk Management

FI - Special Purpose Ledger

Flexible General Ledger (FI-GL)

Forecasting (LO-PR)

Foreign Exchange

Foreign Trade / Customs (SD-FT)

Funds Management

General Ledger Accounting (FI-GL)

General Report Selection

Generic Business Tools for Application Developers (BC-SRV-GBT)

Generic Object Service (BC-SRV-GBT)

Getting Started

Goods Receipt Process for Inbound Deliveries

GR/IR Account Maintenace (MM-IM-VP)

Handeling Unit Management (LO-HU)

How do I use the Reuse Library?

Human Resources (HR)

HR Form Editor (PY-XX-TL)

HR Forms Workplace (PY-XX-FO)

HR Funds and Position Management (PA-PM)

HR - Human Resource Management

HR Infotypes

HR Tools (PY-XX-TL)

HTMLBusiness Language Reference

Hypertext Structure Maintenance (BC-DOC-DTL)

IACs for External Services Management (MM-SRV)

IACs in Foreign Trade

IDoc Class Library (BC-FES-AIT)

IDoc Connector for XML Component (BC-FES-AIT)

IDoc Interface: EDI

IDoc Interface / Electronic Data Interchange (BC-SRV-EDI)

IM - Investment Management

Implementation Assistant

Import Basis Module (SD-FT-IMP)

Incentive Wages: Overview

Inflation Accounting

Information System

Inspection Data Interface (QM-IDI)

Inspection Lot Completion (QM-IM-UD)

Inspection Lot Creation (QM-IM-IL)

Inspection Planning (QM-PT-IP)

Inspection Planning with the Engineering Workbench

Integration with SAP Business Workflow

Interfaces to Accounting (AC)

Interface Toolbox in Human Resources (PX-XX-TL)

Interfaces to the Project System

Internal Orders (CO-OM-OPA)

Internal Service Request

Internet Application Development with Flow Flies: Reference

Internet Application Development with Flow Flies: Tutorial

Internet Time Sheet

Introduction to BPML

Introduction: Overview

Introduction to Data Archiving (CA-ARC)

Inventory Management and Physical Inventory (MM-IM)

Inventory Sampling (MM-IM-PI)

Investment Management (IM)

ITS Administration Guide

ITS Implementation Models

ITS System Templates

ITS User Management

Job Search

KANBAN on the Internet (PP-KAB-CRL)

Language Transport (BC-CTS-LAN)

Legal Control (SD-FT-CON)

LE - Logistics Execution

Library of ALE Business Processes

Line Design

Loans

Loans Management (TR-LO)

LO - General Logistics Workflow Scenarios

Logistics Execution (LE)

Logistics - General (LO)

Logistics General (LO)

Logistics Information System (LO-LIS)

Logistics Invoice Verification (MM-IV-LIV)

LO Logistics General

Long-Term Planning (PP-MP-LTP)

Maintenance Bills of Material (PM-EQM-BM)

Maintenance Planning

Maintenance Task Lists

Manager's Desktop (PA-MA)

Managing Special Stocks (MM-IM)

Market Risk Management

Master Data Distribution (Human Resources)

Material

Materials Management (MM)

Material Master

Material Requirements Planning

Memory Management (BC-CST-MM)

Messages 6.2 (BC)

Messages 7.2 (BC)

Mexico

Migration/Upgrading to Oracle Version 8.1.5: UNIX

MM Component Short Description

MM Materials Management

MM - Materials Management: Workflow Scenarios

MM - Material Price Change (MM-IV-MP)

MM MM-MOB and WM-LSR Interfaces

MM Vendor Evaluation

Model Company Great Britain (PY-GB)

Money Market

Network Integration Guide (BC-NET)

Notifications (CA-NO)

Objects on Loan/Internal Control (PA-PA)

Off-Cycle Activities

Old and New Processing of Averages

Order BOMs

Organizational Plan Mode

Other Countries (PY-XX)

Other Single Roles

Output Determination (SD)

PA - Personnel Management: Workflow Scenarios

Partial Period Remuneration (Factoring)

Payments

Payment Card Processing

Payment Program for Payment Requests (FI-BL)

Payment Release

Payroll Account (Report RPCKTOx0;HxxCKTO0)

Payroll Argentina (PY-AR)

Payroll Australia (PY-AU)

Payroll Austria (PY-AT)

Payroll Basics (PY-XX-BS)

Payroll Belgium (PY-BE)

Payroll Brazil (PY-BR)

Payroll Canada(PY-CA)

Payroll Denmark (PY-DK)

Payroll France (PY-FR)

Payroll Germany (PY-DE)

Payroll Great Britain (PY-GB)

Payroll Hong Kong (PY-HK)

Payroll in a Background Operation

Payroll Indonesia (PY-ID)

Payroll in the SAP System

Payroll Ireland (PY-IE)

Payroll Italy (PY-IT)

Payroll Japan (PY-JP)

Payroll Journal (Report RPCLJNx0;HxxCLJN0)

Payroll Malaysia (PY-MY)

Payroll Mexico (PY-MX)

Payroll New Zealand (PY-NZ)

Payroll Philippines (PY-PH)

Payroll Portugal (PY-PT)

Payroll Singapore (PY-SG)

Payroll Spain (PY-ES)

Payroll Sweden (PY-SE)

Payroll Taiwan (PY-TW)

Payroll Thailand (PY-TH)

Payroll United States (PY-US)

Payroll Venezuela (PY-VE)

Payroll South Africa (PY-ZA)

Payroll Switzerland (PY-CH)

Pension Fund CH: Reference Guide

Pension Fund CH: Technical User Handbook

Pension Fund CH: User Hand Book

Performance Monitor

Periodic Declarations

Personnel Administration

Personnel Cost Planning

Personnel Development

Personnel Time Management (PT)

Peru

Philippines

Plant Maintenance

Plant Maintenance and Customer Service (PM/CS)

PM/CS - Data Transfer in Plant Maintenance and Customer Service

PM/CS - Plant Maintenance & Customer Service: Workflow Scenarios

Posting (FI)

Posting to Accounting (PY-XX-DT)

PP Bills of Material Guide

PP - Capacity Planning

PP Component Short Description

PP PDC Interface

PP KANBAN

PP - PI-PCS Interface: Linking of Process Control

PP - Production Orders

PP - Work Centers

Preference

Preparations for Consolidation (FI)

Pricing and Conditions

Process Flow Hierarchy

Processing a Calibration Inspection

Product Catalog and Online Store on the Internet (LO-MD-AM)

Product Cost Controlling Information System (CO-PC-IS)

Product Cost Planning

Production lot planning / individual project planning

Production Planning and Control (PP)

Production Planning & Control Workflow Scenarios

Production Planning - Process Industries (PP-PI)

Production Resources/Tools (PRT)

Product Lifecycle Management (PLM)

Product Safety (EHS-SAF)

Product Structure Browser

Profitability Analysis (COPA)

Profit Center Accounting (EC-PCA)

Programming Utilities for the Logical Databases PNP and PAP

Project Estimator

Project Information System

Project Progress

Project System (PS)

Public-Key Technology

Purchasing (MM-PUR)

Quality Certificates

Quality Management

Quality Management (QM)

Quality Notifications

Quality-Related Costs (QM-IM-IC)

Question & Answer Database

QM in Procurement (QM-PT-RP-PR)

QM in Production

QM in Sales and Distribution (QM-PT-RP-SD)

QM/PM Partner Roles

QM - Quality Management: Data Transfer

QM - Quality Management: Workflow Scenarios

R/3 Database Management CONTROL (BC)

R/3 Database Manager DBMCLI (BC)

R/3 Database Manager DBMGUI (BC)

R/3 on IBM AS/400

Real Estate: Data Transfer (RE)

Real Estate Management

Real Estate Management (RE)

Recruitment

Reference Manual 7.2 (BC)

Remote Communications

Remuneration Statement (Report RPCEDTx0;HxxCEDTO)

Repetitive Manufacturing (PP-REM)

Replication Manager

Reporting in Human Resource Management

Report Programming in HR

Reports and Analyses (SD)

Repository Service Component (BC-FES-AIT)

RE Real Estate Management Archiving

RE Real Estate Management: Workflow Scenarios

Resources

Results Recording

Retroactive Billing

Revenues and Earnings

Reverse Buisness Engineer

RFC C++ Class Library (BC-FES-AIT)

RFC Java Class Library (BC-FES-AIT)

RFC Programming in ABAP

Room Reservation Management (PE-RPL)

Routings (PP-BD-RTG)

Salary Packaging

Sales (SD-SLS)

Sales and Distribution (SD)

Sales and Distribution

Sales and Distribution (SD) Workflow Scenarios

Sales and Operations Planning (LO-LIS-PLN)

Sales Employee (PA-PA)

Sales Support: Computer-Aided Selling (CAS)

Sample Management

SAP ArchiveLink (BC-SRV-ARL)

SAP ArchiveLink - Scenarios in Applications (BC-SRV-ARL)

SAP Automation

SAP Automation GUI Code Generator (BC-FES-AIT)

SAP Automation GUI Interfaces (BC-FES-AIT)

SAP Automation RFC and BAPI Interfaces (BC-FES-AIT)

SAP@Web Studio

SAP Business Partner (SAP BP)

SAP Business Workflow (BC-BMT-WFM)

SAP Business Workflow Demo Examples

SAP Communication: CPI-C Programming (BC-CST-GW)

SAP Communication: Configuration (BC-SRV)

SAP Container

SAP Control Framework

SAP Data Provider

SAP Exchange Connector (BC-SRV-COM)

SAP Graphics

SAP GUI for HTML

SAP High Availability (BC-CCM-HAV)

SAP HTML Viewer

SAP Internet Mail Gateway (BC-SRV-COM)

SAP Knowledge Provider (BC-SRV-KPR)

SAP License (BC-CST-SL)

SAP List Viewer (ALV): Classic

SAP MAPI Service Provider (BC-SRV-GBT)

SAP/MS SQL Server DBA in CCMS (BC-DB-MSS-DBA)

SAP Open Information Warehouse

SAP Patch Assembly/Distribution Engine (SPADE)

SAP Patch Manager (SPAM)

SAPphone (BC-SRV-COM)

SAP Picture (BC-CI)

SAP Query (BC-SRV-QUE)

SAP Retail

SAProuter (BC-CST-NI)

SAP Session Manager

SAP Smart Forms (BC-SRV-SCR)

SAP Textedit

SAP Time Management

SAP Time Management in the Internet/Intranet

SAP Toolbar (BC-CI)

SAP Tree and Tree Model (BC-CI)

Schedule Manager

Scheduling Agreements for Component Suppliers

SD Partner Functions

SD - Sales and Distribution

Secure Network Communications (BC-SEC-SNC)

Secure Store & Forward / Digital Signatures (BC-SEC-SSF)

Securities

Security Audit Log

Security Audit Log (BC-SEC)

Serial Number Management (LO-MD-SN)

Service: Feedback Notifications (SV-FDB)

Setting Up Activity Allocation in R/3 Time Management

South African Model Company (PY-ZA)

South Korea

Space Management Interface (LO-MD-PL)

Spain

Special G/L Transactions: Bills of exchange

Specification System

SQL Studio (BC)

Standard Values Calculation with CAPP (PP-BD-RTG)

Statistical Data Interface (QM-STI)

Statistical Process Control (SPC)

Structures

Supplier Workplace

Supply Chain Planning Interfaces (LO-SCI)

Support Line Feedback

System Administration Assistant

Terminology and Glossary in SAPterm (BC-DOC-TER)

Test Equipment Management

The Appointment Calendar (BC-SRV-GBT)

The BAPI Gateway Component (BC-FES-AIT)

The DCOM Connector

The Form Editor (PT-EV-FO)

The Payroll Process

The RFC API

The RFC Generator

The SAP Lock Concept (BC-CST-EQ)

The Test Workbench in the SAP System (BC-CAT-PLN)

Time Management Aspects in Payroll

Time Sheet and Human Resources in Distributed Systems

Time Zones

Training and Event Management

Transfering Trip Costs to Accounting

Transfering Wage Components to Payroll (PY-XX-TL)

Transfer of Legacy Assets to the R/3 System

Transfer of PRICAT Messages (SD-MD-PL)

Translation Tools for Coordinators

Translation Tools for Translators

Transportation

Transport Management System (BC-CTS-TMS)

Transport Organizer (BC-CTS-ORG)

Transport Tools (BC-CTS-TLS)

Travel Management (FI-TV)

TR - Cash Budget Management

Treasury (TR)

Treasury - Changeover to the Euro

Treasury Workstation

TR - Treasury: Workflow Scenarios

Turkey

United States

Unqualified Advance Payments

Updates in the R/3 System (BC-CST-UP)

Users and Roles (BC-CCM-USR)

Using Evaluation Schemas

ValueSAP

Variant Configuration (LO-VC)

Venezuela

Versions

Wage and Salary Payments

Wage Type Distribution

Wage Type Reporter (H99CWTR0)

Wage Type Statement

Wage Type Valuation

Wage Types

Warehouse Management Guide

Web Transaction API

Web Transaction Programming

Web Transaction Tutorial

WebRFC Programming

Workflow

Working with Parameter Effectivity

Worklist

www.dietseratalami.com

www.okawirasatha.com

A current or future standard price exists for material ....

noreply@blogger.com (Oka) — Wed, 2 Mar 2011 05:13:00 -0800

A current or future standard price exists for material 1610616033

Message no. CKPRCH025

Diagnosis

A current or future cost estimate exists.

Procedure

You can set the price of a marked cost estimate through the radio button 'Default Planned Prices' and release it by saving.

*****

This message come up when i am try to change standard price of material. Why ?
It's happen because standard cost estimate has set for current period. So how to change price with MR21 ?

First we have to delete current cost estimate, used tcode CKR1. And standard cost estimate ready to change with MR21.

Hope this step can help.

Upload Kurs to SAP from BI web site

noreply@blogger.com (Oka) — Sat, 22 Jan 2011 22:36:00 -0800

dSanca adalah program untuk upload rate dari website Bank Indonesia ke SAP. jika tertarik silakan di download versi trialnya disini.

FAGL_FC_VAL and SM35

noreply@blogger.com (Oka) — Sat, 8 Jan 2011 19:45:00 -0800

When running SM35 from FAGL_FC_VAL every line item document user have to input field business area, this is make frustrate input.
How to make automatic input right business area ?
Solution :
1. Make field status group GL account for fields business area optional
2. Setting substitution role for fill right value for business area.
Just it ... and know your user client will be little bit happy :)

How to handle one SAP T-CODE link to many report/program ?

noreply@blogger.com (Oka) — Mon, 22 Nov 2010 18:30:00 -0800

If you implement SAP more than one company in one machine (client) where few report/program has a same purpose and we have to create few T-CODE for same purpose report/program. The Question is How to create one T-CODE for many report/program.
For handle this
1. Just copy t-code and program in START_REPORT to ZSTART_REPORT and add new dialog screen for input company code and add checking authorization in module user_command.
2. Create table for maintain link between tcode and program name.
    Field                  Type                   Key
    MANDT              MANDT                            X
    TCODE             TCODE                             X
    BUKRS               BUKRS                             X
    REPORTTYPE    REPORTTYPE                 X
    REPORT             PROGNAME                   X
    EXTDREPORT   EXTDREPORT
    RVARIANT        RALDB_VARI
3. Insert code in user_command_screen 100
CASE d100_okcode.
    WHEN c_command_okay.
*     submit report
*     authority check is disabled. authority will be checked when
      CALL SCREEN 9000
        STARTING AT 35 05 ENDING AT 70 10.
      IF d9000_okcode = 'CANCEL'.
        LEAVE TO SCREEN 0.
      ENDIF.

      SELECT SINGLE * INTO d_linktcode
      FROM zco_linktcode
      WHERE bukrs = v_bukrs
        AND tcode = d_srepovari-report.
      IF sy-subrc NE 0.
        MESSAGE i181(ds) WITH 'This company not related for this tcode !'.
        LEAVE TO SCREEN 0.
      ENDIF.
      d_srepovari-report = d_linktcode-report.
      d_srepovari-reporttype = d_linktcode-reporttype.
      d_srepovari-extdreport = d_linktcode-extdreport.
      d_srepovari-variant = d_linktcode-rvariant.
**
Hope this tips can help

New GL Manual Update FAGLFLEXA & FAGLFLEXT

noreply@blogger.com (Oka) — Tue, 26 Oct 2010 18:12:00 -0700

Recently we go live the system on sep 1st, due to missing customization PRCTR & KOSTL filed not updated in General ledger view ( FAGLFLEXA & T ) Tables.

We came to know Sep 9th and we did the customization and transported. That day onwards system updating PRCTR and KOSTL filed in those tables.

Could you please help me, how do we update PRCTR and KOSTL fields in New general ledger tables & also tell me what are the impacts, if direct table updation.

Solution :

Delete the line item whichever not having profi centre from FAGLFLEXA & FAGLFLEXT tables & run the GLGCU1 transaction code. GLGCU1 retriving data from BSEG tables and posted in above mentioned FLEX tables.

How to deleted please read
How to delete line item (row) of SAP table ?

How to delete line item (row) of SAP table ?

noreply@blogger.com (Oka) — Tue, 26 Oct 2010 10:17:00 -0700

How to delete line item (row) of SAP table ?

Answer :

you can use se16n transaction like this:
start tr. se16n
type the table name and press ENTER.
Then type the string "&sap_edit" into the command line and strike Enter
again.
enter your selection criteria.
run.(F8)
now you can easily delete the lines you want (and then save)

All Changes are noted in the tables
SE16N_CD_DATA and
SE16N_CD_KEY.

Nice answer from christina

***************************
There are another way to delete this table, you can create abap program for delete detail and summary table New GL. This is example ABAP program for that purpose

REPORT zfi_fagl_del.

TABLES : faglflexa,faglflext.

INCLUDE : zgen_alv,zgen_alv_event.
SELECTION-SCREEN BEGIN OF BLOCK box1 WITH FRAME TITLE text-t01.
SELECT-OPTIONS :
            s_bukrs FOR faglflexa-rbukrs OBLIGATORY.
PARAMETERS:
            p_gjahr LIKE faglflexa-gjahr OBLIGATORY,
            p_rldnr LIKE faglflexa-rldnr OBLIGATORY,
            p_detai RADIOBUTTON GROUP radi,
            p_total RADIOBUTTON GROUP radi,
            p_delet AS CHECKBOX.

SELECTION-SCREEN END OF BLOCK box1.

INITIALIZATION.
GET PARAMETER ID : 'BUK' FIELD s_bukrs-low,
                     'ZBUKH' FIELD s_bukrs-high,
                     'ZBUKO' FIELD s_bukrs-option,
                     'ZBUKS' FIELD s_bukrs-sign,
                     'GJA' FIELD p_gjahr,
                     'GLN_FLEX' FIELD p_rldnr.

START-OF-SELECTION.
SET PARAMETER ID : 'BUK' FIELD s_bukrs-low,
                     'ZBUKH' FIELD s_bukrs-high,
                     'ZBUKO' FIELD s_bukrs-option,
                     'ZBUKS' FIELD s_bukrs-sign,
                     'GJA' FIELD p_gjahr,
                     'GLN_FLEX' FIELD p_rldnr.

IF p_delet = 'X'.
    IF p_detai = 'X'.
      DELETE FROM faglflexa
      WHERE rbukrs IN s_bukrs
        AND gjahr = p_gjahr
        AND rldnr = p_rldnr.
    ENDIF.
    IF p_total = 'X'.
      DELETE FROM faglflext
      WHERE rbukrs IN s_bukrs
        AND ryear = p_gjahr
        AND rldnr = p_rldnr.
    ENDIF.
    COMMIT WORK.
ELSE.
    g_repid = sy-repid.
    gs_variant-report = g_repid.
    g_save           = 'A'.
    gs_variant-handle = ''.
    IF p_detai = 'X'.
      PERFORM f_alv_list_a.
    ELSE.
      PERFORM f_alv_list_t.
    ENDIF.
ENDIF.

*&---------------------------------------------------------------------*
*&      Form f_alv_list_a
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM f_alv_list_a.
DATA : lt_faglflexa LIKE faglflexa OCCURS 0 WITH HEADER LINE.

PERFORM f_event_tab_build USING i_events[].
* PERFORM f_comment_build USING i_top_of_page[].

SELECT * INTO CORRESPONDING FIELDS OF TABLE lt_faglflexa
FROM faglflexa
WHERE rbukrs IN s_bukrs
    AND gjahr = p_gjahr
    AND rldnr = p_rldnr.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
    EXPORTING
      i_callback_program       = g_repid
      i_callback_pf_status_set = c_form_name_pf_status_set
      i_callback_user_command = c_form_name_user_command
      i_structure_name         = 'FAGLFLEXA'
      is_layout                = i_layout
      it_fieldcat              = i_fieldtab[]
      i_save                   = g_save
      is_variant               = gs_variant
      it_events                = i_events[]
    TABLES
      t_outtab                 = lt_faglflexa.
ENDFORM.                    " f_alv_screen
*&---------------------------------------------------------------------*
*&      Form f_alv_list_t
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM f_alv_list_t.
DATA : lt_faglflext LIKE faglflext OCCURS 0 WITH HEADER LINE.

SELECT * INTO CORRESPONDING FIELDS OF TABLE lt_faglflext
FROM faglflext
WHERE rbukrs IN s_bukrs
    AND ryear = p_gjahr
    AND rldnr = p_rldnr.

PERFORM f_event_tab_build USING i_events[].
* PERFORM f_comment_build USING i_top_of_page[].

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
    EXPORTING
      i_callback_program       = g_repid
      i_callback_pf_status_set = c_form_name_pf_status_set
      i_callback_user_command = c_form_name_user_command
      i_structure_name         = 'FAGLFLEXT'
      is_layout                = i_layout
      it_fieldcat              = i_fieldtab[]
      i_save                   = g_save
      is_variant               = gs_variant
      it_events                = i_events[]
    TABLES
      t_outtab                 = lt_faglflext.
ENDFORM.                    " f_alv_screen
*&---------------------------------------------------------------------*
*&      Form f_pf_status_set
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->FT_EXTAB   text
*----------------------------------------------------------------------*
FORM f_pf_status_set USING ft_extab TYPE slis_t_extab.
SET PF-STATUS '9001' OF
    PROGRAM 'ZGEN_STATUS' EXCLUDING ft_extab.
ENDFORM.                    "f_pf_status_set
*&---------------------------------------------------------------------*
*&      Form f_user_command
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->FV_UCOMM     text
*      -->FT_SELFIELD text
*----------------------------------------------------------------------*
FORM f_user_command USING fv_ucomm LIKE sy-ucomm
ft_selfield TYPE slis_selfield.
ENDFORM.                    "f_user_command

www.okawirasatha.com

Error when Assign Chart of Depreciation to Company Code

noreply@blogger.com (Oka) — Thu, 21 Oct 2010 01:29:00 -0700

Company code entries for AW07 are incomplete - See long text
Message no. AC551

Diagnosis
The result of the check of company code AW07 shows that important global parameters from Financial Accounting are missing for Asset Accounting.

One or more of the following fields are affected:

Currency
Chart of accounts
Fiscal year version
Input tax indicator for non-taxable transactions
Procedure
You cannot use the company code for Asset Accounting without this information.

First complete these entries.

Solution
Complete setting for Assign Input Tax Indicator for Non-Taxable Acquisitions (OBCL)

SAP Help

ABAP : Dynamic ITAB for Ranges

ABAP Dialog Programming : Set Filter data of Table Control

ABAP Dialog Programming : Sorting selected column in Table Control

Problem SAP-SCRIPT line command too long

Dynamic Selection Screen Base on TCODE

Dynamic selection screens based on user input parameters

Dynamic Table Selection

Field Catalog Options In ALV

Maintain Message Class Validation and Substitution

SAP Error : System error (termination point Document Number Replacement)

How to import SAP Script to Text File

User Exit for Validation (GGB0)

BOM not loading in CK11N

Add fields for Substitutions In Accounting Document (OBBH)

Why in New GL Receive Asset From PO posted to Dummy PC

SAP Note 325546 - CO line item reports : Creating a user-defined field

RFCEXEC

SAP Online Help PDFs

SAP Online Help PDFs

A current or future standard price exists for material ....

A current or future standard price exists for material 1610616033

Diagnosis

A current or future cost estimate exists.

Procedure

You can set the price of a marked cost estimate through the radio button 'Default Planned Prices' and release it by saving.

*****

This message come up when i am try to change standard price of material. Why ? It's happen because standard cost estimate has set for current period. So how to change price with MR21 ?

First we have to delete current cost estimate, used tcode CKR1. And standard cost estimate ready to change with MR21.

Hope this step can help.

Upload Kurs to SAP from BI web site

FAGL_FC_VAL and SM35

How to handle one SAP T-CODE link to many report/program ?

New GL Manual Update FAGLFLEXA & FAGLFLEXT

How to delete line item (row) of SAP table ?

Error when Assign Chart of Depreciation to Company Code

This message come up when i am try to change standard price of material. Why ?
It's happen because standard cost estimate has set for current period. So how to change price with MR21 ?