topic Re: BAPI_CONTRACT_CHANGE in Application Development and Automation Discussions

BAPI_CONTRACT_CHANGE

Former Member — Wed, 13 Jul 2016 20:50:20 GMT

Hello

Need help on adding a new Condition Validity Period (ME32K) I'm using 'BAPI_CONTRACT_CHANGE filling table ITEM_COND_VALIDITY and ITEM_CONDITION and setting CHANGE_ID = 'I' but I get the following error message: Internal error T IVAKE F IVAKE_INSERT I MV13F01

I also fill the corresponding "X" tables. Maybe I cannot add Validity Periods using BAPI_CONTRACT_CHANGE? Any help would be greatly appreciated.

Thanks

Gary

Re: BAPI_CONTRACT_CHANGE

Former Member — Thu, 14 Jul 2016 03:41:58 GMT

Dear Gary,

May be you can try the below logic :

DATA : lt_ekpo TYPE STANDARD TABLE OF ekpo.

DATA : lt_item_cond_validity TYPE STANDARD TABLE OF bapimeoutvalidity,

       lt_item_cond_validityx TYPE STANDARD TABLE OF bapimeoutvalidityx,

       lt_item_condition      TYPE STANDARD TABLE OF bapimeoutcondition,

       lt_item_conditionx      TYPE STANDARD TABLE OF bapimeoutconditionx,

       lt_item_cond_scale_quan TYPE STANDARD TABLE OF bapimeoutitemscalequan,

       lt_return              TYPE STANDARD TABLE OF bapiret2.

DATA : lx_ekpo TYPE ekpo.

DATA : lx_item_cond_validity TYPE bapimeoutvalidity,

       lx_item_cond_validityx TYPE bapimeoutvalidityx,

       lx_item_condition      TYPE bapimeoutcondition,

       lx_item_conditionx      TYPE bapimeoutconditionx,

       lx_item_cond_scale_quan TYPE bapimeoutitemscalequan.

DATA : lx_return TYPE bapiret2.

DATA : ld_purchasingdocument TYPE bapimeoutheader-number,

       ld_error TYPE char1.

ld_purchasingdocument = '0141000000'.

SELECT *

INTO TABLE lt_ekpo

FROM ekpo

WHERE ebeln = ld_purchasingdocument.

LOOP AT lt_ekpo INTO lx_ekpo.

lx_item_cond_validity-item_no = lx_ekpo-ebelp.

lx_item_cond_validity-valid_from = '20160801'.

lx_item_cond_validity-valid_to = '20161231'.

APPEND lx_item_cond_validity TO lt_item_cond_validity.

lx_item_cond_validityx-item_no = lx_ekpo-ebelp.

lx_item_cond_validityx-item_nox = 'X'.

lx_item_cond_validityx-valid_from = 'X'.

lx_item_cond_validityx-valid_to = 'X'.

APPEND lx_item_cond_validityx TO lt_item_cond_validityx.

lx_item_condition-item_no = lx_ekpo-ebelp.

lx_item_condition-cond_count = '2'.

lx_item_condition-cond_type = 'PB00'.

lx_item_condition-scale_type = 'A'.

lx_item_condition-calctypcon = 'C'.

lx_item_condition-cond_value = '2500'.

lx_item_condition-currency = 'USD'.

lx_item_condition-currency_iso = 'USD'.

*NUMERATOR

*DENOMINATOR

lx_item_condition-cond_p_unt = 1.

lx_item_condition-cond_unit = 'UNT'.

lx_item_condition-cond_unit_iso = 'UNT'.

lx_item_condition-base_uom = 'UNT'.

lx_item_condition-base_uom_iso = 'UNT'.

*LOWERLIMIT

*UPPERLIMIT

lx_item_condition-vendor_no = '0000200000'.

lx_item_condition-change_id = 'I'.

APPEND lx_item_condition TO lt_item_condition.

lx_item_conditionx-item_no = lx_ekpo-ebelp.

