Maintenance View - Desc

[former_member194669]

All,

I have created custom table with same as table T179 and added a one more key as like

MANDT	MANDT	CLNT	3
PRODH	PRODH_D	CHAR	18
PRODH2	PRODH_D	CHAR	18

and added field PRODH2, Now my question is i needed to create a maintenance view for this, But in the mainteance view i need to display the description from T179T for field PRODH and PRODH2. The issue while creating maintenance view system will description VTEXT for only PRODH and not PRODH2 (If this is key field in this table ) .This is creating issue with table maintenance

MANDT	MANDT	CLNT	3
PRODH	PRODH_D	CHAR	18
VTEXT	BEZEI40	CHAR	40  "<< Desc From T179T 
PRODH2	PRODH_D	CHAR	18
VTEXT	BEZEI40	CHAR	40 " << Desc From T179T

1. Possible options are i find is in the Table Mainteance create a dummy field and change the flow logic to fill the descr field PRODH2.

Any other suggestion

[former_member194669]

All,

I have created custom table with same as table T179 and added a one more key as like

MANDT	MANDT	CLNT	3
PRODH	PRODH_D	CHAR	18
PRODH2	PRODH_D	CHAR	18

and added field PRODH2, Now my question is i needed to create a maintenance view for this, But in the mainteance view i need to display the description from T179T for field PRODH and PRODH2. The issue while creating maintenance view system will description VTEXT for only PRODH and not PRODH2 (If this is key field in this table ) .This is creating issue with table maintenance

MANDT	MANDT	CLNT	3
PRODH	PRODH_D	CHAR	18
VTEXT	BEZEI40	CHAR	40  "<< Desc From T179T 
PRODH2	PRODH_D	CHAR	18
VTEXT	BEZEI40	CHAR	40 " << Desc From T179T

1. Possible options are i find is in the Table Mainteance create a dummy field and change the flow logic to fill the descr field PRODH2.

Any other suggestion

[Former Member]

A text table has a language field and a key field that has a foriegn key relationship with the check table of that key field. In the foreign key relationship, the foreign key field relationship "Key fields of a text table" is selected. That is how system recognizes it as the text table.

In your case, you create your own text table associated with your Z table or do like what you mentioned.

[Former Member]

Hi a®s,

Create Ztable ZT179T (Text Table)

MANDT
SPRAS
PRODH
VTEXT
PRODH2
VTEXT2

OR

MANDT
SPRAS
PRODH2
VTEXT2

Create Foreign Key Relation ship from your ZTable ZT179T (Text Table)

Field    Check Table
MANDT  ==> T000 
PRODH  ==> T179T
PRODH2  ==> ZT179T

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

[former_member189059]

Hi,

I know this thread is old, but I have the exact same problem.

I have a custom view on a custom table.

The table has two LIFNR type fields and the view has their descriptions as well.

I cannot create another text table and have it populated with data as well.

One option I found is as below

After the maintenance is generated, find the form FORM GET_DATA_Z.. in the ..F00 include

There is a select single on LFA1 and the resultant value is put into both fields.

That can be modified to add another selection and populate accordingly.

But if someone else later regenerates this maintenance, they would miss out on this point.