Get structure names used in a database table

-
Aim:
To get the structure name of the .INCLUDE structures used in a database table.
Tip: Navigate to PRECFIELD field in the output to see the Structure name of the include

Report:
REPORT zag_test_extract_structures.

PARAMETERS: p_table TYPE tabname16 DEFAULT 'EKKO'.

DATA: lt_fields TYPE TABLE OF dd03p,
      lv_name   TYPE ddobjname.
DATA(lref_structype) = cl_abap_typedescr=>describe_by_name( p_table ).
lv_name = p_table.

CALL FUNCTION 'DDIF_TABL_GET'
  EXPORTING
    name          = lv_name
  TABLES
    dd03p_tab     = lt_fields
  EXCEPTIONS
    illegal_input = 1
    OTHERS        = 2.
IF sy-subrc = 0.
  CALL METHOD cl_demo_output=>display_data
    EXPORTING
      value = lt_fields
      name  = 'Navigate to PRECFIELD field to see the Structure name of the include'.
ELSE.
  WRITE 'Error'.
ENDIF.

 <End of Document>

Comments

Post a Comment

Popular posts from this blog

EWM PPF Trigger the existing PPF Action through Custom Program

-
Aim: Same as title Description: An Action has been scheduled for the Handling Unit in the EWM Monitor and we need to execute it in a Custom Program without executing it from the Monitor. What to do? Use the below code accordingly. Code: *&---------------------------------------------------------------------* *& Report ZAG_TEST_HU_PRINTING *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT zag_test_hu_printing. PARAMETERS: p_hu TYPE /scwm/huident DEFAULT '154118660000024802'. DATA: lt_huhdr     TYPE /scwm/tt_huhdr_int,       lt_protocol  TYPE bal_t_logh,       lt_contexts  TYPE ppftcntxts,       lo_hu_ppf    TYPE REF TO /scwm/cl_hu_ppf,       lo_manager   TYPE REF TO cl_manager_ppf,       lt_trigger   TYPE ppfttr...
Read more

ABAP 7.5 - FILTER Statement

-
There are two internal tables, say, itab1 and itab2. Both are of the same definition. If the entries in itab2 should not be present in itab1, we use FILTER function along with 'EXCEPT IN'. There are two internal tables, say, itab1 and itab2. Both are of the same definition. If only the entries in itab2 should be present in itab1, we use FILTER function along with 'IN'. FILTER required SORTED / HASHED internal tables. Example program is below. REPORT  zag_75_filter1 . TYPES :  BEGIN  OF  lty_filter ,          field1  TYPE  i ,          field2  TYPE  i ,         END  OF  lty_filter ,        ltt_filter  TYPE  SORTED  TABLE  OF  lty_filter  WITH  NON-UNIQUE  KEY  field1 field2 . DATA :  lt_main   ...
Read more

Useful Transaction Codes / Tools in OData ABAP Service / SAP UI5/ SAP Fiori

-
Tips:   1) FND stands for 'Front End' 2) GW stands for Gate Way / Gateway S. No. Transaction Code Description 1 SEGW SAP Service Gateway Builder 2 /IWFND/ERROR_LOG SAP Gateway Error Log 3 /IWFND/APPS_LOG SAP Gateway Application Log Viewer 4 /IWFND/VIEW_LOG SAP Gateway Application Log Viewer 5 /IWFND/CACHE_CLEANUP Cleanup of GW Model Cache - GW stands for Gateway 6 /IWFND/TRACES SAP Gateway Traces 7 /IWFND/SRV_VALIDATE This transaction exists only on SAP Gateway 2.0 (Netweaver 7.31 and below) systems 8 /IWFND/REG_SERVICE Activate Services (Unavailable in latest releases) 9 /IWFND/MAINT_SERVICE Activate and Maintain Services 10 /IWFND/VIRUS_SCAN Configuration of SAP GW Virus Scan 11 SICF Edit HTTP Service Hierarchy 12 ...
Read more