2007 Feb 02 8:04 AM
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.
2007 Feb 02 8:07 AM
Hi Sudheer,
make use of the bapi: BAPI_MATERIAL_SAVEDATA.
Refer this link for sample usage of the same:
Regards,
Ravi
2007 Feb 02 9:37 AM
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,
2007 Feb 02 8:12 AM
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.
2007 Feb 02 8:13 AM
Hi sydheer,
if you want mass-update, use tcode MASS with object BUS1001001 or BUS1001.
Regards, Dieter
2007 Feb 02 8:20 AM
hi
Check out this function module
MVKE_ARRAY_UPDATE
Sourabh
Bluesky
