2007 May 22 6:24 AM
1.can any one solve this plz, i have a standard table 'mara'. it has 200 fields.i want to add new ' 5 ' fields to this standard table.how can i do this plz give me the solution.
2.wat is 'append structure',wat is the diff b/w 'append' and 'include'?
3.i have a int table with a, b, c , i want to display 200 entries in my out put using alv report? plz wat is the logic to this?
1.can any one solve this plz, i have a standard table 'mara'. it has 200 fields.i want to add new ' 5 ' fields to this standard table.how can i do this plz give me the solution.
2.wat is 'append structure',wat is the diff b/w 'append' and 'include'?
3.i have a int table with a, b, c , i want to display 200 entries in my out put using alv report? plz wat is the logic to this?
2007 May 22 7:02 AM
Hi,
To add 5 fields to the standard table you have to get access key from SAP.Before adding new fields you have to be check whether it will affe ct any other objects.
3.Use REUSE_ALV_GRID_DISPLAY you can display the output from the internal table.
Reward points if it is helpful.
Regards,
Sangeetha.A
2007 May 22 7:38 AM
Hai,
1.U can't able to change the Standard Table.U must have Authorisation to change the Standard Table.
2.Include structures can be reused while an append structure is unique and may be used only once. (you can try to append to another table an append with same name, it wont work).
You can activate include structures themselves while at append structures you need to active the whole table again.
Append structures are always at the end of a TABLE, while include structures can be at any place.
Append structure can only be assigned to exactly one table or structure.If you want to append the same fields to several tables or structures, you can store these fields in an include structure. In this case you must create an append structure for each of these tables or structures and include the include structure there.
3.Use REUSE_ALV_LIST_DISPLAY FM.
Regards,
Padmam.
2007 May 22 7:39 AM
Hi Murali,
Answering your questions:
1. You can very well add new fields to any of the standard tables like MARA. But to do so you have to get the access key from OSS.
When we want to add customer fields to the table, to protect these fields from being overwritten by SAP, they are stored in an append of the table. We have to define a name for this append. The system offers a list of appends that already exist for this table. If those don't match your requirement create a new append structure. Also the new fields can be added through include structure.
2. Difference betwee append & include structure:
Append structures are used for enhancements which are not provided for in the standard (special developments, country versions and adding customer fields to SAP standard tables).
<b>An append structure is assigned to exactly one table.</b> i.e., an append structure can be used only for the table it is created.
But an include structure can be used in several tables.If you add a field to an include structure, all tables that contain that include structure will be updated.
3. You can use the function module REUSE_ALV_LIST_DISPLAY.
Hope all your questions are answered.
Reward all the useful questions.
Regards
Sayee
Message was edited by:
Sayee
2007 May 22 7:54 AM
hi murali,
there are two ways to add filed to 'MARA' table,
one is,
create a database view for a mara table then u can add new records to that,
second one is that,
go to T.code mm01 and create material records.
then about structure and include,
both can be used for, to add one or more fields to the data base table,
the difference is include structure has reusabilitey concept where as append structure doesn't.
finaly about the alv list output,
u just call FM 'reuse_alv_list_display' to show output in alv list before that fill your fieldcatlog and <itab> then pass these into parameters of the FM.
regards,
seshu.
2007 May 22 8:09 AM
Hi Murali,
Pls pls use proper subject for the query you want to post. this helps others in identifying the problem in a better manner.
and kindly mark helpful answers.
Regards,
Karan