Skip to Content
0
Former Member
Dec 08, 2006 at 06:52 AM

Excel upload to SAP-SD pricing conditions

595 Views

This is big sceanorio, please understand this and make a reply.it is quiet intresting and challenging.

Enhancement is adding scale value field to existing functionalality .This functionality contains unique key combination, scale value or scalequantity or ..

and some fixed columns like amount,currency,validfrom,validto,unitof measure .

This data format is going to be populated in xk15 transaction using BDC.

In first screen of XK15 transaction,

enter condition type =zcsp, application =v, then click on keycombination button in application toolbar.

based on different key combinations selected , second screen will vary(different screennumbers).

select first unique key combination button, then we go into second screen.

there enter details for salesorg=1000,distchanel=01,division=01,shiptoparty=1234057,material=204633990,place cursor on Amount and press f2 u will go to third screen

In third screen,it contains scalequantity and amount,

and in third screen name is sapmv13a and screenno: 303.

now i need to populate data dynamically in third screen containing scalequanity and amount using BDC from the excel sheet.

excel sheet contain different uniquekey combination,scale value or quantitity or...

and some fixed columns like amount ,valid from,validto,unitof measure,currency.

if we consider another sceanario,

if we take condition type as zhi1, applicaiton =v, by click on key combination .select first unique key combination, then we go into second sceen.

then enter details for salesorg,distchannel,division,shiptoparty,material and place cursor on amount and press f2 u will go to third sceen.

here third screen contains scale value and amount..

here for third screen, screen name:sapmv13a and screenno:301

here based on condition type,second and third screen is varying and i need to call third screen dynamically . is it possible ?

checking scalebase indicatior(KZBZG) from T685A table for a given condition type. if KZBZG is present for given condition type, then we will have third screen .otherwise we dont have any third screen in XK15 Transaction.

IF KZBZG is present the third screen contains scale value or scale quantity or xxxx.

here second screen is also varying dynamically ,while populating data in xk15 transaction ,using bdc.

the program is handled dynamically for second screen as follows.

DATA: BEGIN OF int_dynpronr OCCURS 0,

kotabnr LIKE t681s-kotabnr,

dynpronr LIKE t681s-dynpronr,

END OF int_dynpronr.

LOOP AT int_dynpronr.

SELECT SINGLE dynpronr FROM t681s INTO int_dynpronr-dynpronr

WHERE kvewe = 'A'

AND kotabnr = int_dynpronr-kotabnr

AND setyp = ' '.

MODIFY int_dynpronr INDEX sy-tabix.

ENDLOOP.

This way program is doing BDC for second screen

PERFORM: bdc_dynpro USING 'SAPMV13A' int_dynpronr-dynpronr

Is there any possiblity to call dynamically for third screen.

we have 15 scale base indicators(kzbzg).

suppose if we take condition type is zcsp ,scale base indicator for this condition type (kzbzg) is 'c' . for this scalebaseindicator the third screen contains scalevalue.

if we have take condition type is zhi1, scalebase ='b' and then for this kzbzg, the third screen contains scale quantity.

if we have take condition type is xxx, suppose kzbzg s is 'f'' and in the third screen contains differnt distance paramters(Kilometers).

For this purpose iam asking can we call the third screen dynamically.

so that for any scalebase indicator, my BDCdata can be populated dynamically in the third screen.

please respond to this query. iam waiting for reply.

Thanks

s.anilkumar