Home » Posts tagged 'ERP'

Tag Archives: ERP

Preparing to install SAP ERP 6 EhP 8 with MaxDB 7.9


Hi…my blog readers…

This time, I will show you on step by step installing SAP ERP 6 EhP 8 using MaxDB 7.9 as database server. This posting will show you about preparation and prerequisite step. Make sure that you have copied all your installers on local disk.

Prepare your environment.

Run the sapinst.

(more…)

Advertisements

Bypass Maintenance Optimizer on SAP Solution Manager


We had to confirm each packages through Maintenance Optimizer. I’ve found the way to bypass maintenance optimizer:

go at http://service.sap.com/patches and add all patches you want to download basket

you can go into SE37
choose function module /TMWFLOW/MO_UI_BASKET_AUTHORIZ
choose SINGLE TEST
click on EXECUTE
choose packages and click on CONFIRM

there ya go, you can download using SAP download manager… and avoid Maintenance Optimizer.

IBM DB2 10.1 has been supported by SAP


Finally, IBM DB2 10.1 has been supported by SAP. There are a lot of improvement whic had been done by IBM on DB2 10.1 such as Adaptive Compression (prior than Deep Compression which now mentioned as Static Compression), Log Compression, etc.

SAP has just certified DB2 10.1 this July 2012.

There are several SAP Notes need to be read and implement if you want to use DB2 10.1.

sapnote_0001700631_DB6: Using DB2 10.1 with SAP Applications

sapnote_0001701181_DB6: ABAP DDIC: Enhancements for DB2 10.1

sapnote_0001692571_DB6: DB2 10.1 Standard Parameter Settings

sapnote_0001365982_DB6: Current db6_update_db_db6_update_client script (V 27)

Right now, I also doing some research on this DB2 10.1 using SAP ERP 6 EHP 5.

Happy hacking, guys !!

ABAP : Program to generate Solution Manager Key


Here are ABAP program so you can use to generate Solman Key :

——————————————

*&———————————————————————*
*& Report ZSLMKEY *
*& *
*&———————————————————————*
*& *
*& *
*&———————————————————————*

*&———————————————————————*
*& Report ZSLMKEY
*&
*&———————————————————————*
*&
*&
*&———————————————————————*

REPORT ZSLMKEY.

types: begin of dswpclientkey,
INSTNO type num10,
DBID(3),
BUNDLE_ID(8),
SERVICE_KEY(40),
end of dswpclientkey.
*data: dswpclientkey_w type standard table of dswpclientkey.
DATA: P_VALUE(10),
P_INSTNO(10).

PARAMETERS: P_SID(3),
P_SYSNO(2),
P_SERVER(15).

START-OF-SELECTION.
PERFORM GET_SP_VALUE USING P_SID
P_SYSNO
P_SERVER
P_INSTNO
CHANGING P_VALUE.

END-OF-SELECTION.
WRITE P_VALUE.
*&———————————————————————*
*& Form get_sp_value
*&———————————————————————*
* text
*———————————————————————-*
* –>P_PF_SID text
* –>P_PF_SYSNO text
* –>P_PF_SERVER text
* <–P_PF_VALUE text
*———————————————————————-*
FORM get_sp_value USING P_PF_SID
P_PF_SYSNO
P_PF_SERVER
P_PF_INSTNO
CHANGING P_PF_VALUE.

CONSTANTS: lc_part_len TYPE i VALUE 5,
lc_pw_len TYPE i VALUE 10,
lc_allowed_chars(38) TYPE c VALUE
‘-0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ_’.

data: lf_string(20) type c,
lf_key type i,
ls_key type dswpclientkey,
lf_part(lc_part_len) type c,
lf_finalf(lc_pw_len) type c,
lf_finalx type xstring,
lf_xbuffer type xstring,
lf_opf(10) type c,
lf_langu like sy-langu,
lf_subrc like sy-subrc,
lf_len type i,
lo_conv_to_x TYPE REF TO cl_abap_conv_out_ce.

clear: lf_string, lf_finalx, lf_opf.

concatenate p_pf_sid p_pf_sysno p_pf_server into lf_string.

* Large letters only
translate lf_string to upper case.

lf_langu = sy-langu.
SET LOCALE LANGUAGE ‘E’.
lo_conv_to_x = cl_abap_conv_out_ce=>create( encoding = ‘1100’ ).
lf_len = STRLEN( lf_string ).

IF lf_string(lf_len) CN lc_allowed_chars.
else.

* Fold the input string to a lc_part_len long string
WHILE lf_len > 0.
lf_part = lf_string(lc_part_len).
SHIFT lf_string BY lc_part_len PLACES.
lf_len = STRLEN( lf_string ).
CALL METHOD lo_conv_to_x->reset.
CALL METHOD lo_conv_to_x->write( data = lf_part n = -1 ).
lf_xbuffer = lo_conv_to_x->get_buffer( ).
lf_finalx = lf_finalx BIT-XOR lf_xbuffer.
ENDWHILE.

lf_key = 12.

PERFORM scramble USING lf_finalx
lf_key
lc_part_len
CHANGING lf_finalf
lf_subrc.

