topic Z table population in Application Development and Automation Discussions

Z table population

Former Member — Sat, 13 Dec 2008 18:15:09 GMT

Hi,

I need a suggestion. I have created a ztable and i need to fill this table with 1000 records.

Please suggest me the best way to fill the z table with 1000 records.

2) Which request(Customizing or workbench) i need to use to transport this table

Regards

Sarvan

Re: Z table population

Former Member — Sat, 13 Dec 2008 18:27:58 GMT

Search the best option.

Did you Notice what happend to your thread.

Re: Z table population

RaymondGiuseppi — Sat, 13 Dec 2008 20:31:01 GMT

Just write a small report like

DO 1000 TIMES.
* fill warea (ztable structure) via counter, random generator or tool like [SYSTEM_GET_UNIQUE_ID|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=system_get_unique_id&adv=false&sortby=cm_rnd_rankvalue],
* [QF05_RANDOM|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=qf05_random&adv=false&sortby=cm_rnd_rankvalue]  or [GUID_CREATE|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=guid_create&adv=false&sortby=cm_rnd_rankvalue] to generate unique key fields
  WRITE ztable FROM warea.
ENDDO.

To transport the table values, insert the following object into an order : [R3TR TABU|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=r3tr+tabu&adv=false&sortby=cm_rnd_rankvalue] ZTABLE, then click on key list and add a key record with only "*" value.

Regards

Re: Z table population

Former Member — Sun, 14 Dec 2008 12:20:13 GMT

Hi,

1) You can run a report program to upload the data into your ztable

2) For transporting data into other systems, you need to create a customizing table(TYPE C in attributes) This will prompt a transport request, select a customizing request..

Regards

Shiva

Re: Z table population

Former Member — Mon, 15 Dec 2008 05:36:57 GMT

Hi,

INSERT INTO ZTable VALUES WA_Ztable.

Use above command to insert records into z table.

first take your 1000 records into local internal table then loop it.

before this diclare work area type of your Z Tbale

then

Loop IT_Table into wa_Table.

wa_ztable-matnr = wa_table-matnr.

..............

then use

INSERT INTO ZTable VALUES WA_Ztable.

endloop.