Archive for the ‘Standard Function Module’ Category
WS_UPLOAD – File transfer from presentation server file to internal table
WS_DOWNLOAD – File Transfer From Internal Table to Presentation Server File
WS_DOWNLOAD – Save Internal Table as File on the Presentation Server
WS_FILE_DELETE – Delete File at the Frontend
WS_FILENAME_GET – Call File Selector
FILENAME_GET – popup to get a filename from a user, returns blank filename if user selects cancel
LIST_DOWNLOAD – Download of ABAP list (Report) to local file
LIST_TO_ASCI – Converts the specified list (LIST_INDEX) or the provided list (LISTOBJECT) to ASCII.
RZL_READ_FILE – Read a file from the presentation server if no server name is given, or read file from remote server. Very useful to avoid authority checks that occur doing an OPEN DATASET. This function using a SAP C program to read the data.
RZL_WRITE_FILE_LOCAL – Saves table to the presentation server (not PC). Does not use OPEN DATASET, so it does not suffer from authority checks!
Get a date
DATE_GET_WEEK Returns week for a date
WEEK_GET_FIRST_DAY Returns first day for a week
RP_LAST_DAY_OF_MONTHS Returns last day of month
FIRST_DAY_IN_PERIOD_GET Get first day of a period
LAST_DAY_IN_PERIOD_GET Get last day of a period
RP_LAST_DAY_OF_MONTHS Determine last day of month
Date calculations
DATE_COMPUTE_DAY Returns a number indicating what day of the week the date falls on. Monday is returned as a 1, Tuesday as 2, etc.
DATE_IN_FUTURE Calculate a date N days in the future.
RP_CALC_DATE_IN_INTERVAL Add days/months to a date
RP_CALC_DATE_IN_INTERVAL Add/subtract years/months/days from a date
SD_DATETIME_DIFFERENCE Give the difference in Days and Time for 2 dates
MONTH_PLUS_DETERMINE Add or subtract months from a date. To subtract a month, enter a negative value for the ‘months’ parameter.
DATE_CREATE Calculates a date from the input parameters:
Example: DATE_CREATE
CALL FUNCTION ‘DATE_CREATE’
EXPORTING
anzahl_jahre = 1
anzahl_monate = 2
anzahl_tage = 3
datum_ein = ‘20010101’
IMPORTING
datum_aus = l_new_date.
Result:
l_new_date = 20020304
Example: MONTH_PLUS_DETERMINE
data: new_date type d.
CALL FUNCTION ‘MONTH_PLUS_DETERMINE’
EXPORTING
months = -5 ” Negative to subtract from old date, positive to add
olddate = sy-datum
IMPORTING
NEWDATE = new_date.
write: / new_date.
Holidays
HOLIDAY_GET Provides a table of all the holidays based upon a Factory Calendar &/ Holiday Calendar.
HOLIDAY_CHECK_AND_GET_INFO Useful for determining whether or not a date is a holiday. Give the function a date, and a holiday calendar, and you can determine if the
date is a holiday by checking the parameter HOLIDAY_FOUND.
Example: HOLIDAY_CHECK_AND_GET_INFO
data: ld_date like scal-datum default sy-datum,
lc_holiday_cal_id like scal-hcalid default ‘CA’,
ltab_holiday_attributes like thol occurs 0 with header line,
lc_holiday_found like scal-indicator.
CALL FUNCTION ‘HOLIDAY_CHECK_AND_GET_INFO’
EXPORTING
date = ld_date
holiday_calendar_id = lc_holiday_cal_id
WITH_HOLIDAY_ATTRIBUTES = ‘X’
IMPORTING
HOLIDAY_FOUND = lc_holiday_found
tables
holiday_attributes = ltab_holiday_attributes
EXCEPTIONS
CALENDAR_BUFFER_NOT_LOADABLE = 1
DATE_AFTER_RANGE = 2
DATE_BEFORE_RANGE = 3
DATE_INVALID = 4
HOLIDAY_CALENDAR_ID_MISSING = 5
HOLIDAY_CALENDAR_NOT_FOUND = 6
OTHERS = 7.
if sy-subrc = 0 and
lc_holiday_found = ‘X’.
write: / ld_date, ‘is a holiday’.
else.
write: / ld_date, ‘is not a holiday, or there was an error calling the function’.
endif.
Checking dates
DATE_CHECK_PLAUSIBILITY Check to see if a date is in a valid format for SAP. Works well when validating dates being passed in from other systems.
Converting dates
DATE_CONV_EXT_TO_INT Conversion of dates to SAP internal format e.g. ‘28.03.2000’ -> 20000328 Can also be used to check if a date is valid ( sy-subrc 0 )
Function to return literal for month
he table you want to use is T247. You can also use the function MONTH_NAMES_GET. [ Monique Goodrich ,posted to SAP listserver]
You can also try table T015M. It has the month number in it’s key.
[Walter Barr , posted to SAP listserver]
Formatting
DATUMSAUFBEREITUNG Format date as the user settings
Other
MONTH_NAMES_GET It returns all the month and names in repective language.
CURRENCY_AMOUNT_SAP_TO_IDOC – Convert currency to IDOC format
CONVERT_TO_LOCAL_CURRENCY – Conversion of currency
CLOI_PUT_SIGN_IN_FRONT Move the negative sign from the left hand side of a number, to the right hand side of the number. Note that The result will be left justified (like all
character fields), not right justifed as numbers normally are.
CONVERT_TO_FOREIGN_CURRENCY Convert local currency to foreign currency.
CONVERT_TO_LOCAL_CURRENCY Convert from foreign currency to local currency
Example 1: Convert amount to/from string
Amount to string:
CALL FUNCTION ‘HRCM_AMOUNT_TO_STRING_CONVERT’
EXPORTING
betrg = 3000
WAERS = ‘DKK’
* NEW_DECIMAL_SEPARATOR =
* NEW_THOUSANDS_SEPARATOR =
IMPORTING
STRING = slam
.
String to amount:
CALL FUNCTION ‘HRCM_STRING_TO_AMOUNT_CONVERT’
EXPORTING
string = slam2
DECIMAL_SEPARATOR = ‘.’
* THOUSANDS_SEPARATOR =
WAERS = ‘HUF’
IMPORTING
BETRG = b2
* EXCEPTIONS
* CONVERT_ERROR = 1
* OTHERS = 2
Recent Comments