how to fill DDIC table

[Former Member]

hi sdnrs,

i want to fill DDIC table from two different internal tables is this possible if yes how . kindly give the sytax.

rewards will be sured.

thanks in advance.

[Former Member]

Hi,

Collect the data from two tables into a final table say it_final.

This can achieved using using loop ....endlooop.

The structure of it_final should be same as that of ztable which you to fill with data.

Once you fill the final internal table modify the DDIC table(ZTABLE) using this table.

MODIFY Ztable from table it_final.

Regards,

Shailaja

[Former Member]

hiii

you can do it by using MODIFY statement

MODIFY (table-name) FROM TABLE (internal table)

or you can do it by using same structure

LOOP AT I_TAB INTO WA_TAB.
MOVE-CORRESPONDING WA_TAB TO WA_STD_TAB.
INSERT WA_STD_TAB INTO STD_TAB INDEX 1.
ENDLOOP.

regards

twinkal

[Former Member]

Hi,

It is possible by using MODIFY statement

for multiple line Syntax is

MODIFY itab FROM wa TRANSPORTING f1 f2 ... WHERE cond.

For furtherdetail check,

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb35eb358411d1829f0000e829fbfe/content.htm

Regards,

Anirban

[Former Member]

HI,

if not IT_ZPPPINF_DATA is initial.
    modify ZPPPINF from table IT_ZPPPINF_DATA.
endif.

but the IT_ZPPPINF_DATA. should have the strucuture of ZPPPINF.

Donu2019t forget to reward points..

[Former Member]

Hi Friend,

Here is the syntax.

append lines of itab2 to itab1.

modify ztable from itab1.

Regards,

Madhusudhan

[former_member705122]

Hi,

The Open SQL statement for inserting data into a database table is: 
INSERT INTO <target> <lines>.

The Open SQL statement for changing data in a database table is: 
UPDATE <target> <lines>.

To insert lines into a database table regardless of whether there is 
already a line in the table with the same primary key, use the following: 
MODIFY <target> <lines>.

Check this link:

For insert,

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3a6d358411d1829f0000e829fbfe/content.htm

For update,

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3a94358411d1829f0000e829fbfe/content.htm

For modify,

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3ac8358411d1829f0000e829fbfe/content.htm

Regards

Adil

[Former Member]

Hi,

I think u can fill only ztable in the sap database , for which as u asked u can combine two tables into one final internal table and then u can fill the Ztable.But If u want to fill the Data Dictionary table in the sap database, then u have to run transaction i.e., module pool programming.

If found correct, let me know.

Rgds,

khadeer.