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
0
votes
1 answer

How to link SAP tables (EKPO, MARA, ...) with SAP transactions (ME23n, ME3M, ...)?

I want to automate SAP Exports in my Company and query Data from transactions directly from our Datalake. The only problem is that the query results differ from the exported Data directly from SAP ERP. It seems like the wrong attributes/tables are…
010x0
  • 11
  • 4
0
votes
1 answer

How to get long text object change log programmatically?

I have a requirement to fetch all changes that were made to a long text object. From what I know, there is a program called S_AUT_REP10 where you can see the changes that were made to a long text in ALV but I can't seem to find how to extract this…
Assaf
  • 63
  • 4
  • 11
0
votes
2 answers

How to copy database table content from one table to another? SAP

i created a copy of SAP database table SFLIGHT called ZFLIGHT99, but i need to copy a data from original table too. I tried to copy by report like DATA itab1 TYPE TABLE OF SFLIGHT. DATA itab2 TYPE TABLE OF ZFLIGHT99. itab2[] = itab1[]. But it…
Abapito
  • 73
  • 7
0
votes
2 answers

Custom table primary key changed

I have created a custom table as a data dictionary object in SE11. I have the following fields : ID (KEY Field ) NAME (KEY Field ) DEP (KEY Field ) DESIGNATION I have activated the table and also generated a table maintenance generator but after…
Surya Pratap Yadav
  • 1
  • 2
0
votes
1 answer

Storing numbers in character type columns

I'm researching the data types of the field of SAP's data table. I realized that the fields that only store numbers are sometimes varchar or char data types. e.g., KUNNR(Customer Number) and BUKRS(Company Code) are character data types. What is the…
上原英知
  • 11
  • 2
0
votes
0 answers

Talend - Retrieve SAP Table window doesn't open

I have been retrieving SAP tables okay but am now having a problem. We have a SAP connection set up and when I right-click and choose "Retrieve SAP table", a lock appears against the SAP connection, the list of tables expands and then contracts and…
Caz
  • 57
  • 1
  • 5
0
votes
1 answer

Parameter to be passed for Field to read in SAP connector: Read SAP table(preview)

I am not able to fetch multiple columns/fields from SAP table using Read SAP table(preview) action in Logic app. I tried passing it as array but it is throwing an error: unexpected token StartArray. Path queries.fieldname.'.' If we don't pass any…
ashwani nagar
  • 31
  • 3
0
votes
1 answer

SAP - See all table entries in SE16 for table with numeric key

I'm trying to inspect the data of a table via transaction code SE16(n) on a development system. I'd like to see all of the table's records. In other words, I don't want there to be any selection criteria. But the table has a numeric key that I have…
Joshua Schroijen
  • 376
  • 6
  • 23
0
votes
1 answer

Difference between Dictionary type and ABAP type?

Sorry, I am new to SAP system, and I really can't understand some basic logic about the SAP system even I study and search in the Internet almost two days. My question is: Why can I only use several Dictionary type in ABAP program? Below is my SAP…
keep_learner
  • 19
  • 1
  • 6
0
votes
0 answers

How can I write a stored procedure to change the datatype of table under datadictionary to money from numeric type

We convert DBF table to ADT. While running the code after conversion, an error pops up in numeric datatype in columns. If we manually change the datatype to money it will work. I want to automate this stored procedure to change the table column…
gopi.jtech
  • 11
  • 5
0
votes
2 answers

SM30 error Changes to repository or cross-client customizing are not permitted

I created a table in SAP via se11, then I used the table maintenance generator. Then I transported the changes from development system to q-system. Now I want to maintain the table via sm30. This works in the DEV system. I just get a warning: "This…
guettli
  • 25,042
  • 81
  • 346
  • 663
0
votes
2 answers

Show all search help in maintenance view-abap

I made a maintenance view to a table that contains 2 foreign keys, when I use the search help only shows the parameter of the foreign key: but what I want is to show all parameters of the search help like this: How can I do it? Thank you in…
Marinel Chávhez
  • 1
  • 3
0
votes
2 answers

DB tables technical info in SAP Data Dictionary

I was given a task to develop a report that would present the following details (as separate columns in ALV): 1) Name of the DB table (like MSEG, EKPO etc.) 2) Size of the DB table in megabytes 3) Number of records 4) Number of read requests…
user9695260
  • 347
  • 3
  • 17
0
votes
2 answers

Check if column X exists in table Y

I have two string variables: lv_table_name contains a table name lv_column_name contains a column name Is there a way to check if there is a table (or view) which has the given column?
guettli
  • 25,042
  • 81
  • 346
  • 663
0
votes
3 answers

ABAP Domain and Data Types Understanding

so my company wants me to learn ABAP for SAP and I have started on the road to learn this. My background is mainly VB.net and sqlserver with T-SQL but also have experience in c#. With ABAP though I am needing some clarification or confirmation on…
altaaf.hussein
  • 274
  • 2
  • 13
1 2 3 4
5
6 7 8