Stack Overflow
Stack Overflow

Questions tagged [sap-data-dictionary]

Questions about creation and management of ABAP data definitions like tables, views, search helps, domains and data elements

The ABAP Dictionary is used to manage SAP data definitions. The dictionary can be used to create, change, and display table entries and structures. Within SAP, the dictionary can be navigated to using transaction code SE11.

Some important object types defined in the data dictionary are:

  • Tables: database tables made up of rows and columns, the collection of fields that contain data.
  • Views: define tables and fields from one or more tables to create an application-dependent view of those components, hiding fields that are not needed.
  • Lock Objects: used to manage parallel access to a table by locking and unlocking table access.
  • Domains: used to maintain the technical information of a field, including its data type.

Useful links

Related tags

107 questions
1
vote
1 answer

String type in dictionary table column

I have an SE11 table with a column of type STRING and I'm wondering how this is stored on the underlying DB system (SAP Hana in this case). I read that only a reference to the LOB is actually saved in a column typed as STRING and the string itself…
andrecito
  • 476
  • 5
  • 13
1
vote
2 answers

Excluding view cluster maintenance from transport

I want to exclude a view cluster maintenance from being transported (standard SAP customizing view cluster FISKVC_TAXSECTN) To do this, I copied the maintenance views of that view cluster and excluded the new maintenance views from the transport…
Gerd Castan
  • 6,275
  • 3
  • 44
  • 89
1
vote
3 answers

Foreign key: check table has no key field with the domain

I have two tables: ZDEPARTMENT01 and ZEMPLOY01. ZDEPARTMENT01 has a foreign key DEPHEAD, whose data element is ZPERSONNEL_NO of domain ZPERSONNEL_NO ( NUMC, 10 ). ZEMPLOY01 has a primary key EMP_NUM, whose data element is ZEMP_NUM of domain ZEMP_NUM…
gram77
  • 361
  • 1
  • 12
  • 30
1
vote
1 answer

Accessing SAP Pool Table A016 from Sql Developer

We have two divisions in our company, one uses E1 on Oracle 11g the other uses SAP on Oracle 11g. We also have a SQL Server system we use to data warehouse information once a night from both system to run our report server against. The question I…
Stephen Archbold
  • 93
  • 13
1
vote
5 answers

Check if the table exists

I need a SELECT statement in ABAP, but the problem is, that the table does not exist on that system. I am checking the existence of the table with the FM: CALL FUNCTION 'DDIF_TABL_GET' EXPORTING name = 'mytable' IMPORTING gotstate…
user3405132
  • 11
  • 1
  • 2
1
vote
4 answers

Class/Method to check if table exists in SE11 or not?

I want to check if a table exists in SE11 or not through ABAP. Their are some FM's available like "C_TABLE_EXISTENCE".... But i can't use FM's. I want to use or have to use Class and its methods in my software. Please suggest me, how can i check…
Piyush Aggarwal
  • 172
  • 3
  • 11
1
vote
1 answer

Mapping the fields of two database tables

The scenario is that, I have 2 database tables A and B. The table B is an upgraded version of the table A. (ie It might possibly have different field names and some extra fields). I need to compare these 2 tables to inform the user about these extra…
Themasterhimself
  • 1,016
  • 4
  • 17
  • 25
1
vote
2 answers

How to create a foreign key for a non-key table field?

Simply put, i want to create a structure that has a component MAKTX, and to have a foreign key relation with MAKT-MAKTX. More generally i want to have a foreign key check for a field that's not part of a primary key. I see the button…
vlad-ardelean
  • 7,480
  • 15
  • 80
  • 124
0
votes
0 answers

How to find the net asset value as Zero under a company code

In SAP MM table ANLA (Asset Master Record Segment), which field is to be considered for calculating to arrive net asset value as zero under a company code?
Jayu Anna
  • 23
  • 2
0
votes
0 answers

HR-ABAP: how limit values in select-options list

When I want to get a list of users absence types, I use: select-options: abs for p2001-awart. When I want to get a list of users presence types, I use: select-options: prs for p2002-awart. In both cases I get a list that contains all types…
OlMarkov
  • 1
  • 1
0
votes
2 answers

Highlight (mark) / set a cursor to a specific line in an event in Table Maintenance Generator (SM30)

I have implemented the event 01 - Before saving the data in the database for a table in the Table Maintenance Generator TMG. In the implementation code I am looping over the total table, checking for a certain field to satisfy some condition. In…
Frontmaniaac
  • 221
  • 3
  • 14
0
votes
1 answer

How to signal that some fields from a DDIC structure are intended to be hidden or "technical" in an ALV?

My goal is to make a dynamic ALV whose field catalog is based on a custom DDIC structure that is passed to it. I want some fields of my DDIC structure to be hidden in the ALV but I should not hardcode any specific field to be hidden or technical,…
Cutter
  • 1,673
  • 7
  • 27
  • 43
0
votes
0 answers

Need to create a specific search help for a field in an exit screen

In an exit screen I added a new field, everything is ok for display/modification/save management. Now I would like to add a search help on this field, but the need is relatively complex so I have to do a specific search help with a search help exit…
tafkap
  • 9
  • 2
0
votes
2 answers

What is SAP Table lock object for and how to use it?

Once we created a lock object for the particular table in SAP ABAP from SE11, is it possible to create entries in the table? If yes then what is the special thing in lock object? I have tried creating a lock object in SE11 and after that in SE37 I…
kirthika nagarajan
  • 1
0
votes
0 answers

SAP RAP Function DDIC Type as Import Parameter

I am trying to create a OData function import via RAP. When I use an abstract CDS view to define my parameter like this it works just fine: static function XXX parameter YYY result [0..*] $self; define abstract entity YYY { importParameter:…
Erch
  • 589
  • 5
  • 25
1 2 3
4
5 6 7 8