Create a Dictionary Table from ABAP

[Former Member]

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-e9d0243e...

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

[yuezhi_zhao]

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

[uwe_schieferstein]

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

[Former Member]

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...!!