Unable to update standard table ( /mrss/d_dem_adm )

[Former Member]

Hi,

I am trying to update / Insert a standard database table ( /mrss/d_dem_adm ). But i am unable to update the table.

I am getting dump when i am trying to update using this FM ( /MRSS/SGD_DEM_adm_DU ).

Let me know is there any other way to update this table.

When i am trying to execute this FM in SE37 it is not allowing me to enter input. I mean import parameter is blocked. I feel this might be the problem for that dump.

Do the needful.

Regards,

Thiyag.

[Former Member]

Hi,

Check whether you are passing parameter or structure key fields data or not. if you are missing to pass required field values, fill those mandatory fields and try with it.

if you pass all the fields to the parameter, even it will not work. Then declare work area for the same table and pass required values to the decalred structure and insert the data to the table and after that write commit work.

Example:

insert table from work area.

commit work.

Ram.

[Former Member]

Hi,

It will work. If i give explicit commit.

But i feel writing directly INSERT / UPDATE or MODIFY for a standard table is not a good practise. It may cause database inconsistencies. So that is not the good approach.

My question is very simple if i execute that standard FM directly why it is not allowing me to enter input and also let me is there any alternative FM to replace this table update.

regards,

Thiyag.

[umashankar_sahu]

Hi Thiyag ,

FM what you are using is of FG /MRSS/SGD_DU. which contains some other FM like /MRSS/SGD_DEM_H_DU.

which is having Importing parameter ready for input check out with this if it full fills your requirement.