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

Create nested DDIC tables for JSON?

I created a table "users" with user properties... however, I wanted to have a complex/nested field called "address", but it seems tables can only be flat in abap dict tables... I can only use ".INCLUDE" to put the address fields flat into the table…
MMMM
  • 3,320
  • 8
  • 43
  • 80
1
vote
0 answers

Repository / tool for determining table relationships (or possible relationships)

Is there a repository/tool (within or outside SAP ERP) that can help me determine the fields that I can use when trying to link 2 tables (or possibly show other necessary tables before I can link the 2 tables) between SAP ERP tables? I've been…
Hazzan Dalisay Ortuoste Jr.
  • 11
  • 3
1
vote
1 answer

Fetching SAP table data throws Error 8114

I'm trying to update SQL data from SAP data (same happens with insert). I'm always getting runtime error SQL error 8114 The reason for the exception is: Database error text: "Error converting data type nvarchar to numeric." All fields of…
Dragonite LvL 100
  • 11
  • 1
  • 7
1
vote
2 answers

Adding all table fields into the SE11 structure?

I'm learning SAP and ABAP language, I need to create a structure with all the fields of the SFLIGHT database table and a few more. Do I have to enter all the fields of the SFLIGHT table manually or is there any possibility to add all the fields of a…
Abapito
  • 73
  • 7
1
vote
1 answer

Disable records removal of standard table through maintenance view

There is a standard table T513 and customer master data table T7SK13, which is modified by customer using maintenance view V_T7SK13, with following tables/join conditions: Is there a possibility to somehow disable removal of records from…
kocica
  • 6,412
  • 2
  • 14
  • 35
1
vote
1 answer

Is there any way to exclude a component via the type table syntax?

I am trying to declare a global table gt_sel2 as type table zqmqnewslist(which is a structure), however one component of the zqmqnewslist which is PRUEF(type ZQMKZPRUEF), I do not want it in the newly table gt_sel2. Is there any way to declare the…
Frank
  • 153
  • 3
  • 17
1
vote
2 answers

How to auto-populate field via foreign key relation in SM30?

Sorry if my title doesn't make sense but I found it hard to describe! I have a Z table in SAP TM: With a foreign key relationship to the standard table /SAPAPO/LOC But I want to have an SM30 maintenance where the user populates the…
mmgro27
  • 475
  • 1
  • 8
  • 18
1
vote
1 answer

STRING type or SSTRING element for a text field in table? Pros and cons

I need to create a Z table to store reasons for modifications of a certain custom object. In the UI, the user will pick a reason ID and then optionally fill a text box. The table will have more or less the fields below: key objectID key…
RaTiO
  • 979
  • 2
  • 17
  • 33
1
vote
4 answers

Get components of DDIC structure with includes

I am using cl_abap_structdescr->get_components to get a list of fields in a structure. It works fine when I use it on locally declared structure types, but when I use it on DDIC structures, it doesn't give me the results I expect. Reproducable…
Legxis
  • 886
  • 7
  • 19
1
vote
1 answer

Convert rawstring (Byte String) into readable String

Requirement: To convert SRT_MMASTER table's MESSAGE_DATA field data into readable string format or in internal table. I have tried different function modules to convert Byte String (Blob) data stored in SRT_MMASTER table's MESSAGE_DATA field but…
Chandan Jha
  • 21
  • 1
  • 7
1
vote
1 answer

Dates as column headers in a custom DDIC table

I want to create a custom table with dynamic column headers. For example, column 1 would be the date today then the second column would be tomorrow's date and so on. Can anybody help light me up on this one? Thanks a lot in advance!
Czarinaaaaa29
  • 311
  • 2
  • 8
  • 23
1
vote
3 answers

timestamp from sap into datetime in sql

from the beginning. I extracted data from Sap to MYSQL DB. In some tables, there are columns that were extracted as FLOAT and looks like this: 20131009012152 As you can see it's like the string, but not float. If I try to convert it into datetime,…
verner
  • 11
  • 1
  • 4
1
vote
1 answer

Where does the value of 'Last changed on/by' is stored for any element in 'se11' (Inside attributes tab)

I want to find out 'last changed on/by' for a large number of elements going in 'se11' and checking it's attribute value . So instead of copying each elements name and checking it's attribute for the same value, is there any table or database in…
user5741320
1
vote
2 answers

How to return value to user from a Search Help Exit

I have a Search Help with many fields to be displayed to the user in order to apply values. I want to get 3 fields APOFASI, SKOPOS, KATDANL from the user. In the CALLCONTROL-STEP = SELECT in the exit FM, I want to get these values in variables and…
ekekakos
  • 563
  • 3
  • 20
  • 39
1
vote
3 answers

How to extract program sub-objects from SE80?

Does anyone know how to extract program list objects from package. Classes,fileds,screend ? or in which the tables can I find this information. Like in the picture below... is there any way?
siasty
  • 167
  • 1
  • 2
  • 10
1 2
3
4 5 6 7 8