Extract Business partners,Technical Installations, Devices all together

[Former Member]

Dear Gurus,

We have a requirement to extract below three objects into our Target system through a single TDMS package run :

1) Business partners installed on premises

2) Technical Installations which do not have contracts assigned

3) Available Devices ( which are not allocated to any Device Location )

In our prior runs, we used only Business partners as input in traditional approach and could see that all the Business and Technical master data has been extracted but are linked these Business Partners.

But for the next run, along with Business partners we would like to extract Technical Installations and Available Devices ( both not linked to these Business Partners).

We have the list of Business partners, Technical Installations, Devices from our source system.

Is this possible ?, if so could you please advise on the approach.

Thanks,

Sai

[former_member65049]

Hi Sai,

Could you please tell me the tables involved in the Technical Installations and Available Devices?

If you use TDMS 4.0 BPL and select the BPL object for Business Partner, only data relevant to Business Partner and its related objects will be retreived.

Using BPL modeler tool, you have the option of copying the standard BPL object for Business Partner and then extending it to include the tables related to Technical Installations and Available Devices.

You can not make any changes in the standard SAP delivered BPL objects. You need to copy them and only extend to suit your requirements.

The tables related to Technical Installations and Available Devices should be attached to the model of the copied BPL object through the foreign key mappings.

You can also create 2 new custom BPL objects to include tables related to Technical Installations and Available Devices.

These custom objects can then be used to transfer data related to relevant tables only and not related to business partner.

Regards,
Rupam

[Former Member]

Hi Rupam,

Thanks for the Information.

BPL is certainly an option to be considered for our requirement. But we also know that in TDMS traditional approach with Business objects selection we can retrieve data based on :

Business Partner

Contracts

Installations

Devices

Points of delivery (External ID)

I would like to know, If we provide input criteria for Business Partner, Installations & Devices. Does TDMS extracts based on "Business Partner or Installations or Devices" OR "Business Partner and Installations and Devices" ?

I hope you have understood our requirement, in short we would like to extract data based on three inputs in single run.

Please Advise.

Thanks,

Sai

[former_member65049]

Hi Sai,

You can check the BPL object for Business partner if it includes tables related to Installation and Devices as well.

If these tables are included, then once you give the reduction criteria for Business Partner, related Installation and Devices data will be copied by TDMS.

But if the tables for Installation and Devices are not included in BPL object for Business Partner, then you need to copy and extend this object.

If you want to transfer Installation and Devices data without relation to Business Partner, then you need to create your own custom objects for these 2 areas. These custom objects can then be used to transfer data related to each area.

If I understand you correctly, extracting data based on three inputs in single run without any relation to each other is not a feasible option.

Regards,
Rupam

[Former Member]

Rupam,

Thanks for the detailed response.

Sai