topic Re: DATA DICTIONARY in Application Development and Automation Discussions

DATA DICTIONARY

Former Member — Fri, 01 Feb 2008 04:44:12 GMT

plz send me some links to knw about ABAP data dicitonary

Re: DATA DICTIONARY

Former Member — Fri, 01 Feb 2008 04:46:47 GMT

Hope it will help you.

Pls reward if help.

ABAP Dictionary

Purpose

Data definitions (metadata) are created and managed in the ABAP Dictionary. The ABAP Dictionary permits a central description of all the data used in the system without redundancies. New or modified information is automatically provided for all the system components. This ensures data integrity, data consistency and data security.

You can create the corresponding objects (tables or views) in the underlying relational database using these data definitions. The ABAP Dictionary therefore describes the logical structure of the objects used in application development and shows how they are mapped to the underlying relational database in tables or views.

The ABAP Dictionary also provides standard functions for editing fields on the screen, for example for assigning a screen field an input help.

What Information is Stored in the ABAP Dictionary?

The most important object types in the ABAP Dictionary are tables, views, types, domains, search helps and lock objects.

Tables are defined in the ABAP Dictionary independently of the database. A table having the same structure is then created from this table definition in the underlying database.

Views are logical views on more than one table. The structure of the view is defined in the ABAP Dictionary. A view on the database can then be created from this structure.

Types are used in ABAP programs. The structure of a type can be defined globally in ABAP programs. Changes to a type automatically take effect in all the programs using the type.

Lock objects are used to synchronize access to the same data by more than one user. Function modules that can be used in application programs are generated from the definition of a lock object in the ABAP Dictionary.

Different fields having the same technical type can be combined in domains. A domain defines the value range of all table fields and structure components that refer to this domain.

The ABAP Dictionary also contains the information displayed with the F1 and F4 help for a field in an input template. The documentation about the field is created for a data element that describes the meaning of the contents of a table field. The list of possible input values that appears for the input help is created by a foreign key or a search help.

Integration in the ABAP Workbench

The ABAP Dictionary is completely integrated in the ABAP Workbench. The R/3 System works interpretatively, permitting the ABAP Dictionary to be actively integrated in the development environment. Instead of the original objects, the interpreters see only internal representations of these objects.

These internal representations are adjusted automatically when the system finds that changes have been made in the ABAP Dictionary. This ensures that the screen and ABAP interpreters, input help, database interface, and development tools always access current data.

The following ABAP program lists the airline carriers (see Flight model) and carrier IDs contained in table SCARR.

DATA: SCARR_TAB TYPE SCARR.

SELECT * INTO SCARR_TAB FROM SCARR.

WRITE: / SCARR_TAB-CARRID, SCARR_TAB-CARRNAME.

ENDSELECT.

Only structure SCARR_TAB is declared in the program. All the information about this structure, such as the field names, data types and field lengths, are copied from table SCARR, which is defined in the ABAP Dictionary. This information about table SCARR is called from the ABAP Dictionary when the program is generated.

This means that the source text of the program need not be adjusted when a change is made to table SCARR, for example when the length of a table field is changed. The next time the program is called, the system automatically determines that the structure of table SCARR has changed. The program is simply regenerated, thereby retrieving up-to-date information about table SCARR from the ABAP Dictionary.

Re: DATA DICTIONARY

soumya_jose3 — Fri, 01 Feb 2008 04:47:49 GMT

Hi,

Check this link

http://www.sapbrainsonline.com/TUTORIALS/TECHNICAL/dictionary_tutorial.html

Reward points if helpful.

Regards,

Soumya.

Re: DATA DICTIONARY

Former Member — Fri, 01 Feb 2008 04:47:51 GMT

Hope it will help you.

Pls reward if help.

ABAP book

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCABA/BCABA.pdf

ABAP in 21 days

http://cma.zdnet.com/book/abap/index.htm

You can also check for documentation in pdf files

http://www.easymarketplace.de/online-pdfs.php

ABAP in 21 days