if not lf_finalf is initial.
p_pf_value = lf_finalf.
ls_key-dbid = p_pf_sid.
ls_key-instno = p_pf_instno.
ls_key-bundle_id = ‘SM_KEY’.
ls_key-service_key = lf_finalf.
if not p_pf_instno is initial.
* insert dswpclientkey_w from ls_key.
if sy-subrc <> 0.
* update dswpclientkey_w from ls_key.
endif.
endif.
else.
clear p_pf_value.
endif.
endif.
ENDFORM. ” get_sp_value
*&———————————————————————*
*& Form scramble
*&———————————————————————*
* text
*———————————————————————-*
* –>P_LF_FINALX text
* –>P_LF_KEY text
* –>P_LC_PART_LEN text
* <–P_LF_finalf text
* <–P_LF_SUBRC text
*———————————————————————-*
FORM scramble USING iv_xstring TYPE xstring
iv_key TYPE i
iv_src_len TYPE i
CHANGING lf_finalf
lf_subrc LIKE sy-subrc.

CONSTANTS: lc_max_len TYPE i VALUE 20,
lc_mask(4) TYPE x VALUE ‘0000003F’,
lc_random(64) TYPE x VALUE
‘F0ED53B83244F1F876C67959FD4F13A2’ &
‘C15195EC5483C234774943A27DE26596’ &
‘5E5398789A17A33CD383A8B829FBDCA5′ &
’55D702778413ACDDF9B83116610E6DFA’.

DATA: lv_key_index(4) TYPE x,
lv_rand_index(4) TYPE x,
lv_xkey(4) TYPE x,
lv_xkey_shl_1(4) TYPE x,
lv_xkey_shr_5(4) TYPE x,
lv_scramble_byte TYPE x,
lv_dest(lc_max_len) TYPE x,
lv_index TYPE i,
lv_len TYPE i.

CLEAR lf_subrc.

IF iv_src_len EQ 0. EXIT. ENDIF.
lv_len = XSTRLEN( iv_xstring ).
IF iv_src_len GT lc_max_len OR
iv_src_len GT lv_len.
lf_subrc = 2.
EXIT.
ENDIF.

lv_xkey = iv_key.
lv_xkey_shl_1 = iv_key * 2.
lv_xkey_shr_5 = iv_key DIV 32.
lv_rand_index = lv_xkey BIT-XOR lv_xkey_shr_5 BIT-XOR lv_xkey_shl_1.
lv_rand_index = lv_rand_index BIT-AND lc_mask.

lv_index = 0.
DO iv_src_len TIMES.
CATCH SYSTEM-EXCEPTIONS compute_int_times_overflow = 1.
lv_key_index = ( iv_key * lv_index * lv_index ) – lv_index.
ENDCATCH.
IF sy-subrc <> 0.
lf_subrc = 1.
EXIT.
ENDIF.
lv_scramble_byte = lc_random+lv_rand_index(1) BIT-XOR
lv_key_index+3(1).
lv_dest+lv_index(1) = iv_xstring+lv_index(1) BIT-XOR
lv_scramble_byte.
lv_index = lv_index + 1.
lv_rand_index = lv_rand_index + 1.
lv_rand_index = lv_rand_index BIT-AND lc_mask.
ENDDO.
IF lf_subrc <> 0.
EXIT.
ENDIF.

WRITE lv_dest(iv_src_len) TO lf_finalf.

ENDFORM. ” scramble

——————————————

Note : You need ABAP/SAP system to write and run it

SAP Basis & Virtualization Services


Hi guys,

I am offering Remote SAP Basis Support and Service to your company. No matter your company have dedicated SAP Basis or not, we can help you. Your company could hire me as Remote SAP Basis.

I also have virtualization support on VMware, Proxmox VE, Linux, Oracle, and DB2. Usually, I support my client via TeamViewer connection.

You can contact me through

Email : devratt@yahoo.com
Phone/SMS/WA/Telegram : +62-85330356073

Simple Table Reorganization for SAP R/3 using BRSPACE


SAP R/3 are ERP software that relied on database performance to support its performance. High performance database directly effect on SAP R/3 system performance. One of activity that effect on its are table reorganization. Reorganization improves the structure of the database and can result in improved database performance. BRSPACE performs the reorganization using the new Oracle feature, online table redefinition. The following graphic shows some of the reasons for reorganization:

One of the reason to reorganization are that large disk and RAID system with large and secure memory buffers reduce I/O hotspot. You can check more about reorganization for SAP R/3 here.

I’ll use my Windows box and use [sid]adm user. For Unix box user, use ora[sid] user. Let’s do simple table reorganization here. Open your MS-DOS prompt.

Type > brspace -f tbreorg -t MSEG

Explanation :

  • -f means function to do table reorganization
  • -t means refer to tableĀ  name. On this tutorial, MSEG table.

Type ENTER.

Additional option available for table reorganization. Just accept default option. Type C to continue.

Table reorganization is running.

Table reorganization has been completed succesfully. Type C to continue.

Now you can try to reoganization simple and little table. This tutorial only show you simple and online reorganization. Be carefull when you are using it. Test it first on your Develop system or Test system.

First Intro to SAP


SAP is known as world largest business software company with its product such as SAP R/3, SAP NetWeaver, SAP Business Intelligent Warehouse, SAP Solution Manager, SAP Advanced Planner and Oprimizer, etc.

SAP was founded by five former IBM employees in Mannheim, Germany. SAP was stand for Systeme, Anwendungen und Produkte in der Datenverarbeitung (“Systems, Applications and Products in Data Processing”). Currently, SAP headquarters is on Walldorf, Germany.

SAP’s products focus on Enterprise Resource Planning (ERP) with its main product SAP ERP.

SAP R/3 implementation usually held by consutant company certified by SAP. SAP customers are spread widely all over the world. Some of Indonesian’s company that implement SAP solution are Astra, Indofood, Blue Bird, Sari Husada, etc.