function module to insert table VBEH /move from VBEP to VBEH

Former Member — Thu, 06 Nov 2008 10:02:53 GMT

Hi all,

Actually, I'm using BAPI_SALESORDER_CHANGE to change quantity of the schedule line, but it only update quantity in table VBEP. I want to make old quantity saved to history table (VBEH).

is there any function module/BAPI to get this?

When Sales Distribution - schedule line agreement (VBEP) move to schedule line history (VBEH) ?.

Thanks.

Re: function module to insert table VBEH /move from VBEP to VBEH

Former Member — Tue, 11 Nov 2008 05:12:10 GMT

u can pass line item and quantity according following example

ORDER_HEADER_INX-updateflag = 'U'.

i_sched-itm_number = p_posnr.

i_sched-sched_line = p_etenr.

i_sched-req_qty = p_reqqty.

i_schedx-updateflag = 'U'.

i_schedx-itm_number = p_posnr.

i_schedx-sched_line = p_etenr.

i_schedx-req_qty = 'X'.

APPEND i_sched.

APPEND i_schedx.

CALL FUNCTION 'BAPI_SALESORDER_CHANGE'

EXPORTING

salesdocument = p_vbeln

order_header_in = i_hdr

order_header_inx = i_hdrx

TABLES

return = i_ret

schedule_lines = i_sched

schedule_linesx = i_schedx.

Re: function module to insert table VBEH /move from VBEP to VBEH

Former Member — Tue, 11 Nov 2008 06:00:11 GMT

yeah....

i got this method from my friend. Thanks Teddy

it will save old schedule line to VBEH and create new release order



*   Populate Sales and Distribution Document Number
    p_salesdocument = pwa_curr_forecast-vbeln.

*   Populate Sales Document Header Checkbox
    pwa_order_header_inx-updateflag = 'U'.

* Populate Schedule Lines
  CLEAR lwa_schedule_in.
  lwa_schedule_in-itm_number  = pwa_curr_forecast-posnr.
  lwa_schedule_in-sched_line  = pwa_curr_forecast-etenr.
  lwa_schedule_in-req_qty     = pwa_curr_forecast-wmeng.
  APPEND lwa_schedule_in TO pi_schedule_in.

* Populate Schedule Line Checkbox
  CLEAR lwa_schedule_inx.
  lwa_schedule_inx-itm_number = pwa_curr_forecast-posnr.
  lwa_schedule_inx-sched_line = pwa_curr_forecast-etenr.
  lwa_schedule_inx-updateflag = 'I'.
  lwa_schedule_inx-req_qty    = 'X'.
  APPEND lwa_schedule_inx TO pi_schedule_inx.

* Populate delete schedule vblb
  CLEAR lwa_del_schedule_in.
  lwa_del_schedule_in-itm_number   = pwa_release_ord-posnr.
  lwa_del_schedule_in-rel_type     = '1'.
  lwa_del_schedule_in-dlvschedno   = l_labnk.
  lwa_del_schedule_in-dlvscheddate = pwa_release_ord-abrdt.
  APPEND lwa_del_schedule_in TO pi_del_schedule_in.

* Populate delete schedule vblb checkbox
  CLEAR lwa_del_schedule_inx.
  lwa_del_schedule_inx-itm_number   = pwa_release_ord-posnr.
  lwa_del_schedule_inx-rel_type     = '1'.
  lwa_del_schedule_inx-dlvschedno   = 'X'.
  lwa_del_schedule_inx-dlvscheddate = 'X'.
  lwa_del_schedule_inx-updateflag   = 'I'.
  APPEND lwa_del_schedule_inx TO pi_del_schedule_inx.


CALL FUNCTION 'SD_SALESDOCUMENT_CHANGE'
    EXPORTING
      salesdocument               = p_salesdocument
*     ORDER_HEADER_IN             =
      order_header_inx            = pwa_order_header_inx
*     SIMULATION                  = ' '
*     INT_NUMBER_ASSIGNMENT       = ' '
*     BEHAVE_WHEN_ERROR           = ' '
*     BUSINESS_OBJECT             = ' '
*     CONVERT_PARVW_AUART         = ' '
*     CALL_FROM_BAPI              = ' '
*     LOGIC_SWITCH                =
*     I_CRM_LOCK_MODE             = ' '
*     NO_STATUS_BUF_INIT          = ' '
*   IMPORTING
*     SALES_HEADER_OUT            =
*     SALES_HEADER_STATUS         =
    TABLES
      return                      = li_return
*     ITEM_IN                     =
*     ITEM_INX                    =
      schedule_in                 = pi_schedule_in
      schedule_inx                = pi_schedule_inx
*     PARTNERS                    =
*     PARTNERCHANGES              =
*     PARTNERADDRESSES            =
*     SALES_CFGS_REF              =
*     SALES_CFGS_INST             =
*     SALES_CFGS_PART_OF          =
*     SALES_CFGS_VALUE            =
*     SALES_CFGS_BLOB             =
*     SALES_CFGS_VK               =
*     SALES_CFGS_REFINST          =
*     SALES_CCARD                 =
*     SALES_TEXT                  =
*     SALES_KEYS                  =
*     CONDITIONS_IN               =
*     CONDITIONS_INX              =
*     SALES_CONTRACT_IN           =
*     SALES_CONTRACT_INX          =
*     EXTENSIONIN                 =
*     ITEMS_EX                    =
*     SCHEDULE_EX                 =
*     BUSINESS_EX                 =
*     INCOMPLETE_LOG              =
*     EXTENSIONEX                 =
*     CONDITIONS_EX               =
*     SALES_SCHED_CONF_IN         =
*     DEL_SCHEDULE_EX             =
      del_schedule_in             = pi_del_schedule_in
      del_schedule_inx            = pi_del_schedule_inx
*     CORR_CUMQTY_IN              =
*     CORR_CUMQTY_INX             =
*     CORR_CUMQTY_EX              =
*     PARTNERS_EX                 =
*     TEXTHEADERS_EX              =
*     TEXTLINES_EX                =
*     BATCH_CHARC                 =
            .

Re: function module to insert table VBEH /move from VBEP to VBEH

Former Member — Tue, 11 Nov 2008 06:01:33 GMT

with my own answer from Teddy

topic Re: function module to insert table VBEH /move from VBEP to VBEH in Application Development and Automation Discussions

function module to insert table VBEH /move from VBEP to VBEH

Re: function module to insert table VBEH /move from VBEP to VBEH

Re: function module to insert table VBEH /move from VBEP to VBEH

Re: function module to insert table VBEH /move from VBEP to VBEH