[DOS] DATE / TIME 取位置的用法

@ECHO OFF
SET dtime=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%_%TIME:~0,2%%TIME:~3,2%
HTTP-PING -d -i 4 http://www.website.net:80 > web.log
REN web.log Web%dtime%.log

**************************************
DATE:~X,Y
TIME:~X,Y
從第X個位置後開始(index value from '0')取Y個字。

Read More

建立來源系統

Create BI Source System.

Tcode: SU01

建立BW的帳號(User: ALEREMOTE)並設定存取權限。

Profiles	Desc.
S_BI-WHM_RFC	Business Information Warehouse, RFC user in the Warehouse
SAP_NEW	SAP_NEW
S_BI-WX_RFCA	RFC Extractor SAP Business Information Warehouse

Tcode: BD54

定義邏輯系統。

維護來源系統的使用者名稱。

Tcode: SM59

建立RFC 目的地。

RFC Destination: QASCLNT780

Connection Type: 3

點選Connection Test，看連線是否成功。

Tcode: RSA1

建立資料來源系統。

若建立成功在SAP目錄下會出現R/3系統的邏輯名稱。

以下為附註：

若要更換BW的背景使用者，可在Setting > Global Settings做修改。Tcode: RSCUSTA

Read More

Bandicam setting

Read More

[Table] USR21 and ADCP

◎ USR21
Assign user name address key.
USR21 is in the package SUSR, which belongs to the module User and Authorization Management.

◎ ADCP
Person/Address Assignment (Business Address Services).
ADCP is in the package SZAD, which belongs to the module Address Management/Business Address.

USR21-BNAME 為系統的登入帳戶名稱。
USR21-PERSNUMBER 參照 ADCP-PERSNUMBER。

Read More

SAP GUI 捷徑儲存密碼

SAP GUI Logon without entering userid and password

Create register key for SAP shortcut by SAPSHCUT command.




Using command REGEDIT to enable saving password.


The register path is HKEY_CURRENT_USER/Software/SAP/SAPShortcut/Security.
Change the string value of EnablePassword from 0 to 1.


The password field is from gray area to enable saving password.




Env: WIN 7, SAP Logon 730

Read More

Internal Table

TABLES: <TableName>.
參考透明表時，需先引用。

APPEND (<work area> INTO) <itab>.
有Header Line的內表，數據可賦值到Header Line或經由Work Area存放。
數據被賦予內表Head Line後，再 APPEND到內表最後一行。

APPEND <work area> TO <itab>.
無Herader Line的內表，數據要先存到Work Area再以APPEND...TO...放到內表。
數據被賦予Work Area後，再 APPEND到內表。

CLEAR <itab>. 僅清空Header Line。
REFRESH <itab>. 清空內表數據。
FREE <itab>. 清空內表數據。
REFRESH <itab> FROM TABLE <dbtab>. 清空從資料表獲取的內表數據。

Read More

cannot be converted to a character-type field

Issue: cannot be converted to a character-type field.

DATA: BEGIN OF itab OCCURS 0.
        INCLUDE STRUCTURE empinfo.
DATA: END OF itab.


DATA: ld_string    TYPE string.
DATA: ls_record   LIKE LINE OF itab.

LOOP AT itab INTO ls_record.

  CALL METHOD cl_abap_container_utilities=>fill_container_c
    EXPORTING
      im_value               = ls_record
*    IMPORTING
*      ex_container           = ld_string
*    EXCEPTIONS
*      illegal_parameter_type = 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.

  WRITE :/ ls_record.
ENDLOOP.

Read More