TMG IN SAP ABAP | how to create tmg in sap abap | tmg events in sap abap | tmg creation in sap abap | how to create tmg events in sap abap |events in tmg in sap abap
Table of Contents
TMG in SAP ABAP
TMG (Table Maintenance Generator) in SAP ABAP is a tool to generate table maintenance program to maintain table entries in sap, TMG in sap abap created by using transaction code SE11 and TMG events in sap abap call by SM30.
In SAP ABAP sometime abap consultant or a super user required to maintain table records by manual process to fulfill some requirements. in this case we will generate TMG in SAP ABAP or in data dictionary.
For Example: we have requirement to pass some specific entries or some specific commands like we want to pass tax rate or tax calculation in program in all scenario except nil gst case so we will create a TMG in SAP ABAP and pass that table into program codes and if entries found in table then tax rate and calculation will not pass. Please see the below piece of code in program logic to understand the scenario. Here Zcheck_uname is table with TMG and ZSD_PARAM is also table with TMG.
SELECT SINGLE uname FROM ZCHECK_UNAME INTO @DATA(lv_flag) WHERE uname = @sy-uname.
IF lv_flag IS INITIAL.
IF SY-TCODE = ‘VF01’ OR SY-TCODE = ‘VF02’ OR SY-TCODE = ‘VF03’.
DATA(IT_XVBRP) = XVBRP[].
IF IT_XVBRP IS NOT INITIAL.
SELECT * FROM zsd_param INTO TABLE @DATA(it_tax_12) WHERE ZPROGRAM = ‘RV60AFZZ’
AND FIELD1 = ‘BILLTAX_12’
AND FIELD2 = ‘STEUC’
AND VAL3 = ‘X’.
SELECT * FROM zsd_param INTO TABLE @DATA(it_tax_5) WHERE ZPROGRAM = ‘RV60AFZZ’
AND FIELD1 = ‘BILLTAX_5’
AND FIELD2 = ‘STEUC’
AND VAL3 = ‘X’.
SELECT * FROM zsd_param INTO TABLE @DATA(it_tax_COND_TYPE) WHERE ZPROGRAM = ‘RV60AFZZ’
AND FIELD1 = ‘BILLTAX’
AND FIELD2 = ‘COND_TYPE’
AND VAL3 = ‘X’.
LOOP AT XKOMV ASSIGNING FIELD-SYMBOL(<FS_KOMV>) WHERE KPOSN NE ”.” XVBRP-POSNR “VBRP-POSNR
READ TABLE IT_TAX_COND_TYPE INTO DATA(WA_COND_TYPE) WITH KEY VAL1 = <FS_KOMV>-KSCHL.
IF SY-SUBRC IS INITIAL.
READ TABLE IT_XVBRP INTO DATA(WA_XVBRP) WITH KEY POSNR = <FS_KOMV>-KPOSN.
IF SY-SUBRC IS INITIAL.
SELECT SINGLE steuc FROM marc
INTO @DATA(lv_steuc)
WHERE matnr = @WA_Xvbrp-matnr
AND werks = @WA_Xvbrp-werks.
READ TABLE it_tax_12 INTO DATA(WA_TAX_12) WITH KEY VAL1 = LV_STEUC+0(4).
IF SY-SUBRC IS INITIAL.
CASE <FS_KOMV>-KSCHL.
WHEN ‘JOIG’.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘120.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 12 ) / 100.
ENDIF.
WHEN ‘JOCG’.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘60.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 60 ) / 1000.
ENDIF.
WHEN ‘JOUG’.
IF <FS_KOMV>-KBETR IS NOT INITIAL.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘60.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 60 ) / 1000.
ENDIF.
ENDIF.
WHEN ‘JOSG’.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘60.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 60 ) / 1000.
ENDIF.
ENDCASE.
ENDIF.
READ TABLE it_tax_5 INTO DATA(WA_TAX_5) WITH KEY VAL1 = LV_STEUC+0(2).
IF SY-SUBRC IS NOT INITIAL .
READ TABLE it_tax_5 INTO WA_TAX_5 WITH KEY VAL1 = LV_STEUC+0(4).
ENDIF.
IF SY-SUBRC IS INITIAL.
CASE <FS_KOMV>-KSCHL.
WHEN ‘JOIG’.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘50.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 5 ) / 100.
ENDIF.
WHEN ‘JOCG’.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘25.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 25 ) / 1000.
ENDIF.
WHEN ‘JOUG’.
IF <FS_KOMV>-KBETR IS NOT INITIAL.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘25.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 25 ) / 1000.
ENDIF.
ENDIF.
WHEN ‘JOSG’.
IF ( <FS_KOMV>-KAWRT / WA_XVBRP-FKIMG ) LE 1000.
<FS_KOMV>-KBETR = ‘25.00’.
<FS_KOMV>-KWERT = ( <FS_KOMV>-KAWRT * 25 ) / 1000.
ENDIF.
ENDCASE.
ENDIF.
ENDIF.
ENDIF.
ENDLOOP.
ENDIF.
ENDIF.
ENDIF.
Table Maintenance Generator Events: Create, Update and Delete
Table Maintenance generator events are Create, Update and Delete, and we all know about create update and delete. table maintenance generator events are called by transaction code SM30.
What is SAP Table Maintenance Generator?
TMG (Table Maintenance Generator) in SAP ABAP is a tool to generate table maintenance program to maintain table entries in sap, TMG in sap abap created by using transaction code SE11 and TMG events in sap abap call by SM30.
In SAP ABAP sometime abap consultant or a super user required to maintain table records by manual process to fulfill some requirements. in this case we will generate TMG in SAP ABAP or in data dictionary.
How to create Table Maintenance Generator?
To create Table Maintenance Generator in SAP ABAP please follow the below steps.
Step 1. Enter T-code SE11 (ABAP Dictionary) in command box.
Step 2. Now ABAP Dictionary initial screen will open here you have to enter table name and click on create button.
Step 3. Complete the process of table creation, after table creation process create TMG in table.
Step 4. Enter authorization group, function group and maint. screen no. after entering the detail click on create button your TMG will created.
FAQ
What is the T-code to create Table?
To create database table or data dictionary related element we will use Transaction code SE-11.
What is TMG?
TMG stands for table maintenance generator, TMG created because we want a table into maintenance mode. sometime user or technical requirement is to maintain a table a run the process accordingly.
What are the TMG events in SAP ABAP?
Create, update and delete are the main events of table maintenance generator.
Others Articles You Can Also Look :
Hope this article helps you to understand the process of TMG in Table.
2 thoughts on “TMG IN SAP ABAP | how to create tmg in sap abap | tmg events in sap abap | Table Maintenance Generator Events | SE11 tcode in sap”
Comments are closed.