Skip to Content
0
Jan 19, 2023 at 09:50 AM

Split GL accounts in BW

227 Views

Hi All,

We got one requirement to build report based on GL and amount (coming from source) in such a way that GL gets split based on below highlighted XYZ, ABC, EFG (which is not coming from the source). I tried with Bex Query designer Structure, But no luck

Could you please help me how to get the expected result.

XYZ

Amount

10009

72

10010

74

10020

2

10021

800

10011

500

10012

20

ABC

35156

720

35164

740

35157

20

35165

8

35158

50

35166

2000

EFG

20009

7200

20010

7

20020

2

20021

8000

30011

5

50012

20