Currency field in Table maintenance generator

[former_member276465]

Hi,

I have created a table with fields amont and currency..When I create generate the table maintenance for this table I am not able to see currency and amounts field on the generated screen. Please do help me whats missing from my end.

raghu

[gopi_narendra]

make the foriegn key for the currency TCURC

This was for those whose currency keys are not maintained

Resaon might be the Currency is not maintained in the table TCURC

they can be maintained in SPRO

SAP Netweaver - > General Setting - > Currencies - > Check Currency Codes

Regards

- Gopi

[former_member276465]

Hi.

I have one overview screen and 1 detailed screen. these two fields are not appearing in the overview screen but it appears in the detailed screen. Why these two fields are not appearing in the overview screen./

[Sandeep_Kumar]

Hi,

If u have not specified Currencya nd amount fields as primary keys then these two fields will not appear in the generated views.

SO u can specify CURRENCY and AMOUNT as primary keys and try.

Hope this helps.

[former_member276465]

I cant make these two fields as primary key fields... I have one overview screen and 1 detalied screen. In overview screen these two fields are not appearing but in detailed screen they are appearing..

[Former Member]

Create a <b>foreign key relation</b> for the Currency field with the table <b>TCURC</b> and regenerate the table maintenance.

Regards

Kathirvel

[former_member276465]

Yeah I maintened check table for currency as TCURC

[former_member404244]

Hi,

Check the data types of fields amont and currency in ur table.Also u need to specify the reference field for amount and currency.

Regards,

nagaraj

[Former Member]

Check the following things.

Adjust database table. Utilities--> Database utility --> select adjust and activate.

Check the reference is maintained for Amount Field.

[former_member404244]

Hi,

U should make them primary fields otherwise they won't appear in the overview screen.If possible use only one screen.When u r maintaining the table ,instead of going for two step maintainence,go for one step maintanence .

Regards,

Nagaraj