Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 10:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 10:45 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 10:49 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 10:50 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.