topic Re: ADRC table updation in Application Development and Automation Discussions

ADRC table updation

Former Member — Mon, 29 Dec 2008 11:07:42 GMT

Hi,

How can we update the fields in adrc table based on address number.

For some address numbers , full address details are not maintained.

Because of this in sap scripts forms full address details are not coming.

Ex : In FORM 16 A , the address of Person deducting tax is not displaying.

When i debug i came to know that fields of adrc are not maintained based on address number.

please help me to resolve this issue.

Thanks & Regards,

Hari priya

Re: ADRC table updation

Sm1tje — Mon, 29 Dec 2008 11:10:26 GMT

There are some function groups starting with BUBA* in which you can find function modules / BAPI's for updating these address tables using the address number.

Re: ADRC table updation

Former Member — Mon, 29 Dec 2008 11:42:47 GMT

Hi Micky,

Can you please elobrate how can we update the fields of ADRC.

i know the address number.

I want to update some fields for this address number....

please help me...

Regards,

Hari priya

Re: ADRC table updation

Former Member — Mon, 29 Dec 2008 13:13:41 GMT

HI,

you can update directly by using INSERT command right?????//

TYPES: BEGIN OF ty_file_list_glb1.

INCLUDE STRUCTURE ADRC.

TYPES: END OF ty_file_list_glb1.

DATA: it__detail1 TYPE STANDARD TABLE OF ty_file_list_glb1,

wa_detail LIKE LINE OF it_detail1.

loop at it_table into wa_table.

wa_detail-bet12 = wa_tablel-bet12.

wa_detail-bet13 = wa_table-bet13.

wa_detail-bet14 = wa_table-bet14.

*******************************Inserting records into DB table

INSERT into ADRC values wa_zhrpy_fbp_detail.

IF sy-subrc EQ 0.

COMMIT WORK.

ELSE.

ROLLBACK WORK.

ENDIF.

endloop.

try this.

Edited by: mallikarjuna goud on Dec 29, 2008 2:15 PM

Re: ADRC table updation

Sm1tje — Mon, 29 Dec 2008 13:26:14 GMT

Never do a manual insert as suggested above, since there are a lot of dependencies for the addresses.

In function group starting with BUBA* (do a search in se80 and enter BUBA*). You will get a few function groups and one of these function groups also holds some function modules for updating address of business partners (person or organization).

You can also do a search via se37 (function modules) and enter something like this;

BUPAADDRESSCREATE

BUPAADDRESSUPDATE (or BUPAUPDATEADDRESS).

When you have found one of these, navigate to the function group to which this function module belongs and you will find all the other relevant function modules for creating, updating, searching addresses (based on address number).

You can also do a search via transaction BAPI.

P.S. I have no system at hand, so I can't give you the exact function module name).

Re: ADRC table updation

Former Member — Mon, 29 Dec 2008 13:38:26 GMT

try these

BAPI_BUPA_ADDRESS_CHANGE -SAP BP, BAPI: Change Address

BUPA_ADDRESS_CHANGE

Re: ADRC table updation

Sm1tje — Mon, 29 Dec 2008 13:40:27 GMT

those are the ones I meant!!

Re: ADRC table updation

Former Member — Mon, 29 Dec 2008 23:23:53 GMT

BAPI_BUPA_ADDRESS_ADD

Regards,

Darshan Mulmule

Re: ADRC table updation

Former Member — Tue, 30 Dec 2008 02:09:54 GMT

Looks like functionality of P and B has been swapped(Not completely but often) in your keyboard.

Re: ADRC table updation

Former Member — Tue, 30 Dec 2008 09:56:26 GMT

Hi Amit,

I tried some function modules , but it is not getting updated.

I want to update the following fields for my address number in ADRC table.

str_suppl1,

str_suppl2,

street, city2,

post_code1,

city_code,

sort1,

name_text .

please help me to resolve this issue.

Thanks & regards,

Hari priya