topic Re: Which One is Best for database table - (.INCLUDE or .APPEND ) in Application Development and Automation Discussions

Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Wed, 27 May 2009 03:35:04 GMT

After adding .INCLUDE structure in VBAP table, the same include is comming automatically in KOMP & KOMG table.

But while adding .APPEND in VBAP table, structure is not appearing in KOMP & KOMG table. so which one is better choice INCLUDE OR APPEND ?

While adding .APPEND to Database table , ACCESS KEY is not required But while adding .INCLUDE

Access key is needed. Can i add .INCLUDE without access key ?

Some search helps are getting deleted while transporting the table with .APPEND.

what may be the reason?

Finally, please suggest me which one to use for the best - .APPEND or .INCLUDE .

Best Regards

pabitra

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Wed, 27 May 2009 03:49:29 GMT

Hi,

I believe using APPEND is better rather than using INCLUDE statement. The access key depends on the server you are using try it with another server which is havaing prior permissions to access it. Then it wont ask you for access key.

Thanks & regards,

Pavan.

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Wed, 27 May 2009 05:56:29 GMT

Hi,

using .append is always better as it will attach the fields at runtime and also you need not give any access key to the table.... and also you are actually not modifying the table, wherein if you give .include you have to adjust the table, in that process may be some data would be lost... it does not happen always but in certain cases it might happen which the adjust process is going on it might delete some of the data....

hence using append structure is better....

Regards,

Siddarth

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Wed, 27 May 2009 06:00:11 GMT

Hi,

Search the SCN..you can find lot of threads answered to your question.

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Wed, 27 May 2009 09:10:35 GMT

Hi,

<< Cut and paste without attribution from http://www.saptechies.com/difference-bn-include-structure-and-append-structure/ removed >>

Regards,

Ravali

Edited by: Rob Burbank on May 29, 2009 2:28 PM

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

MarcinPciak — Wed, 27 May 2009 09:37:01 GMT

Hi Pabitra,

Siddarth is right. I will just extend his answer a litte bit.

INCLUDE phisically changes strcutre of the table, so that's why you need and access key as it is the same as you would change i.e field names of that table.

APPEND structure is an enhacement method to cope with any extra fields which might be added in the future, but SAP developer who was preparing the table didn't think of.

So the first should be always used when there is need to add some fields but table is custom one, and this will not affect current usage of that structure in some programs.

The second should be used each time you want to do extend structure of standard table (and if tables settings allows that for doing so, you can check that selecting Extras->Enhacenment categoy in menu bar of a table). Please note that all new field names here must start with ZZ or YY in case when SAP developer would send some correction to a table in future (where field could start with Z or Y).

The rest is well explained by Siddarth.

@ Ravali,

Please do not copy paste any text without any your input. This will be reported to moderators. This time I will not do this, as you are a new one here. Please read Rules and engagement to avoid violating them.

Regards

Marcin

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Thu, 28 May 2009 12:25:24 GMT

Hi,

Always an append is better than the Include for various reasons.

Try to find out from the attached link, the difference between the two.

http://www.saptechies.com/difference-bn-include-structure-and-append-structure/

Regards

Ramesh Sundaram

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Fri, 29 May 2009 06:37:13 GMT

dear pabitra,

Do visit http://help.sap.com/search/highlightContent.jsp for append structure .

Cheers

fareed

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Fri, 29 May 2009 18:21:13 GMT

Always use .APPEND to a std database table,if u want to use .INCLUDE then

u need access key which u need to get from the basis.

u can go for both .APPEND and .INCLUDE for the ZTables that u create.

Regards

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Mon, 01 Jun 2009 13:50:42 GMT

Hi,

Include Struct:

===============

Can be used for any number of Tables / Structres.

Append Struct:

=============

1. Can be used/assigned exactly for one table or structure.

i.e., When u assign a structure to a table, in future u cannot use the same Append struct for any other tble / structure.

2.Foreign keys for the appended fields must be defined within the append structure

3. No append structures may be added to tables with long fields like data types VARC, LCHR or LRAW.

see the link for more info

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ebc9446011d189700000e8322d00/content.htm

Hope this helps.

Best Regards,

Sumana

Re: Which One is Best for database table - (.INCLUDE or .APPEND )

Former Member — Fri, 05 Jun 2009 02:47:18 GMT

hello ,

In this case APPEND in better than Include , so you can go ahead with APPEND

Regards

Sathish