I have to add a new field for the existing table like "ztell".

[Former Member]

Hi all,

my requirement is that,

I have to add a new field for the existing table like "ztell", this table(ztell) has some sample fields like name,address etc now I want to add new field email.Can anyone tell me how to go through this.

Thanks in advance

Venkat.

[Former Member]

Open the table in SE11 change mode

go to components tab

place the cursor after existing fields and give the name for new fiels and then data type

activate the table

Narendra

[Former Member]

Hi,

Go to the field catalog screen and click add new field button.

Make sure that the new field shd start with Z.

1.Call up the ABAP Dictionary (Transaction SE11)

2. Go to the field catalog screen and click add new field button.

Make sure that the new field shd start with Z. Give The domain and data element of corresponding field if already exists other wise create the Z for both the domain and data element.

Save, check and activate the change you made.

c the below example... May be it is useful for u.

1. Call up the ABAP Dictionary (Transaction SE11) and create data type ZZPSTYV. Choose PSTYV as a domain.As a short text, you can use, for example, 'ZZ - sales document item category' and as a field label, you can use the field labels of PSTYV.Save, check and activate your entries.

2. Call up structure KOMPAZ in the ABAP Dictionary (Transaction SE11) in the change mode and make the following entry:

Component Component type

ZZPSTYV ZZPSTYV

Save, check and activate the change you made.

3. Note:Because of the change in structure KOMPAZ, field ZZPSTYV is now known in structures KOMG and KOMP because structure KOMPAZ is included in both structures.

4. Call up Transaction SPRO. Navigate to 'Sales and Distribution -> Basic Functions -> Pricing -> Pricing Control' and execute 'Define Condition Tables'.

Choose 'Conditions: Allowed fields' and include ZZPSTYV as a new entry.

5. Note:Now you can use field ZZPSTYV as a key field when you create a condition table Axxx.

6. Supply the new field you defined by including the following source code line in USEREXIT_PRICING_PREPARE_TKOMP:

MOVE xxxx-PSTYV TO TKOMP-ZZPSTYV.

In order processing you find the user exit in Include MV45AFZZ, and in billing document processing you find it in Include RV60AFZZ.

Consider that you can also use this note as a help if you want to use other customer-specific fields as key fields in a condition table.

For header fields, use structure KOMKAZ instead of structure KOMPAZ and USEREXIT_PRICING_PREPARE_TKOMK instead of USEREXIT_PRICING_PREPARE_TKOMP.

[Former Member]

Hi,

Goto ur table in change mode via SE11 and under the fields column, give the field as 'email'. For this field, u can either create a data element or u can give the predefined data type.

But it will say an error like 'Table needs be adjusted'. In that case, goto SE14 and choose ur table name and click on 'EDIT' and there click 'Adjust and activate database' and press 'Adjust'. Now u can come again to SE11 and activate ur table.

Hope it will help u.

Reward points if helpful

Cheers,

Shanthi.

[Former Member]

Hi,

Goto ur table in change mode via SE11 and under the fields column, give the field as 'email'. For this field, u can either create a data element or u can give the predefined data type.

But it will say an error like 'Table needs be adjusted'. In that case, goto SE14 and choose ur table name and click on 'EDIT' and there click 'Adjust and activate database' and press 'Adjust'. Now u can come again to SE11 and activate ur table.

Hope it will help u.

Reward points if helpful

Cheers,

Shanthi.