SAP Table Maintenance Display
In previous tutorial, you’ve learned how to create table maintenance generator by using TCODE SE54, today you will learn how to create the table display that utilizes TCODE SM30 to maintain the table values.
1. Execute TCODE SE93.
Enter the TCODE name, start with Z or Y.
Choose “Transaction with parameters (Parameter transaction).
Click “OK”
Table Maintenance Generator in SAP
Today I want to teach you how to create table maintenance generator in SAP, if you never heard about table maintenance generator, it’s actually used to maintain table values by using TCODE SE54 and after you create the table maintenance then you can display the values by using SM30.
Follow these steps to create table maintenance generator.
1. Execute TCODE SE54.
2. Enter the table name. Select “Generated Objects.” Click Create.
Table Relationship In SAP
Today I want to teach you how to find SAP table relationships, this is very useful for functional analyst to make a good program specification and also it can help ABAPer to look at the table relationships also.
The TCODE we’ll be using is SE11.
1. EXECUTE TCODE SE11 and enter the table name that you want to look at the relationship, in this tutorial I want to see table relationships between table EQUZ and ILOA, so I just type in the EQUZ table name and click on the display button.
Convert Number To words Using ABAP
Today I want to share some ABAP code samples that you can use to convert numbers or amount into words using SPELL_AMOUNT function module.
Here’s the ABAP Sample code:
data:
lw_spell LIKE spell,
saywords(150),
lv_text TYPE ltext,
p_amt TYPE eban-preis,
p_amt2(15),
p_waers type eban-waers.
START-OF-SELECTION.
p_amt = ‘123450′.
p_waers = ‘USD’.
SELECT SINGLE ktext INTO lv_text
FROM tcurt
WHERE spras = sy-langu
AND waers = p_waers.
TRANSLATE lv_text to UPPER CASE.
CALL FUNCTION ‘SPELL_AMOUNT’
EXPORTING
amount = p_amt
currency = p_waers
filler = ‘ ’
language = sy-langu
IMPORTING
in_words = lw_spell.
DATA: lv_cent TYPE spell.
lw_spell-decimal = lw_spell-decimal / 10.
IF lw_spell-decimal IS NOT INITIAL.
CALL FUNCTION ‘SPELL_AMOUNT’
EXPORTING
amount = lw_spell-decimal
* currency = lw_vbak-waerk
filler = ‘ ’
language = sy-langu
IMPORTING
in_words = lv_cent.
ENDIF.
IF NOT lv_cent-word IS INITIAL.
CONCATENATE lw_spell-word ‘AND’ lv_cent-word ‘CENTS’
lv_text INTO saywords
SEPARATED BY space.
ELSE.
CONCATENATE lw_spell-word lv_text INTO saywords
SEPARATED BY space.
ENDIF.
WRITE p_amt to p_amt2 CURRENCY p_waers.
WRITE:/ p_amt2, saywords.
“end code
Run the program and you will see the number has been converted into words.
Run the program
How To Maintain Long Text Object in SAP
Long Text has many usages in SAP, in this text object we can put on information such as names, job position without have to create any tables or user exits.
To read the information in the long text object, we’re can use the “READ_TEXT” function, You can check here to find out how to read from the text object.
The TCODE you can use to maintain long text object in SAP is SO10. Using this tcode you can edit or just display the value of the long text object.
After you execute the TCODE, you need to enter, TEXT NAME, TEXT ID and LANGUAGE. Click Display or Change To maintain the long text values.
How To Know What TCODE Used In ABAP Program
Today I want to teach you how to find out what TCODE that is used by the ABAP Program, to do this we can see the package of the program it self, in order to do this, you can execute TCODE SE80.
Select Program in the “Test Repository” tab, and enter the ABAP Program name, press enter to continue.
Now you can see that this program package consists of several folders such as Dictionary Structures, Fields, Events, Subroutines, etc.
How does Customer Relationship Management Work?
Customer Relationship Management (CRM) is now being widely used by businesses all over the world. It can be very beneficial whether it’s a big, medium or small business. CRM intends to improve customer relationship, and this relationship is the key to a successful business. Customers are the ones who keep a business surviving in a very tight competitive market. Without them, the business will have no sense anymore. That is why CRM is offered to help build a stronger customer relationship, but how does it work?
