update database tables in material master

[Former Member]

Hi Gurus,

I need to update the MVKE database table. can any one suggest the standard function modules to update it.

Thanks in Advance,

Sudheer.

[former_member181962]

Hi Sudheer,

make use of the bapi: BAPI_MATERIAL_SAVEDATA.

Refer this link for sample usage of the same:

Regards,

Ravi

[Former Member]

Hi Ravi,

I used the bapi_material_savedata. its execute sucessfully but not update the database table.

LOOP AT IT_MVKE INTO WA_MVKE.

L_HEADDATA-MATERIAL = WA_MVKE-MATNR.

L_SALESDATA-SALES_ORG = WA_MVKE-VKORG.

L_SALESDATA-DISTR_CHAN = WA_MVKE-VTWEG.

L_SALESDATA-PROD_HIER = WA_MVKE-PRODH.

APPEND L_SALESDATA.

L_SALESDATAX-SALES_ORG = 'X'.

L_SALESDATAX-DISTR_CHAN = 'X'.

L_SALESDATAX-PROD_HIER = 'X'.

APPEND L_SALESDATAX.

ENDLOOP.

CALL FUNCTION 'BAPI_MATERIAL_SAVEDATA'

EXPORTING

HEADDATA = L_HEADDATA

• CLIENTDATA =

• CLIENTDATAX =

• PLANTDATA =

• PLANTDATAX =

• FORECASTPARAMETERS =

• FORECASTPARAMETERSX =

• PLANNINGDATA =

• PLANNINGDATAX =

• STORAGELOCATIONDATA =

• STORAGELOCATIONDATAX =

• VALUATIONDATA =

• VALUATIONDATAX =

• WAREHOUSENUMBERDATA =

• WAREHOUSENUMBERDATAX =

SALESDATA = L_SALESDATA

SALESDATAX = L_SALESDATAX

• STORAGETYPEDATA =

• STORAGETYPEDATAX =

• FLAG_ONLINE = ' '

• FLAG_CAD_CALL = ' '

• NO_DEQUEUE = ' '

• NO_ROLLBACK_WORK = ' '

IMPORTING

RETURN = IT_RETURN

• TABLES

• MATERIALDESCRIPTION =

• UNITSOFMEASURE =

• UNITSOFMEASUREX =

• INTERNATIONALARTNOS =

• MATERIALLONGTEXT =

• TAXCLASSIFICATIONS =

• RETURNMESSAGES =

• PRTDATA =

• PRTDATAX =

• EXTENSIONIN =

• EXTENSIONINX =

.

can u solve this problem

thanks & Regards,

Sudheer.

[Former Member]

see MVKE is material sales data .

materials in a sales area are present in this table.

The views in MM03 for material sales updates this table at the time of material creation.

What is the requirement for updating the MVKE? im not clear on that .

regards,

vijay.

[Former Member]

Hi sydheer,

if you want mass-update, use tcode MASS with object BUS1001001 or BUS1001.

Regards, Dieter

[sourabhshah]

hi

Check out this function module

MVKE_ARRAY_UPDATE

Regards,

Sourabh