lx_item_conditionx-cond_count = '2'.

lx_item_conditionx-item_nox = 'X'.

lx_item_conditionx-cond_countx = 'X'.

lx_item_conditionx-cond_type = 'X'.

lx_item_conditionx-scale_type = 'X'.

lx_item_conditionx-calctypcon = 'X'.

lx_item_conditionx-cond_value = 'X'.

lx_item_conditionx-currency = 'X'.

lx_item_conditionx-currency_iso = 'X'.

lx_item_conditionx-cond_unit = 'X'.

lx_item_conditionx-cond_unit_iso = 'X'.

lx_item_conditionx-cond_p_unt = 'X'.

lx_item_conditionx-base_uom = 'X'.

lx_item_conditionx-base_uom_iso = 'X'.

lx_item_conditionx-vendor_no = 'X'.

APPEND lx_item_conditionx TO lt_item_conditionx.

* lx_item_cond_scale_quan-item_no = lx_ekpo-ebelp.

* lx_item_cond_scale_quan-cond_count = '2'.

**LINE_NO

* lx_item_cond_scale_quan-scale_base_qty = 20000.

* lx_item_cond_scale_quan-cond_value = 2500.

* APPEND lx_item_cond_scale_quan TO lt_item_cond_scale_quan.

ENDLOOP.

CALL FUNCTION 'BAPI_CONTRACT_CHANGE'

EXPORTING

    purchasingdocument          = ld_purchasingdocument

*   HEADER                      =

*   HEADERX                     =

*   VENDOR_ADDRESS              =

*   TESTRUN                     =

*   TECHNICAL_DATA              =

* IMPORTING

*   EXP_HEADER                  =

TABLES

*   ITEM                        =

*   ITEMX                       =

*   ACCOUNT                     =

*   ACCOUNTPROFITSEGMENT        =

*   ACCOUNTX                    =

*   DELIVERY_ADDRESS            =

   item_cond_validity          = lt_item_cond_validity

   item_cond_validityx         = lt_item_cond_validityx

   item_condition              = lt_item_condition

   item_conditionx             = lt_item_conditionx

*   ITEM_COND_SCALE_VALUE       =

   item_cond_scale_quan        = lt_item_cond_scale_quan

*   ITEM_TEXT                   =

*   HEADER_TEXT                 =

*   HEAD_COND_VALIDITY          =

*   HEAD_COND_VALIDITYX         =

*   HEAD_CONDITION              =

*   HEAD_CONDITIONX             =

*   HEAD_COND_SCALE_VAL         =

*   HEAD_COND_SCALE_QUAN        =

*   PARTNER                     =

*   PARTNERX                    =

*   RELEASE_DOCU                =

*   EXTENSIONIN                 =

*   EXTENSIONOUT                =

   return                      = lt_return

          .

CLEAR ld_error.

LOOP AT lt_return TRANSPORTING NO FIELDS WHERE type = 'E' OR type = 'A'.

ld_error = 'X'.

ENDLOOP.

IF ld_error IS INITIAL.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

    EXPORTING

      wait   = 'X'

    IMPORTING

      return = lx_return.

ENDIF.

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Thu, 14 Jul 2016 12:16:27 GMT

Hello Yance

Thanks so much for responding to my post. I tried your code replacing Purchasing Document and Vendor number with my data and I still getting the following:

Internal error: T IVAKE F IVAKE_INSERT I MV120F01

Re: BAPI_CONTRACT_CHANGE

Former Member — Thu, 14 Jul 2016 12:18:28 GMT

Correction I typed the last part of the internal error message incorrectly it should be MV130F0I not MV120F0I

Re: BAPI_CONTRACT_CHANGE

Former Member — Thu, 14 Jul 2016 12:49:31 GMT

Dear Gary,

I have seen that error message in MV130F0I. The error will be happened if the valid date from and valid date to are the same with the existing record. Please make sure for the valid date from and valid date to.

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Thu, 14 Jul 2016 13:40:45 GMT

