Skip to Content
0
Former Member
Sep 26, 2006 at 06:52 AM

Update partner function in KNVP table using FM sd_customer-maintain_all

4187 Views

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