Skip to Content

Append structure vs custom table

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 08: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2008 at 08: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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2009 at 10:56 PM

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

    Add comment
    10|10000 characters needed characters exceeded