RFBIDE00 - Address data issue

[Former Member]

Hi,

I want to populate the street2 and street3 fields of the customer master when uploading master data with LSMW using standard program - RFBIDE00 (Batch Input Program).

These fields are not available in structure BKNA1 provided by the standard program. I tried to use structure BIADDR2 instead. The data is converted properly and show in the structure. But, when I run the generated session, the fields for street2 and street3 are not populated.

Has anyone done this?

Much appreciate if you let me know how to do this?

Thanks,

Shyam

[Former Member]

Hi,

What are the fields you use in that structure.

Are u using transfer_record at the end of this Structure.

Regards,

Anita

[Former Member]

Hi Shyam,

Central address management fields cannot be transferred using the standard program. You have to do a second pass at it to get the full centrally managed address fields. Read documentation of the program. Here is an excerpt from it.

<i>Additional address fields:

There are additional address fields available due to linking the customer and vendor master and the respective contact person to central address management. This additional address information is stored in central address management's own tables not in the actual master tables (KNA1 for the customer master, LFA1 for the vendor master, KNVK for the contact person).

A separate transfer run via the ALE interface is needed to transfer this additional address information. This run should be before the transfer run for master data.

See Transfer of address data

If you use number ranges with internal number assignment when creating new customer and vendor masters, the number which is used to identify the master object in the system must be determined beforehand due to address information and master data being transferred separately.

You can determine the numbers using the following BAPIs:

BAPI_VENDOR_GETINTNUMBER (for the vendor master)

BAPI_CUSTOMER_GETINTNUMBER (for the customer master)

BAPI_PARTNEREMPLOYEE_GETINTNUM (for the contact person)

Master data fields for which there is a counterpart in central address management (such as name, street, or telephone number) continue to be filled in the actual master tables. The formatting for these fields within central address management is different from the original formatting of the fields without the link to central address management. We therefore recommend that you only transfer the data for such fields when transferring central address management address information.</i>

If answered, please reward and close.

Regards,

Srinivas

[Former Member]

Yes, I've read the documentation of the standard program RFBIDE00. It suggests to use business object BUS4001 - Method SaveReplica to upload the address information.

The scenario is that we have to upload around 1.6 million customer master records. We would be using the standard program in LSMW for this purpose (BI session).

What I'm looking at is the exact approach of how to integrate the process of address data upload along with the other standard fields (approach in terms of addional coding in LSMW, a different LSMW / Transfer program etc..). I'm trying to find the best approach since the number of records are huge.

Thanks for your inputs.

Shyam

[Former Member]

You may check oss 306275 / 384462. It will help you design your process of load.

Cheers

[Former Member]

Hi,

Thanks for the replies so far.

I need help in figuring out the exact steps to upload the master and address data separately.

Excerpt from the documentation of RFBIDE00.

"<i>A separate transfer run via the ALE interface is needed to transfer this additional address information. This run should be before the transfer run for master data.

See Transfer of address data</i>"

I've written an LSMW to upload the address data using BUS4001-SaveReplica method. It works fine. Later, when I try to upload the master data using LSMW (with standard program RFBIDE00), it doesn't link the master data with the address already uploaded. How is this link established? We're using internal number range for customer master upload.

Can I use LSMW for address data upload or I have to use DX Workbench (transaction SXDA). It's kinda confusing to use SXDA.

Any help would be greatly appreciated.

Regards,

Shyam

[Former Member]

SXDA you can use if you have the file in required format.

LSMW is used when you want to convert / map one file struture to another file structure to enable it for loading into SAP. Ultimately SXDA or LSMW will load using BDC/ IODC / DIRECT Input .

The difference really lies whether you want to massage the input file.

Cheers

[Former Member]

Hi Guys,

Request you to please help me. It's very urgent.

I need help in figuring out the exact steps to upload the master and address data separately.

I've written an LSMW to upload the address data using BUS4001-SaveReplica method. It works fine. Later, when I try to upload the master data using LSMW (with standard program RFBIDE00), it doesn't link the master data with the address already uploaded. How is this link established? We're using internal number range for customer master upload.

As per the documentation, when uploading customer master data, I'm generating the next available number using FM: BAPI_CUSTOMER_GETINTNUMBER in LSMW and passing it to the session that is created. What is it that I'm missing?

How is the link established between the adrnr already generated (in the address transfer run) and the current customer being uploaded?

Thank you.

Shyam

[Former Member]

Hi Shyam,

"As per the documentation, when uploading customer master data, I'm generating the next available number using FM: BAPI_CUSTOMER_GETINTNUMBER in LSMW and passing it to the session that is created. What is it that I'm missing? "

I think you should also pass the generated customer number while uploading the address data. That is how the link will be established. So generate the customer number and then pass it while uploading the address data and then use the same customer number while uploading customer master data.

Hope this helps..

Sri

[Former Member]

Hi Srikanth,

Thanks for your reply. Your suggestion did help me, but one small issue still remains.

In my LSMW for address data upload, I'm populating the next available customer number using the "BAPI_CUSTOMER_GETINTNUMBER" function module and address data gets uploaded. Next, when I upload the customer master data, how do I get the same customer number that was generated when I uploaded the address for that customer?

I cannot find the customer number that was generated when uploading the address in ADRC table. How do I retrieve the customer number associated with the address (before uploading the customer master).

Thanks so much.

Regards,

Shyam