Skip to Content
0
Jul 29, 2016 at 12:32 PM

BW Docnumber Should not Repeat ?

55 Views

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.

Attachments

pastedImage_0.png (243.6 kB)