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

Adding fields to transaction VA01 & also to database table

Hi all,

can we add some fields to database tables like vbap, vbak if we will get key from sap?

will it create any problem in future?

crea

i need to create some new fields in VA01 so that i can populate those fields while creating sales order.generally, these fields r not present in VA01.but i want to add some fields in this transaction.

These fields r not present in any database tables. if i will populate these fields in VA01, then how i can update the database table?

actually, i want to add some new fields in transaction VA01 & i want to update the database while creating the sales order.but there is no such fields in database tables.

plz suggest me the most possible ways to do this?

it's urgent.plz suggest.

Thanks

pabi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Apr 24, 2007 at 08:53 PM

    Depending on if you want to add the fields at the header or item level, you can do append structure to VBAK or VBAP. You can add fields to the header and item screens to capture those values using screen exits provided on the header additional data screen and the item additional data screen.

    You can then pass those values from the screen to the database in user exits provided through out the VA01 program (SAPMV45A) like MV45AFZZ etc.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2007 at 09:26 PM

    you can create new z fields and u can append it into Standards ABAP tables.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2007 at 04:28 AM

    Hi,

    This is for XD01 like that you can do for the va01.

    Creating Custom Screen in XD01

    Go to Transaction SPRO à Logistics – General à Business Partner à Customers à Control à Adoption of Customer’s own Master Data fields à Prepare Modification à Free enhancement of Customer Master Record.

    Following screen appears:

    Go to CHANGE mode and Click ‘New Entries’ button. Then add a Screen Group (SK here)and meaningful description. Save the entry and then SELECT that entry and Click on ‘Label Tab Pages’.

    Add a Label Tab Page i.e. enter a Screen Number, Function Code and Meaningful Description.

    Save the entry and come back to the SPRO screen. Click Business Add-in: Processing Master Data Enhancements

    Create one Implementation by giving implementation name (must start with Z. ZSURESHKUMAR here). Give meaningful description and press enter. The following screen appears.

    Go to Interface and Click on ‘CHECK_ADD_ON_ACTIVE’ method. Add the following code and save.

    method IF_EX_CUSTOMER_ADD_DATA~CHECK_ADD_ON_ACTIVE .

    data: l_flg_active type BOOLE-BOOLE.

    if i_screen_group = 'SK'.

    e_add_on_active = 'X'.

    endif.

    endmethod.

    Activate that and come back to SPRO initial screen. Click Business Add-in: Customer Subscreens

    The following screen will appear. Create one implementation (ZSURESHKUMAR1 here).

    Press enter. The following screen will come. Enter a meaningful Description and Screen Group (which we created earlier) as shown below.

    Then go to Interface

    Create a Function Pool SAPLZSURESHKUMAR. (See the code of the program for other details). Create a Screen ‘1111’ with field old Customer Number – screen group PSK (SE51)

    Click on GET_TAXI_SCREEN method and add the following code.

    method IF_EX_CUSTOMER_ADD_DATA_CS~GET_TAXI_SCREEN .

    case i_taxi_fcode.

    when 'SK_TAB'.

    e_screen = '1111'. "Eart + Objekt

    e_program = 'SAPLZSURESHKUMAR'.

    e_headerscreen_layout = ' '.

    endcase.

    endmethod.

    Activate and leave the transaction.

    Go to KNA1 (Customer Master) table and add a custom field as shown below. Activate the table.

    Now go to XD01 transaction.

    The screen we created will appear as shown in the above screen-shot. Click the button. The following screen will appear.

    Enter a customer number and save the transaction. Now go to KNA1 table and check the value of the Old Customer Number field’s value. The value you entered in this screen will appear on there.

    Until now, we wrote code for creating the Custom field. Now we need to disable that field when we are opening the transaction in DISPLAY mode.

    Go to include – LZSURESHKUMARTOP and enter the following code and activate the program.

    Now execute the Transaction in display mode and check the output.

    *************Rewards

    Rgds,

    P.Nag

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2007 at 05:42 AM

    Hi Pabitra rout,

    <b>You have 2 options to include the Fields 1) Append Structure 2) Include structure</b>

    Append Structure:- An append structure is a structure assigned to just one table. When a table is activated, all append structures for the table are found and appended to the table. Append structures are used to add customer fields to SAP tables.

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb61446011d189700000e8322d00/content.htm

    Include Structure:- Include structures are used to add fields in the middle also.where as append structures adds fields only at the end.In addition to listing the individual fields, you can also include the fields of another structure in tables and structures. Individual fields and includes can be mixed as required.

    include--append

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb61446011d189700000e8322d00/frameset.htm

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb61446011d189700000e8322d00/frameset.htm

    <b>Here is the detailed preocedure to add fields/structure to Database table:</b>

    just follow this to add structure to the database table,

    <b>go to the se11 ->,

    provide the table name ->,

    go for display ->,

    select GOTO option at the menu ->,

    select Append structure ->,

    provide the Append name ->,

    Enter ->,

    provide stort text and fields to the structure ->,

    then save and activate,</b>

    now check the table, now u can see the table with new structure at the last.

    Hope this helps you about how to add fields to Database tables like VBAK,VBAP…

    <b>Reward points if it helps you.</b>

    Regards,

    Rama chary.Pammi

    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.