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 raise dunning level in a document?

I want to raise the dunning level from '3' to '4' in a document for 1 when I change the dunning from 'L' to 'N' for example. I need a simple function but I cant find it. Anybody have an idea? I have data for debitor, document number, booking date…
BMW3000
  • 111
  • 1
  • 4
  • 11
0
votes
1 answer

Calculate the length of itab structure in bytes

The internal table size (e.g. for a DSO) is limited to 4030 bytes. I have a list of infoobjects and would like to calculate if their amount will exceed this limit. How can I convert their data type in bytes? Example: CHAR 4 -> xxx bytes DATS ->…
Student
  • 1
  • 1
  • 1
0
votes
1 answer

Create DB table by copying to another one

I want to create a backup copy ztable through the abap program and not through SE11. Is there anyway to do it? e.g. I want to copy the zmydbtable to zmydbtable_bckp, how can I do it dynamically? Thanks
ekekakos
  • 563
  • 3
  • 20
  • 39
0
votes
1 answer

Constraints in Data Dictionary table creation

How to set a constraint on a field value in an ABAP table so that it can contain any of 'n' possible values? For example, if I am entering a weekday, it can have either of only 7 possible values. Is there a consistency check setting for this during…
ad123
  • 37
  • 6
0
votes
1 answer

Can a field from primary key be used as a foreign key in the same table?

I have a table T1 with 4 fields (F1, F2, F3 and F4) together acting as unique identifier of the table rows. Can one of these fields (F4 say) be used as a foreign key for the same table? We already have master data table (T2) for the same.
Gazeelle Kaito Wanijima
  • 11
  • 4
0
votes
0 answers

Long texts maintenance via SM30

I need to store long text data in a Z-table and maintain the data manually. Is there any way to maintain the texts via se54 generated dialogs? If no I will develope an ALV table report to maintain the table/long texts data of course...
Skalozub
  • 539
  • 7
  • 26
0
votes
1 answer

Want to get the database fields used in SAP TCode report

I am working on a data governance project with a lot of custom tcodes in SAP environment for various reports. Over a time there has been developed a lot of similar reports with minimal differences. My requirement is to fetch all the fields used in a…
Jnaneswar Vanga
  • 1
0
votes
3 answers

How do I store nested JSON objects directly in ABAP DDIC?

ABAP Databases, oracle, MaxDB et al., are mostly RDBMS. Right now, I have a JSON structure that cannot be normalised and hence I want to store it as is. So, I want a MongoDB like Object store in ABAP. What's the best way to achieve this? Is data…
lonelymo
  • 3,972
  • 6
  • 28
  • 36
0
votes
2 answers

Error when SELECT...FOR ALL ENTRIES have currency fields

I get this error: In a SELECT access, the read file could not be placed in the target field provided. when executing this line of code: SELECT vbeln posnr matnr netpr netwr kondm FROM vbap INTO TABLE…
RamonC
  • 31
  • 7
0
votes
0 answers

Data dictionary object check with rs_dd_check

rs_dd_check is a great function to check ddic objects. But the function module does not fit me that i can call it directly because i need to use it on older systems which only have the dialog and you can not export the messages out of the fm. so i…
Hārdža
  • 75
  • 2
  • 10
0
votes
1 answer

Removing a search help from a field

I am getting the following error: Search field ZEMPLOY01-CARRIER not contained in search help attachment. A search help ZEMPLOY_ESH is attached to the table field: ZEMPLOY01-CARRIER. However, as i am getting this error i want to remove the search…
gram77
  • 361
  • 1
  • 12
  • 30
0
votes
1 answer

check table and foreign key table check

The system correctly set the foreign key (zemploy01-department) with the check table (zdepartmentt02-department) - inside the red box in the diagram. If i do a system check, the system says: zemploy01-department is consistant. It is apparent that…
gram77
  • 361
  • 1
  • 12
  • 30
0
votes
2 answers

Different table names in different databases?

Sorry for a very basic question, suppose you have an oracle database with sap system in organisation, then while writing the select queries , will the database tables names differ? Suppose if am retrieving data from standard sap vbak table, then…
I_code
  • 59
  • 3
  • 11
0
votes
1 answer

Move fields from table to local table based on structure

I customized the table KNVV. The append structure includes a structure where I actually defined all my custom fields. Lets call it zz_knvv_app_s. A function pool, used to get and set the custom fields, has a function called ZSD_FOO_GET_DATA. It is…
SDD64
  • 706
  • 13
  • 28
0
votes
1 answer

Same Values unable to be inserted in SAP table

I have made two keys in the table in SAP, mandt and subject values of subject have to be repetitive. But I'm unable to insert same values. Error being shown is: an entry already exists with the same key This error persists even after I remove…
user3373861
  • 13
  • 1
  • 8
1 2 3 4 5
6
7 8