Splitting the single record into multiple records based on validity

[Former Member]

Hi Guru's,

basically i am an BI consultant with less knowledge on ABAP, can i request your help on the ABAP task.

I am working on HR module which is integrated with SAP BI, the reports will be executed based on calendar month the requirement is i should split the single record into a multiple records based on validity of the record. basically the HR data would be in data from and date to.

below is the logic

Check whether the start and end date of the record are in the same month and year.

If yes  nothing changes

If no  create multiple records

1st record  original start date of the record u2018till end of that month

Following record  1st of the next month u2018till last day of the month

u2026

Last record  1st of the month u2018till original end date.

All fields will have the same values, only the datefrom and dateto fields change.

Can any one please provide me the same code to proceed on my task.

Thanks and Regards,

Venkat

[former_member181964 · Accepted solution]

Hi,

Using Rule group we can split it.

Using Rule Group in SAP-BI Part - 1

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/business-intellige...

Thanks

Reddy