‎2008 Apr 25 12:24 PM
hI expert !
plz tell me what is the criteria to choose append structure or include in my standard tables . what is the benefit , disadvantage of these two . are they ehancements or modification. plz help me as i m confused about this two .
thanks
‎2008 Apr 25 12:28 PM
Hi Rajna,
you can add additional fields to table by using
1)include structure
2)append structure
Include Structure:you can include any no of fields using include structure and you can include this structure in any no of fields.but if you want to use include for sap tables they have to provide include.check table MARA.we have an include EMARA.so if you insert any field in EMARA it is added to the field
Append Structure:You can include any no of fields using append structure.but append structure is only for one table.you can use the structure for only one table.mara is also have some append structures.check by clicking on append structures which is in application toolbar
so finally if you want to add the structure at the end means fields at the end use append,if in the middle use include structure.
rewards points if helpful.
‎2008 Apr 25 12:32 PM
Hi Ranjna,
APPEND STRUCTURES
Append structures are used for enhancements that are not included in the standard. This includes special developments, country versions and adding customer fields to any tables or structures.
An append structure is a structure that is assigned to exactly one table or structure. There can be more than one append structure for a table or structure.
The following enhancements can be made to a table or structure TAB with an append structure:
· Insert new fields in TAB,
· Define foreign keys for fields of TAB that already exist,
· Attach search helps to fields of TAB that already exist,
INCLUDE STRUCTURE
Basic form
INCLUDE STRUCTURE rec.
Effect
When you define a structure rec (with DATA or TYPES ), this statement copies the components of the structured data type subRec to the structure rec .
Since you can define nested data structures (i.e. structures with sub-structures) starting from Release 3.0, you should use INCLUDE STRUCTURE only if you want to introduce types in a program first and nested structures in a later step.
you can find more information on sap help.
Please reward if helpful
Manish
‎2008 Apr 25 1:30 PM
Hi,
Structures:
Adding new fields to an existing table using
1.Append Structure
2.Include structure
Inserting Append Structure:
Procedure Follows:
1.Go to change mode in the maintenance screen of the table where you want to add the append structure.
2. Choose Goto -> Append structures.
3. Enter the append structure name and choose enter .
4. Define the fields of the append structure. You can proceed as when creating a normal structure two restrictions .
1.An append structure must be flat, that is each field of the append structure must either refer to a data element or be directly assigned a data type, length, decimal places and short text.
2.That is the field names must begin with ZZorYY. This prevents conflicts with fields inserted in the table by SAP.
5. Choose Activate.
Inserting an Include Structure:
Procedure Follows:
1.Place the cursor under the line in which you want to insert the include and choose Edit ® Include ® Insert.
A dialog box appears.
2.Enter the structure name. You can optionally enter a group name or a three-place suffix.
3.Choose enter.
4. Select column Key if all the fields in the include should be key fields of the table.
5. Choose enter.
6.Save and activate.
Reward if it useful.
Thanks in advance
Lakshmi.
‎2008 Apr 25 3:08 PM
hi
Edit -> include -> insert . Give the name of pre defined structure.. can be anywhere in the table
Goto -> append .. you can not give the name of pre defined, so we say that append can only be done to a single table. And at the end
please reward points