Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Extract all new fields added to tables

Former Member
0 Kudos

Hello.

I need to extract all fieldnames that have been added to the specific tables in my data dictionary.

The user inputs a date then i have a SQL query but i'm not really sure about the results it gives me.


  SELECT tabname fieldname as4date FROM DD03N
    INTO TABLE t_newfield
    WHERE as4date > p_date
    AND tabname like 'ZVOIT%'
    OR tabname like 'mvke'
    or tabname like 'mara'
    ORDER BY tabname.

In fact this query only returns me the fields with data elements than have been created (or modified). It's incomplete as some fields were added but refering to a data element that already exist and they are not extracted.

Anyone has an idea about how i can do that ? Or maybe my query is'nt questionning the right table ?

Thanks for the help

4 REPLIES 4

venkata_ramisetti
Active Contributor
0 Kudos

Hi,

Please check the table DD03L. It contains all fields that you require.

Let us know if you need futher help.

Thanks,

Ramakrishna

Former Member
0 Kudos

You should use the function DDIF_TABL_GET.

this function return all what you need.

Laurent.

Former Member
0 Kudos

Hi

Only the structure of view are stored in the DD03N.

If I understand you're speaking about transparent table, aren't you?

You can use fm DDIF_FIELDINFO_GET or read the table DD03L

Max

Former Member
0 Kudos

Using the table DD03L was my first idea but in this table you don't have any date so i can't filter the fields by date...

I will try the fonction modules you gave me and i'll let you know if it works for me.

Thanks.