Sep 19, 2018

Function Module DDUT_TEXTTABLE_GET to Determine Text Table for a Table of ABAP Dictionary

Determine Text Table for a Table of ABAP Dictionary

Functionality
This function module defines the name of the text table for a table defined in the ABAP Dictionary.

Pass the name of the table for which you want the text table in parameter TABNAME. If this table does not exist in the ABAP Dictionary or if it does not have a text table, the EXPORT parameters are empty. Otherwise the name of the text table is returned in export parameter TEXTTABLE. The name of the field from this text table that is used as check field for the text foreign key relationship is returned in export parameter CHECKFIELD.

Notes
If the name of the text table is known, your definition can be read with one of the function modules
DDIF_TABL_GET, DDIF_FIELDINFO_GET or DDIF_NAMETAB_GET as needed.

Parameters
TABNAME
TEXTTABLE
CHECKFIELD




Related posts:



Jun 10, 2018

Auto Update Fields in Table Maintenance Generator

Requirement:

In SM30 for table ZMMT_NIE, when there is an input, field username, current date, and time must be automatically filled. In order to do that, certain enhancement must be created.


Solution:
1. Check tab Delivery and Maintenance > Data browser/table view editing must be 'X' = 'Display Maintenance Allowed'.


2. Select Utilities > Table Maintenence Generator


This will take you to Maintenance screen.


3. Environment > Modification > Events


4. Create form routines:
  • ZBEFORE_SAVING. Type  '01' (will be called before saving)
  • ZNEW_ENTRY. Type '05' (Every new entry creation)

5. Click on the Editor button and you can create the routine to update the fields.


Result:



Related posts:

Jan 21, 2018

Append Fix Value in SAP Standard Domain

Requirement:

In transaction VB22, Release Status currently only has value: A, B, and C.
Another value Z will be added.



Solution:

Open the domain of Release Status (KFRST)

Click menu: Goto > Fixed Value Append

Create Fixed Value name. e.g.: ZFV_KFRST

Append value Z

Value Z added

Result:




Related posts: