Application Development 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: 

Update partner function in KNVP table using FM sd_customer-maintain_all

Former Member
0 Kudos

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

7 REPLIES 7

Former Member
0 Kudos

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
Member

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'

0 Kudos

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

0 Kudos

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.

0 Kudos

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

sankar1781
Participant
0 Kudos

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

sankar1781
Participant
0 Kudos

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