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

What is SOLIX_TAB (SAP)?

I want to know, what is SOLIX_TAB ? What type of conversion methodology should be used ? How to decrypt or export it as a PDF in C# or VB.NET ? EDIT (text taken from OP comment): "I am accessing a SAP Function, which return the employee information…
Man of Joy
  • 9
  • 1
  • 6
0
votes
1 answer

How to change selection popup for countries in sap

I want to change the SAP selection table that can be popped up when entering a country - I think it is table T005T (countries). Could you please tell me how to change the entries? Or show a completely different table with different entries, or…
chrnit
  • 17
  • 2
  • 8
0
votes
2 answers

Can I import SAP tables that were exported by SE16?

I have exported the contents of a table with transaction SE16, by selecting all the entries and going selecting Download, unconverted. I'd like to import these entries into another system (where the same table exists and is active). Furthermore,…
vlad-ardelean
  • 7,480
  • 15
  • 80
  • 124
0
votes
1 answer

How to create index in SAP?

Currently we are interfacing our application with SAP. We are having a lot of performance problems with bapi/rfc approach. So recently we are trying "direct sql" approach to retrieve some data from SAP. Unfortunately, we've found that some of SAP…
Sake
  • 4,033
  • 6
  • 33
  • 37
0
votes
3 answers

Can the user be forced to enter a non-initial value by the Table Maintenance screen in SM30?

I'd like to force the user to chose between Yes and No, and not let him add an entry where the value is initial. This is regardless of whether I check the Initial checkbox in the table definition. Can this be done? Domain data type : CHAR, 1…
vlad-ardelean
  • 7,480
  • 15
  • 80
  • 124
0
votes
2 answers

How can I add a text column to a table?

i want to add a text column to the MMBE table, it could be the lot size text field: KZTXT or any other (that is the one they are using right now, but do not want to click on it to see it, instead just see it in the front page). it will just add…
Sapslzr
  • 23
  • 1
  • 3
0
votes
1 answer

Abap table creation, combination reference table/field does not exist. What could be wrong?

I'm trying to activate my table in the SAP system. As you may tell, i'm only a beginner, anyway, the error log: TABL ZAVG_SO_OO was not activated Check table ZAVG_SO_OO (VARDELEAN/17.07.12/17:27) ZAVG_SO_OO-NETWR (combination reference table/field…
vlad-ardelean
  • 7,480
  • 15
  • 80
  • 124
-1
votes
1 answer

How can I validate a foreign key in a table control in abap?

I am learning ABAP, and one of the excersises is to make a table control with a table that has a foreign key in it. I already did the Table control, but, how can I validate that the foreign key is correct or not?
-1
votes
1 answer

SAP ABAP CRATING TABLES

I'm creating a table and I've inserted the following fields: MATERIAL CODES (MARA-MATNR) Type of GAS (MARM-MEINH) but I'm having problems with the 'CO2 coefficient' field. Any help for the domain and Data Element of the field ?
Korca95
  • 1
  • 1
  • 6
-1
votes
1 answer

what is the corresponding sql data type for abap DF16_DEC data type?

I am trying to map abap data type to SQL data type, but I don't know to which data type in SQL should I map. I am trying to map these following data type: DF16_DEC: 8 byte Decimal floating point number stored in BCD format. DF16_RAW: 8 byte Decimal…
-1
votes
1 answer

How to determine if an object contains either master or transactional data

I would like to know how to determine if an object in SAP has either transactional or master data. I do not know where to locate this information if it even states it anywhere within the datasets. Also, if it has to be determined based on certain…
Bruno
  • 1
  • 1
-1
votes
1 answer

'N' type variable is not saving into 'NUMC' type table field

My variable is of type N ie., COMP_ID(8) TYPE n I have created a Transparent Table. In my table, COMPLAINT_ID field is of type 'NUMC'. while I'm saving COMP_ID into my table's COMPLAINT_ID, it is not fetching the value.
BalajiB
  • 326
  • 6
  • 29
-1
votes
2 answers

How to check if a field is present in a particular view or table using ABAP

I have list of 100 views for which I need to check if those views have fields A and B. If any of those 100 views uses those two fields, I need to display a message. Any existing function module will help.
Sujeet325
  • 21
  • 1
  • 1
-1
votes
3 answers

Change field length afterwards

TABLES: VBRK. DATA: BEGIN OF it_test, BUKRS LIKE VBRK-BUKRS, FKDAT LIKE VBRK-FKDAT, END OF it_test. DATA: wa_test LIKE it_test. SELECT * FROM VBRK INTO CORRESPONDING FIELD OF wa_test. IF wa_test-BUKRS = 'xxxx'. wa_test-BUKRS =…
RamonC
  • 31
  • 7
-2
votes
1 answer

SQL Server: how to convert SAP-style CALWEEK to CALMONTH?

The year 2015 has 53 weeks while the year 2016 has 52 weeks. Hence, the CALMONTH cannot be calculated by the week number divided by four and then ceiling it. CALWEEK is reported such as 201652, 201501 and 201104. CALMONTH is a number between a range…
hhh
  • 50,788
  • 62
  • 179
  • 282