‎2007 Aug 10 7:53 AM
hi experts urgent plz,
1.i have created a Z- table, now i want to add new field or fields to that table, how can i add to that?wat r the steps plz explain and show the steps plz....
2.i have an int table with f1, f2, f3,
f1 f2 f3
1 1 3
2 2 4
when i write ,
at new f3
write: / itab-f3,
endat.
wat's the o/p?
ii. at new f3
write:/ itab- f1,
endat.
iii. at new f2,
write:/ itab-f2,
endat.
plz explain the 3 cases wat will happen?
‎2007 Aug 10 8:00 AM
hi
to add fields,
directly goto se11 , in the change mode . Add the fields save and activate.
then go to se14 and then activate the adjustments there..
‎2007 Aug 10 8:02 AM
1) Addition of fields to databae tables.
Hi create a structure with all ur required fields and inthat table in field provide <b>.include</b>, and indataelement provide that structurename and activate that table.
Using append structure addition also we can add what ever fields we want to add. append structure addition at beside the pushbutton technical settings.
Regards,
B.Sreenivasulu.
‎2007 Aug 10 8:17 AM
Hi,
1. To add field/fields you go to se11 and your ztable in change mode you can add new fields with proper element and domain, If you have already made the entries for the old fields you need to adjust the database. To do that you go to in your table maintenance screen select UTILITIES-DATABASE UTILITY-ADJUST DATABASE. The database will be adjusted now you can make entries into it.
2 . For your second question, you will get the output like this
i)
3
1 1 3
4
2 2 4
ii)
1
1 1 3
2
2 2 4
iii)
1
1 1 3
2
2 2 4 .
I suppose you should be knowing they call it control level processing, It is mainly used to have totals and subtotals in a report. You can have multiple control levels also. By using ON CHANGE OF <f1> you can get the same result. You try the same code and confirm the same on your own.
Reward points if useful.
Regards
Tharanatha