Append structure vs custom table

[brian_basch]

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.

[Former Member]

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.

[Former Member]

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

[brian_basch]

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