09-22-2006 10:02 PM
Hello,
I'm currently trying to update bank account data for a customer through SD_CUSTOMER_MAINTAIN_ALL. When I update the record, I get 5 records written out to ADRU each missing PERSNUMBER and VALID_TO??
CLIENT ADDRNUMBER PERSNUMBER COMM_TYPE CONSNUMBER COMM_USAGE VALID_TO VALID_FROM DEF_USAGE
260 3000000133 INT 001 AD_DEFAULT X
260 3000000133 INT 001 AD_HOME X
260 3000000133 TEL 001 AD_DEFAULT X
260 3000000133 TEL 001 AD_HOME X
260 3000000133 TEL 001 AD_NMBDEFA X
I am reading KNA1 for my customer for i_kna1. I am also populating t_xknbk and t_yknbk with the bank data.
CALL FUNCTION 'SD_CUSTOMER_MAINTAIN_ALL'
EXPORTING
i_kna1 = ls_kna1
I_KNB1 =
I_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 = ''
PI_CAM_CHANGED = ' '
PI_ADD_ON_DATA =
I_FROM_CUSTOMERMASTER = ' '
IMPORTING
E_KUNNR =
O_KNA1 =
E_SD_CUST_1321_DONE =
TABLES
t_xknbk = lt_knbk_upd
t_yknbk = lt_knbk_old
Am I not populating something correctly? I am not attempting to update any address information.
Thanks for any Help.
Brent
09-23-2006 7:00 AM
Hello Brent
I assume your customer's address is a <b>type 1 address</b> (company address). Thus, in the ZAV you will have an address number but no personal number. Why VALID_TO is missing I do not know nor whether that is an error or not.
Regards
Uwe
09-23-2006 7:00 AM
Hello Brent
I assume your customer's address is a <b>type 1 address</b> (company address). Thus, in the ZAV you will have an address number but no personal number. Why VALID_TO is missing I do not know nor whether that is an error or not.
Regards
Uwe
09-25-2006 2:19 PM
Hello Uwe,
This is my first use of SD_CUSTOMER_MAINTAIN_ALL so please excuse my lack of knowledge. I'm only trying to add bank account information and not update any address data. Does SD_CUSTOMER_MAINTAIN_ALL always update address fields even though that is not what I am doing? If so, I will have to use the bdc.
In addition to adding the 5 records to ADRU, it also creates 5 change logs. Then every time I call SD_CUSTOMER_MAINTAIN_ALL after that, it creates 5 more change logs.
Thanks for your help.
Brent
09-25-2006 3:20 PM
I did some more testing and want to clarify what is going on. I use SD_MAINTAIN_ALL to add bank account information. At that time, the 5 records are added to ADRU. After that, I update the bank account info using the same function and each time I get 5 change logs created. Here is the detail of one of the change logs:
Details
Date 09/25/2006
Time 09:04:08
User U0059664
Field Address number ( ADRU-ADDRNUMBER )
Deletion ADRU
So I'm not sure if I can avoid adding the 5 records to ADRU and not have the change logs created.
Thanks.
Brent
09-25-2006 9:20 PM
Hello Brent
I am by no means an expert on this function module yet I have to become one because I currrently have to use this function module in an exiting project.
I tested the function module with bank data (just country, bank number and account number, nothing else) and I did not see any inserts in ADRU.
Perhaps you could try to set <b>I_NO_BANK_MASTER_UPDATE = 'X'</b> meaning that no bank addresses will be updated.
Regards
Uwe
09-27-2006 3:20 PM
Thanks for your help. I will continue to look at this but will probably end up using bdc.