Dear Guru's
I have Requirement to Create a Bex Report Document number(DOC_NUM) wise Proft Center Transactions.
Client Needs Two profit centers need to show at a time in Report.
One 0Profit_CTR is Presented in BSEG (0FI_GL_14) and another ZProft_CTR is presented in EKKN tabel(Customized Datasource).
For this i Have Created Two DSO's
DSO1 Contains DOC_NUM, BWDOC_NUM, PROFIT_CTR, VALUE
DSO2 Contains BWDOC_NUM, ZPROFIT_CTR
For this,
I have done in this way
I.e.., For In DSO1 I have added ZPROFT_CTR and i created Second transformation to DSO2 and i loaded the data with reference to BW doc num and ZPROFTI_CTR,
Now i am getting the OUTPUT in this manner, BW document is repeating.

But actually I want the BW doc Number should not repeat ,
Entry SHOULD come in single manner,
Please Guide me
Thanks,
Syam.