Creating SAP Pricing Conditions Using BAPI

Creating SAP Pricing conditions using BAPI_PRICES_CONDITIONS •

•

Category: SD Published on Thursday, 17 September 2009 18:1 !ritten by "e#in !ilson $its: 1119% This &ode snippet inserts a &ondition re&ord 'or Pri&ing &ondition type (12) *ith +ey sales order and line number C-.ST/.TS: l&+s&hl12) TP3 +s&ha 4/563 (12) D/T/: D/T /: l#datum l#&ount l#unit

TP3 sydatum,

TP3 +opos, TP3 +pein,

isbapi&ond&t TP3 bapi&ond&t, isbapi&ondhd TP3 bapi&ondhd, isbapi&ondit TP3 bapi&ondit, itbapi&ond&t itbapi&o nd&t TP3 ST/.D/D T/ T/53 53 - bapi&on bapi&ond&t, d&t, itbapi&ondhd itbapi&o ndhd TP3 ST/.D/D T/ T/53 53 - bapi&ond bapi&ondhd, hd, itbapi&ondit itbapi&o ndit TP3 ST/.D/D ST/.D/D T/ T/53 53 - bapi&ond bapi&ondit, it, itbapi&ond;s itbapi&o nd;s TP3 ST/.D/D T/ T/53 53 - bapi&ond bapi&ond;s, ;s, itbapi&ond#s itbapi&o nd#s TP3 ST/.D/D T/ T/53 53 - bapi&ond bapi&ond#s, #s, itbapiret2 itbapire t2

TP3 ST/.D/D T/ T/53 53 - bapiret2 bapiret2,,

isbapiret2

TP3 bapiret2,

itbapi+numhs itbapi+n umhs TP3 ST/ ST/.D/D .D/D T/53 T/53 - bapi+nu bapi+numhs, mhs, itmeminitial TP3 ST/.D/D T/53 - &ndmeminitial l#datum < sy=datum l#&ount < 1 5--P /T gt#bap >.T- *a#bap

? /P> Stru&ture 'or Condition Tables isbapi&ond&t=operation < 009 isbapi&ond&t=tableno < 700 isbapi&ond&t=appli&atio < 4 isbapi&ond&t=&ondusage < / isbapi&ond&t=&ondtype < l&+s&hl12) @Set the #ar+ey 'rom /700 table +ey 'ields C-.C/T3./T3 *a#bap=#beln *a#bap=posnr  >.T- isbapi&ond&t=#ar+ey isbapi&ond&t=#alidto < 12A)1A2009 isbapi&ond&t=#alid'rom < l#datum isbapi&ond&t=&ondno

< B000000001

???? /P> Stru&ture o' "-.$ *ith 3nglish ield .ames isbapi&ondhd=operation < 009 isbapi&ondhd=&ondno

< B000000001

isbapi&ondhd=&reatedby < sy=uname isbapi&ondhd=&reatdate < sy=datum isbapi&ondhd=&ondusage < / isbapi&ondhd=tableno < 700 isbapi&ondhd=appli&atio < 4 isbapi&ondhd=&ondtype < l&+s&hl12) isbapi&ondhd=#ar+ey

< isbapi&ond&t=#ar+ey

isbapi&ondhd=#alidto < 12A)1A2009 isbapi&ondhd=#alid'rom < l#datum ??? /P> Stru&ture o' "-.P *ith 3nglish ield .ames C53/ isbapi&ondit isbapi&ondit=operation < 009 isbapi&ondit=&ondno

< B000000001

isbapi&ondit=&ond&ount < l#&ount isbapi&ondit=appli&atio < 4 isbapi&ondit=&ondtype < l&+s&hl12) isbapi&ondit=s&aletype < / isbapi&ondit=s&alebasin <   /DD 1 T- isbapi&ondit=s&ale;ty

