Updating Standard Database

[Former Member]

I have desined one customised Editable Alv having PO Quantity in it.

I want to know, how many ways are there to update SAP Standard database apart from FM, and BAPI.

Pls share your suggestions.

[Former Member]

Hi,

To update standard Database tables ,we can use these methods

-->BDC(call transaction and session method)

--> LSMW

--> BAPI

--> IDOC using ALE and EDI technologies

Regards,

vineela

[Former Member]

Hi,

1.Using Table Maintenace,

2.IDOC processing using ALE.

3.LSMW,BDC

Example for Editable ALV:

Check the following link:

http://sapdev.co.uk/reporting/alv/alvgrid_editable.htm

Check this:

fieldcat-edit = 'X'.

Regards,

Shiva Kumar

[Former Member]

Hi,

You can use a BDC recording and use a call transaction.

Never try a direct database update on standard tables.

regards,

Advait.

[Former Member]

I am asking for standard database table update approach pls.

[Former Member]

Hi,

To update standard Database tables ,we can use these methods

-->BDC(call transaction and session method)

--> LSMW

--> BAPI

--> IDOC using ALE and EDI technologies

Regards,

vineela

[Former Member]

Hi Anee,

When you are trying to update a standard database table, you need to use BDC or BAPI method of updating a transaction, because when we update a standard DB table, it has relations with many other DB tables. It is wrong to update a single DB table, without updating the related DB tables.

So we use BDC or BAPI, which in turn have several ways, such as Session, Call Transaction, BAPI(FM), Idoc, LSMW, Idoc, etc..

Anyway, if you need to update a single DB table only for a particular requirement, you can write a z-prg to update the respective table, and use MODIFY keyword to modify an existing entry, or INSERT a new entry if it does not exist.

Hope this is helpful to you. If you need further information, revert back.

Reward all the helpful answers.

Regards

Nagaraj T