2013 Jul 22 10:59 AM
HI Everyone,
Iam able to create inquiry in SAP but price is not updating, Below is the code iam using please let me know if anything iam missing.
DATA: WA_HEADER TYPE BAPISDHD1,
WA_HEADERX TYPE BAPISDHD1X,
DOC_NO TYPE BAPIVBELN-VBELN,
WA_RETURN TYPE BAPIRET2,
IT_RETURN TYPE TABLE OF BAPIRET2,
WA_ITEM TYPE BAPISDITM,
IT_ITEM TYPE TABLE OF BAPISDITM,
WA_ITEMX TYPE BAPISDITMX,
IT_ITEMX TYPE TABLE OF BAPISDITMX,
WA_PARTNER TYPE BAPIPARNR,
IT_PARTNER TYPE TABLE OF BAPIPARNR,
WA_INQUIRY_TEXT TYPE BAPISDTEXT,
IT_INQUIRY_TEXT TYPE TABLE OF BAPISDTEXT,
LV_OUT TYPE PARVW,
LV_DOCTYPE TYPE AUART,
lv_matnr TYPE matnr,
lv_cust TYPE kunnr.
DATA:IT_CON TYPE TABLE OF BAPICOND,
WA_CON TYPE BAPICOND.
DATA:IT_CONX TYPE TABLE OF BAPICONDX,
WA_CONX TYPE BAPICONDX.
data:wa_scheline type BAPISCHDL,
it_scheline type table of BAPISCHDL.
data:wa_schelinex type BAPISCHDLX,
it_schelinex type table of BAPISCHDLX.
WA_HEADER-DOC_TYPE = 'AF'. "ls_zsales_int-SALES_DOC_T. "'AF'.
WA_HEADER-SALES_ORG = '1000'.
WA_HEADER-DISTR_CHAN = '10'.
WA_HEADER-DIVISION = '20'.
WA_HEADER-SALES_GRP = ' '.
WA_HEADER-SALES_OFF = '1100'.
WA_HEADER-DOC_DATE = '2013/06/10'.
WA_HEADER-SD_DOC_CAT = 'A'.
WA_HEADER-CURRENCY = 'INR'.
**********************************************
WA_HEADERX-DOC_TYPE = 'X'.
WA_HEADERX-SALES_ORG = 'X'.
WA_HEADERX-DISTR_CHAN = 'X'.
WA_HEADERX-DIVISION = 'X'.
* WA_HEADERX-SALES_GRP = ' '.
* WA_HEADERX-SALES_OFF = 'X'.
WA_HEADERX-DOC_DATE = 'X'. "SY-DATUM.
WA_HEADERX-SD_DOC_CAT = 'X'.
* WA_HEADERX-CURRENCY = 'X'.
*********************************************
*** CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
*** EXPORTING
*** input = ls_zsales_int-MATERIAL
*** IMPORTING
*** OUTPUT = lv_matnr
*** .
***********************************************
WA_ITEM-ITM_NUMBER = '000010'.
WA_ITEM-MATERIAL = '000000000400000083'.
WA_ITEM-BILL_DATE = '20130226'.
WA_ITEM-SHORT_TEXT = 'Sales Inquiry Testing'.
*WA_ITEM-PURCH_NO_C = ls_zsales_int- "'PO123'.
WA_ITEM-PURCH_DATE = '20130226'.
*wa_item-PURCH_DATE = '26.02.2013'.
WA_ITEM-PO_DAT_S = '20130226'."SY-DATUM.
WA_ITEM-TARGET_QTY = '2.00'.
**WA_ITEM-COMP_QUANT = '12'.
WA_ITEM-TARGET_QU = 'MT'.
WA_ITEM-TARGET_VAL = '100.00'.
WA_ITEM-CURRENCY = 'INR'.
WA_ITEM-DIVISION = '20'.
WA_ITEM-ITEM_CATEG = 'AFN'.
WA_ITEM-PRICE_DATE = '20130226'.
APPEND WA_ITEM TO IT_ITEM.
*********************************************
WA_ITEMX-ITM_NUMBER = 'X'.
WA_ITEMX-MATERIAL = 'X'.
WA_ITEM-BILL_DATE = 'X'. "SY-DATUM.
WA_ITEM-SHORT_TEXT = 'X'. "Sales Inquiry Testing'.
***WA_ITEM-PURCH_NO_C = 'X'. "'PO123'.
WA_ITEM-PURCH_DATE = 'X'. "SY-DATUM.
WA_ITEM-PO_DAT_S = 'X'. "SY-DATUM.
WA_ITEMX-TARGET_QTY = 'U'.
WA_ITEMX-TARGET_QU = 'X'.
WA_ITEMX-TARGET_VAL = 'X'.
*WA_ITEMX-CURRENCY = 'X'.
WA_ITEMX-ITEM_CATEG = 'X'.
WA_ITEM-DIVISION = 'X'.
WA_ITEM-PRICE_DATE = 'X'.
**WA_ITEMx-COMP_QUANT = 'X'.
APPEND WA_ITEMX TO IT_ITEMX.
wa_scheline-ITM_NUMBER = '000010'.
wa_scheline-SCHED_LINE = '0010'.
wa_scheline-REQ_QTY = '10'.
append wa_scheline to it_scheline.
wa_schelinex-ITM_NUMBER = '000010'.
wa_schelinex-SCHED_LINE = '0010'.
wa_schelinex-REQ_QTY = 'X'.
append wa_schelinex to it_schelinex.
*********************************************
**
** CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
** EXPORTING
** input = ls_zsales_int-CUSTOMER
** IMPORTING
** OUTPUT = lv_cust
** .
***********************************************
WA_PARTNER-PARTN_ROLE = 'AG'. "LV_OUT. "AG = SOLD TO & WE = SHIP TO
WA_PARTNER-PARTN_NUMB = '0000100094'.
*WA_PARTNER-ITM_NUMBER = '000010'.
APPEND WA_PARTNER TO IT_PARTNER.
CLEAR:wa_partner.
*********************************************
WA_INQUIRY_TEXT-ITM_NUMBER = '000010'.
WA_INQUIRY_TEXT-TEXT_LINE = 'Testing'.
APPEND WA_INQUIRY_TEXT to it_INQUIRY_TEXT.
*********************************************
CALL FUNCTION 'BAPI_INQUIRY_CREATEFROMDATA2'
EXPORTING
* SALESDOCUMENTIN =
inquiry_header_in = WA_HEADER
INQUIRY_HEADER_INX = WA_HEADERX
* SENDER =
* BINARY_RELATIONSHIPTYPE =
* INT_NUMBER_ASSIGNMENT =
* BEHAVE_WHEN_ERROR =
* LOGIC_SWITCH =
* TESTRUN =
* CONVERT = ' '
IMPORTING
SALESDOCUMENT = DOC_NO
tables
RETURN = IT_RETURN
INQUIRY_ITEMS_IN = IT_ITEM
INQUIRY_ITEMS_INX = IT_ITEMX
inquiry_partners = IT_PARTNER
INQUIRY_SCHEDULES_IN = it_scheline
INQUIRY_SCHEDULES_INX = it_schelinex
INQUIRY_CONDITIONS_IN = IT_CON
INQUIRY_CONDITIONS_INX = IT_CONX
* INQUIRY_CFGS_REF =
* INQUIRY_CFGS_INST =
* INQUIRY_CFGS_PART_OF =
* INQUIRY_CFGS_VALUE =
* INQUIRY_CFGS_BLOB =
* INQUIRY_CFGS_VK =
* INQUIRY_CFGS_REFINST =
INQUIRY_TEXT = it_INQUIRY_TEXT
* INQUIRY_KEYS =
* EXTENSIONIN =
* PARTNERADDRESSES =
.
CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
WAIT = 'X'.
* IMPORTING
* RETURN =
.
write: DOC_NO.
Regards,
Mahipal
HI Everyone,
Iam able to create inquiry in SAP but price is not updating, Below is the code iam using please let me know if anything iam missing.
DATA: WA_HEADER TYPE BAPISDHD1,
WA_HEADERX TYPE BAPISDHD1X,
DOC_NO TYPE BAPIVBELN-VBELN,
WA_RETURN TYPE BAPIRET2,
IT_RETURN TYPE TABLE OF BAPIRET2,
WA_ITEM TYPE BAPISDITM,
IT_ITEM TYPE TABLE OF BAPISDITM,
WA_ITEMX TYPE BAPISDITMX,
IT_ITEMX TYPE TABLE OF BAPISDITMX,
WA_PARTNER TYPE BAPIPARNR,
IT_PARTNER TYPE TABLE OF BAPIPARNR,
WA_INQUIRY_TEXT TYPE BAPISDTEXT,
IT_INQUIRY_TEXT TYPE TABLE OF BAPISDTEXT,
LV_OUT TYPE PARVW,
LV_DOCTYPE TYPE AUART,
lv_matnr TYPE matnr,
lv_cust TYPE kunnr.
DATA:IT_CON TYPE TABLE OF BAPICOND,
WA_CON TYPE BAPICOND.
DATA:IT_CONX TYPE TABLE OF BAPICONDX,
WA_CONX TYPE BAPICONDX.
data:wa_scheline type BAPISCHDL,
it_scheline type table of BAPISCHDL.
data:wa_schelinex type BAPISCHDLX,
it_schelinex type table of BAPISCHDLX.
WA_HEADER-DOC_TYPE = 'AF'. "ls_zsales_int-SALES_DOC_T. "'AF'.
WA_HEADER-SALES_ORG = '1000'.
WA_HEADER-DISTR_CHAN = '10'.
WA_HEADER-DIVISION = '20'.
WA_HEADER-SALES_GRP = ' '.
WA_HEADER-SALES_OFF = '1100'.
WA_HEADER-DOC_DATE = '2013/06/10'.
WA_HEADER-SD_DOC_CAT = 'A'.
WA_HEADER-CURRENCY = 'INR'.
**********************************************
WA_HEADERX-DOC_TYPE = 'X'.
WA_HEADERX-SALES_ORG = 'X'.
WA_HEADERX-DISTR_CHAN = 'X'.
WA_HEADERX-DIVISION = 'X'.
* WA_HEADERX-SALES_GRP = ' '.
* WA_HEADERX-SALES_OFF = 'X'.
WA_HEADERX-DOC_DATE = 'X'. "SY-DATUM.
WA_HEADERX-SD_DOC_CAT = 'X'.
* WA_HEADERX-CURRENCY = 'X'.
*********************************************
*** CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
*** EXPORTING
*** input = ls_zsales_int-MATERIAL
*** IMPORTING
*** OUTPUT = lv_matnr
*** .
***********************************************
WA_ITEM-ITM_NUMBER = '000010'.
WA_ITEM-MATERIAL = '000000000400000083'.
WA_ITEM-BILL_DATE = '20130226'.
WA_ITEM-SHORT_TEXT = 'Sales Inquiry Testing'.
*WA_ITEM-PURCH_NO_C = ls_zsales_int- "'PO123'.
WA_ITEM-PURCH_DATE = '20130226'.
*wa_item-PURCH_DATE = '26.02.2013'.
WA_ITEM-PO_DAT_S = '20130226'."SY-DATUM.
WA_ITEM-TARGET_QTY = '2.00'.
**WA_ITEM-COMP_QUANT = '12'.
WA_ITEM-TARGET_QU = 'MT'.
WA_ITEM-TARGET_VAL = '100.00'.
WA_ITEM-CURRENCY = 'INR'.
WA_ITEM-DIVISION = '20'.
WA_ITEM-ITEM_CATEG = 'AFN'.
WA_ITEM-PRICE_DATE = '20130226'.
APPEND WA_ITEM TO IT_ITEM.
*********************************************
WA_ITEMX-ITM_NUMBER = 'X'.
WA_ITEMX-MATERIAL = 'X'.
WA_ITEM-BILL_DATE = 'X'. "SY-DATUM.
WA_ITEM-SHORT_TEXT = 'X'. "Sales Inquiry Testing'.
***WA_ITEM-PURCH_NO_C = 'X'. "'PO123'.
WA_ITEM-PURCH_DATE = 'X'. "SY-DATUM.
WA_ITEM-PO_DAT_S = 'X'. "SY-DATUM.
WA_ITEMX-TARGET_QTY = 'U'.
WA_ITEMX-TARGET_QU = 'X'.
WA_ITEMX-TARGET_VAL = 'X'.
*WA_ITEMX-CURRENCY = 'X'.
WA_ITEMX-ITEM_CATEG = 'X'.
WA_ITEM-DIVISION = 'X'.
WA_ITEM-PRICE_DATE = 'X'.
**WA_ITEMx-COMP_QUANT = 'X'.
APPEND WA_ITEMX TO IT_ITEMX.
wa_scheline-ITM_NUMBER = '000010'.
wa_scheline-SCHED_LINE = '0010'.
wa_scheline-REQ_QTY = '10'.
append wa_scheline to it_scheline.
wa_schelinex-ITM_NUMBER = '000010'.
wa_schelinex-SCHED_LINE = '0010'.
wa_schelinex-REQ_QTY = 'X'.
append wa_schelinex to it_schelinex.
*********************************************
**
** CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
** EXPORTING
** input = ls_zsales_int-CUSTOMER
** IMPORTING
** OUTPUT = lv_cust
** .
***********************************************
WA_PARTNER-PARTN_ROLE = 'AG'. "LV_OUT. "AG = SOLD TO & WE = SHIP TO
WA_PARTNER-PARTN_NUMB = '0000100094'.
*WA_PARTNER-ITM_NUMBER = '000010'.
APPEND WA_PARTNER TO IT_PARTNER.
CLEAR:wa_partner.
*********************************************
WA_INQUIRY_TEXT-ITM_NUMBER = '000010'.
WA_INQUIRY_TEXT-TEXT_LINE = 'Testing'.
APPEND WA_INQUIRY_TEXT to it_INQUIRY_TEXT.
*********************************************
CALL FUNCTION 'BAPI_INQUIRY_CREATEFROMDATA2'
EXPORTING
* SALESDOCUMENTIN =
inquiry_header_in = WA_HEADER
INQUIRY_HEADER_INX = WA_HEADERX
* SENDER =
* BINARY_RELATIONSHIPTYPE =
* INT_NUMBER_ASSIGNMENT =
* BEHAVE_WHEN_ERROR =
* LOGIC_SWITCH =
* TESTRUN =
* CONVERT = ' '
IMPORTING
SALESDOCUMENT = DOC_NO
tables
RETURN = IT_RETURN
INQUIRY_ITEMS_IN = IT_ITEM
INQUIRY_ITEMS_INX = IT_ITEMX
inquiry_partners = IT_PARTNER
INQUIRY_SCHEDULES_IN = it_scheline
INQUIRY_SCHEDULES_INX = it_schelinex
INQUIRY_CONDITIONS_IN = IT_CON
INQUIRY_CONDITIONS_INX = IT_CONX
* INQUIRY_CFGS_REF =
* INQUIRY_CFGS_INST =
* INQUIRY_CFGS_PART_OF =
* INQUIRY_CFGS_VALUE =
* INQUIRY_CFGS_BLOB =
* INQUIRY_CFGS_VK =
* INQUIRY_CFGS_REFINST =
INQUIRY_TEXT = it_INQUIRY_TEXT
* INQUIRY_KEYS =
* EXTENSIONIN =
* PARTNERADDRESSES =
.
CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
WAIT = 'X'.
* IMPORTING
* RETURN =
.
write: DOC_NO.
Regards,
Mahipal
2013 Jul 22 11:19 AM
Hi Mahi
The code has to be corrected as follows:
WA_ITEMX-ITM_NUMBER = 'X'.
WA_ITEMX-MATERIAL = 'X'.
WA_ITEM-BILL_DATE = 'X'. "SY-DATUM.
WA_ITEM-SHORT_TEXT = 'X'. "Sales Inquiry Testing'.
***WA_ITEM-PURCH_NO_C = 'X'. "'PO123'.
WA_ITEM-PURCH_DATE = 'X'. "SY-DATUM.
WA_ITEM-PO_DAT_S = 'X'. "SY-DATUM.
WA_ITEMX-TARGET_QTY = 'U'.
WA_ITEMX-TARGET_QU = 'X'.
WA_ITEMX-TARGET_VAL = 'X'.
*WA_ITEMX-CURRENCY = 'X'.
WA_ITEMX-ITEM_CATEG = 'X'.
WA_ITEM-DIVISION = 'X'. <-- You missed X WA_ITEMX
WA_ITEM-PRICE_DATE = 'X'. <-- You missed X WA_ITEMX
**WA_ITEMx-COMP_QUANT = 'X'.
APPEND WA_ITEMX TO IT_ITEMX.
Review for IT_ITEMX table for the value WA_ITEMX.. Some place it is only WA_ITEM
Regards
Venkat
2013 Jul 22 12:09 PM
Hi venkat,
i have changed to Itemx for price date...but still not uploading the Target price value.
Thanks & Regards,
Mahipal.
2013 Jul 22 12:21 PM
Hi Mahi vangeti
Seems like it_con internal table values empty
why you didn't full any values there
Regards,
Bastin.G
2013 Jul 22 12:29 PM
HI Basitn.G
Now i have added the code for condition price, here is the code
WA_CON-ITM_NUMBER = '000010' .
WA_CON-COND_ST_NO = '010'.
WA_CON-COND_COUNT = '01'.
WA_CON-COND_TYPE = 'ZBPR'.
WA_CON-CONBASEVAL = '100.00'.
WA_CON-CURRENCY = 'INR'.
APPEND WA_CON TO IT_CON.
WA_CONX-ITM_NUMBER = '000010'.
WA_CONx-COND_ST_NO = '010'.
WA_CONX-COND_VALUE = 'X'.
WA_CONx-COND_TYPE = 'ZBPR'.
WA_CONX-COND_COUNT = '01'.
WA_CONx-CURRENCY = 'X'.
*WA_CONx-
APPEND WA_CONX TO IT_CONX.
but still its not updating the target price,
Please let me know if iam missing anything.
Regards,
Mahipal.
2013 Jul 22 12:40 PM
Hi Mahi vangeti
Is your condition type Manual? if not, can you ask your FC to update that ?
Regards,
Bastin.G
2013 Jul 22 1:50 PM
Hi Bastin,
I have taken the conidition type from a inquiry which is created in SAP manually by FC.
Regards,
Mahipal.
2013 Jul 22 2:15 PM
Hi Mahi vangeti
did you try it manually with your sample inputs in inquiry transaction .
whether its taking condition type and amount at that time ?
mean while am also debugging your program if anything i have found means l will inform you surely .
i hope some other experts throw lights to your program
Regards,
Bastin.G