Update partner function in KNVP table using FM sd_customer-maintain_all

[Former Member]

Hi All,

I have to update Partner Function ‘PARVW’ in KNVP table using FM sd_customer_maintain_all.

I had already created a BDC program for updating which is running successfully.

But my requirement is to create a BAPI using FM customermaintain_all.

Ex: Tcode VD02

KUNNR PARVW KUNN2

Old data 123 Z1 70006666

123 Z2 70007777

Req. output 123 Z1 70006666

123 Z1 70007777

PARVW ‘Z2’ should not exist after updation.

When updating, I am getting the error message to my inbox as

“ Error Info... F2 802: System error in table KNVP ”

The above error is triggered while committing work after execution of ‘SD_CUSTOMER_MAINTAIN_ALL’.

The options I tried while looping at internal table containing kunnr, parvw & kunn2

*********************************************************

CALL FUNCTION 'SD_CUSTOMER_MAINTAIN_ALL'

EXPORTING

I_KNA1 = w_kna1

• I_KNB1 =

I_KNVV = w_knvv

• I_BAPIADDR1 =

• I_BAPIADDR2 =

• I_MAINTAIN_ADDRESS_BY_KNA1 = ' '

• I_KNB1_REFERENCE = ' '

• I_FORCE_EXTERNAL_NUMBER_RANGE = ' '

• I_NO_BANK_MASTER_UPDATE = ' '

• I_CUSTOMER_IS_CONSUMER = ' '

• I_RAISE_NO_BTE = ' '

PI_POSTFLAG = 'X'

• PI_CAM_CHANGED = ' '

• PI_ADD_ON_DATA =

• I_FROM_CUSTOMERMASTER = ' '

• IMPORTING

• E_KUNNR =

• O_KNA1 =

• E_SD_CUST_1321_DONE =

• TABLES

• T_XKNAS =

• T_XKNBK =

• T_XKNB5 =

• T_XKNEX =

• T_XKNVA =

• T_XKNVD =

• T_XKNVI =

• T_XKNVK =

• T_XKNVL =

T_XKNVP = I_XKNVP

• T_XKNZA =

• T_YKNAS =

• T_YKNBK =

• T_YKNB5 =

• T_YKNEX =

• T_YKNVA =

• T_YKNVD =

• T_YKNVI =

• T_YKNVK =

• T_YKNVL =

T_YKNVP = i_yknvp ***

• T_YKNZA =

• T_UPD_TXT =

EXCEPTIONS

CLIENT_ERROR = 1

• KNA1_INCOMPLETE = 2

• KNB1_INCOMPLETE = 3

• KNB5_INCOMPLETE = 4

• KNVV_INCOMPLETE = 5

• KUNNR_NOT_UNIQUE = 6

• SALES_AREA_NOT_UNIQUE = 7

• SALES_AREA_NOT_VALID = 8

• INSERT_UPDATE_CONFLICT = 9

• NUMBER_ASSIGNMENT_ERROR = 10

• NUMBER_NOT_IN_RANGE = 11

• NUMBER_RANGE_NOT_EXTERN = 12

• NUMBER_RANGE_NOT_INTERN = 13

• ACCOUNT_GROUP_NOT_VALID = 14

• PARNR_INVALID = 15

• BANK_ADDRESS_INVALID = 16

• TAX_DATA_NOT_VALID = 17

• NO_AUTHORITY = 18

• COMPANY_CODE_NOT_UNIQUE = 19

• DUNNING_DATA_NOT_VALID = 20

• KNB1_REFERENCE_INVALID = 21

• CAM_ERROR = 22

OTHERS = 23.

IF sy-subrc eq ‘0’.

Commit work and wait.

Endif.

All above tables have a field called ‘KZ’ which has options

U-update

D-delete

I-insert

E-………(I don’t know)

Ex: T_XKNVP structure = KNVP Structure + Field ‘KZ’.

**************************************************************************

Documentation for this FM is not Available in English or German

*************************************************************************

1. I tried sending Z2 KZ as ‘D’ first & Z1 with KZ as ‘I’ with business partner of Z2 (KUNN2)

as single update.

Ex: T_XKNP table

KUNNR PARVW KUNN2 KZ

123 Z2 70007777 D

123 Z1 70007777 I

2. I tried it as a separate delete record and insert record i.e calling the FM twice .

3. I tried passing table T_YKNVP with old partner data + TXKNVP table new partner data

Ex: T_YKNP table

KUNNR PARVW KUNN2 KZ

123 Z2 70007777 U or space (I tried both one after another)

4. All combinations for field ‘KZ’ are tried.

Please help me to overcome this problem.

I ) I need which parameters are to be passed to FM for updating partner function in KNVP table .

II) Do I need to pass structure I_KNA1 or I_KNVV to FM ? (Blank or with values corresponding to

partner function ).

III) Any sample code which can guide me.

Even a small hint or clue from you will certainly help me.

Thanks in Advance.

AJAX

[Former Member]

i have the same problem. I need to update the partner function PARVW thru a program that i created. I tried to use this FM but it didn't work. Anyone knows another FM that i can use to update the KNVP table?

[jesus_azuaje]

Hi...

The problem is solved.

When you want to Update the PARVW in the KNVP, the tables T_XKNVP and T_YKNVP must be filled. Take into account the following:

1.- In the T_XKNVP table the final data that the KNVP table must have for the PARVW that you want to modify

2.- In the T_YKNVP table the current data of the PARVW that is being modified

The bapi has a perform that checks if the T_YKNVP table was completed. If it is empty, the function assumes that we want to make an insert of PARVW in the KNVP

Take into account that in both tables T_YKNVP and T_XKNVP, the field KZ = 'U'

[ayyappan_venugopal2]

It works, able to create or update partner function of customer thanks.

[sankar1781]

Hi,

I have a requirement and the CM update is happening thru an IB IDoc using DEBMAS.

The request is a change of CM Partner functions. The data would be a change of an existing partner function and also a creation of new partner function.

The above solution that you provided, will work?

For example: in the below one, AG is a change to modify the KUNN2 and WE is an additional one as a creation.

Please share your valuable comment.

Thanks.

[sankar1781]

The field PARZA must be updated with value to manage multiple partner function and also to edit the existing PF.

[sankar1781]

The field PARZA must be updated with value to manage multiple partner function and also to edit the existing PF.

[sankar1781]

The field PARZA must be updated with value to manage multiple partner function and also to edit the existing PF.