Denise's IT Story

1. Get class name of Component:SE37 -  WDY_WB_GET_CLSNAME_WITH_GENERA 2. Get includes from class nameSE24 - CL_OO_CLASSNAME_SERVICE=>GET_ALL_METHOD_INCLUDES

with bom as ( SELECT *    FROM HIERARCHY (     SOURCE (                 SELECT m1.mandt                 , m1.stlnr                 , m1.stlal                 , m1.stlan                 , s1.stlty                 , s1.stlkn                 , m2.stlnr  as child_bom                   , m1.matnr  as parent_id                 , p1.posnr                 , p1.idnrk  as node_id                          ..

Method SET_TABLE_FOR_FIRST_DISPLAY of CL_GUI_ALV_GRID sets NO_OUT = 'X' of field catalog when number of column is over 99 entries when I_STRUCTURE_NAME is filled. -> remove I_STRUCTURE_NAME or after SET_TABLE_FOR_FIRST_DISPLAY call GET_FRONTEND_FIELDCATALOG and set NO_OUT = ' ' then call SET_FRONTEND_FIELDCATALOG & REFRESH_TABLE_DISPLAY

FUNCTION zpp_routing_comp_allocation. *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_PLNTY) TYPE PLNTY DEFAULT 'N' *" REFERENCE(IV_WERKS) TYPE WERKS_D *" REFERENCE(IV_MATNR) TYPE MATNR *" REFERENCE(IV_PLNAL) TYPE PLNAL *" REFERENCE(IV_DATUV) TYPE DATUV DEFAULT SY-DATUM *" REFERENCE(IV_CAPID) TYPE CAPID DEFAULT 'PP01' *" ..

FUNCTION zdk_rgb_to_ole_color. *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_RGB) TYPE CSEQUENCE *" EXPORTING *" REFERENCE(EV_COLOR) TYPE CSEQUENCE *" EXCEPTIONS *" INVALID_COLOR *"---------------------------------------------------------------------- CONSTANTS: lc_rgb TYPE i VALUE 256. DATA: lv_color TYPE c LENGTH 6. D..

When proxy error occurs, soap fault message always returns "MESSAGE.GENERAL" you can get the detail message from XI server. *--- Call Method CALL METHOD lo_proxy->(ls_header-obj_name1) PARAMETER-TABLE lt_params[] EXCEPTION-TABLE lt_except[]. COMMIT WORK. IF iv_async IS NOT INITIAL. CALL FUNCTION 'ZDK_GET_PROXY_ASYNC_ACK' EXPORTING io_proxy = lo_proxy IMPORTING ev_status = ev_status ev_message = ..

sometimes adjusting table thru SE14 error occurs because table data is not valid in field type. it has no short dump in ST22 but table is not activating with the message 'SQL exception SQL code 289 SQL message cannot use duplicate index name'. in this case try to find out existing index on temp table generated while adjusting. in tcode ST04, execute query below. SELECT * from sys.indexes where t..

gname : table to check the lock gargs : key values of table ( ex. AENR keys are MANDT, AENNR ) # recursive call until lock is released.

# 1. 에러 발생 시 에러 위치 선택 후 포커스 처리기능 # 2. order by 구문 추가 시 ALV SORT 처리 # 3. 권한관리 # 4. Standard table 처리 제한( 가능하나 일단 막음) # 5. DDL, DML 모두 가능 확인 SAP 패치버전 SAP_BASIS 756 0001 SAPK-75601INSAPBASIS SAP Basis Component SAP_ABA 75G 0001 SAPK-75G01INSAPABA Cross-Application Component -> 위 버전의 경우 CL_HDB_SQL_EXECUTOR->GET_STATEMENT_TYPE 메서드에서 오류가 있음 23라인 아래쪽에 첨부 로직 추가 하여 overwrite 필요. 추가를 안하는 경우 쿼리 앞부분 공백이나 탭 ..

생산버전 MKAL FORM call_bapi CHANGING ps_header TYPE gty_s_alv. DATA: lt_version TYPE TABLE OF mpes_plan_pv_mkal WITH HEADER LINE. DATA: lt_message TYPE gty_t_bapiret2 WITH HEADER LINE. MOVE-CORRESPONDING ps_header TO lt_version. APPEND lt_version. CLEAR: ps_header-icon. CASE ps_header-mode. WHEN gc_mode_update. PERFORM call_bapi_del CHANGING ps_header. IF ps_header-icon = gc_icon_red. EXIT. ENDIF. ..

To Activate Change History1. SE38 -> RCCLUKA2 Run for Class Type2. English : SPRO -> Cross-Application Components -> Classification System -> Classes -> Maintain Object Types and Class Types Korean : SPRO -> CA 구성요소 -> 분류 시스템 -> 클래스 -> 오브젝트유형 및 클래스유형 유지보수 # Tcode : O1CL3. Double click MARA table4. Double click Class Types5. Double click 0016. set Multiple objs allowed & Change Docs7. Double clic..

*&---------------------------------------------------------------------* *& Report Z_MAT_CONF *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT z_mat_conf. PARAMETERS : p_werks TYPE werks_d DEFAULT '1211', p_matnr TYPE matnr DEFAULT 'TMECP-U5016889P'. PARAMETERS : p_basic AS CHECKBOX D..

1. SE37 : SEO_CLASS_GET_METHOD_INCLUDES2. Run with class name.

1. SE37 : DD_TBFD_CHK_TABLELENGTH2. Break point3. SE09 - Release4. change ALLOWED_LENGTH value.

# Set Matintenance View column property.PROCESS AFTER INPUT. MODULE liste_exit_command AT EXIT-COMMAND. MODULE liste_before_loop. LOOP AT extract. MODULE liste_init_workarea. CHAIN. FIELD zmgbvcode-cprog . FIELD zmgbvcode-code . FIELD zmgbvcode-seq . FIELD zmgbvcode-value . FIELD zmgbvcode-text . FIELD zmgbvcode-crdate . FIELD zmgbvcode-crtime . FIELD zmgbvcode-cruser . FIELD zmgbvcode-chdate . ..

FUNCTION zmgg_send_office_mail. *"---------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" REFERENCE(IV_SENDER) TYPE SYUNAME *" REFERENCE(IV_OBJNM) TYPE SO_OBJ_NAM DEFAULT 'OFFICE_MAIL' *" REFERENCE(IV_TITLE) TYPE SO_OBJ_DES *" REFERENCE(IT_TEXT) TYPE TTTEXT255 *" REFERENCE(IT_RECEIVER) TYPE SPERS_ULST *" EXCEPTIONS *" MAIL_ERROR *"-------------..

TEXT Object 등록 : SM30 - V_TTXOBI 텍스트오브젝트 LOG_REASON 내역 BOM 로그 종료사유 백업모드 V 편집기 어플리케이션 TN 라인너비 72 스타일 서식 텍스트포맷 TEXT ID 등록 : SM30 - V_TTXIDI 텍스트오브젝트 LOG_REASON 텍스트 ID ZLOG 내역 I/F 로그 INCLUDE ID 텍스트포맷 구조 - 전역선언 *----------------------------------------------------------------------* * Constants *----------------------------------------------------------------------* CONSTANTS : gc_text_tdid TYPE tdid..

case SY-SUBRC = 0. 1. local function call 2. Remote call with destination 'NONE' *--- Check if Function is called via RFC : SY-SUBRC 0 CALL 'RFCControl' ID 'CODE' FIELD '?'. "#EC CI_CCALL IF sy-subrc IS INITIAL. *--- Local ELSE. *--- RFC ENDIF.

*--- Data Element search select l.rollname, l.datatype, l.leng, l.decimals, l.signflag , t.ddtext, t.reptext from dd04l l , dd04t t where t.rollname = l.rollname and t.ddlanguage = '3' and t.as4local = l.as4local and t.as4vers = l.as4vers and t.ddtext like '%지연%' *--- Domain search select l.domname, l.datatype, l.leng, l.decimals, l.signflag , t.ddtext from dd01l l , dd01t t where t.domname = l...

Ref program : LSVIMF44form : vim_process_assigns # View 의 추가부분. MODULE set_if_data. MODULE liste_after_loop. # 호출부분. MODULE set_if_data INPUT. CHECK function EQ 'SAVE'. PERFORM save_if_data. ENDMODULE. # 함수호출부분. FORM save_if_data . DATA : lv_offset TYPE i. lv_offset = x_header-after_tabc / cl_abap_char_utilities=>charsize + x_header-aft_txttbc / cl_abap_char_utilities=>charsize. LOOP AT total. C..

TYPES : gty_t_query TYPE TABLE OF string. FORM execute_native USING pt_query TYPE gty_t_query CHANGING pt_data TYPE STANDARD TABLE. DATA: lo_conn TYPE REF TO cl_sql_connection. DATA: lo_stmt TYPE REF TO cl_sql_statement. DATA: lo_result TYPE REF TO cl_sql_result_set. DATA: lo_except TYPE REF TO cx_sql_exception. DATA: lv_rc TYPE i. DATA: lv_rows TYPE i. DATA: lv_text TYPE string. DATA: lv_query ..

FUNCTION zca_set_sc_variant. *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_REPID) TYPE REPID *" REFERENCE(IV_UNAME) TYPE UNAME *" REFERENCE(IV_USERSPECIFIC) TYPE BOOLEAN_FLG DEFAULT 'X' *"---------------------------------------------------------------------- DATA : lt_varid TYPE TABLE OF varid WITH HEADER LINE. DATA : l..

