GL_COA_MAPPING : Primary to Secondary Ledger

Good People,

I have a requirement of creating secondary ledger with a different COA where

The expectation is as following :

Primary Ledger                               Secondary Ledger

---------------------                              -------------------------

Segment 1                   =                 Segment 1

Segment 2                   =                 Segment 2

Segment 3                   =                 Segment 3

Segment 4 in

Combination with

Segment 5 uniquely    =                 Segment 4

I know we can use the CCID mapping but being dynamic insertion is on its always challenging.

Please advise if anyone has come across something like this ?

Thanks,

Soumya