I tried From Date 08/01/2016 and To Date 12/31/2016 still getting that error. Attached are all the Validity Periods that currently exist for Purchasing Doc I'm trying to update .

Re: BAPI_CONTRACT_CHANGE

Former Member — Fri, 15 Jul 2016 09:52:22 GMT

Dear Garry,

Sorry, i was running the program which i gave in the previous email, not in the latest sap version and ran successfully. My current sap version is SAP ECC 6.0 EHP 0.

But I have searched and read other scn, It would be the overlapping validity date. May be my solution which i could give to you are :

1. Update the latest validity date record which is :

07.19.2016 to 12.31.9999

to be

07/19/2016 to 07/31/2016

2. Insert the new validity date record which is :

08/01/2016 to 12/31/9999

I refer the below link :

1. 901718 - Conditions: Inconsistencies for material listing/exclusion

2. https://scn.sap.com/thread/3756719

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Fri, 15 Jul 2016 14:59:59 GMT

That worked for the dates. Now need to get amount loaded for my new validation period. I fill Item_condition and Item_conditionx but looks like it is pulling previous amount, How do I get Amount to be 8 for new validation rcd?

Re: BAPI_CONTRACT_CHANGE

Former Member — Fri, 15 Jul 2016 15:43:22 GMT

Dear Gary,

Glad to hear that It worked.

To populate the amount that you should the parameter item_condition and item_conditionx. for example like the below :

lx_item_condition-item_no = lx_ekpo-ebelp.

lx_item_condition-cond_count = '2'. ->the last record + 1, If you insert the new record

if modify the existing record, get cond_count from table KONP

lx_item_condition-cond_type = 'PB00'. ->depends on your data

lx_item_condition-scale_type = 'A'. ->depends on your data

lx_item_condition-calctypcon = 'C'. ->depends on your data

lx_item_condition-cond_value = '2500'. -> put amount in here

lx_item_condition-currency = 'USD'. ->depends on your data

lx_item_condition-currency_iso = 'USD'. ->depends on your data

lx_item_condition-cond_p_unt = 1. ->depends on your data

lx_item_condition-cond_unit = 'EA'. ->depends on your data

lx_item_condition-cond_unit_iso = 'EA'. ->depends on your data

lx_item_condition-base_uom = 'EA'. ->depends on your data

lx_item_condition-base_uom_iso = 'EA'. ->depends on your data

lx_item_condition-vendor_no = '0000200000'. ->depends on your data

lx_item_condition-change_id = 'I'. -> I for new record, U for existing record

APPEND lx_item_condition TO lt_item_condition.

lx_item_conditionx-item_no = lx_ekpo-ebelp.

lx_item_conditionx-cond_count = '2'.

lx_item_conditionx-item_nox = 'X'.

lx_item_conditionx-cond_countx = 'X'.

lx_item_conditionx-cond_type = 'X'.

lx_item_conditionx-scale_type = 'X'.

lx_item_conditionx-calctypcon = 'X'.

lx_item_conditionx-cond_value = 'X'.

lx_item_conditionx-currency = 'X'.

lx_item_conditionx-currency_iso = 'X'.

lx_item_conditionx-cond_unit = 'X'.

lx_item_conditionx-cond_unit_iso = 'X'.

lx_item_conditionx-cond_p_unt = 'X'.

lx_item_conditionx-base_uom = 'X'.

lx_item_conditionx-base_uom_iso = 'X'.

lx_item_conditionx-vendor_no = 'X'.

APPEND lx_item_conditionx TO lt_item_conditionx.

I hope that It will help you.

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Fri, 15 Jul 2016 18:44:39 GMT

Dear Yance

Thanks so much for all your help, I'm so close. I tired filling item & itemx condition tables like you suggested but still not updating qty. It creates a validation rcd but with wrong qty. I have 19 Condition rcds for a particular Contract / item. Do I need to have all Condition rcds plus rcd I want to add in item condition table?

