topic Re: Create a Dictionary Table from ABAP in Application Development and Automation Discussions

Create a Dictionary Table from ABAP

Former Member — Thu, 03 May 2007 19:48:02 GMT

Hi,

I have to create around 20 dictionary tables, each with its data elements and domains...

I found a document that describes how to do it but its made for CRM, so it doesnt work with the ERP...

if you want to look at it here is the link: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/775bc73e-0e01-0010-79a0-e9d0243e3ad7

can anyone tell me how to make it work with ERP?

Re: Create a Dictionary Table from ABAP

yuezhi_zhao — Thu, 03 May 2007 22:01:06 GMT

Hello Luis,

This works for ERP too. Both CRM and ERP uses the same SAP BASIS --- R/3, web Application server. The table creating, mantentance in SE11 is exactly the same for both systems.

Regads,

Joe

Re: Create a Dictionary Table from ABAP

uwe_schieferstein — Fri, 04 May 2007 05:35:26 GMT

Hello Luis

On a CRM 4.0 function module COM_GEN_DBTABLE_CREATE has the following interface:

[code]function com_gen_dbtable_create.

*"----

""Lokale Schnittstelle:

*" IMPORTING

*" REFERENCE(IV_DBTABLE_NAME) TYPE TABNAME

*" REFERENCE(IV_DEVCLASS) TYPE DEVCLASS

*" REFERENCE(IV_ACTIVATE) TYPE COM_GEN_ACTIVATE DEFAULT 'X'

*" REFERENCE(IT_DD03P) TYPE COMT_GEN_DD03P

*" REFERENCE(IS_DD02V) TYPE DD02V

*" REFERENCE(IS_DD09L) TYPE DD09L

*" REFERENCE(IV_GENFLAG) TYPE GENFLAG DEFAULT 'T'

*" REFERENCE(IV_REQUEST) TYPE TRKORR DEFAULT SPACE

*" EXPORTING

*" REFERENCE(ES_RETURN) TYPE COMS_RETURN

*"----

[/code]

The corresponding function module on a standard R/3 system is:

[code]FUNCTION RPY_TABLE_INSERT.

*"----

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(LANGUAGE) LIKE SY-LANGU DEFAULT SY-LANGU

*" VALUE(TABLE_NAME) LIKE RPY_TABL-TABLNAME

*" VALUE(WITH_DOCU) LIKE RGLIF-WITH_DOCU DEFAULT SPACE

*" VALUE(DOCUTYPE) LIKE RGLIF-DOCUTYPE DEFAULT 'T'

*" VALUE(TRANSPORT_NUMBER) LIKE RGLIF-TRKORR

*" DEFAULT SPACE

*" VALUE(DEVELOPMENT_CLASS) LIKE RGLIF-DEVCLASS

*" DEFAULT '$TMP'

*" VALUE(TABL_INF) LIKE RPY_TABL STRUCTURE RPY_TABL

*" VALUE(TABL_TECHNICS) LIKE RPY_TBTECH

*" STRUCTURE RPY_TBTECH DEFAULT SPACE

*" TABLES

*" TABL_FIELDS STRUCTURE RPY_FIEL_U

*" DOCU_TABLE_USER STRUCTURE RPY_OBJTAB OPTIONAL

*" DOCU_TABLE_TECH STRUCTURE TLINE OPTIONAL

*" EXCEPTIONS

*" CANCELLED

*" ALREADY_EXIST

*" PERMISSION_ERROR

*" NAME_NOT_ALLOWED

*" NAME_CONFLICT

*" DB_ACCESS_ERROR

*"----

[/code]

Now it is up to you to combine the function module of group <b>SIFD</b> in a proper way to create your domains -> data elements -> tables/structures.

Regards

Uwe

Re: Create a Dictionary Table from ABAP

Former Member — Thu, 10 May 2007 13:44:42 GMT

hi Luis

Goto->se11,there you have an option called create table.click that,so that you will get table name and choose direct type of creating table.

then just giv the domain name and data element name and activate it.

you table will be created.

REWARD IT PLEASE...!!