Some useful standard Function modules

 *=============================================================

*SPELL_AMOUNT

*This function module converts amount into English words

*=============================================================

DATA WORDS1 TYPE SPELL.

CALL FUNCTION 'SPELL_AMOUNT'

EXPORTING

AMOUNT = 679340232

IMPORTING

IN_WORDS = WORDS1.  * WORDS1 is a structure with some components

WRITE:/ WORDS1-WORD.

*==============================================================

*NUMERIC_CHECK.

*this function module adds leading zeroes for standard SAP field variables

*=============================================================

DATA ZEROES TYPE KNA1.

PARAMETERS PAR_KUNNR TYPE C LENGTH 10.

CALL FUNCTION 'NUMERIC_CHECK'

EXPORTING

STRING_IN = PAR_KUNNR

IMPORTING

STRING_OUT = PAR_KUNNR.

SELECT SINGLE * FROM KNA1 INTO ZEROES WHERE KUNNR = PAR_KUNNR.

WRITE:/ ZEROES-KUNNR,

ZEROES-STRAS,

ZEROES-ORT01,

ZEROES-LAND1.
DATA MATL TYPE MARA.

PARAMETERS PAR_MATNR TYPE C LENGTH 18.

CALL FUNCTION 'NUMERIC_CHECK'

EXPORTING

STRING_IN = PAR_MATNR

IMPORTING

STRING_OUT = PAR_MATNR.

SELECT SINGLE * FROM MARA INTO MATL WHERE MATNR = PAR_MATNR.

WRITE /:

MATL-MATNR,

MATL-MBRSH,

MATL-MTART,

MATL-MEINS.
 

 

Comments

Post a Comment

Popular posts from this blog

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more

OPEN SQL EXAMPLES IN ABAP – PART 2

 ******************************************* **displaying Raw Materials and Finished products **only from MARA table. DATA WA TYPE MARA. * **--WHERE clause is for filtering the records SELECT * FROM MARA INTO WA WHERE MTART = 'ROH' OR MTART = 'FERT'. WRITE: / WA-MATNR, WA-MBRSH, WA-MTART, WA-MEINS. ENDSELECT. * **************************************************
Read more