topic Re: adding extra column in md61 using BAPI_REQUIREMENTS_CREATE in Application Development and Automation Discussions

adding extra column in md61 using BAPI_REQUIREMENTS_CREATE

Former Member — Mon, 05 Aug 2013 07:22:53 GMT

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.

Re: adding extra column in md61 using BAPI_REQUIREMENTS_CREATE

Rushikesh_Yeole — Mon, 05 Aug 2013 07:40:51 GMT

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.

Re: adding extra column in md61 using BAPI_REQUIREMENTS_CREATE

Former Member — Mon, 05 Aug 2013 08:59:23 GMT

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.

Re: adding extra column in md61 using BAPI_REQUIREMENTS_CREATE

Former Member — Mon, 05 Aug 2013 09:15:02 GMT

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

Re: adding extra column in md61 using BAPI_REQUIREMENTS_CREATE

Former Member — Mon, 05 Aug 2013 11:56:45 GMT

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.

Re: adding extra column in md61 using BAPI_REQUIREMENTS_CREATE

Former Member — Tue, 06 Aug 2013 03:28:42 GMT

Hi Ram,

Check this Note 883434 - MD62: Duplicate planned ind reqmts for one pd (consulting)

Regard's

Smruti