This website is not affiliated with, sponsored by, or approved by SAP AG.

ROLLNAME - missing from DD04L

SAP-OTHER (SAP Components and all other issues that do not fall under above categories)

Moderators: Snowy, thx4allthefish

ROLLNAME - missing from DD04L

Postby simonB2013 » Tue Mar 25, 2014 7:06 am

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 :)
simonB2013
 
Posts: 3
Joined: Wed Jul 24, 2013 4:27 am

Re: ROLLNAME - missing from DD04L

Postby Gothmog » Wed Mar 26, 2014 7:36 am

I don't think it should happen. Is the table active? Would you have an example?
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1942
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: ROLLNAME - missing from DD04L

Postby simonB2013 » Wed Mar 26, 2014 7:59 am

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
simonB2013
 
Posts: 3
Joined: Wed Jul 24, 2013 4:27 am

Re: ROLLNAME - missing from DD04L

Postby Gothmog » Wed Mar 26, 2014 8:07 am

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).
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1942
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: ROLLNAME - missing from DD04L

Postby simonB2013 » Thu Mar 27, 2014 7:19 am

Many thanks for that ... I'll use what you've explained and see if I can make more sense of my structure accordingly !
simonB2013
 
Posts: 3
Joined: Wed Jul 24, 2013 4:27 am


Return to SAP Other

Who is online

Users browsing this forum: No registered users and 3 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.