topic Re: Update partner function in KNVP table using FM sd_customer-maintain_all in Application Development and Automation Discussions

Update partner function in KNVP table using FM sd_customer-maintain_all

Former Member — Tue, 26 Sep 2006 06:52:43 GMT

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

Re: Update partner function in KNVP table using FM sd_customer-maintain_all

Former Member — Tue, 17 Apr 2007 20:37:24 GMT

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?

Re: Update partner function in KNVP table using FM sd_customer-maintain_all

jesus_azuaje — Thu, 27 May 2021 16:09:40 GMT

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'

Re: Update partner function in KNVP table using FM sd_customer-maintain_all

ayyappan_venugopal2 — Sun, 10 Sep 2023 20:49:59 GMT

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

Re: Update partner function in KNVP table using FM sd_customer-maintain_all

sankar1781 — Fri, 15 Sep 2023 08:32:23 GMT

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.

Re: Update partner function in KNVP table using FM sd_customer-maintain_all

sankar1781 — Tue, 19 Sep 2023 12:55:34 GMT

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

Re: Update partner function in KNVP table using FM sd_customer-maintain_all

sankar1781 — Tue, 19 Sep 2023 12:56:34 GMT

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

Re: Update partner function in KNVP table using FM sd_customer-maintain_all

sankar1781 — Tue, 19 Sep 2023 12:58:06 GMT

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