Re: BAPI_CONTRACT_CHANGE

Former Member — Sat, 16 Jul 2016 02:51:00 GMT

Dear Gary,

Do you ask me for updating amount or quantity ? My last email was to update the amount.

And Now is that you ask me to update the quantity, so my suggestion is

If your requirement is to have the contract based on quantity. please don't forget to put the below logic :

lx_item_condition-scale_type = 'A'. "Base scale

lx_item_condition-calctypcon = 'C'. "Quantity

Where do you wanna update the quantity ? Is it in line item or scale condition ?

If you wanna update the quantity in line item :

lx_item-target_qty = "fill in this..

If you wanna update the quantity in the scale condition :

lx_item_cond_scale_quan-item_no = lx_ekpo-ebelp.

lx_item_cond_scale_quan-cond_count = '2'.

*LINE_NO

lx_item_cond_scale_quan-scale_base_qty = 20000.

lx_item_cond_scale_quan-cond_value = 2500.e

APPEND lx_item_cond_scale_quan TO lt_item_cond_scale_quan.

I hope that it works for you..

Please try to search in google for the other reference (sap BAPI_CONTRACT_CHANGE), it will help you so much.

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Tue, 19 Jul 2016 14:19:32 GMT

I searched and searched on internet and cannot figure what I'm doing wrong when I use BAPI_CONTRACT_CHANGE to add a condition Record. Here is what is happening, on Item Overview screen for Item 80 the Net Price is changed to 11 which is correct. see below

But on the Condition screen amount should be 11 but it is 3. The amount of 3 is coming from the last condition record. How do I get the correct amount on this screen?

on the

Re: BAPI_CONTRACT_CHANGE

Former Member — Wed, 20 Jul 2016 09:49:42 GMT

Dear Gary,

Have you tried the below condition ?

lx_item_cond_validity-item_no = '00080'.
lx_item_cond_validity-valid_from = '20130410'.
lx_item_cond_validity-valid_to = '9991231'.
APPEND lx_item_cond_validity TO lt_item_cond_validity.

lx_item_cond_validityx-item_no = '00080'.
lx_item_cond_validityx-item_nox = 'X'.
lx_item_cond_validityx-valid_from = 'X'.
lx_item_cond_validityx-valid_to = 'X'.
APPEND lx_item_cond_validityx TO lt_item_cond_validityx.

lx_item_condition-item_no = '00080'.
lx_item_condition-cond_count = '2'. ->your sequence
lx_item_condition-cond_type = 'PB00'.
lx_item_condition-scale_type = 'A'.
lx_item_condition-calctypcon = 'C'.
lx_item_condition-cond_value = '11'.
lx_item_condition-currency = 'USD'.
lx_item_condition-currency_iso = 'USD'.
lx_item_condition-cond_p_unt = 1.
lx_item_condition-cond_unit = 'EA'.
lx_item_condition-cond_unit_iso = 'EA'.
lx_item_condition-base_uom = 'EA'.
lx_item_condition-base_uom_iso = 'EA'.
lx_item_condition-change_id = 'U'.
APPEND lx_item_condition TO lt_item_condition.

lx_item_conditionx-item_no = '00080'. ->your sequence
lx_item_conditionx-cond_count = '2'.
lx_item_conditionx-item_nox = 'X'.
lx_item_conditionx-cond_countx = 'X'.
lx_item_conditionx-cond_type = 'X'.
lx_item_conditionx-scale_type = 'X'.
lx_item_conditionx-calctypcon = 'X'.
lx_item_conditionx-cond_value = 'X'.
lx_item_conditionx-currency = 'X'.
lx_item_conditionx-currency_iso = 'X'.
lx_item_conditionx-cond_unit = 'X'.
lx_item_conditionx-cond_unit_iso = 'X'.
lx_item_conditionx-cond_p_unt = 'X'.
lx_item_conditionx-base_uom = 'X'.
lx_item_conditionx-base_uom_iso = 'X'.
APPEND lx_item_conditionx TO lt_item_conditionx.

