Output table fields to a list

Output table fields to a list

This tip is excerpted from Matt Wong's SAP Basis site.

When you're looking at the structure of a table, SAP will let you print the structure, but it won't let you save the structure. This can be annoying. This report outputs the table structure to a list. At this point you can use the System->List->Save->Local file command to save the list to a file.

*&---------------------------------------------------------------------*
*& Report  YTABFLDS                                                    *
*&                                                                     *
*&---------------------------------------------------------------------*
*&                                                                     *
*&                                                                     *
*&---------------------------------------------------------------------*

REPORT  YTABFLDS                      .
TABLES: DD02L, DD03L, DD04T.

PARAMETERS THETABLE LIKE DD02L-TABNAME OBLIGATORY.
DATA: BEGIN OF MYTABLE,
      TABNAME LIKE DD02L-TABNAME,
      AS4LOCAL LIKE DD02L-AS4LOCAL,
      AS4VERS LIKE DD02L-AS4VERS,
      END OF MYTABLE.

SELECT SINGLE TABNAME AS4LOCAL AS4VERS INTO MYTABLE FROM DD03L
       WHERE TABNAME = THETABLE.
  WRITE: / MYTABLE-TABNAME, 11 MYTABLE-AS4LOCAL, 13 MYTABLE-AS4VERS.
  SELECT * FROM DD03L
         WHERE TABNAME = MYTABLE-TABNAME AND
              AS4LOCAL = MYTABLE-AS4LOCAL AND AS4VERS = MYTABLE-AS4VERS.
    WRITE: / DD03L-FIELDNAME, 11 DD03L-KEYFLAG, 13 DD03L-ROLLNAME,
    24 DD03L-CHECKTABLE, 35 DD03L-INTTYPE, 37 DD03L-REFTABLE,
    48 DD03L-DATATYPE.
    SELECT SINGLE * FROM DD04T
          WHERE ROLLNAME = DD03L-ROLLNAME AND
          AS4LOCAL = MYTABLE-AS4LOCAL AND AS4VERS = MYTABLE-AS4VERS AND
          DDLANGUAGE = 'E'.

    WRITE: 53 DD04T-DDTEXT.
ENDSELECT.

Did you like this tip? If so (or if not) let us know. Send an email to sound off.


This was first published in February 2001

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close