Extract Vendor master data which maintain in International Versions

[former_member267332]

Hi All,

Can you please kindly advice how to extract the international versions of the vendor master data which maintain in Tcode: FK03 please?

In tcode : FK03 and click "International version" where we already activated this function.

We have maintained the chinese vendor master data.

We tried tcode: SE16N and enter LFA1 but the vendor master data is in english version but it did not display chinese version of the master data.

We tried to use report S_ALR_87012086 and S_ALR_87012087 to extract out the vendor master data but it only display english version but did not display chinese version.

Can you please kindly advice and share with us if you have any better idea?

Thanks.

Best regards,

CJ

[former_member184580 · Accepted solution]

Hi Khor,

Can you check table ADRC? (Pass address no from the LFA1 table to ADRC).

Regards,

Prasad

[former_member267332 · Accepted solution]

Hi Prasad,

Table : ADRC does not display chinese version of the master data. Do you know is there any report where we can display it please?

Thanks.

Best regards

CJ

[former_member184580 · Accepted solution]

Hi Khore,

If you have created with Chines version it will display in ADRC table. Please pass selection criteria as below

I don't see any report available for the same.

Thanks & Regards,

Prasad

[former_member267332 · Accepted solution]

Hi Prasad,

Yes.It works now. Thanks. But however, my users cannot have the access to Tcode: SE16 or SE16N due to audit issues.

As such, they are unable to check the vendor master data themselves to look for missing chinese text.

Thanks.

Best regards,

CJ

[former_member184580 · Accepted solution]

Hi Khor,

I don't think any standard report available other than table extract (ADRC or SADR).

Please find below sap help link for more details on International address versions.

International Address Versions - Business Address Services (BC-SRV-ADR) - SAP Library

Thanks & Regards,

prasad

[Former Member]

Hi,

You should get the address from ADRC, pass address no (ADDRNUMBER) from LFA1 table and NATION = 'C' (Chinese)

[former_member267332]

Hi Thanh Tam Nguyen Thi,

Thanks for your reply.

Yes. It works now but do you aware is there any reports where we can extract the chinese text into excel?

Report S_ALR_87012086 and S_ALR_87012087 is unable to display the chinese text which maintain in international languages function.

The reason is because my users cannot have the access to Tcode: SE16 or SE16N due to audit issues. As such, they are unable to check the vendor master data themselves to look for missing chinese text.

Thank you .

Best regards,

CJ

[former_member188028]

Then create a query report using logical data base KDF.

Please search SCN for query creation if you are not familiar with.

[Former Member]

Please refer SAP Note 316331.

[Former Member]

Hi,

In LFA1 - LAND1 Not Equal to "IN" can also give the list of Foreign Vendors.

Regards,

Jaymin R. Bhatt

[former_member267332]

Hi Jaymin R. Bhatt,

LFA1 only display EN languages eventhough in international version we already maintain in chinese version.

Thanks.

Best regards,

CJ

[suma_mani]

Hi CJ

Filter Country not equal to IN in above mentioned transaction code under dynamic selections.

Regards

Mani

[former_member267332]

Hi Mani,

The LFA1 and dynamic selections does not display the text in chinese languages.

I would like to display the vendor master data text in chinese languages in the report.

Below screen shot is from FK03 after click international versions.

Thanks.

Best regards,

CJ

[Former Member]

Hi,

Collect the LFA1 - ADRNR Number and pass the same in ADRC Table.

Select the Version, it would give the details in the Language Maintained.

Regards,

Jaymin R. Bhatt