I tried in my system, It worked.

How about you ? Is it returned Error?

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Wed, 20 Jul 2016 13:05:19 GMT

Thanks so much for all your help Yance.

The code works great when I want to do a change, but I can not get the add to work (create a new condition record) When I do an add I have to adjust last record in Validity Table that has a from date of 12/31/9999 to 9/01/2013 then my new date range for new rcd will be 9/02/2013 - 12/31/9999 otherwise I get an duplicate error message when I run 'BAPI_CONTRACT_CHANGE'. My Item Validity and Condition tables have all ITEM_NO (00080) rcds. Not sure if suppose to fill SERIAL_ID for my new rcd and not sure what I should enter so I leave it blank. I set CHANGE_ID to 'I'. for insert. This seems to work but amount on Overview Screen and Condition Price not matching.

Gary

Re: BAPI_CONTRACT_CHANGE

Former Member — Wed, 20 Jul 2016 13:58:38 GMT

Dear Gary Morman,

I think that you just combined the change and insert indicator.

For edit the last record :

lx_item_cond_validity-item_no = '00080'.
lx_item_cond_validity-serial_id = A068-KNUMH ->please query first

lx_item_cond_validity-valid_from = '20130410'.
lx_item_cond_validity-valid_to = '20130509'.
APPEND lx_item_cond_validity TO lt_item_cond_validity.

lx_item_cond_validityx-item_no = '00080'.

lx_item_cond_validity-serial_id = A068-KNUMH ->please query first

lx_item_cond_validityx-item_nox = 'X'.
lx_item_cond_validityx-valid_from = 'X'.
lx_item_cond_validityx-valid_to = 'X'.
APPEND lx_item_cond_validityx TO lt_item_cond_validityx.

lx_item_condition-item_no = '00080'.

lx_item_condition-serial_id = A068-KNUMH ->please query first
lx_item_condition-cond_count = '1'. ->your sequence
lx_item_condition-cond_type = 'PB00'.
lx_item_condition-scale_type = 'A'.
lx_item_condition-calctypcon = 'C'.
lx_item_condition-cond_value = '11'.
lx_item_condition-currency = 'USD'.
lx_item_condition-currency_iso = 'USD'.
lx_item_condition-cond_p_unt = 1.
lx_item_condition-cond_unit = 'EA'.
lx_item_condition-cond_unit_iso = 'EA'.
lx_item_condition-base_uom = 'EA'.
lx_item_condition-base_uom_iso = 'EA'.
lx_item_condition-change_id = 'U'.
APPEND lx_item_condition TO lt_item_condition.

lx_item_conditionx-item_no = '00080'. ->your sequence
lx_item_conditionx-serial_id = A068-KNUMH ->please query first

lx_item_conditionx-cond_count = '1'.
lx_item_conditionx-item_nox = 'X'.
lx_item_conditionx-cond_countx = 'X'.
lx_item_conditionx-cond_type = 'X'.
lx_item_conditionx-scale_type = 'X'.
lx_item_conditionx-calctypcon = 'X'.
lx_item_conditionx-cond_value = 'X'.
lx_item_conditionx-currency = 'X'.
lx_item_conditionx-currency_iso = 'X'.
lx_item_conditionx-cond_unit = 'X'.
lx_item_conditionx-cond_unit_iso = 'X'.
lx_item_conditionx-cond_p_unt = 'X'.
lx_item_conditionx-base_uom = 'X'.
lx_item_conditionx-base_uom_iso = 'X'.
APPEND lx_item_conditionx TO lt_item_conditionx.

For Insert the new record :

lx_item_cond_validity-item_no = '00080'.

lx_item_cond_validity-serial_id = ''.

