topic Re: Updating Standard Database in Application Development and Automation Discussions

Updating Standard Database

Former Member — Wed, 21 May 2008 09:43:10 GMT

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.

Re: Updating Standard Database

Former Member — Wed, 21 May 2008 09:46:25 GMT

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

Re: Updating Standard Database

Former Member — Wed, 21 May 2008 09:47:35 GMT

Hi,

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

Never try a direct database update on standard tables.

regards,

Advait.

Re: Updating Standard Database

Former Member — Wed, 21 May 2008 10:13:03 GMT

I am asking for standard database table update approach pls.

Re: Updating Standard Database

Former Member — Wed, 21 May 2008 12:32:22 GMT

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

Re: Updating Standard Database

Former Member — Wed, 21 May 2008 12:37:23 GMT

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