maintenance view for standerd table

[Former Member]

hi . i want to update a field in standerd table. i try &sap_edit.but i dont know why people suggest that...its not working...any alternate to update standerd table .

[Former Member]

hi . i want to update a field in standerd table. i try &sap_edit.but i dont know why people suggest that...its not working...any alternate to update standerd table .

[MarcinPciak]

- you can use maintenance view as long as table Display/Maintenance not allowed option is not choosen for it

- providing above is fulfilled the same you can update it using &SAP_EDIT - this is however not recommened as you can mess up something accidentally

- write simple ABAP report using INSERT/UPDATE statements to work on this table

Still, updating the standard table should generally be avoided. If table has option Display/Maintenance not allowed on, it is not intended to be changed, therefore you do it no your own risk.

Regards

Marcin

[Former Member]

Hi Haris,

To add a few points to the above poster, I would say that you must first check if there is any BAPI or function module to achieve your requirement. If not, consider using BDC and if even that is not possible , only then you should consider writing a update/Insert statement to a standard table in your Z program ( but at your own risk )

Br,

Advait

[Former Member]

let us know the field & table

Regards,

Srinivas

[Former Member]

Hi,

-Execute tcode SE16N

-Specify table name and execute &sap_edit tocde

-Press F8

-Change the required field value and 'Save'

-It should work.........But at own risk...........

Else as Standard Practise Develop a report and use Insert/Update/Modify Statement to update the relevant table.

Regards,

Vaishali.

[Former Member]

Hi ,

First talk to your Function Consultant , why the standard table needs tobe updated .

if there is a purpose or a reason , then see the table attribute whether it is Masterdata/Customdata /Transcation data.

Masterdata table

Becuase for all Master data there will be define Transcationcode with screen program .

Ex: for creating Vendor Master/Customer Master/Hr Master,etc so for all Master data ,there is Change Transcation code also ,so the Functional Consultant can change it , if it is bulk then just record that screen using LSMW or BDC so that you can modify the data in the Screen which will update the corresponding tabels.

Customdata table

If it is Customizing table then there will be a define Table Maintainance directly or a View with Table maintaintance View. so Again Function Consultant can change the data. one thing here if that data field is Primary Key ,then in the table maintaince view he or you cannot change the data directly ,so either way is to delete the entry and create new entry with the changes you/he want .

Transcationdata table

If it is Transcation data then you should not do the change's for the transcaction data , if still it is required then there will be reversable entry process (Ex: In Finance if posting with incorrect entries of Currency or GL, then that record should be reversed .)likewise in SD ,HCM also they can reverse .

Final OPTION is already you are trying already with SAP_EDIT and also Our Community friends told how to play with editing table data.

Regards,

[Former Member]

-