08-20-2007 10:59 AM
Hi all,
My requirement is to update Quotation using VA22 transaction,here i have to pass order quantity under sales tab.
for the same iam using BAPI BAPI_CUSTOMERQUOTATION_CHANGE,So in which field should i have to pass the Order Quantity.
Pls help me in solving this Problem....
Regards
Balaji
08-20-2007 11:32 AM
hi,
go to the FM BAPI_CUSTOMERQUOTATION_CHANGE
and then go to the table entry for ITEMS : QUOTATION_ITEM_IN
and go to the field : TARGET_QTY
and enter the quantity,
That i think is the field u need,
Reward if helpful.
08-20-2007 11:32 AM
hi,
go to the FM BAPI_CUSTOMERQUOTATION_CHANGE
and then go to the table entry for ITEMS : QUOTATION_ITEM_IN
and go to the field : TARGET_QTY
and enter the quantity,
That i think is the field u need,
Reward if helpful.
08-20-2007 11:46 AM
Hi Mrunal,
Thanks alot for ur answer.
I did the same as u said.but ehen i run the bapi and check the quotation,quantity was not updated remaining fields like material,item number are updated correctly.
what would be the reason ...
08-20-2007 12:56 PM
Hi can u send me ur mail-id.
I'll send a doc.. that might be useful.
U would hav to create a report program where u update the fields of the databse n give a commit database stmt. Only then ur records will reflect the changes.
08-20-2007 1:45 PM
Hi mrunal,
Iam working on the following code..
READ TABLE IT_VBAP_VBAK INTO WA_VBAP_VBAK WITH KEY VBELN =
WA_QUOTATION-QUOTE_NO POSNR = WA_QUOTATION-LINE_ITEM.
L_KWMENG = WA_VBAP_VBAK-KWMENG.
CONDENSE L_KWMENG.
ST_QUOT_HEADER_IN-SALES_ORG = '1100'.
ST_QUOT_HEADER_IN-DISTR_CHAN = '10'.
ST_QUOT_HEADER_IN-DIVISION = '50'.
ST_QUOT_HEADER_INX-UPDATEFLAG = 'U'.
IT_QUOTATION_ITEM_IN-ITM_NUMBER = WA_QUOTATION-LINE_ITEM.
IT_QUOTATION_ITEM_IN-REASON_REJ = '23'.
APPEND IT_QUOTATION_ITEM_IN.
CLEAR IT_QUOTATION_ITEM_IN.
IT_QUOTATION_ITEM_INX-ITM_NUMBER = WA_QUOTATION-LINE_ITEM.
IT_QUOTATION_ITEM_INX-UPDATEFLAG = 'I'.
IT_QUOTATION_ITEM_INX-REASON_REJ = 'U'.
APPEND IT_QUOTATION_ITEM_INX.
CLEAR IT_QUOTATION_ITEM_INX.
L_POSNR = WA_QUOTATION-LINE_ITEM + 5.
CONDENSE L_POSNR.
IT_QUOTATION_ITEM_IN-ITM_NUMBER = L_POSNR.
IT_QUOTATION_ITEM_IN-MATERIAL = WA_QUOTATION-NEW_MAT.
IT_QUOTATION_ITEM_IN-TARGET_QTY = L_KWMENG.
IT_QUOTATION_ITEM_IN-TARGET_QU = 'EA'.
IT_QUOTATION_ITEM_IN-PLANT = WA_VBAP_VBAK-WERKS.
APPEND IT_QUOTATION_ITEM_IN.
CLEAR IT_QUOTATION_ITEM_IN.
IT_QUOTATION_ITEM_INX-ITM_NUMBER = L_POSNR.
IT_QUOTATION_ITEM_INX-UPDATEFLAG = 'I'.
IT_QUOTATION_ITEM_INX-MATERIAL = 'I'.
IT_QUOTATION_ITEM_INX-TARGET_QTY = 'I'.
IT_QUOTATION_ITEM_INX-TARGET_QU = 'I'.
IT_QUOTATION_ITEM_INX-PLANT = 'I'.
APPEND IT_QUOTATION_ITEM_INX.
CLEAR IT_QUOTATION_ITEM_INX.
CALL FUNCTION 'BAPI_CUSTOMERQUOTATION_CHANGE'
EXPORTING
SALESDOCUMENT = WA_QUOTATION-QUOTE_NO
QUOTATION_HEADER_IN = ST_QUOT_HEADER_IN
QUOTATION_HEADER_INX = ST_QUOT_HEADER_INX
TABLES
RETURN = IT_RETURN
QUOTATION_ITEM_IN = IT_QUOTATION_ITEM_IN
QUOTATION_ITEM_INX = IT_QUOTATION_ITEM_INX.
CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.
CLEAR IT_QUOTATION_ITEM_IN.
CLEAR IT_QUOTATION_ITEM_INX.
My mail id is balumeda@gmail.com
Thanks in advance for ur help..
regards
Balaji
09-20-2007 2:49 PM
Hi,
Pass ur order quantity to SHEDULELINES-REQ_QTY variable and update.
Suman