METHOD Ref : LIBAPI_ALM_ORDER_PROCESSINGCON DATA : lv_lines TYPE i, lv_count TYPE i, lv_last TYPE c. DATA : lt_method TYPE TABLE OF bapi_alm_order_method WITH HEADER LINE, lt_header TYPE TABLE OF bapi_alm_order_headers_i WITH HEADER LINE, lt_headerx TYPE TABLE OF bapi_alm_order_headers_up WITH HEADER LINE, lt_return TYPE TABLE OF bapiret2 WITH HEADER LINE. DESCRIBE TABLE gt_indexes LINES lv_line..

1. in print popup, Uncheck the options, but New Spool Request field. fill title in case to recognize easily. 2. tcode : SP02, get spool no. 3. tcode : SE38 , run RSTXPDFT4 with Download PDF file option. ref : http://www.saptechnical.com/Tutorials/Smartforms/PDF/Index.htm.

FUNCTION zca_remove_escape. *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_HEX) TYPE XSTRING OPTIONAL *" REFERENCE(IV_CHARS) TYPE CSEQUENCE OPTIONAL *" CHANGING *" REFERENCE(CV_DATA) TYPE CSEQUENCE *"---------------------------------------------------------------------- DATA : lv_chars TYPE char100. DATA : lv_string TYPE..

