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

Display 500+ character field from SAP transparent table

As it commonly known, it is not recommended by SAP to use 255+ character fields in transparent tables. One should use several 255 fields instead, wrap text in LCHR, LRAW or STRING, or use SO10 text etc. However, while maintaining legacy (and ugly)…
Suncatcher
  • 10,355
  • 10
  • 52
  • 90
3
votes
5 answers

What is the best solution to update the MARA table?

I'm facing to a problem today: how to update the MARA table with custom and non-custom fields? I found some solutions, but I would like to know what is the best solution. I came from HCM module. On this module we have changelogs. So I would like to…
Georges O.
  • 972
  • 1
  • 9
  • 21
3
votes
2 answers

Is it possible to create database view programmatically?

I know one can create Database Views in DDIC, but is it possible to define a Database View directly with ABAP?
Koray Tugay
  • 22,894
  • 45
  • 188
  • 319
3
votes
1 answer

Why are the character fields of a transparent table in SAP 3 times bigger on the database level (DB2)?

I work with an SAP system with an IBM DB2 database attached to it. I created a transparent table in SAP system and then I checked how it looked like on the database level. It turned out that the character fields (CHAR, DATS, CUKY, NUMC) are three…
Jagger
  • 10,350
  • 9
  • 51
  • 93
3
votes
2 answers

Maintenance view event for checking if field is initial or not

I'm trying to check if a field is leaved initial or not in sm30 with a table that I've made. I've gone to table maintenance generator, then Environment->Modifications->Events and made an entrance named check_class with type 01 (before saving the…
Eva Dias
  • 1,709
  • 9
  • 36
  • 67
2
votes
1 answer

Can't add two FK-related tables into maintenance view?

I created two database tables: Primary table and Secondary table. An Employer field of Primary table is a foreign key for an Employer field for Secondary table, at least I see a checked checkbox at Secondary->Entry Help/Check for Employer field.…
Haradzieniec
  • 9,086
  • 31
  • 117
  • 212
2
votes
1 answer

How to filter the SAP tables by the number of fields?

SAP table DD02L lists, for each table in SAP, among others, the number of fields in each table. For example table, PLPO (PM task lists) contains 244 fields, according to T-Code S_PH0_48000138. For business reporting and using SQL, I only want to…
Mike McNally
  • 21
  • 1
2
votes
2 answers

Combine conditions in table expression?

I am using the line_index function and would like to search for two values, not only for carrid but also for connid. Is it possible? If so, in what way? Because right now, this works: lv_index = line_index( lt[ carrid = 'LH' ] ). But after adding…
Abapito
  • 73
  • 7
2
votes
1 answer

Get currency symbol referenced by a currency field symbol

I have a field symbol of a component of a structure: ASSIGN COMPONENT lv_field_name OF STRUCTURE ls_structure TO . IF sy-subrc = 0. WRITE TO lv_field_value. ENDIF. Problem: if is of type CURR the result of WRITE...…
Gerd Castan
  • 6,275
  • 3
  • 44
  • 89
2
votes
2 answers

Use output without conversion exit with SALV class

in SE16N in Technical Settings there is a Checkbox the OUTPUT WITHOUT CONVERSION EXIT. In my programs I use the class CL_SALV_TABLE for creating the ALVs. Is it possible to put a checkbox in the program similar to SE16N and when the user enable it…
ekekakos
  • 563
  • 3
  • 20
  • 39
2
votes
3 answers

How to find table type for a data element?

I create a new function modul in abap which should return a list of the data element AGVAL. AFAIK there are two ways now: I use an already available table type I create a new table type How to do this kind of introspection? I would like to now if…
guettli
  • 25,042
  • 81
  • 346
  • 663
2
votes
2 answers

Data compression algorithm in SAP clusters

I'm interested in data decompression in SAP systems. Which algorithm is used for compression/decompression in clustered tables? For example, in RFBLG table. I read something about the LZ algorithm but I'm not sure how it exactly works. Is there a…
bajky
  • 332
  • 6
  • 17
2
votes
4 answers

Finding SAP table relations?

I'm new to SAP. I have access to the SAP database, but not to the SAP GUI. I wanna know the tables relation i.e., how to join two tables. Suppose, if I want to know all the relations VNVK has, where should I start? I can only view the primary keys…
sam
  • 69
  • 1
  • 2
  • 4
2
votes
3 answers

What is "POSNR" an abreviation or acronym for?

I'm working with some data that's coming out of an SAP system. There's a field named POSNR that appears to be a line item/database identifier of some kind. What is this an abbreviation for? It's not hyper-critical to what I'm doing, but every…
Alana Storm
  • 164,128
  • 91
  • 395
  • 599
2
votes
1 answer

Using search help for different system?

I need a search help for my bukrs field. The problem is data should come from different system. There are 2 systems like X and Y. i am in X system and running a program. At selection screen bukrs field exists. When i click on search help data should…
EkremG
  • 131
  • 1
  • 13
1
2
3 4 5 6 7 8