isbapi&ondit=&al&typ&on <  l#unit < *a#bap=+*meng isbapi&ondit=&ondpunt < l#unit isbapi&ondit=&ond#alue < *a#bap=#alue isbapi&ondit=&ond&urr < *a#bap=*aer+  /PP3.D: isbapi&ond&t T- itbapi&ond&t, isbapi&ondhd T- itbapi&ondhd, isbapi&ondit T- itbapi&ondit 3.D5--P ??? /P> 'or pri&ing Condition e&ords C/55 6.CT>-. /P>P>C3SC-.D>T>-.S T/53S tibapi&ond&t < itbapi&ond&t tibapi&ondhd < itbapi&ondhd tibapi&ondit < itbapi&ondit tibapi&ond;s < itbapi&ond;s tibapi&ond#s < itbapi&ond#s tobapiret2

< itbapiret2

tobapi+numhs < itbapi+numhs tomeminitial < itmeminitial 3C3PT>-.S updateerror < 1 -T$3S

< 2

> sy=subr& 3 0 !>T3: A1 eturn Eessages 'or Condition &reateFt0)G 5--P /T itbapiret2 >.T- isbapiret2 !>T3: A1 isbapiret2=message 3.D5--P 65>.3 C/55 6.CT>-. /P>T/.S/CT>-.C-EE>T 3P-T>.H *ait < 

>EP-T>.H return < isbapiret2 3.D> Correct AnswerRe: Bapi to create pricing condition\VK

Niran!an Kris"na#urt"i Jul Hi,

9, 2012 9:02 AM

Please try tis! "A#A: $%G&'  ls*+o+ CC-./ 10! &'C-"% /#.-C#-.% +o+! "A#A: %'"  ls*+o+! "A#A:ls*+o #P% +o! "A#A: $%G&'  ls*+o3 CC-./ 10! &'C-"% /#.-C#-.% +o3! "A#A: %'"  ls*+o3! "A#A: $%G&'  lt*+o3 CC-./ 0! &'C-"% /#.-C#-.% +o3! "A#A: %'"  lt*+o3! "A#A: +o+ #P% +o+ , +op #P% +op ! ls*+o4atnr 5 6aterial7! ls*+o43+or 5 6sales or7! ls*+o43twe 5 6dist cn7! C%A.: lt*+o3,ls*+o3! ls*+o34+appl 5 88!  Application  5 /ales ls*+o34+scl 5 67!  Condition type ls*+o34+nu 5 6condition record nu;er7! ls*+o34+rec 5 67!  calculation type< ls*+o34+;etr 5 67! ls*+o34+ein 5 67! ls*+o34+pein 5 67! ls*+o34waers 5 67! ls*+o34upd+= 5 8&8! APP%'" ls*+o3 # lt*+o3! C%A. lt*+o3! "A#A wa*pispr #P% pispr! wa*pispr4atnr 5 67! wa*pispr43+or 5 67! wa*pispr43twe 5 67! CA -'C#&' 8/P.*>M>*>MP*&8   %?P.#&'G pi*i*spr 5 wa*pispr   &MP.#&'G pe*i*+o+ 5 +o+ pe*i*+op 5 +op! CA -'C#&' 8.*C'"&#&'*CP8   %?P.#&'G application 5 88

(in response to Gil Hadida)

condition*ta;le 58 8  @ caracter cond! ta;le   condition*type 58 8  cond! type   date*ro 5 8201201018  3alid on date*to 5 8999912@18  3alid to enBueue 5 8?8  loc+ entry i*+o+ 5 +o+ i*+op 5 +op   +ey*elds 5 ls*+o  +ey elds aintain*ode 5 8$8  A5 create  $5 cane,  C5 display  "5 create   no*autority*cec+ 5 8?8 selection*date 5 8201201018  3alid on +eep*old*records 588 o3erlap*conred 5 8?8 no*d;*update 5 space   &MP.#&'G e*+o+ 5 +o+ e*+op 5 +op new*record 5 l3*new*record   #A$%/ copy*records 5 lt*+o3   %?C%P#&'/   enBueue*on*record 51 in3alid*application 52 in3alid*condition*nu;er 5 @ in3alid*condition*type 5 D no*selection 5E ta;le*not*3alid 5F   no*autority*e+or 5   no*autority*+scl 5 ! & sy4su;rc 5 0! CA -'C#&' 8.*C'"&#&'*/A%8! CMM&# I.>! CA -'C#&' 8.*C'"&#&'*.%/%#8! necessary to write data CMM&# I.>! I.&#%: 8/uccess8! %/%! I.&#%:  8%rror8! %'"&! Ceers K'iranLan