1. Dialog / Background 모두 가능. FUNCTION zlock_program. *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_PROG) TYPE CSEQUENCE *" REFERENCE(IV_LOCK) TYPE BOOLE_D DEFAULT ' ' *" EXPORTING *" REFERENCE(EV_SUBRC) TYPE SY-SUBRC *"---------------------------------------------------------------------- DATA : lv_name TYPE indx-srtfd..

SAPscript Control Tables and Structures This topic introduces the control tables SAPscript employs. You also find an overview of the structures used.Control TablesTTXOBDefinition of the text objectsTTXOTDescriptions of the text objectsTTXIDDefinition of the text IDsTTXITDescriptions of the text IDs

1. 날짜 형식 데이터가 내부포멧과 출력포멧이 서로 다른경우 내부포멧을 출력포멧으로 변경. ( 일, 월 혼용 ). 2. 일의 경우 TYPE d, 월의 경우 CHAR 타입 길이는 상관없음..FORM get_date_string USING pv_date CHANGING pv_text. DATA : lv_count TYPE i, lv_date TYPE d. DATA : lv_format TYPE xudatfm. lv_count = STRLEN( pv_date ). lv_format = cl_abap_datfm=>get_datfm( ). CASE lv_count. WHEN 6. cl_abap_datfm=>conv_period_int_to_ext( EXPORTING im_periodint = pv_date im_..

1. 판매조직이 CBO code master에 저장된 값이면 VA01의 고객 search help의 기본 탭을 변경.2. SD_DEBI 의 경우 스탠다드 변경 키를 받아서 Search help exit에 넣어줘야함.FUNCTION f4ut_debi. *"---------------------------------------------------------------------- *"*"Local Interface: *" TABLES *" SHLP_TAB TYPE SHLP_DESCT *" RECORD_TAB STRUCTURE SEAHLPRES *" CHANGING *" REFERENCE(SHLP) TYPE SHLP_DESCR *" REFERENCE(CALLCONTROL) TYPE DDSHF4CTRL *"-..

1. 기말재고 수량을 조회시 MMBE, MB52는 너무 느려서 만듬.*-- Table types ZTT_MM_MARD / ZST_MM_MARD WERKSWERKS_DCHAR MATNRMATNRCHAR LGORTLGORT_DCHAR LABSTLABSTQUANMARAMEINS INSMEINSMEQUANMARAMEINS SPEMESPEMEQUANMARAMEINS LFGJALFGJANUMC LFMONLFMONNUMC ZTT_MM_MSLB / ZST_MM_MSLB WERKSWERKS_DCHAR MATNRMATNRCHAR CHARGCHARG_DCHAR LIFNRLIFNRCHAR SOBKZSOBKZCHAR LBLABLABSTQUANMARAMEINS LBINSINSMEQUANMARAMEINS LFGJALFGJANUMC..