Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database View ITOB IN sap PM

Former Member
0 Kudos

Hi all,

I have two custom fields zzccomp & zzcplant. Both fields have been included in Table : IFLOT (CI_IFLOT). Now i was trying to inclue the same fields in table EQUI ( CI_EQUI )
while , Activating it is giving error zzcXX & zzpXX are not unique in ITOB. Since, Both this table is being used in database view ITOB.

Note : I don't want to use the Different fields name for both tables. Because, same data is being saved to both the master table so, why use different field names.

Since, ITOB is standard DBView. I am Not getting how to Achieve this.

Kindly, Suggest .

1 ACCEPTED SOLUTION

Rashid_Javed
Contributor
0 Kudos

Well if you have change access to ITOB, you can change the filed names in it.

Example: Table EQUI and EQUZ both use field ERDAT. In view ITOB, the field form EQUI is named as ERDAT but similar field from table EQUZ is named as ERDAT_Z (thus for the view ITOB, both are unique fields).

So in your case, fields from table IFLOT can have the same name but for fields in EQUI you have to manually rename these like zzccomp_e

However for this to happen i think you must have change access to view ITOB (access key).

RJv
2 REPLIES 2

Rashid_Javed
Contributor
0 Kudos

Well if you have change access to ITOB, you can change the filed names in it.

Example: Table EQUI and EQUZ both use field ERDAT. In view ITOB, the field form EQUI is named as ERDAT but similar field from table EQUZ is named as ERDAT_Z (thus for the view ITOB, both are unique fields).

So in your case, fields from table IFLOT can have the same name but for fields in EQUI you have to manually rename these like zzccomp_e

However for this to happen i think you must have change access to view ITOB (access key).

RJv

0 Kudos

Yes Rashid You are Correct .

The only way is to get Access key and make changes and activate ITOB.