Tips and Tricks for SAP EC Calculations
Attaching the tips and tricks for SAP EC calculation.
Topics covered are
1. Strings
Operations
2. Date
operation
Thanks and Regards,
Vikram Chavan
Tips and Tricks for
Calculations:
Calculations:
Applies to:
EC SP 15
Summary:
This article covers tips and tricks which can be used in EC
calculations.
calculations.
Author: Vikram Chavan.
Company: Igate Corporation.
Created on: 22nd Oct 2013.
Author Bio:
Vikram Chavan is working as ABAP/EC technical consultant in Igate
Corporation and has More than 9 years of experience in SAP ABAP and EC.
Corporation and has More than 9 years of experience in SAP ABAP and EC.
Table of Contents
- Strings Operations. 3
- 1.1 Concatenate strings. 3
- 1.2 Concatenate strings with
numerical variable. 3 - 1.3 Concatenate with New line. 3
- Date operation. 3
- 2.1 Difference between two dates. 3
- 2.2 Get start date of the period
and previous years date. 3 - 2.3 To get month, day or year. 4
- 2.4 Shift
the period to last year. 4
1. Strings Operations
1.1 Concatenate strings
lv_ fstname
= “Mr Sam”;
= “Mr Sam”;
lv_lstname = “Buck”;
lv_fullname = Lv_ fstname + “ “ + Lv_lstname;
Result: lv_fullname will have value “Mr Sam
Buck”.
Buck”.
1.2 Concatenate strings with numerical variable
lv_ fstname
= “Mr Sam”;
= “Mr Sam”;
lv_lstname = “Buck”;
lv_age =
“Age”;
“Age”;
lv_ageno
= 35;
= 35;
lv_str = lv_
fstname + ” “ + lv_lstname
+ ”, “ + lv_age
+ “ “ +
lv_ageno ;
fstname + ” “ + lv_lstname
+ ”, “ + lv_age
+ “ “ +
lv_ageno ;
Result : lv_str will have value “Mr Sam
Buck, Age 35”.
Buck, Age 35”.
1.3 Concatenate with New line
lv_str = “Hello
World”.
World”.
lv_str1 = “First
Code”.
Code”.
Lv_str = “Hello
World” + “\nFirst Code”.
World” + “\nFirst Code”.
Result: Hello World
First Code.
2. Date
operation
2.1 Difference between two dates.
lv_date1 =
#2005.12.05 00:00:00#
#2005.12.05 00:00:00#
lv_date2
= #2005.12.01 00:00:00#.
= #2005.12.01 00:00:00#.
lv_numdays = LV_DATE1 –
LV_DATE2;
LV_DATE2;
Result: Lv_numdays = 4.
2.2 Get start date of the period and previous years
date
Example:
Consumption C has a start date
5/10/2011 11:00:00 (that is, May, 10th, 11 a.m.).
5/10/2011 11:00:00 (that is, May, 10th, 11 a.m.).
CalculateTimePeriod(C,”YEARS”,1,”PREVOUS”)
returns: ([1/1/2010
12:00:00],[31/12/2010 11:59:59])
12:00:00],[31/12/2010 11:59:59])
CalculateTimePeriod(C,”YEARS”,1,”FROM_TODAY”)
returns: ([5/10/2010
11:00:00],[5/10/2011 10:59:59])
11:00:00],[5/10/2011 10:59:59])
2.3 To get month, day or year
FROMDATE = C.from;
Result:
j =
FROMDATE.month ;
FROMDATE.month ;
p =
FROMDATE.day ;
FROMDATE.day ;
k =
FROMDATE.year ;
FROMDATE.year ;
2.4 Shift the period to last year
- fromDate.year = fromDate.year – 1;
- fromDate.hour = 12;
- fromDate.minute = 00;
- fromDate.second = 00;
- toDate.year = toDate.year – 1;
- toDate.hour = 11;
- toDate.minute = 59;
- toDate.second = 59;
Be the first to leave a comment
You must be Logged on to comment or reply to a post.