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

sales order table control

Hi Experts,

I want to upload sales order information (va01 transaction) from flat file to sap.

but in va01 tcode table control is there

so could you plz guide me whts the procedure to upload sales information.

points sure

Thanks in advance,

Divya sree

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Oct 13, 2006 at 01:47 PM

    Hi,

    You can use different ways for this.

    The best to do this is using BAPI function module.

    You can use function module BAPI_SALESORDER_CREATEFROMDAT1.

    If you google with this function module, you will lot of sample codes also to do that.

    Thanks,

    Ramakrishna

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 01:50 PM

    use BAPI_SALESORDER_CREATEFROMDAT2 hope it help u.........

    Thanks,

    Venkat Chaitanya

    Tata Consultancy Services Ltd

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 13, 2006 at 01:51 PM

    Hi,

    When you have enter multiple line in BDC for a table control use call transaction code using i_bdcdata options from opt message into i_messages.

    Check the below example.

    data: lws_cnt type char2,

    lws_field type char15.

    LOOP AT i_invoicing_plan INTO wa_invoicing_plan.

    lws_cnt = sy-tabix.

    CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

    EXPORTING

    input = lws_cnt

    IMPORTING

    output = lws_cnt .

    CONCATENATE 'FPLT-AFDAT(' lws_cnt ')' INTO lws_field.

    CONCATENATE wa_invoicing_plan-date+6(2)

    wa_invoicing_plan-date+4(2)

    wa_invoicing_plan-date+0(4) INTO lws_date

    SEPARATED BY '.'.

    PERFORM bdc_field USING lws_field lws_date.

    CONCATENATE 'FPLT-FPROZ(' lws_cnt ')' INTO lws_field.

    lws_perct = wa_invoicing_plan-percentage.

    CONDENSE lws_perct.

    PERFORM bdc_field USING lws_field lws_perct.

    ENDLOOP.

    While calling the transaction give like this:

    DATA: opt TYPE ctu_params.

    opt-dismode = 'N'.

    opt-updmode = 'A'.

    opt-defsize = 'X'.

    CALL TRANSACTION tcode

    USING i_bdcdata OPTIONS FROM opt MESSAGES INTO i_messages.

    LOOP AT i_messages.

    ENDLOOP.

    Regards

    Pavan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 02:27 PM

    HI,

    do recording using SHDB transaction for sample

    data and copy the recording screen

    sequence in your program .

    Regards

    amole

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 05:50 PM

    Use SHDB to record BDC for your VA01,

    do not forget to press "add Item" button before every item you add, it will shift all items up to the last one which will be on the 1st row and the 2nd row will always be available for new item info.

    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.