topic Re: updating database tables in Application Development and Automation Discussions

updating database tables

Former Member — Wed, 13 Feb 2008 09:22:10 GMT

Hi,

I am working on a module pool program.I want to update the values of some fields in marc and mvke tables by changing the field values in one screen.

I am using BAPI_MATERIAL_SAVEDATA function module for updating the database tables.I tried changing mrp type and mrp controller field values for a material 123-L540-22.But in the debugging mode in the return parameter of this fm i can see the message as 'The field MARC-MTVFP/BAPI_MARC-AVAILCHECK is defined as a required field; it doesnot contain any entry’.Why is it giving this message?

Re: updating database tables

Former Member — Wed, 13 Feb 2008 09:27:02 GMT

Those are required fields pass the values to them also

Regards

Shiva

Re: updating database tables

Former Member — Wed, 13 Feb 2008 09:29:31 GMT

hi hema,

you need to specify the values for these fileds before executing the program.

hope it helps..

do reward if helpful..

Re: updating database tables

Former Member — Wed, 13 Feb 2008 09:33:21 GMT

Hi,

In that screen there are 10 fields.If the user wants to change the values for only 2 fields how can he know that this field is a mandatory field?

Re: updating database tables

Former Member — Wed, 13 Feb 2008 09:38:35 GMT

Hi,

The Material is configure In different Ways, with some fields mandatory or Optional.

Write a Select Statement and get the data for that particular field and again you update.

BAPI or T.code does not work unless all the required fields are passed .

Regards

Balu.Malvatu