Skip to Content
0
Former Member
Dec 20, 2006 at 07:37 AM

Accepting multiple scale values as one condition record

59 Views

Hi,

This is anil. i need to run bdc for xk15 transaction.

This is related to sap pricing conditions.

<gt_table> contains excel sheet data. which is uploaded through xk15 transaction into sap.

loop at <gt_table> into <wa>

In this loop fist and second screen BDC mapping is done

and for third screen bdc mapping is to be done.

some part of bdc code for third screen as follows.

IF kzbzg1 = 'B'.

PERFORM bdc_dynpro USING 'SAPMV13A' '0301'.

PERFORM bdc_field using 'BDC_OKCODE' '/00'.

ASSIGN COMPONENT 'KSTBW' OF STRUCTURE <WA> TO <WS_VALUE> .

concatenate 'KONW-KSTBW(' ws_count ')' into ws_field_name.

PERFORM bdc_field USING ws_field_name <WS_VALUE>.

ASSIGN COMPONENT 'KBETR' OF STRUCTURE <WA> TO <WS_VALUE>.

concatenate 'KONW-KBETR(' ws_count ')' into ws_field_name.

PERFORM bdc_field USING ws_field_name <WS_VALUE>.

ws_count = ws_count + 1.

PERFORM bdc_field using 'BDC_OKCODE' '=SICH'.

endif.

Endloop.

whenever iam running this code each scale value is storing as separate condition record.

but i want multiple scale values accepted as one Condition record.

In my program, end user will enter data in excelsheet for only one condition record.

the format of data is given below.

Sales Org. Distr. Channel Division Sales doc. type IncotermsMaterial Condition type Scale quantity Amount Cond. currency Pricing unit Unit of measure Valid on Valid to

1000 1 5 ZOST FB1 216766982 ZHI1 29 36 USD 1 GA 10/16/2006 10/19/2006

1000 1 5 ZOST FB1 216766982 ZHI1 49

35 USD 1 GA 10/16/2006 10/19/2006

1000 1 5 ZOST FB1 216766982 ZHI1 89

34 USD 1 GA 10/16/2006 10/19/2006

For this key combination like salesorg =1000,distchannel =1,division =5,

salesdoctype =zost,incoterms =fb1,material = 216766982, condition type = zhi1,

scalevalues and amount in third screen(screen no=301) should be populated in xk15 transaction as follows.

scale value amount

29 36

49 35

89 34

These three rows of scalevalues and amount must stored under one condition record ( sales org =1000,distchannel =1,diivison=5, salesdoctype =zost, incoterms =fb1, material=216766982.) .

and fields like unit of measure,validon,validto,scalevalue,amount,condcurrency are optional in xk15 transaction.

please solve this problem.

Thanks

s.anilkumar