main custom table and its text table

[Former Member]

Dear All,

I am having one main custom table and one text table for it.

I can create Table Maintenance for one table like for text table.

My requirement is that I need to populate two tables together.

Means if new records are entered in text table, those should be updated in main table also.

or vice-versa (but text needs to enter where then ?)

pls guide me how shall I do this.

Rishi

[Former Member]

Dear All,

I am having one main custom table and one text table for it.

I can create Table Maintenance for one table like for text table.

My requirement is that I need to populate two tables together.

Means if new records are entered in text table, those should be updated in main table also.

or vice-versa (but text needs to enter where then ?)

pls guide me how shall I do this.

Rishi

[Former Member]

YOu have to create maintenance view.

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ed2d446011d189700000e8322d00/frameset.htm

Regards,

Ravi

[Sm1tje]

Not quite sure what it is exactly you did, but here's how it should be done.

1. Create custom table (key field FOR EXAMPLE, mandt and OBJECT)

2. Create text table with field SPRAS (language), OBJECT (this should have a foreign key field relationship with table from step 1. Press the KEY icon when creating the table and check radiobutton for text relationship. Relationship type will be 1:CN. Last field will be the long text of the OBJECT.

3. Create a database view with type MAINTENANCE VIEW. As tables you should join both tables (step 1 and 2) in this view.

4. Determine which fields should be displayed (forget about the SPRAS field, do not include this field as fields to be maintained.

5. Create the actual maintenance view with Table maintenance generator (Via Menu).

6. Via SM30 you can now maintain your tables in ONE step.

[Former Member]

Hi ,

Form SE11 you will have to create a Maintainance view.

good luck ,

Varghese