Skip to Content
Oct 21, 2019 at 07:49 AM

Balance Sheet By fiscal period - Need inputs in creating sap bw Bex customer exit

103 Views Last edit Oct 21, 2019 at 10:46 AM 2 rev

Hi All,

i want to see balance by fiscal period in bex output. for this i have followed below steps.

1. Created structure as in attachedbalnce-by-fiscal-period-1.png screen shot.

2. created a CKF with two RKFs. ( CKF name is Movement actual = Current month - previous month).

3.) 1 st rkf have a key figure called 0balance . ( Need to restrict with current month cust exit variable ?? )

2 nd rkf is restruicted with key figure 0balance. ( Need restrict with Previous month cust exit variable ?? )

if i do this am getting only september and october values in output.

but i want to see results as per user entered range.

Note: user always enter 001.current year to 012.current year only. (001.2019 - 012.2019).

so in output , data will display from Jan 2019 till dec 2019. But in keyfigure column, value should come as per point 2.

please let me know if you need more inputs from my end.

Thanks in advance.



rfk-1-def.png (9.4 kB)
rkf2-def.png (5.6 kB)