Dynamic section in a fixed Bex structure

[Former Member]

Hi experts,

I have such a report requirement from the client, which is similar to a monthly income statement of an insurance agent:

+Opening Balance: xxx EUR
+Total Commission Type 1: xxx EUR
+Total Commission Type 2: xxx EUR
+....
+Total Commission Type N: xxx EUR
+Miscellaneous Income: xxx EUR
- Payment:
-- Payment 1
-- Payment 2
....
-- Payment n
+New Balance: xxx EUR

I have modeled this report with a Bex structure in Query Designer. But I have a big problem dealing with the line "Payment", because it is not a fixed structure. One agent can receive up to n payments in a month and I have to list out every payment.

So I would like to ask if there is a workaround for designing such a requirement?

Thanks in advance!

Regards,

Meng

[Former Member · Accepted solution]

How do you differentiate between different payments?

based on a char I guess.

Why do not go for a hierarchy in R/3 side and can hav the expansion there?

In a fixed structure I guess only option is to create max and hide supress zero and yes it is a horrible design if u do this.

Thanks

Navneet

[Former Member]

Hi,

I have solved the problem by creating another 10 fixed structure elements for the payment and getting the selection dynamically via customer exit. This is a terrible solution, but the only one I could think of.

Regards,

Joon

[former_member223480]

Hi there

You have a structure , in the payment block you will have only the key figure for the payments. Add after the structure the characteristic which indicates your payments and make this area to have hierarchical view, expand it until the structure.

I think this will break, manually your payments based on the payment characteristic.

[Former Member]

Hi,

Displaying total Payments in the current structure and providing RRI for the payments detail would be a work around.

--

Sankar Kumar

[Former Member]

not able to understand the issue properly. if the agen tis the key and you rpayment is a key figure just put that in the columns and it should show all the other payments.. or eleborate more..

[Former Member]

Hi,

any updates?

Thanks,

Meng

[gunesbt]

If you know the max number of payments, then create that number of payments and hide zeros.Then empty payments will not be shown up.However, this is a terrible solution if he can have 50 payments for example.