10-20-2008 9:26 PM
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.
10-20-2008 9:34 PM
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.
10-22-2008 9:33 AM
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
02-09-2009 10:56 PM
Thank you for assistance. This has helped in designing and customization.