Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Issue in Updating price in bapi BAPI_INQUIRY_CREATEFROMDATA2.

former_member212913
Participant
0 Likes
1,427

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

7 REPLIES 7
Read only

venkateswaran_k
Active Contributor
0 Likes
1,346

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

Read only

0 Likes
1,346

Hi venkat,

                             i have changed to Itemx for price date...but still    not uploading the Target price value.

Thanks & Regards,

Mahipal.

Read only

0 Likes
1,346

Hi Mahi vangeti

Seems like it_con internal table values empty

why you didn't full any values there

Regards,

Bastin.G

Read only

0 Likes
1,346

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.

Read only

0 Likes
1,346

Hi Mahi vangeti

Is your condition type Manual? if not, can you ask your FC to update that ?

Regards,

Bastin.G

Read only

0 Likes
1,346

Hi Bastin,

                  I have taken the conidition type from a inquiry  which is created in  SAP manually by FC.

Regards,

Mahipal.

Read only

0 Likes
1,346

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