ABAP Logic for Splitting one record with Validfrom and ValidTo into n numbers based on month

[praveen_kumar334]

Hi Team,

Can someone please help me in getting the logic to split one record with ValidFrom and ValidTo into n number of records based on calmonth. Below is the one example 

Source :

Product	ValidFrom	ValidTo	Amount
P1001	20240101	20240430	100

Target : 

PRODUCT	CALMONTH	Amount
P1001	202401	100
P1001	202402	100
P1001	202403	100
P1001	202404	100

Regards,

Praveen.

[Sandra_Rossi]

Isn't it a loop from 01 to 04? It seems trivial. What is your issue? What did you try? Do you want us to code it for you?

[GRI]

You can put ValidFrom and ValidTo in a SPMON typped variables (spmon_from,spmon_to).

spmon_from = ValidFrom(6).

Increment of 1 for spmon_from until you reach spmon_to value.