SM30 view with join

[Former Member]

Hello.

I'm new in this part of abap and would like to know how to do the following:

Table 1: Profiles

Primary Key: Profile_ID type Profile_ID

Datafield: Profile Name Type Char length 50.

Table 2: Prof_entries.

Primary Key: Entry_ID type NUMC length 5.

Foreign Key: Profile_ID type Profile_ID

Datafield: Name type Char Length 50.

So.. Suppose table Profiles is filled. Now I want A maintainence view of Prof_entries where the user can enter the Entry_ID and the Name. Then he can select a profile name from a list. ==> Profile_ID is assigned to the table.

Any idea on how to do that ?

Thanks

[Former Member]

Create a database view based on this two tables.

Conect the two tables using the keys relations.

Create a maintenance view based on the database view.

[Former Member]

Hello,

Just remember that the view must be of type Maintanance view.

Regards,

[Former Member]

Hello.

Problem is that I don't know how to create the list of profiles. I also don't know how to get the ID in the table when they select a profile name.

Greets

[Former Member]

Can someone help me please??