http://cma.zdnet.com/book/abap/ch03/ch03.htm

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm SAP Online Help For Dictionary.

http://sappoint.com/abap/

for SAPscripts

For follg., refer http://www.henrikfrank.dk/abapuk.html

Please note that I do not offer any support for the examples !

ABAP objects and control technology

IDOC

SapScript

Performance tuning

BAPI Programming

Visual Basic Integration - Using the DCOM Connector and BAPI OCX (Only available in Danish)

JAVA and the SAP java connector

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/abapindx.htm

for keywords

very useful link for all

http://www.sapgenie.com/abap/index.htm

http://www.sap-img.com/abap.htm

http://www.sapdevelopment.co.uk/tips/tipshome.htm

http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm

http://sap.ittoolbox.com/nav/t.asp?t=322&p=322&h1=322

http://sap.ittoolbox.com/nav/t.asp?t=448&p=448&h1=448

http://www.thespot4sap.com/

http://www.kabai.com/abaps/q.htm

http://www.geocities.com/mpioud/Abap_programs.html

http://www.sapgenie.com/abap/tips_and_tricks.htm

http://www.sapassist.com/code/d.asp?whichpage=1&pagesize=10&i=10&a=c&o=&t=&q=&qt=

For FAQ

http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm

http://www.sapgenie.com/faq/abap.htm

BAPI-step by step

http://www.sapgenie.com/abap/bapi/example.htm

Weblog for receive email and processing it through ABAP

/people/thomas.jung3/blog/2004/09/09/receiving-e-mail-and-processing-it-with-abap--version-610-and-higher

For Logical database

http://help.sap.com/saphelp_46c/helpdata/en/9f/db9bed35c111d1829f0000e829fbfe/frameset.htm

very useful

http://help.sap.com/saphelp_46c/helpdata/EN/35/2cd77bd7705394e10000009b387c12/frameset.htm

Useful link to websites

http://www.hernangn.com.ar/sap.htm

Useful for background

http://www.sappoint.com/basis/bckprsng.pdf

http://help.sap.com/saphelp_nw04/helpdata/en/6f/08703713bf277ee10000009b38f8cf/frameset.htm

http://publib.boulder.ibm.com/infocenter/wbihelp/index.jsp?topic=/com.ibm.wbix_adapters.doc/doc/mysap4/sap4x41.htm

Table control in BDC

http://www.sap-img.com/abap/bdc-example-using-table-control-in-bdc.htm

For posting weblog,

/people/sap.user72/blog/2005/06/28/sdn-weblogs-making-it-easier

Dynamic Internal table -weblog in sdn

/people/subramanian.venkateswaran2/blog/2004/11/19/dynamic-internal-table

Smartforms

http://www.sap-basis-abap.com/sapsf001.htm

http://www.sap-press.com/downloads/h955_preview.pdf

http://www.ossincorp.com/Black_Box/Black_Box_2.htm

http://www.sap-img.com/smartforms/sap-smart-forms.htm

How to trace smartform

http://help.sap.com/saphelp_47x200/helpdata/en/49/c3d8a4a05b11d5b6ef006094192fe3/frameset.htm

Workflow

http://www.sap-img.com/workflow/sap-workflow.htm

http://help.sap.com/saphelp_47x200/helpdata/en/a5/172437130e0d09e10000009b38f839/frameset.htm

For examples on WorkFlow...check the below link..

http://help.sap.com/saphelp_47x200/helpdata/en/3d/6a9b3c874da309e10000000a114027/frameset.htm

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PSWFL/PSWFL.pdf

http://help.sap.com/saphelp_47x200/helpdata/en/4a/dac507002f11d295340000e82dec10/frameset.htm

http://www.workflowing.com/id18.htm

http://www.e-workflow.org/

http://web.mit.edu/sapr3/dev/newdevstand.html

ALV

http://www.geocities.com/mpioud/Abap_programs.html

Mail

http://www.geocities.com/mpioud/Z_EMAIL_ABAP_REPORT.html

http://www.thespot4sap.com/Articles/SAP_Mail_SO_Object_Send.asp

