H_BLOG

CLASS demo IMPLEMENTATION. METHOD main. DELETE FROM demo_update. INSERT demo_update FROM TABLE @( VALUE #( ( id = 'A' col1 = '1' col2 = '10' col3 = '100') ( id = 'B' col1 = '2' col2 = '20' col3 = '200') ( id = 'C' col1 = '3' col2 = '30' col3 = '300') ( id = 'D' col1 = '4' col2 = '40' col3 = '400') ( id = 'E' col1 = '5' col2 = '50' col3 = '500') ( id = 'F' col1 = '6' col2 = '60' col3 = '600') ) )..

RP_CALC_DATE_IN_INTERVAL TSTR_CALC_TIME CALL FUNCTION 'TSTR_CALC_TIME' EXPORTING IV_BEGIN_DATELOCAL_REQ = GV_DATUM_FROM IV_BEGIN_TIMELOCAL_REQ = GV_UZEIT_FROM IV_DURATION_INTEGER = GC_DURATION " 단위는 초... IV_DIRECTION = GC_DIRECTION " ==> +(미래) / -(과거) IMPORTING EV_END_DATELOCAL = GV_DATUM_TO EV_END_TIMELOCAL = GV_UZEIT_TO EXCEPTIONS FATAL_ERROR = 1 TIME_INVALID = 2 TIME_MISSING = 3 TSTREAM_NOT_L..

CLASS=/SCWM/CL_DLV_MANAGEMENT_PRD CALL METHOD me->get_item_details EXPORTING io_sp = io_sp is_exclude_data = ls_exclude_data is_read_options = ls_read_options it_sp_k_item = lt_sp_k_item IMPORTING et_a_item = lt_a_item et_a_item_addmeas = lt_a_item_addmeas_t et_a_item_admin = lt_a_item_admin_t et_a_item_date = lt_a_item_date_t et_a_item_product = lt_a_item_product_t et_a_item_quantity = lt_a_ite..

CLASS=/SCWM/CL_DLV_MANAGEMENT_PRD CALL METHOD me->get_header_details EXPORTING it_sp_k_head = lt_sp_k_head io_sp = io_sp is_exclude_data = ls_exclude_data IMPORTING et_a_head_admin = lt_a_head_admin_t et_a_head_incoterms = lt_a_head_incoterms_t et_a_head_addmeas = lt_a_head_addmeas_t et_a_head_date = lt_a_head_date_t et_a_head_partyloc = lt_a_head_partyloc_t et_a_head_refdoc = lt_a_head_refdoc_t..

CALL FUNCTION 'TSTR_CALC_TIME' EXPORTING * IV_CALENDARID = m_timestream-calendarid * IV_TSTREAMID = m_timestream-tstreamid IV_BEGIN_DATELOCAL_REQ = SY-DATUM IV_BEGIN_TIMELOCAL_REQ = SY-UZEIT IV_DURATION_INTEGER = 600 " 단위는 초... IV_DIRECTION = '-' " ==> +(미래) / -(과거) * IV_SPLIT_ALLOWED = 'X' IMPORTING EV_END_DATELOCAL = LV_DATUM EV_END_TIMELOCAL = LV_UZEIT EXCEPTIONS FATAL_ERROR = 1 TIME_INVALID ..

SELECT docid, itemid, productno FROM /scdl/db_proci_o WHERE docid = '42010A02B0231EECBFD32CA4C3AAFAFA' INTO TABLE @DATA(lt_doc). DATA: lo_outb TYPE REF TO /scdl/cl_sp_prd_out. DATA: lt_sp_k_item TYPE /scdl/t_sp_k_item_addmeas, l_wa_sp_k_item TYPE /scdl/s_sp_k_item_addmeas, lt_a_item_addmeas TYPE /scdl/t_sp_a_item_addmeas, lv_rejected TYPE boole_d, lt_return_codes TYPE /scdl/t_sp_return_code. TYP..

DATA: gv_time TYPE tzntstmps. DATA: gv_time1 TYPE tzntstmps. DATA: par_date TYPE dats, par_time TYPE tims. START-OF-SELECTION. GV_TIME = '20220729053458'. CONVERT TIME STAMP GV_TIME TIME ZONE 'UTC+9' INTO DATE par_date TIME par_time. * * CONVERT DATE '20220531' TIME '235959' INTO * TIME STAMP gv_time TIME ZONE 'UTC+9'. * * * * CONVERT DATE '20220101' TIME '000000' INTO * TIME STAMP gv_time1 TIME..

** https://blogs.sap.com/2021/11/24/window-expressions-in-abap-sql/ ** https://blogs.sap.com/2021/11/30/new-window-functions-in-abap-sql/ SELECT char1, char2, num1, COUNT(*) OVER( PARTITION BY char1, char2 ) AS cnt, MAX( num1 ) OVER( PARTITION BY char1, char2 ) AS max, MIN( num1 ) OVER( PARTITION BY char1, char2 ) AS min, SUM( num1 ) OVER( PARTITION BY char1, char2 ) AS sum, RANK( ) OVER( PARTIT..

** https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/abensql_date_time_conversions.htm * *... TSTMP_TO_DATS( tstmp = tstmp, * tzone = tzone[, * client = client][, * on_error = on_error] ) * | TSTMP_TO_TIMS( tstmp = tstmp, * tzone = tzone[, * client = client][, * on_error = on_error] ) * | TSTMP_TO_DST( tstmp = tstmp, * tzone = tzone[, * client = client][, * on_error = on_error] ) *..

DATA: go_mon_stock TYPE REF TO /scwm/cl_mon_stock. DATA: GT_MATNR_R TYPE /SCWM/TT_MATNR_R , GT_CAT_R TYPE /SCWM/TT_CAT_R , GT_OWNER_R TYPE /SCWM/TT_OWNER_R , GT_ENTITLED_R TYPE /SCWM/TT_ENTITLED_R , GT_CHARG_R TYPE /SCWM/TT_CHARG_R , GT_IDPLATE_R TYPE /SCWM/TT_IDPLATE_R , GT_SERID_R TYPE /SCWM/TT_SERID_RANGE , GT_UII_R TYPE /SCWM/TT_UII_RANGE , GT_HUIDENT_R TYPE /SCWM/TT_HUIDENT_R , GT_LGTYP_R T..