cancel
Showing results for 
Search instead for 
Did you mean: 

Trading partner not activated in ECC

0 Kudos

Hi All,

I am implementing the BPC 10.1 and I have a situation where Trading partner field is not activated in ECC.

The current consolidation is done in excel and the interunit elimination is done via excel only.

Request you all to suggest any method or way where we can implement the interunit elimination.

Regards,

VM.

View Entire Topic
Former Member
0 Kudos

Hi,

You can extract balance from BSEG table using data source 0FI_GL_04. After importing line item data create a table to maintain customer and vendor mapping  with Inter-company. The third party customer and vendor members directly mapped to I_NONE. The inter-company mapping table can be updated using web dynpro.

Create a start routine to convert customer and vendor numbers to inter-company and add this this start routine in the transformation file.  Following this method your 0FI_GL_04 will have all the line items. the cube line item will be big.

                                             Or

Alternate way  you can import AP and AR and GL balance using respective data sources and create another cube  and load GL balance without  AR/AP sub ledger GL  account balance  and load AR/ AP balance with customer vendor balance.

In the conversion file maintain mapping for customer and vendor with Inter-company.

Regards,
Chandra

0 Kudos

Hi Chandra,

Thanks for your reply. The option 1 mentioned in your response would not feasible in this client as the there is no provision for custom dynpro udates.

The second option seems to be an alternative can you elaborate a bit more so that i can discuss the approach with the BI/BW consultant.

Regards

VM

Former Member
0 Kudos

Hi,

Attaching a picture for data extraction from ECC to BW to identify inter-company details.

Regards,

Chandra

0 Kudos

Hi Chandra,

Thanks for your prompt reply.

FYI..... we are using 10.1 version BPC ,BW HANA .

Would the solution provided  by you work in BW HANA or should we do something in ECC or BPC?

Appreciate your response.

Regards,

VM

Former Member
0 Kudos

Hi VM,

Need not do anything. Follow the standard data extraction procedure.

Regards,
Chandra

0 Kudos

Thanks Chandra for your help.

Seems the extraction suggested by you would work by segregating the GL's.

Regards,

VM