general

[Former Member]

i have created two tables ie zstudent and zstudentmarks and i have maintained data by using table maintanence generator if we want to combine the fields can we use maintanence view to create it?if so how plz reply to me. points will be rewarded.

[Former Member]

Hi

You can create Database view and can combine both the tables based on their primary and foreign key relationships.

Reward Points if usefull.

Regards

Haritha.

[Former Member]

Hi

Yes you can create a Database view to combine the two tables by using a Join condition between the two tables.Go to SE11 and create

Create a foreign Key relation ship between the two Tables for the field STUDENT No from the menu, and with the help of common fields in both tables we can combine the data.

Reward points if useful

Regards

Anji

[p291102]

Hi,

check complete refrense..,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

Well the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

SE11->Utillities->table maintainence generator

You need to enter the values of following fields:

1. Table name

2. Authorization group , and authorization object (select the suitable one )

3. Function group and package

4. Maintainence type : single or double screen maintainence view depending on the option selected.

5. Maintain screen number : you may specify a value or let the system generate one for you.

The validation code for the table entry is written in the flow logic of this screen. Even some of the fields may be made display only , by adding suitable code in the logic or directly disabling the input in table control in the layout.

6) Activate

Thanks,

Sankar M

[Former Member]

hi manjula,

u want to join two tables or u need to create a view in which u want l the feilds of both tables..

for joining two tables.. u can do it by forgien key.. for this u `ll b having a key type symbol click on it.. and give base table (table in which primary key is there)

and click generate proposal.. ur tables r joined..

or else u want to create a maintaince view. go to se11 click on view.. check maintainence view..

give description,

give primary table name n click on relation ships..

u`ll get a list of tables which r realated to that tables..take the table u need.

n choose the fields ofur required....

and then cleck ontable maintaince genrator in menu bar,

give function module name and sabve check activate..

u`ll get it..

u `ll get it..

[Former Member]

The tables zstudent and zstudentmarks should have a key relation ship between them.

1. In Se11 Choose View --> Maintenance View.

2. here specify the two tables and maintain the relation ship. Specify the fields which you want maintenance. (Ex; Check VBAP_VAPMA for reference this is a data base view).

3. Go to Utilities and select Table maintenance generator.

4. Then using the maintenance generator we can maintain the data.

Raj