Page 1 of 1

ROLLNAME - missing from DD04L

Posted: Tue Mar 25, 2014 7:06 am
by simonB2013
Hi, and maybe I should explain ... I am not a SAP delveoper, programmer or any other kind of SAP expert.
However, I am on a project where I have to extract the Data Dictionary data into SQL Server and do some reporting on the contents.

Most of the structure I believe that I understand correctly, including tables, data elements, rollnames, domains and relationships.
However, a few nuances elude me !

Here's todays ..
I have entries in DD03L, that have a ROLLNAME populated... yet that ROLLNAME does not appear in DD04L.

I guess some of the questions that come to mind from this :
> Do the populated fields in DD03L server any practical purpose if there is no corresponding detail in DD04L ?
> Is this orphaned data a 'problem' ?
> What causes this to happen ?


Sorry if this is 101 stuff to you chaps .. but I'm used to working on much stricter structures where this simply isn't allowed to happen !

Many thanks for any guidance :)

Re: ROLLNAME - missing from DD04L

Posted: Wed Mar 26, 2014 7:36 am
by Gothmog
I don't think it should happen. Is the table active? Would you have an example?

Re: ROLLNAME - missing from DD04L

Posted: Wed Mar 26, 2014 7:59 am
by simonB2013
Are the tables active?
.. that's a difficult one as I've not got a lot of access.

I have noticed that the tables affected are all TABCLASS='INTTAB' or 'APPEND'.
These TABCLASSes might not actually be required for my project, but I do hate loose ends or just burrying seomthing through a lack of understanding !

TABNAME______________________FIELDNAME_________________ROLLNAME_______________________TABCLASS
EHFNDS_POWL_BO_CONFIG........PAGING_OPTIONS............../BOBF/S_FRW_QUERY_PAGING.......INTTAB
ZXSTRUCT_CTN_TAGFLD............TAG_DATA ....................../AIN/ACTIVITY_TAGFLD_TAB..........INTTAB
FGD_DET_REQUEST..................ATTRIBUTES..................../SAPCND/DET_ATTRIB_VALUES_T.....INTTAB

Re: ROLLNAME - missing from DD04L

Posted: Wed Mar 26, 2014 8:07 am
by Gothmog
These fields are table types (not a single field with a data element, but internal tables included in the structure, found in table DD40L) or structures (including possibly several fields, found in DD02L).

IF DD03L-DATATYPE = TTYP, the field is a table.
If DD03L-DATATYPE = STRU, the field is a structure.

DD02L-TABCLASS = INTTAB is for structures (a line description, not a database table).
DD02L-TABCLASS = APPEND is for append structures - structures used to enhance other (usually standard) structures (or tables).

Re: ROLLNAME - missing from DD04L

Posted: Thu Mar 27, 2014 7:19 am
by simonB2013
Many thanks for that ... I'll use what you've explained and see if I can make more sense of my structure accordingly !