Accepting multiple scale values as one condition record

[Former Member]

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

[Former Member]

Hi Anil

Instead of creating a BDC for XK15, try to make use of program: <b>RV14BTCI</b>.

Documentation of the program should help you using the same...

Kind Regards

Eswar

[Former Member]

Hi Eshwar,

There is a zee program already developed for pricing conditions. my role is to add functionality of scalevalues in that program. accepting multiple scale values as one condition record based on unique key combination.

Iam trying for this .

Thanks for reply.

Thanks

S.anilkumar.