topic Creating Records Based on Joining record in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/creating-records-based-on-joining-record/m-p/4876563#M1139915 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have an requirement</P><P></P><P></P><P>Pernr | Begda | Endda | Wage1| Wage2 |Join Date</P><P>1 | 01.01.08 | 31.01.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.02.08 | 28.02.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.03.08 | 31.03.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.04.08 | 30.01.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.05.08 | 31.05.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.06.08 | 30.06.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.07.08 | 31.07.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.08.08 | 31.08.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.09.08 | 30.09.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.10.08 | 31.10.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.11.08 | 30.11.08 | 140 | 12 | 05.05.xxxx </P><P>1 | 01.12.08 | 31.12.08 | 140 | 12 | 05.05.xxxx</P><P></P><P></P><P>I have to make these 12 recors into 2 records based on employee joining date and month irrespective of emplyee joining year xxxx.</P><P>The records should appear in below mentioned format.</P><P>Pernr | Begda | Endda | Wage1| Wage2 |Join Date</P><P> 1 01.01.08 04.05.08 100 10 05.05.xxxx </P><P> 1 05.05.08 31.12.08 140 12 05.05.xxxx</P><P></P><P></P><P>Please advice.Thanks in Advance.</P><P></P><P>Regards,</P><P>IFF</P><P></P><P>Edited by: IFF on Dec 18, 2008 12:02 PM</P></BODY></HTML> Thu, 18 Dec 2008 06:28:06 GMT Former Member 2008-12-18T06:28:06Z Creating Records Based on Joining record https://community.sap.com/t5/application-development-and-automation-discussions/creating-records-based-on-joining-record/m-p/4876563#M1139915 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have an requirement</P><P></P><P></P><P>Pernr | Begda | Endda | Wage1| Wage2 |Join Date</P><P>1 | 01.01.08 | 31.01.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.02.08 | 28.02.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.03.08 | 31.03.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.04.08 | 30.01.08 | 100 | 10 | 05.05.xxxx</P><P>1 | 01.05.08 | 31.05.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.06.08 | 30.06.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.07.08 | 31.07.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.08.08 | 31.08.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.09.08 | 30.09.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.10.08 | 31.10.08 | 140 | 12 | 05.05.xxxx</P><P>1 | 01.11.08 | 30.11.08 | 140 | 12 | 05.05.xxxx </P><P>1 | 01.12.08 | 31.12.08 | 140 | 12 | 05.05.xxxx</P><P></P><P></P><P>I have to make these 12 recors into 2 records based on employee joining date and month irrespective of emplyee joining year xxxx.</P><P>The records should appear in below mentioned format.</P><P>Pernr | Begda | Endda | Wage1| Wage2 |Join Date</P><P> 1 01.01.08 04.05.08 100 10 05.05.xxxx </P><P> 1 05.05.08 31.12.08 140 12 05.05.xxxx</P><P></P><P></P><P>Please advice.Thanks in Advance.</P><P></P><P>Regards,</P><P>IFF</P><P></P><P>Edited by: IFF on Dec 18, 2008 12:02 PM</P></BODY></HTML> Thu, 18 Dec 2008 06:28:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/creating-records-based-on-joining-record/m-p/4876563#M1139915 Former Member 2008-12-18T06:28:06Z Re: Creating Records Based on Joining record https://community.sap.com/t5/application-development-and-automation-discussions/creating-records-based-on-joining-record/m-p/4876564#M1139916 <HTML><HEAD></HEAD><BODY><P>self answered</P></BODY></HTML> Sun, 01 Feb 2009 07:25:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/creating-records-based-on-joining-record/m-p/4876564#M1139916 Former Member 2009-02-01T07:25:28Z