SAP IBP KF PERIODID3 values coming as 6 Digit number (How we will get values like below description)

[dinesh-chandra]

Hi Everyone,

Greetings of the day.

In CI-DS we have a requirement to send the data from IBP to SAP ECC Table. the condition is send data to ECC only for present month and future months. based on this requirement we can use PERIODID3 value as filter the data in CI-DS. Filter condition is like "TableName.PERIODID3 >= 0" .

But in our case we are getting the PERIODID3 Values as 6 Digit Numbers like below. 

Please help us how we will get the PERIODID3 values as blow

Current month PERIODID3 value as 0

Last month PERIODID3 value as -1

Next month PERIODID3 value as 1

Can somebody give me some advice to solve this ?

Thank you !

[riyazahmed_ca2]

Hi Dinesh,

There is no straight forward way to bring your PERIODID3 values as 0, 1, 2.. 

But, we can do the below tweaking to get it that way.

1) Create a column namely ZPERIODID3 in your tranform output.

2) update the mapping as below.

date_diff(systime(),<IBP.KEYFIGUREDATE>,'MM')

Note IBP.KEYFIGUREDATE represents the KEYFIGUREDATE column of IBP Source Table.

Yep, its done now.

Best Regards,

'Riyaz'