2013 Aug 05 8:22 AM
Hello Experts,
I am using BAPI_REQUIREMENTS_CREATE to upload data to MD61, this bapi is adding extra column in md62 when i check the
material ,I am using Week format , for ex i am uploading week 31 and week 32 ,it is uploading like below\
week31.2013 week31.2013 week32.2013 week32.2013
1000 500
it is adding extra column in md62 ,where is the problem ? pls tell me
I am attaching my code.Please help me in this.
2013 Aug 05 8:40 AM
can you share your code?
call function 'BAPI_REQUIREMENTS_CREATE'
exporting
requirements_item = l_req_item
do_commit = 'X'
update_mode = 'X'
tables
requirements_schedule_in = l_it_req_sch
return = l_return.
2013 Aug 05 9:59 AM
Hi,
thank u for giving immediate response,
this is my code, pls tell me where i did mistake?
data: begin of i_requirements_schedule_in occurs 0.
include structure bapisshdin.
data: end of i_requirements_schedule_in.
data: i_bapireturn1 like bapireturn1 occurs 0,
w_bapireturn1 like bapireturn1.
data: w_bapisitemr like bapisitemr,
date1 type budat,
date2 type budat.
constants: c_version type bapisitemr-version value '00',
c_vers_activ type bapisitemr-vers_activ value 'X',
c_reqmtsplannumber type bapisitemr-req_number value '',
c_unit type meins value 'EA',
c_day type prgrs value '1'.
clear i_requirements_schedule_in.
refresh i_requirements_schedule_in.
perform populate_requirements_item.
perform populate_requirements_schedule.
CALL FUNCTION 'BAPI_REQUIREMENTS_CREATE'
EXPORTING
REQUIREMENTS_ITEM = w_bapisitemr
* REQUIREMENT_PARAM =
* DO_COMMIT = 'X'
* UPDATE_MODE = 'X'
* REFER_TYPE = ' '
* PROFILID = ' '
* IMPORTING
* MATERIAL =
* PLANT =
* REQUIREMENTSTYPE =
* VERSION =
* REQMTSPLANNUMBER =
* MRP_AREA =
* MATERIAL_EVG =
TABLES
REQUIREMENTS_SCHEDULE_IN = i_requirements_schedule_in
* REQUIREMENTS_CHAR_IN =
RETURN = i_bapireturn1
.
CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
WAIT = 'X'
* IMPORTING
* RETURN =
.
LOOP AT i_bapireturn1 INTO w_bapireturn1.
ENDLOOP.
*&---------------------------------------------------------------------*
*& Form POPULATE_REQUIREMENTS_ITEM
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM POPULATE_REQUIREMENTS_ITEM .
clear w_bapisitemr.
w_bapisitemr-material = '000000000000600021'.
w_bapisitemr-plant = '1100'.
w_bapisitemr-requ_type = 'LSF'.
w_bapisitemr-version = '00'.
w_bapisitemr-vers_activ = 'X'.
* w_bapisitemr-req_number = c_reqmtsplannumber.
endform.
form populate_requirements_schedule.
date1 = '20130802'.
date2 = '20130809'.
i_requirements_schedule_in-date_type = '2'.
i_requirements_schedule_in-req_date = date1.
i_requirements_schedule_in-req_qty = '1000.0'.
i_requirements_schedule_in-prod_ves = 'DB'.
* i_requirements_schedule_in-unit = c_unit.
append i_requirements_schedule_in.
i_requirements_schedule_in-date_type = '2'.
i_requirements_schedule_in-req_date = date2.
i_requirements_schedule_in-req_qty = '500.0'.
i_requirements_schedule_in-prod_ves = 'DB'.
* i_requirements_schedule_in-unit = c_unit.
append i_requirements_schedule_in.
endform.
2013 Aug 05 10:15 AM
Hi Ram,
date1 = '20130802'.
date2 = '20130809'.
i_requirements_schedule_in-date_type = '2'.
i_requirements_schedule_in-req_date = date1.
i_requirements_schedule_in-req_qty = '1000.0'.
i_requirements_schedule_in-prod_ves = 'DB'.
* i_requirements_schedule_in-unit = c_unit.
append i_requirements_schedule_in.
CLEAR i_requirements_schedule_in . ( Add this line )
i_requirements_schedule_in-date_type = '2'.
i_requirements_schedule_in-req_date = date2.
i_requirements_schedule_in-req_qty = '500.0'.
i_requirements_schedule_in-prod_ves = 'DB'.
* i_requirements_schedule_in-unit = c_unit.
append i_requirements_schedule_in.
CLEAR i_requirements_schedule_in .
=========================================
LOOP AT i_bapireturn1 INTO w_bapireturn1.
ENDLOOP.
Instated of Loop and End loop write as below way ..
READ TABLE i_bapireturn1 WITH KEY TYPE = 'S'.
if SY-SUBRC eq '0' .
....
ELSE.
.....
ENDIF.
Regard's
Smruti
2013 Aug 05 12:56 PM
Hi,
data is uploading to md61 using BAPI_REQUIREMENTS_CREATE' ,but the problem is adding extra column in table column in md62.
i included clear i_requirements_schedule_in but the problem is same.
anybody faced this problem ,pls help me in this.
2013 Aug 06 4:28 AM
Hi Ram,
Check this Note 883434 - MD62: Duplicate planned ind reqmts for one pd (consulting)
Regard's
Smruti