Trading partner not activated in ECC

[former_member241136]

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.

[Former Member · Accepted solution]

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

[former_member241136 · Accepted solution]

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 · Accepted solution]

Hi,

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

Regards,

Chandra

[former_member241136 · Accepted solution]

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 · Accepted solution]

Hi VM,

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

Regards,
Chandra

[former_member241136 · Accepted solution]

Thanks Chandra for your help.

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

Regards,

VM

[Former Member]

The best  way to address this issue you are corrected the posting in ECC, In ECC you post or move amounts from blank/null trading partner to actual trading partner is one solution.

Khokan

[former_member241136]

Hi Khokan,

Thanks for your reply.

So in ECC we need to activate the trading partner and correct the posting for open items.

Can you please share the document if any for solution?

Thanks and Regards,

VM

[Former Member]

For Trading Partner activation you refer to FI people they will guide you.

[former_member241136]

Thanks Khokan for your help.

Will definitely connect with FI guy and activate the trading partner in ECC and upload open items by posting entry with Trading partner field.

Regards,

VM