Denise's IT Story

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' *" ..

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. ..

*&---------------------------------------------------------------------* *& 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 : DD_TBFD_CHK_TABLELENGTH2. Break point3. SE09 - Release4. change ALLOWED_LENGTH value.

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.

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. 기말재고 수량을 조회시 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..

1. 인터널 테이블이나 스트럭쳐의 필드리스트를 가져올 때 사용. 2. 용도 : 동적으로 필드제어가 필요할때. ( ex> 일별 데이터 출력, 집계, 음수 표시, 특정필드 Enabled/Disabled... ) FUNCTION zdk_get_components . *"---------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" REFERENCE(IT_DATA) TYPE ANY *" REFERENCE(IV_INCLUDE_ONLY) TYPE CHAR01 OPTIONAL *" EXPORTING *" REFERENCE(ET_COMPS) TYPE ABAP_COMPONENT_TAB *"-..

1. 엑셀 upload시 셀서식에 의해 데이터가 변형되는것을 방지 할때 사용. 2. 용도 : 엑셀의 날짜값을 raw data로 받아 날짜로 변환.FUNCTION zcp_excel_date_from_serial. *"---------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" REFERENCE(IV_DAYS) TYPE CHAR08 *" EXPORTING *" REFERENCE(EV_DATE) TYPE DATS *"---------------------------------------------------------------------- DATA : lv_years TYPE ..

ZEXCEL_T_HEADER ZEXCEL_S_HEADER ROW 1 Types ZDK_SEQ NUMC 3 TEXT 1 Types CHAR255 CHAR 255 ZEXCEL_T_COLOR ZEXCEL_S_COLOR FIELDNAME 1 Types FIELDNAME COLOR 1 Types UAC_COLOR FUNCTION zdk_download_excel . *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_TITLE) TYPE CHAR255 *" VALUE(IT_HEADER) TYPE ZEXCEL_T_HEADER *" REFERENCE(..

DEFINE $_set_range. &1-sign = 'I'. if &3 is initial. if &2 ca '*'. &1-option = 'CP'. else. &1-option = 'EQ'. endif. &1-low = &2. else. &1-option = 'BT'. &1-low = &2. &1-high = &3. endif. append &1. clear &1. END-OF-DEFINITION.

DATA : conv_in TYPE REF TO cl_abap_conv_in_ce , conv_out TYPE REF TO cl_abap_conv_out_ce, lv_str(255) TYPE c, lv_xstr TYPE xstring, conv_in = cl_abap_conv_in_ce=>create( encoding = 'UTF-8' ). conv_out = cl_abap_conv_out_ce=>create( encoding = '8500' ). conv_out->convert( EXPORTING data = lv_str IMPORTING buffer = lv_xstr ). conv_in->convert( EXPORTING input = lv_xstr IMPORTING data = lv_str ).

# 1. 단위 환산은 자재에 등록된 단위의 factor 값(MARM)으로 환산을 한다. -> 같은 Dimension을 가진 단위는 등록하지 않아도 시스템에서 계산한다. -> 다른 Dimension을 가진 단위는 반드시 등록해야 함. 2. 모든 환산은 기본 단위를 기준으로한다. 3. 재고의 수량은 기본 단위로 관리된다. # 환산 순서 : 단위 A에서 단위 B로 환산 1. 단위 A -> 기본단위 2. 기본단위 -> 단위B # 기본 단위로 환산할지, 입력단위로 환산할지는 kzmeinh 필드로 제어한다. -> 'X' 인경우는 MEINH의 단위를 참조하여 기본단위로 환산. -> default 값은 기본단위를 참조하여 MEINH의 단위로 환산. REPORT ztest_conv NO STANDARD PAGE HEAD..

1. Field Catalog Setting WHEN 'LIFNR2'. gs_fieldcat-edit = 'X'. gs_fieldcat-f4availabl = 'X'. WHEN 'ZADDR2'. gs_fieldcat-edit = 'X'. gs_fieldcat-f4availabl = 'X'. 2. Event receiver setting. handle_f4 FOR EVENT onf4 OF cl_gui_alv_grid IMPORTING e_fieldname es_row_no er_event_data et_bad_cells e_display, 3. Method Implementation METHOD handle_f4. PERFORM on_f4 USING e_fieldname es_row_no-row_id er..

XlHAlign EnumerationNameValueDescriptionxlHAlignCenter-4108Center.xlHAlignCenterAcrossSelection7Center across selection.xlHAlignDistributed-4117Distribute.xlHAlignFill5Fill.xlHAlignGeneral1Align according to data type.xlHAlignJustify-4130Justify.xlHAlignLeft-4131Left.xlHAlignRight-4152Right. http://msdn.microsoft.com/en-us/library/bb241313(v=office.12).aspx XlVAlign Enumeration NameValueDescript..

FUNCTION BAPI_SALESORDER_CHANGE IMPORTING VALUE(SALESDOCUMENT) LIKE BAPIVBELN-VBELN VALUE(ORDER_HEADER_IN) LIKE BAPISDH1 STRUCTURE BAPISDH1 OPTIONAL VALUE(ORDER_HEADER_INX) LIKE BAPISDH1X STRUCTURE BAPISDH1X VALUE(SIMULATION) LIKE BAPIFLAG-BAPIFLAG OPTIONAL VALUE(BEHAVE_WHEN_ERROR) LIKE BAPIFLAG-BAPIFLAG DEFAULT SPACE VALUE(INT_NUMBER_ASSIGNMENT) LIKE BAPIFLAG-BAPIFLAG DEFAULT SPACE VALUE(LOGIC_..

AuthorSerdar Şimşekler is an SAP application developer working for Havelsan Inc., Turkey. He has experience with ABAP program development. He is also studying for an M.A. degree at the department of philosophy at METU. Email : ssimsekler@yahoo.com