topic Re: main custom table and its text table in Application Development and Automation Discussions

main custom table and its text table

Former Member — Mon, 20 Apr 2009 11:38:32 GMT

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

Re: main custom table and its text table

Former Member — Mon, 20 Apr 2009 11:43:16 GMT

YOu have to create maintenance view.

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

Regards,

Ravi

Re: main custom table and its text table

Sm1tje — Mon, 20 Apr 2009 12:20:30 GMT

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.

Re: main custom table and its text table

Former Member — Mon, 20 Apr 2009 12:27:25 GMT

Hi ,

Form SE11 you will have to create a Maintainance view.

good luck ,

Varghese