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
7
votes
3 answers

Syntax for creating internal table from existing database table?

I'm new to ABAP. Started learning about internal tables. I was reading on the ways to create internal tables. I came across the following syntax to create an internal table from an existing database table: data: it_mara type table of mara. I'm…
The-Droidster
  • 635
  • 7
  • 13
7
votes
1 answer

Generate DDIC structure from XSD?

I have a number of XSDs that are part of the enterprise definitions for several services at the client. I would like to be able to take a single XSD and generate a DDIC structure from it (without the use of PI!) Seeing as you can generate proxies…
mydoghasworms
  • 18,233
  • 11
  • 61
  • 95
6
votes
2 answers

Is there a way to find the customizing request number for a given record at a maintenance view?

In ABAP we can check the latest workbench request assigned to a given code from Utilities->Versions->Version Management menu. Is there any similar feature to check which is the customizing request for a given record at a maintenance view (SM30)…
Paulo
  • 1,041
  • 1
  • 7
  • 12
5
votes
2 answers

How to find ForeignKey in SAP Dictionary tables?

Table AUFK has a column called ADRNRA. The values in column ADRNRA have matching rows in table ADRC. In this case I found ADRC because someone told me the solution. Maybe I am blind, but it looks like AUFK-ADRNRA is no explicit foreign key. Is there…
guettli
  • 25,042
  • 81
  • 346
  • 663
5
votes
1 answer

Limit maintenance view output based on authorization

How can i limit on table maintenance fetching data base on authorization? For instance the user only can view plant/storage location based on the authorization object because sometimes the user gets confused of too many plants are irrelevant for…
mapet
  • 868
  • 1
  • 11
  • 21
4
votes
1 answer

Why are there so many "char" types in ABAP when you have "string" type?

In the ABAP Dictionary, you can find data elements of "CHAR" types for almost all lengths, so here goes the question: what functionality have them when you have a string element that can afford all the lengths? I am talking about those with specific…
JD0001
  • 131
  • 3
  • 11
4
votes
2 answers

Get table field description programmatically

I'm trying to query SAP's data dictionary through ERPConnect's ABAP API. The code below retrieves the table names and various field properties fine but fails to show the field description. Anyone knows why? Thanks REPORT ZSELECTCOMMAND. TABLES:…
rodders
  • 229
  • 1
  • 6
  • 9
4
votes
1 answer

Using GUIDs for Custom Tables?

As far as I know, SAP CRM and HANA both utilise GUIDs to uniquely identify records instead of using classic incremented integers. Are there best practices or clear guidelines that cover their use? Here are some factors I've considered in favour of…
Lilienthal
  • 4,327
  • 13
  • 52
  • 88
4
votes
3 answers

Data element description is not updated in SE16N

I changed the DataElement of one column in SE11 transaction. When I open the table at SE16N, the column name is the description of the older DataElement. How do I update the column with the new description? Example: At first time, I created as…
Ailin Albertoni
  • 83
  • 1
  • 2
  • 7
4
votes
2 answers

Get available BAPIs and/or tables

I have developed a component in C# 2010 using SAP .NET Connector 3.0 to run BAPI Modules and read SAP tables data and schemas. Is there a BAPI (or some other way) to get: list of available tables list of available BAPIs Thanks in advance.
Daniele
  • 203
  • 6
  • 20
4
votes
1 answer

Can I call a search help programatically, with some parameters already filled in and non-editable?

I have collective search help S_MAT1 defined for data element MATNR. I want to invoke programatically the append search help S_MAT1_APPEND, this means that when I press a button in an ALV list, I have to trigger a search dialog, like that for a…
vlad-ardelean
  • 7,480
  • 15
  • 80
  • 124
3
votes
2 answers

Make table customizable/transportable?

I've got a table which was set up wrong ( as an application table, but a maintanence view was created ) but it should be an customizing table, so that we are able to transport the entries of the table. So far I changed the type and maintainablity of…
Sasku
  • 517
  • 7
  • 23
3
votes
3 answers

Create entries option is disabled in SE11. Why?

Hi I am new to ABAP and I would like some guidance on how to create a table and also add the database items. I created one transparent table. made data elements and domains for each field, I was given a warning error message stating: [Specify a…
SMOORE
  • 41
  • 4
3
votes
1 answer

What is the use of Table Delivery Class in SAP Data Dictionary?

I want to see the difference of Delivery Class 'A' and 'C'. C for data entered only by the customer, but how can I see it on the code? I created two tables of type 'A' and 'C'. I add data with ABAP code. I thought I couldn't add data to the table I…
shrgrl
  • 87
  • 3
  • 13
3
votes
1 answer

How to select LRAW from DB Table?

I have the following code: SELECT S~CLUSTD AS ZZCLUSTD INTO CORRESPONDING FIELDS OF TABLE @lt_viqmel_iflos FROM viqmel AS v LEFT OUTER JOIN stxl AS S ON s~tdobject = @lv_qmel AND s~tdname = v~qmnum Select statement generates…
Ovidiu Pocnet
  • 579
  • 12
  • 32
1
2 3 4 5 6 7 8