topic Re: update database tables in material master in Application Development and Automation Discussions

update database tables in material master

Former Member — Fri, 02 Feb 2007 08:04:30 GMT

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.

Re: update database tables in material master

Former Member — Fri, 02 Feb 2007 08:07:51 GMT

Hi Sudheer,

make use of the bapi: BAPI_MATERIAL_SAVEDATA.

Refer this link for sample usage of the same:

Regards,

Ravi

Re: update database tables in material master

Former Member — Fri, 02 Feb 2007 08:12:59 GMT

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.

Re: update database tables in material master

Former Member — Fri, 02 Feb 2007 08:13:39 GMT

Hi sydheer,

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

Regards, Dieter

Re: update database tables in material master

sourabhshah — Fri, 02 Feb 2007 08:20:18 GMT

Check out this function module

MVKE_ARRAY_UPDATE

Regards,

Sourabh

Re: update database tables in material master

Former Member — Fri, 02 Feb 2007 09:37:26 GMT

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.