data source for getting address of vendor-LFA1-LIFNR from table ADRC

[Former Member]

Hi,

I would like to know the data source which will extract Vendor ,Manufacturer and Customer address from table ADRC. Vendor shall be derived from LFA1-KUNNR, Manufacturer shall be derived from Material(MARA) and Customer wil be derived from KNA1-KUNNR. Could anyone provide the data source which will provide address for Vendor , Manufacturer and Customer?

Thanks,

Sangarsh

[Former Member · Accepted solution]

Hi Sarhan,

I want some address lines which are not available in 0vendor_attr and 0customer_attr.

Regards,

Sangarsh

[Former Member · Accepted solution]

You can enhance the data source, here you find how to do it.

[Former Member]

Try this one:

0BP_DEF_ADDRESS_ATTR - SAP BP: BP Standard Address Extraction

Extractor Details:

Datasource Type : Master Data Attributes Extractor

Application : -

Delta Process :

Extraction Method : Based on Function Module (Complete Reference)

Extractor : BUPA_DEF_ADDRESS_BW

Extractor Structure : BUS_PARTNER_ADDRESS_BW

Source Tables (Function Module) : BUPA_DEF_ADDRESS_BW (Function Module)

Read more: http://www.tcodesearch.com/sap-bw-datasources/detail?id=0BP_DEF_ADDRESS_ATTR#ixzz3DUXOLDoa

[Former Member]

Hi Sarhan,

0BP_DEF_ADDRESS_ATTR provides address of Business partner.How should it be joined with Vendor ,Manufacturer and Customer?

[Former Member]

It is better for you to use 0vendor_attr and 0customer_attr