lx_item_cond_validity-valid_from = '20130510'.
lx_item_cond_validity-valid_to = '99991231'.
APPEND lx_item_cond_validity TO lt_item_cond_validity.

lx_item_cond_validityx-item_no = '00080'.

lx_item_cond_validityx-serial_id = ''.

lx_item_cond_validityx-item_nox = 'X'.
lx_item_cond_validityx-valid_from = 'X'.
lx_item_cond_validityx-valid_to = 'X'.
APPEND lx_item_cond_validityx TO lt_item_cond_validityx.

lx_item_condition-item_no = '00080'.

lx_item_condition-serial_id = ''.
lx_item_condition-cond_count = '1'.
lx_item_condition-cond_type = 'PB00'.
lx_item_condition-scale_type = 'A'.
lx_item_condition-calctypcon = 'C'.
lx_item_condition-cond_value = '12'.
lx_item_condition-currency = 'USD'.
lx_item_condition-currency_iso = 'USD'.
lx_item_condition-cond_p_unt = 1.
lx_item_condition-cond_unit = 'EA'.
lx_item_condition-cond_unit_iso = 'EA'.
lx_item_condition-base_uom = 'EA'.
lx_item_condition-base_uom_iso = 'EA'.
lx_item_condition-change_id = 'I'.
APPEND lx_item_condition TO lt_item_condition.

lx_item_conditionx-item_no = '00080'.

lx_item_conditionx-serial_id = ''.
lx_item_conditionx-cond_count = '1'.
lx_item_conditionx-item_nox = 'X'.
lx_item_conditionx-cond_countx = 'X'.
lx_item_conditionx-cond_type = 'X'.
lx_item_conditionx-scale_type = 'X'.
lx_item_conditionx-calctypcon = 'X'.
lx_item_conditionx-cond_value = 'X'.
lx_item_conditionx-currency = 'X'.
lx_item_conditionx-currency_iso = 'X'.
lx_item_conditionx-cond_unit = 'X'.
lx_item_conditionx-cond_unit_iso = 'X'.
lx_item_conditionx-cond_p_unt = 'X'.
lx_item_conditionx-base_uom = 'X'.
lx_item_conditionx-base_uom_iso = 'X'.
APPEND lx_item_conditionx TO lt_item_conditionx.

I hope that will help you.

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Wed, 20 Jul 2016 15:19:56 GMT

Thanks for all your help. I did what you suggested but now getting the following error, does this make any sense to you?

These are the parms I'm passing in, do I need to add HEAD structure to 'BAPI_CONTRACT_CHANGE'. I did add HEADER and HEADERx on a previous try but still got the same error unless not filling fields correctly.

Re: BAPI_CONTRACT_CHANGE

Former Member — Wed, 20 Jul 2016 17:44:27 GMT

Thanks Yance for all your help and patience with me, your code worked I just had some data discrepancies to work out.

Gary Morman

Re: BAPI_CONTRACT_CHANGE

Former Member — Wed, 20 Jul 2016 21:10:31 GMT

I thought I had it working using code for update and insert posted earlier but the Amount in the Price Condition (PB00) is not getting the value I have coded in the Insert part of the code. The Net Price on the Item Over View screen is getting set to the correct value but the Amount in the Condition Rcd (PB00) is using the previous PB00 value.

Re: BAPI_CONTRACT_CHANGE

Former Member — Thu, 21 Jul 2016 13:13:15 GMT

Dear Gary,

Could I see your coding in how you populate the bapi parameters?

Regards,

Yance

Re: BAPI_CONTRACT_CHANGE

Former Member — Thu, 21 Jul 2016 14:26:49 GMT

I think I found the problem but not sure how to fix? When I just do an update CHANGE_ID = 'U' change validity date from 9999/1231 to 20101229 it automatically creates a second record 20101230 - 99991231. But the SERIAL_ID are visa versa

That is why qty is not correct. The VALID_TO = 99991231 should have SERIAL_ID = 0000783712. Any ideas what I need to do?