topic Append structure vs custom table in Application Development and Automation Discussions

Append structure vs custom table

brian_basch — Mon, 20 Oct 2008 20:26:33 GMT

What are the pro's and con's of using an append structure on a standard SAP table vs using a custom table with the same primary key to store the information?

For example: we have a custom table that stores additional information about certain types of notifications. The custom table has the same primary key as QMEL. There is a one-to-one relation between the custom table and QMEL for those certain types. The action box is used to update the custom table.

Re: Append structure vs custom table

Former Member — Mon, 20 Oct 2008 20:34:49 GMT

Its mainly a design decision. I have used both in various scenarios. Once advantage of using Append Structure is that you dont have to worry about maintaining a separate table, ie for updating / deleting rows from the primary table , you dont need to code for your custom Z table too.

During BAPI calls, Append strcutures could be taken care automaticlaly using BAPIPAREX segment, while for custom table you need to code yourself.

Re: Append structure vs custom table

Former Member — Wed, 22 Oct 2008 08:33:57 GMT

Hi,

I think it is mainliy releted with security and maintance purposes.

Refer to the following link for more details.

http://www.beacon.nc.gov/initiatives/hr_payroll/documents/1.2.8.3_TECH_SAPSecurityStrategy.pdf

Thanks

Rajesh Kumar

Re: Append structure vs custom table

brian_basch — Mon, 09 Feb 2009 22:56:58 GMT

Thank you for assistance. This has helped in designing and customization.