Adding Collection Agency to 0Customer

[Former Member]

Hi All,

I have a requirement, we have 0Customer data in BI and now need to add Collection Agency field to 0Customer.

BUSAB is the Collection agency filed from KNB5 table in r/3. I can see the customer and collection agency data while running FDM_P2P_CUSTOMER_LIST ABAP program in r/3.

1) Do I need to create new datasource on FDM_P2P_CUSTOMER_LISTprogram and replicate it to BI and create multiprovider with 0CUSTOMER & newly created datasource?

2) Do I need to change datasource for 0CUSTOMER to add collection Agency filed in r/3 itself, if yes how I need to proceed with it to merge program data with datasource data. I can see Customer(Kunnr) field common in 0CUSTOMER datasource & KNB5 table.

3) Is there any other solution?

Thanks,

Aparna

[former_member360228 · Accepted solution]

Hi,

For your requirement if you can see Customer as the key field in both the tables then you can enhance your 0CUSTOMER data-source with that extra field. You can use the following document for a step by step instructions on how to enhance a data-source.

[http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/00c1f726-1dc2-2c10-f891-ddfbffdb1a46]

Regards,

Arminder Singh

[Former Member · Accepted solution]

Hi Arminder,

Thanks for your quick reply, the datasource 0CUSTOMER_ATTR is not in the LO Cockpit to delete first setup tables and then to add field. It is under LO-IO master data application component.

So I need to enhance structure in RSA6 by appending structure and then write code for extract structure for master data attribute to get data into new field right?

Thanks,

AP

[former_member360228 · Accepted solution]

Hi,

Just go through the enhancement and it has information about LO as well as standard data-source enhancement.

Regards,

Arminder Singh

[Former Member]

No need to create extractor, data is already coming through other extractor. So just added filed as required.

Thanks