Transaction Recorder

 

Tcode : SHDB

MIGO: Call Transaction

 

CALL FUNCTION 'MIGO_DIALOG'
EXPORTING
            i_action            = 'A04'
            i_refdoc            = 'R02'
            i_notree            = 'X'
            i_no_auth_check     = ' '
            i_deadend           = 'X'
            i_skip_first_screen = 'X'
            i_okcode            = 'OK_GO'
            i_mblnr             = w_output-mblnr
            i_mjahr             = w_output-mjahr
            i_zeile             = w_output-zeile.

ESDUS : Dynamic User Settings

 

Table ESDUS

ใช้เก็บค่าตำแหน่งการเลือกต่างๆของ Screen ของแต่ละ User

เช่น ตำแหน่งการเลือกของ Tree, ตำแหน่งการเลือกของ Tabstrip เป็นต้น

Ex. Create data type handle

 

INPUT_TAB    Importing    Type    ANY TABLE
OUTPUT_TAB    Changing    Type    INDEX TABLE

-------------------------------------------------------------------------------------------------------

DATA: output_field TYPE REF TO cl_abap_tabledescr,
        output_line TYPE REF TO data,
        out_linetype TYPE REF TO cl_abap_datadescr.
FIELD-SYMBOLS: <flinein> TYPE ANY, <flineout> TYPE ANY.

  output_field ?= cl_abap_tabledescr=>describe_by_data( output_tab ).
  out_linetype = output_field->get_table_line_type( ).
CREATE DATA output_line TYPE HANDLE out_linetype.
ASSIGN output_line->* TO <flineout>.

LOOP AT input_tab ASSIGNING <flinein>.
CLEAR <flineout>.
MOVE-CORRESPONDING <flinein> TO <flineout>.
APPEND <flineout> TO output_tab.
ENDLOOP.

Error Transport in QAS; cannot connect

Symptom:

sap error XT200 Return code: 0232

Clause:

Oracle User is locked

SQL> connect sapqas/ccsqasadm
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.
SQL> connect /
Connected.
SQL> ALTER USER sapqas ACCOUNT UNLOCK;
ALTER USER sapqas ACCOUNT UNLOCK
*
ERROR at line 1:
ORA-01031: insufficient privileges

Solution:

1)  Unlock Oracle  user
SQL> connect /as sysdba
Connected.
SQL> ALTER USER sapqas ACCOUNT UNLOCK;
User altered.
SQL>
2) Change Oracle User Password
brconnect -u / -f chpass -o sapsr3 -p <password>

How to create project : SPRO

 

1. Go to transaction : SPRO

 

2. Select Menu [Go to > Project Management]

 

3. Click Create Project and input project name.

4. Click button “Change selection…” and Select components.

5. Click button “Generate Project IMG” and Save.

How to SECATT

 

1. Go to transaction “SECATT”

2. Create Script

2.1 Check Test Script and input script name.

2.2 Click button

3.

4.

5.

6. Create Parameter name in VALIN.

6.1 Select Import and click Yes.

7. Save Script.

8. Run Script.

8.1 Check Test Configuration and input script name.

8.2 Click button

9. Set value and save.

10. Click Download Variants.

11. Input data on excel.

12. Execute and set start mode.

13. Input path and execute.