Re: Sa#p$e code %or BAPI_PRICES_CONDITIONS

&err' (ianto Hi Martin,

Apr 1@, 200F 9:01 PM

(in response to Martn $ec+er)

Please cec+ tis saple code ro oter tread! wtable1-table_no = '306'. wtable1-applicatio = 'V'. wtable1-cond_type = 'ZPR0'.

wtable1-operation = '009'. wtable1-varkey = '13001001!" 0000000000#006$9%6'. wtable1-valid_to = '99991&31'. wtable1-valid_ro( = '&00#1101'. wtable1-cond_no = 'wtable1-table_no = '306'. wtable1-applicatio = 'V'. wtable1-cond_type = 'ZPR0'. wtable1-operation = '009'. wtable1-varkey = '13001001!" 0000000000#006$9%6'. wtable1-valid_to = '99991&31'. wtable1-valid_ro( = '&00#1101'. wtable1-cond_no = ')000000001'. *PP+," wtable1  table1. wtable&-operation = '009'. wtable&-cond_no = ')000000001'. wtable&-created_by = /y-na(e. wtable&-creat_date = '&00#10&&'. wtable&-cond_/ae = '*'. wtable&-table_no = '110'. wtable&-applicatio = 'V'. wtable&-cond_type = 'ZPR0'. wtable&-varkey = '13001001!" 0000000000#006$9%6'. wtable&-valid_ro( = '&00#1101'. wtable&-valid_to = '99991&31'. *PP+," wtable&  table&.

wtable3-operation = '009'. wtable3-cond_no = ')000000001'. wtable3-cond_cont = '01'. wtable3-applicatio = 'V'. wtable3-cond_type = 'ZPR0'. wtable3-/caletype = '*'. wtable3-/caleba/in = '2'. wtable3-/cale_ty = '1'. wtable3-cond_p_nt = '1'. wtable3-cond_nit = '+*'. wtable3-calctypcon = '2'. wtable3-cond_vale = '%#%'. wtable3-condcrr = '!"'. *PP+," wtable3  table3.

2*44 5,2, '7*P_PR2+!_2,",!' 8 +PR,: 8 P_initial(ode = '' 8 P_742;,<7+R = *74+! ti_bapicondct = table1 ti_bapicondd = table& ti_bapicondit = table3 ti_bapicond/ = table% ti_bapicondv/ = table# to_bapiret& = table6 to_bapikn(/ = table> to_(e(_initial = table$

+2+P,! pdate_error = 1 ?+R! = & . 5 /y-/brc @A 0. <+!!*:+ " /y-(/id BP+ /y-(/ty ,<7+R /y-(/no C? /y-(/v1 /y-(/v& /y-(/v3 /y-(/v%. +,"5. R+*" *74+ table6 C? ;+B type = '+' R*,!PR,: , 5+4"!. 5 /y-/brc = 0. loop at table6 into ret. writeD E ret-typeF ret-(e//aeF ret-idF R+-4:_,F R+-4:_
wtable3-operation = '009'. wtable3-cond_no = ')000000001'. wtable3-cond_cont = '01'. wtable3-applicatio = 'V'. wtable3-cond_type = 'ZPR0'. wtable3-/caletype = '*'. wtable3-/caleba/in = '2'. wtable3-/cale_ty = '1'. wtable3-cond_p_nt = '1'. wtable3-cond_nit = '+*'. wtable3-calctypcon = '2'. wtable3-cond_vale = '%#%'. wtable3-condcrr = '!"'. *PP+," wtable3  table3. 2*44 5,2, '7*P_PR2+!_2,",!' 8 +PR,: 8 P_initial(ode = '' 8 P_742;,<7+R = *74+! ti_bapicondct = table1 ti_bapicondd = table& ti_bapicondit = table3 ti_bapicond/ = table% ti_bapicondv/ = table# to_bapiret& = table6 to_bapikn(/ = table> to_(e(_initial = table$ +2+P,! pdate_error = 1 ?+R! = & . 5 /y-/brc @A 0. <+!!*:+ " /y-(/id BP+ /y-(/ty ,<7+R /y-(/no C? /y-(/v1 /y-(/v& /y-(/v3 /y-(/v%. +,"5. R+*" *74+ table6 C? ;+B type = '+' R*,!PR,: , 5+4"!. 5 /y-/brc = 0. loop at table6 into ret. writeD E ret-typeF ret-(e//aeF ret-idF R+-4:_,F R+-4:_
wtable&-cond_/ae = '*'. wtable&-table_no = '110'. wtable&-applicatio = 'V'. wtable&-cond_type = 'ZPR0'. wtable&-varkey = '13001001!" 0000000000#006$9%6'. wtable&-valid_ro( = '&00#1101'. wtable&-valid_to = '99991&31'.

*PP+," wtable&  table&.

wtable3-operation = '009'. wtable3-cond_no = 'wtable1-table_no = '306'. wtable1-applicatio = 'V'. wtable1-cond_type = 'ZPR0'. wtable1-operation = '009'. wtable1-varkey = '13001001!" 0000000000#006$9%6'. wtable1-valid_to = '99991&31'. wtable1-valid_ro( = '&00#1101'. wtable1-cond_no = ')000000001'. *PP+," wtable1  table1.

wtable&-operation = '009'. wtable&-cond_no = ')000000001'. wtable&-created_by = /y-na(e. wtable&-creat_date = '&00#10&&'. wtable&-cond_/ae = '*'. wtable&-table_no = '110'. wtable&-applicatio = 'V'. wtable&-cond_type = 'ZPR0'. wtable&-varkey = '13001001!" 0000000000#006$9%6'. wtable&-valid_ro( = '&00#1101'. wtable&-valid_to = '99991&31'.

*PP+," wtable&  table&.

wtable3-operation = '009'. wtable3-cond_no = ')000000001'. wtable3-cond_cont = '01'. wtable3-applicatio = 'V'. wtable3-cond_type = 'ZPR0'. wtable3-/caletype = '*'. wtable3-/caleba/in = '2'. wtable3-/cale_ty = '1'. wtable3-cond_p_nt = '1'. wtable3-cond_nit = '+*'. wtable3-calctypcon = '2'. wtable3-cond_vale = '%#%'. wtable3-condcrr = '!"'. *PP+," wtable3  table3. 2*44 5,2, '7*P_PR2+!_2,",!' 8 +PR,: 8 P_initial(ode = ''

8 P_742;,<7+R = *74+! ti_bapicondct = table1 ti_bapicondd = table& ti_bapicondit = table3 ti_bapicond/ = table% ti_bapicondv/ = table# to_bapiret& = table6 to_bapikn(/ = table> to_(e(_initial = table$ +2+P,! pdate_error = 1 ?+R! = & . 5 /y-/brc @A 0. <+!!*:+ " /y-(/id BP+ /y-(/ty ,<7+R /y-(/no C? /y-(/v1 /y-(/v& /y-(/v3 /y-(/v%. +,"5. R+*" *74+ table6 C? ;+B type = '+' R*,!PR,: , 5+4"!. 5 /y-/brc = 0. loop at table6 into ret. writeD E ret-typeF ret-(e//aeF ret-idF R+-4:_,F R+-4:_
2*44 5,2, '7*P_PR2+!_2,",!' 8 +PR,: 8 P_initial(ode = '' 8 P_742;,<7+R = *74+! ti_bapicondct = table1 ti_bapicondd = table& ti_bapicondit = table3

ti_bapicond/ = table% ti_bapicondv/ = table# to_bapiret& = table6 to_bapikn(/ = table> to_(e(_initial = table$ +2+P,! pdate_error = 1 ?+R! = & . 5 /y-/brc @A 0. <+!!*:+ " /y-(/id BP+ /y-(/ty ,<7+R /y-(/no C? /y-(/v1 /y-(/v& /y-(/v3 /y-(/v%. +,"5. R+*" *74+ table6 C? ;+B type = '+' R*,!PR,: , 5+4"!. 5 /y-/brc = 0. loop at table6 into ret. writeD E ret-typeF ret-(e//aeF ret-idF R+-4:_,F R+-4:_
Also tere are oter options: 4 ro /MI te report .1D$#C& 4 ;atc input to transaction ?>1E 4 usin M odules .*C'"&#&'N (e!! *copy and *sa3e)