topic Re: sales order table control in Application Development and Automation Discussions

sales order table control

Former Member — Fri, 13 Oct 2006 13:41:21 GMT

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

Re: sales order table control

venkata_ramisetti — Fri, 13 Oct 2006 13:47:19 GMT

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

Re: sales order table control

Former Member — Fri, 13 Oct 2006 13:50:17 GMT

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

Thanks,

Venkat Chaitanya

Tata Consultancy Services Ltd

Re: sales order table control

pavankumar_hukkeri — Fri, 13 Oct 2006 13:51:58 GMT

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

Re: sales order table control

Former Member — Fri, 13 Oct 2006 14:27:24 GMT

HI,

do recording using SHDB transaction for sample

data and copy the recording screen

sequence in your program .

Regards

amole

Re: sales order table control

Former Member — Fri, 13 Oct 2006 17:50:06 GMT

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.