http://www.sapdevelopment.co.uk/reporting/email/attach_xls.htm

BOM Explosion

/people/prakash.singh4/blog/2005/05/15/explode-boms-in-enterprise-portal-using-htmlb-tree--part-1-abap

BOM

http://help.sap.com/saphelp_erp2005/helpdata/en/ea/e9b7234c7211d189520000e829fbbd/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/d1/2e4114a61711d2b423006094b9d648/frameset.htm

http://www.sap-img.com/sap-sd/sales-bom-implementation.htm

http://www.sap-basis-abap.com/sappp007.htm

OLE

http://www.sapgenie.com/abap/ole.htm

http://help.sap.com/saphelp_46c/helpdata/en/59/ae3f2e488f11d189490000e829fbbd/frameset.htm

ALVGRID with refresh

http://www.geocities.com/mpioud/Z_DEMO_ALV_REFRESH_BUTTON.html

For language setting and decimal separator

/people/horst.keller/blog/2004/11/16/abap-geek-7-150-babylonian-confusion

Oracle queries

http://sqlzoo.net/

To format SQL

http://www.sqlinform.com/

SCOT settings

http://www.sap-img.com/basis/basis-faq.htm

Status Icon [ALV,Table Control,Tab Strip]

http://www.sapdesignguild.org/resources/MiniSG-old/from_develop/norm_status_icons.htm#positioning_4

ALV Group Heading

http://www.sap-img.com/fu037.htm

For multiMedia

/people/thomas.jung3/blog/2005/05/11/using-classic-activex-controls-in-the-abap-control-framework

Uploading LOGO in SAP

http://www.sap-img.com/ts001.htm

LSMW

http://www.sap-img.com/sap-data-migration.htm

http://www.sapgenie.com/saptech/lsmw.htm

http://sapabap.iespana.es/sapabap/manuales/pdf/lsmw.pdf

http://www.sap.info/public/INT/int/glossary/int/glossaryletter/Word-17643ed1d6d658821_glossary/L#Word-17643ed1d6d658821_glossary

check out these link,

http://www.sapgenie.com/abap/index.htm

http://www.sap-img.com/abap.htm

http://sap.ittoolbox.com/nav/t.asp?t=448&p=448&h1=448

http://www.thespot4sap.com/

http://www.kabai.com/abaps/q.htm

http://www.geocities.com/mpioud/Abap_programs.html

http://www.sapgenie.com/abap/tips_and_tricks.htm

http://www.sapdevelopment.co.uk/tips/tipshome.htm

http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm

Re: DATA DICTIONARY

i048168 — Fri, 01 Feb 2008 04:49:23 GMT

Hi,

The following link will be useful.

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ea0b446011d189700000e8322d00/frameset.htm

Regards

Vadi

Re: DATA DICTIONARY

former_member156446 — Fri, 01 Feb 2008 04:49:57 GMT

Hi Vive, what else can help you more than SAP help:

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ea31446011d189700000e8322d00/content.htm

Re: DATA DICTIONARY

Former Member — Fri, 01 Feb 2008 04:53:36 GMT

Hi,

The ABAP Dictionary also provides standard functions for editing fields on the screen, for example for assigning a screen field an input help.

The most important object types in the ABAP Dictionary are tables, views, types, domains, search helps and lock objects.

Tables are defined in the ABAP Dictionary independently of the database. A table having the same structure is then created from this table definition in the underlying database.

Views are logical views on more than one table. The structure of the view is defined in the ABAP Dictionary. A view on the database can then be created from this structure.

Types are used in ABAP programs. The structure of a type can be defined globally in ABAP programs. Changes to a type automatically take effect in all the programs using the type.

Different fields having the same technical type can be combined in domains. A domain defines the value range of all table fields and structure components that refer to this domain.

Ckeck this link for any help:

ABAP in 21 days Book:

http://cma.zdnet.com/book/abap/ch03/ch03.htm

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm SAP Online Help For Dictionary.

cheers,

vasu.